[Freeswitch-users] odbc basic_calls

Fri Aug 12 02:33:45 MSD 2011

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