[Freeswitch-users] odbc basic_calls

Fri Aug 12 02:42:15 MSD 2011

Where would those logs be?
A "grep -ir basic_calls /var/logs/*" returned nothing and I don't see how to
get beyond /log 7, although I'm sure I've done it before.
-Avi

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

> the create stmt for the view must be offending it.
> Maybe you can dig up the error in your logs?
>
>
> On Thu, Aug 11, 2011 at 5:18 PM, Avi Marcus <avi at avimarcus.net> wrote:
> > 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
> >
> >
> > _______________________________________________
> > 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/5493d97f/attachment-0001.html 