[Freeswitch-users] odbc basic_calls

Fri Aug 12 02:18:17 MSD 2011

I didn't think to try it twice. But no,

freeswitch at default> show calls

-ERR SQL Error [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51
Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'
doesn't exist
]

freeswitch at default> 2011-08-12 01:17:40.494779 [ERR] switch_core_sqldb.c:825
ERR: [select * from basic_calls where hostname='sip2' order by
call_created_epoch]
[STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51
Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'
doesn't exist
]
show calls

-ERR SQL Error [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51
Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'
doesn't exist
]

freeswitch at default> 2011-08-12 01:17:41.314777 [ERR] switch_core_sqldb.c:825
ERR: [select * from basic_calls where hostname='sip2' order by
call_created_epoch]
[STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51
Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'
doesn't exist

-Avi

On Fri, Aug 12, 2011 at 1:12 AM, Anthony Minessale <
anthony.minessale at gmail.com> wrote:

> that's good, the error should be what triggered the creation of the view,
>
> On Thu, Aug 11, 2011 at 3:22 PM, Avi Marcus <avi at avimarcus.net> wrote:
> > I did 1) git pull 2) make sync, rather than doing a make clean, 3)
> restarted
> > and 4) got:
> > 2011-08-11 23:20:45.654766 [ERR] switch_core_sqldb.c:825 ERR: [select *
> from
> > basic_calls where hostname='sip2' order by call_created_epoch]
> > [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51
> > Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'
> > doesn't exist
> > Would a make clean be any different?
> > -Avi
> >
> > On Thu, Aug 11, 2011 at 11:04 PM, Anthony Minessale
> > <anthony.minessale at gmail.com> wrote:
> >>
> >> i see a small way it may happen, update again and see if it works.
> >>
> >>
> >> On Thu, Aug 11, 2011 at 9:30 AM, mazilo <Nabble at slickdeals.endjunk.com>
> >> wrote:
> >> > Avi,
> >> >
> >> > I also just upgraded FS since .. 03/26/2011 ago. Now, my Seagate
> >> > DockStar is
> >> > hosting the same FS version you have. Notice that I don't know much
> >> > about
> >> > using ODBC, but my current FS version has been compiled with the
> >> > /--enable-core-odbc-support/ option. So, I haven't done anything to
> >> > create
> >> > any SQL database to use with my FS. However, then I pressed F4 key
> while
> >> > I
> >> > was on a call to ext. 3000 (conference call), it showed me with the
> call
> >> > in
> >> > progress and didn't show me the error message as you posted above. I
> >> > don't
> >> > know if having no SQL database file has anything to do with it.
> >> >
> >> > -----
> >> > FreeSWITCH hosted on a Seagate DockStar with OpenWRT and ONLY consumes
> 3
> >> > Watts of electricity.
> >> > --
> >> > View this message in context:
> >> >
> http://freeswitch-users.2379917.n2.nabble.com/odbc-basic-calls-tp6676013p6676584.html
> >> > Sent from the freeswitch-users mailing list archive at Nabble.com.
> >> >
> >> > _______________________________________________
> >> > Join us at ClueCon 2011, Aug 9-11, Chicago
> >> > http://www.cluecon.com 877-7-4ACLUE
> >> >
> >> > FreeSWITCH-users mailing list
> >> > FreeSWITCH-users at lists.freeswitch.org
> >> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> >> > UNSUBSCRIBE:
> http://lists.freeswitch.org/mailman/options/freeswitch-users
> >> > http://www.freeswitch.org
> >> >
> >>
> >>
> >>
> >> --
> >> Anthony Minessale II
> >>
> >> FreeSWITCH http://www.freeswitch.org/
> >> ClueCon http://www.cluecon.com/
> >> Twitter: http://twitter.com/FreeSWITCH_wire
> >>
> >> AIM: anthm
> >> MSN:anthony_minessale at hotmail.com
> >> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
> >> IRC: irc.freenode.net #freeswitch
> >>
> >> FreeSWITCH Developer Conference
> >> sip:888 at conference.freeswitch.org
> >> googletalk:conf+888 at conference.freeswitch.org
> >> pstn:+19193869900
> >>
> >> _______________________________________________
> >> Join us at ClueCon 2011, Aug 9-11, Chicago
> >> http://www.cluecon.com 877-7-4ACLUE
> >>
> >> FreeSWITCH-users mailing list
> >> FreeSWITCH-users at lists.freeswitch.org
> >> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> >> UNSUBSCRIBE:
> http://lists.freeswitch.org/mailman/options/freeswitch-users
> >> http://www.freeswitch.org
> >
> >
> > _______________________________________________
> > Join us at ClueCon 2011, Aug 9-11, Chicago
> > http://www.cluecon.com 877-7-4ACLUE
> >
> > FreeSWITCH-users mailing list
> > FreeSWITCH-users at lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
> >
>
>
>
> --
> Anthony Minessale II
>
> FreeSWITCH http://www.freeswitch.org/
> ClueCon http://www.cluecon.com/
> Twitter: http://twitter.com/FreeSWITCH_wire
>
> AIM: anthm
> MSN:anthony_minessale at hotmail.com
> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
> IRC: irc.freenode.net #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888 at conference.freeswitch.org
> googletalk:conf+888 at conference.freeswitch.org
> pstn:+19193869900
>
> _______________________________________________
> Join us at ClueCon 2011, Aug 9-11, Chicago
> http://www.cluecon.com 877-7-4ACLUE
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110812/0700a621/attachment-0001.html 