[Freeswitch-users] odbc basic_calls

Fri Aug 12 02:45:45 MSD 2011

Maybe MySQL has a log of its own somewhere?
 On Aug 11, 2011 5:43 PM, "Avi Marcus" <avi at avimarcus.net> wrote:
> 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/20110811/fda5e1b0/attachment.html