<div dir="ltr">Where would those logs be?<div>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.<br clear="all"><div dir="ltr">
<span style="font-family:Verdana, Arial, Helvetica, sans-serif"><span style="font-size:small">-Avi</span></span></div>
<br><br><div class="gmail_quote">On Fri, Aug 12, 2011 at 1:33 AM, Anthony Minessale <span dir="ltr"><<a href="mailto:anthony.minessale@gmail.com">anthony.minessale@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
the create stmt for the view must be offending it.<br>
Maybe you can dig up the error in your logs?<br>
<div><div></div><div class="h5"><br>
<br>
On Thu, Aug 11, 2011 at 5:18 PM, Avi Marcus <<a href="mailto:avi@avimarcus.net">avi@avimarcus.net</a>> wrote:<br>
> I didn't think to try it twice. But no,<br>
> freeswitch@default> show calls<br>
> -ERR SQL Error [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51<br>
> Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'<br>
> doesn't exist<br>
> ]<br>
> freeswitch@default> 2011-08-12 01:17:40.494779 [ERR] switch_core_sqldb.c:825<br>
> ERR: [select * from basic_calls where hostname='sip2' order by<br>
> call_created_epoch]<br>
> [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51<br>
> Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'<br>
> doesn't exist<br>
> ]<br>
> show calls<br>
> -ERR SQL Error [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51<br>
> Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'<br>
> doesn't exist<br>
> ]<br>
> freeswitch@default> 2011-08-12 01:17:41.314777 [ERR] switch_core_sqldb.c:825<br>
> ERR: [select * from basic_calls where hostname='sip2' order by<br>
> call_created_epoch]<br>
> [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51<br>
> Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'<br>
> doesn't exist<br>
><br>
><br>
><br>
><br>
> -Avi<br>
><br>
> On Fri, Aug 12, 2011 at 1:12 AM, Anthony Minessale<br>
> <<a href="mailto:anthony.minessale@gmail.com">anthony.minessale@gmail.com</a>> wrote:<br>
>><br>
>> that's good, the error should be what triggered the creation of the view,<br>
>><br>
>> On Thu, Aug 11, 2011 at 3:22 PM, Avi Marcus <<a href="mailto:avi@avimarcus.net">avi@avimarcus.net</a>> wrote:<br>
>> > I did 1) git pull 2) make sync, rather than doing a make clean, 3)<br>
>> > restarted<br>
>> > and 4) got:<br>
>> > 2011-08-11 23:20:45.654766 [ERR] switch_core_sqldb.c:825 ERR: [select *<br>
>> > from<br>
>> > basic_calls where hostname='sip2' order by call_created_epoch]<br>
>> > [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51<br>
>> > Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'<br>
>> > doesn't exist<br>
>> > Would a make clean be any different?<br>
>> > -Avi<br>
>> ><br>
>> > On Thu, Aug 11, 2011 at 11:04 PM, Anthony Minessale<br>
>> > <<a href="mailto:anthony.minessale@gmail.com">anthony.minessale@gmail.com</a>> wrote:<br>
>> >><br>
>> >> i see a small way it may happen, update again and see if it works.<br>
>> >><br>
>> >><br>
>> >> On Thu, Aug 11, 2011 at 9:30 AM, mazilo <<a href="mailto:Nabble@slickdeals.endjunk.com">Nabble@slickdeals.endjunk.com</a>><br>
>> >> wrote:<br>
>> >> > Avi,<br>
>> >> ><br>
>> >> > I also just upgraded FS since .. 03/26/2011 ago. Now, my Seagate<br>
>> >> > DockStar is<br>
>> >> > hosting the same FS version you have. Notice that I don't know much<br>
>> >> > about<br>
>> >> > using ODBC, but my current FS version has been compiled with the<br>
>> >> > /--enable-core-odbc-support/ option. So, I haven't done anything to<br>
>> >> > create<br>
>> >> > any SQL database to use with my FS. However, then I pressed F4 key<br>
>> >> > while<br>
>> >> > I<br>
>> >> > was on a call to ext. 3000 (conference call), it showed me with the<br>
>> >> > call<br>
>> >> > in<br>
>> >> > progress and didn't show me the error message as you posted above. I<br>
>> >> > don't<br>
>> >> > know if having no SQL database file has anything to do with it.<br>
>> >> ><br>
>> >> > -----<br>
>> >> > FreeSWITCH hosted on a Seagate DockStar with OpenWRT and ONLY<br>
>> >> > consumes 3<br>
>> >> > Watts of electricity.<br>
>> >> > --<br>
>> >> > View this message in context:<br>
>> >> ><br>
>> >> > <a href="http://freeswitch-users.2379917.n2.nabble.com/odbc-basic-calls-tp6676013p6676584.html" target="_blank">http://freeswitch-users.2379917.n2.nabble.com/odbc-basic-calls-tp6676013p6676584.html</a><br>
>> >> > Sent from the freeswitch-users mailing list archive at Nabble.com.<br>
>> >> ><br>
>> >> > _______________________________________________<br>
>> >> > Join us at ClueCon 2011, Aug 9-11, Chicago<br>
>> >> > <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
>> >> ><br>
>> >> > FreeSWITCH-users mailing list<br>
>> >> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> >> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> >> ><br>
>> >> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> >> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> >> ><br>
>> >><br>
>> >><br>
>> >><br>
>> >> --<br>
>> >> Anthony Minessale II<br>
>> >><br>
>> >> FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
>> >> ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
>> >> Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
>> >><br>
>> >> AIM: anthm<br>
>> >> <a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>
>> >> GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
>> >> IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
>> >><br>
>> >> FreeSWITCH Developer Conference<br>
>> >> <a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br>
>> >> <a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
>> >> pstn:<a href="tel:%2B19193869900" value="+19193869900">+19193869900</a><br>
>> >><br>
>> >> _______________________________________________<br>
>> >> Join us at ClueCon 2011, Aug 9-11, Chicago<br>
>> >> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
>> >><br>
>> >> FreeSWITCH-users mailing list<br>
>> >> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> >> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> >><br>
>> >> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> >> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> ><br>
>> ><br>
>> > _______________________________________________<br>
>> > Join us at ClueCon 2011, Aug 9-11, Chicago<br>
>> > <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
>> ><br>
>> > FreeSWITCH-users mailing list<br>
>> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> ><br>
>> ><br>
>><br>
>><br>
>><br>
>> --<br>
>> Anthony Minessale II<br>
>><br>
>> FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
>> ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
>> Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
>><br>
>> AIM: anthm<br>
>> <a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>
>> GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
>> IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
>><br>
>> FreeSWITCH Developer Conference<br>
>> <a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br>
>> <a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
>> pstn:<a href="tel:%2B19193869900" value="+19193869900">+19193869900</a><br>
>><br>
>> _______________________________________________<br>
>> Join us at ClueCon 2011, Aug 9-11, Chicago<br>
>> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
>><br>
>> FreeSWITCH-users mailing list<br>
>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
> _______________________________________________<br>
> Join us at ClueCon 2011, Aug 9-11, Chicago<br>
> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
><br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
<br>
<br>
<br>
--<br>
Anthony Minessale II<br>
<br>
FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
<br>
AIM: anthm<br>
<a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
<br>
FreeSWITCH Developer Conference<br>
<a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:<a href="tel:%2B19193869900" value="+19193869900">+19193869900</a><br>
<br>
_______________________________________________<br>
Join us at ClueCon 2011, Aug 9-11, Chicago<br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br></div></div>