<div dir="ltr">I turned on verbose logging which is supposed to show failed error too, but I've got nothing.<div>Perhaps the create isn't being triggered? Is there a way to see that debug in the fs_cli somehow?</div>
<div><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:45 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;">
<p>Maybe MySQL has a log of its own somewhere?<br>
</p><div><div></div><div class="h5">
<div class="gmail_quote">On Aug 11, 2011 5:43 PM, "Avi Marcus" <<a href="mailto:avi@avimarcus.net" target="_blank">avi@avimarcus.net</a>> wrote:<br type="attribution">> Where would those logs be?<br>> A "grep -ir basic_calls /var/logs/*" returned nothing and I don't see how to<br>
> get beyond /log 7, although I'm sure I've done it before.<br>> -Avi<br>> <br>> <br>> On Fri, Aug 12, 2011 at 1:33 AM, Anthony Minessale <<br>> <a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>> wrote:<br>
> <br>>> the create stmt for the view must be offending it.<br>>> Maybe you can dig up the error in your logs?<br>>><br>>><br>>> On Thu, Aug 11, 2011 at 5:18 PM, Avi Marcus <<a href="mailto:avi@avimarcus.net" target="_blank">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]<br>>> 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]<br>>> 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" target="_blank">anthony.minessale@gmail.com</a>> wrote:<br>
>> >><br>>> >> that's good, the error should be what triggered the creation of the<br>>> view,<br>>> >><br>>> >> On Thu, Aug 11, 2011 at 3:22 PM, Avi Marcus <<a href="mailto:avi@avimarcus.net" target="_blank">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>
>> *<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" target="_blank">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 <<br>
>> <a href="mailto:Nabble@slickdeals.endjunk.com" target="_blank">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.<br>>> 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>>> >> >> ><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" target="_blank">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:<br>
>> <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" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>>> >> >> GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">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" target="_blank">sip:888@conference.freeswitch.org</a><br>
>> >> >> <a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>>> >> >> pstn:<a href="tel:%2B19193869900" value="+19193869900" target="_blank">+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" target="_blank">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:<br>>> <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" target="_blank">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:<br>>> <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" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>>> >> GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">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" target="_blank">sip:888@conference.freeswitch.org</a><br>
>> >> <a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>>> >> pstn:<a href="tel:%2B19193869900" value="+19193869900" target="_blank">+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" target="_blank">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:<br>>> <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" target="_blank">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" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>>> GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">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" target="_blank">sip:888@conference.freeswitch.org</a><br>
>> <a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>>> pstn:<a href="tel:%2B19193869900" value="+19193869900" target="_blank">+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" target="_blank">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></div>
</div></div><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></blockquote></div><br></div></div>