I just upgraded FS since.. 7 weeks ago I think. Now: FreeSWITCH Version 1.0.head (git-9d98d49 2011-08-10 08-38-55 -0500) While testing the new build clean, when I hit F4 for show calls, I now get: freeswitch@internal> 2011-08-11 14:24:04.574797 [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 Aren't the core odbc tables supposed to be auto-created? -Avi
its a view that should be created? perhaps there is an error on startup creating the view in mysuckwell? On Thu, Aug 11, 2011 at 6:28 AM, Avi Marcus <avi@avimarcus.net> wrote:
I just upgraded FS since.. 7 weeks ago I think. Now: FreeSWITCH Version 1.0.head (git-9d98d49 2011-08-10 08-38-55 -0500) While testing the new build clean, when I hit F4 for show calls, I now get: freeswitch@internal> 2011-08-11 14:24:04.574797 [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 Aren't the core odbc tables supposed to be auto-created? -Avi _______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
I don't see anything in the startup log about it checking the tables: http://pastebin.freeswitch.org/17013 This happens when I do "show calls". I know you changed something for show calls to even show 1 legged IVRs since my last update, but not having looked at the code, I don't see how that would be related. I haven't heard of this basic_calls table before today. -Avi Marcus On Thu, Aug 11, 2011 at 4:33 PM, Anthony Minessale < anthony.minessale@gmail.com> wrote:
its a view that should be created? perhaps there is an error on startup creating the view in mysuckwell?
On Thu, Aug 11, 2011 at 6:28 AM, Avi Marcus <avi@avimarcus.net> wrote:
I just upgraded FS since.. 7 weeks ago I think. Now: FreeSWITCH Version 1.0.head (git-9d98d49 2011-08-10 08-38-55 -0500) While testing the new build clean, when I hit F4 for show calls, I now get: freeswitch@internal> 2011-08-11 14:24:04.574797 [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 Aren't the core odbc tables supposed to be auto-created? -Avi _______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Could you try to create it manually? The view's definition is in switch_core_sqldb.c on line 1721. /Peter ________________________________________ Från: freeswitch-users-bounces@lists.freeswitch.org [freeswitch-users-bounces@lists.freeswitch.org] för Avi Marcus [avi@avimarcus.net] Skickat: den 11 augusti 2011 15:48 Till: FreeSWITCH Users Help Ämne: Re: [Freeswitch-users] odbc basic_calls I don't see anything in the startup log about it checking the tables: http://pastebin.freeswitch.org/17013 This happens when I do "show calls". I know you changed something for show calls to even show 1 legged IVRs since my last update, but not having looked at the code, I don't see how that would be related. I haven't heard of this basic_calls table before today. -Avi Marcus On Thu, Aug 11, 2011 at 4:33 PM, Anthony Minessale <anthony.minessale@gmail.com<mailto:anthony.minessale@gmail.com>> wrote: its a view that should be created? perhaps there is an error on startup creating the view in mysuckwell? On Thu, Aug 11, 2011 at 6:28 AM, Avi Marcus <avi@avimarcus.net<mailto:avi@avimarcus.net>> wrote:
I just upgraded FS since.. 7 weeks ago I think. Now: FreeSWITCH Version 1.0.head (git-9d98d49 2011-08-10 08-38-55 -0500) While testing the new build clean, when I hit F4 for show calls, I now get: freeswitch@internal> 2011-08-11 14:24:04.574797 [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 Aren't the core odbc tables supposed to be auto-created? -Avi _______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@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@hotmail.com<mailto:MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net<http://irc.freenode.net> #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org<mailto:sip%3A888@conference.freeswitch.org> googletalk:conf+888@conference.freeswitch.org<mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900<tel:%2B19193869900> _______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org !DSPAM:4e43de1032765001342651!
Error in query: Unknown column 'a.sent_callee_name' in 'field list' So table channels.. no, I don't see that in there. I see callee_name in there though. Did it miss some channel table alterations? Huh, tables complete, db_data, interfaces and a few more all seem new. I've been running odbc in mysql for a year? but I've never seen these until now. -Avi Marcus p.s. move this to jira now that it's back up..? On Thu, Aug 11, 2011 at 5:02 PM, Peter Olsson < peter.olsson@visionutveckling.se> wrote:
Could you try to create it manually? The view's definition is in switch_core_sqldb.c on line 1721.
/Peter ________________________________________ Från: freeswitch-users-bounces@lists.freeswitch.org [ freeswitch-users-bounces@lists.freeswitch.org] för Avi Marcus [ avi@avimarcus.net] Skickat: den 11 augusti 2011 15:48 Till: FreeSWITCH Users Help Ämne: Re: [Freeswitch-users] odbc basic_calls
I don't see anything in the startup log about it checking the tables: http://pastebin.freeswitch.org/17013 This happens when I do "show calls". I know you changed something for show calls to even show 1 legged IVRs since my last update, but not having looked at the code, I don't see how that would be related. I haven't heard of this basic_calls table before today.
-Avi Marcus
On Thu, Aug 11, 2011 at 4:33 PM, Anthony Minessale < anthony.minessale@gmail.com<mailto:anthony.minessale@gmail.com>> wrote: its a view that should be created? perhaps there is an error on startup creating the view in mysuckwell?
On Thu, Aug 11, 2011 at 6:28 AM, Avi Marcus <avi@avimarcus.net<mailto: avi@avimarcus.net>> wrote:
I just upgraded FS since.. 7 weeks ago I think. Now: FreeSWITCH Version 1.0.head (git-9d98d49 2011-08-10 08-38-55 -0500) While testing the new build clean, when I hit F4 for show calls, I now get: freeswitch@internal> 2011-08-11 14:24:04.574797 [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 Aren't the core odbc tables supposed to be auto-created? -Avi _______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto: FreeSWITCH-users@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@hotmail.com<mailto: MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<mailto: PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net<http://irc.freenode.net> #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org<mailto: sip%3A888@conference.freeswitch.org> googletalk:conf+888@conference.freeswitch.org<mailto: googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900<tel:%2B19193869900>
_______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto: FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
!DSPAM:4e43de1032765001342651!
_______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
I dropped and recreated the channels table, which doesn't have callee_name but sent_callee_name now. Then when I created the view manually, it worked, but none of this got triggered to happen automatically. -Avi On Fri, Aug 12, 2011 at 3:05 PM, Avi Marcus <avi@avimarcus.net> wrote:
Error in query: Unknown column 'a.sent_callee_name' in 'field list' So table channels.. no, I don't see that in there. I see callee_name in there though. Did it miss some channel table alterations?
Huh, tables complete, db_data, interfaces and a few more all seem new. I've been running odbc in mysql for a year? but I've never seen these until now.
-Avi Marcus
p.s. move this to jira now that it's back up..?
On Thu, Aug 11, 2011 at 5:02 PM, Peter Olsson < peter.olsson@visionutveckling.se> wrote:
Could you try to create it manually? The view's definition is in switch_core_sqldb.c on line 1721.
/Peter ________________________________________ Från: freeswitch-users-bounces@lists.freeswitch.org [ freeswitch-users-bounces@lists.freeswitch.org] för Avi Marcus [ avi@avimarcus.net] Skickat: den 11 augusti 2011 15:48 Till: FreeSWITCH Users Help Ämne: Re: [Freeswitch-users] odbc basic_calls
I don't see anything in the startup log about it checking the tables: http://pastebin.freeswitch.org/17013 This happens when I do "show calls". I know you changed something for show calls to even show 1 legged IVRs since my last update, but not having looked at the code, I don't see how that would be related. I haven't heard of this basic_calls table before today.
-Avi Marcus
On Thu, Aug 11, 2011 at 4:33 PM, Anthony Minessale < anthony.minessale@gmail.com<mailto:anthony.minessale@gmail.com>> wrote: its a view that should be created? perhaps there is an error on startup creating the view in mysuckwell?
On Thu, Aug 11, 2011 at 6:28 AM, Avi Marcus <avi@avimarcus.net<mailto: avi@avimarcus.net>> wrote:
I just upgraded FS since.. 7 weeks ago I think. Now: FreeSWITCH Version 1.0.head (git-9d98d49 2011-08-10 08-38-55 -0500) While testing the new build clean, when I hit F4 for show calls, I now get: freeswitch@internal> 2011-08-11 14:24:04.574797 [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 Aren't the core odbc tables supposed to be auto-created? -Avi _______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto: FreeSWITCH-users@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@hotmail.com<mailto: MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<mailto: PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net<http://irc.freenode.net> #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org<mailto: sip%3A888@conference.freeswitch.org> googletalk:conf+888@conference.freeswitch.org<mailto: googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900<tel:%2B19193869900>
_______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto: FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
!DSPAM:4e43de1032765001342651!
_______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
I think i fixed it in tree now so it will On Sun, Aug 14, 2011 at 12:00 PM, Avi Marcus <avi@avimarcus.net> wrote:
I dropped and recreated the channels table, which doesn't have callee_name but sent_callee_name now. Then when I created the view manually, it worked, but none of this got triggered to happen automatically. -Avi
On Fri, Aug 12, 2011 at 3:05 PM, Avi Marcus <avi@avimarcus.net> wrote:
Error in query: Unknown column 'a.sent_callee_name' in 'field list' So table channels.. no, I don't see that in there. I see callee_name in there though. Did it miss some channel table alterations? Huh, tables complete, db_data, interfaces and a few more all seem new. I've been running odbc in mysql for a year? but I've never seen these until now. -Avi Marcus
p.s. move this to jira now that it's back up..?
On Thu, Aug 11, 2011 at 5:02 PM, Peter Olsson <peter.olsson@visionutveckling.se> wrote:
Could you try to create it manually? The view's definition is in switch_core_sqldb.c on line 1721.
/Peter ________________________________________ Från: freeswitch-users-bounces@lists.freeswitch.org [freeswitch-users-bounces@lists.freeswitch.org] för Avi Marcus [avi@avimarcus.net] Skickat: den 11 augusti 2011 15:48 Till: FreeSWITCH Users Help Ämne: Re: [Freeswitch-users] odbc basic_calls
I don't see anything in the startup log about it checking the tables: http://pastebin.freeswitch.org/17013 This happens when I do "show calls". I know you changed something for show calls to even show 1 legged IVRs since my last update, but not having looked at the code, I don't see how that would be related. I haven't heard of this basic_calls table before today.
-Avi Marcus
On Thu, Aug 11, 2011 at 4:33 PM, Anthony Minessale <anthony.minessale@gmail.com<mailto:anthony.minessale@gmail.com>> wrote: its a view that should be created? perhaps there is an error on startup creating the view in mysuckwell?
On Thu, Aug 11, 2011 at 6:28 AM, Avi Marcus <avi@avimarcus.net<mailto:avi@avimarcus.net>> wrote:
I just upgraded FS since.. 7 weeks ago I think. Now: FreeSWITCH Version 1.0.head (git-9d98d49 2011-08-10 08-38-55 -0500) While testing the new build clean, when I hit F4 for show calls, I now get: freeswitch@internal> 2011-08-11 14:24:04.574797 [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 Aren't the core odbc tables supposed to be auto-created? -Avi _______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@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@hotmail.com<mailto:MSN%3Aanthony_minessale@hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net<http://irc.freenode.net> #freeswitch
FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org<mailto:sip%3A888@conference.freeswitch.org>
googletalk:conf+888@conference.freeswitch.org<mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900<tel:%2B19193869900>
_______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
!DSPAM:4e43de1032765001342651!
_______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
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-tp6676013p667... Sent from the freeswitch-users mailing list archive at Nabble.com.
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@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-tp6676013p667... 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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
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@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@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-tp6676013p667... 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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@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@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-tp6676013p667... 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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
I didn't think to try it twice. But no, freeswitch@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@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@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@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@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@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@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-tp6676013p667...
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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@avimarcus.net> wrote:
I didn't think to try it twice. But no, freeswitch@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@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@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@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@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@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@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-tp6676013p667... 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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
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@gmail.com> wrote:
the create stmt for the view must be offending it. Maybe you can dig up the error in your logs?
I didn't think to try it twice. But no, freeswitch@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@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@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@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@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
On Thu, Aug 11, 2011 at 5:18 PM, Avi Marcus <avi@avimarcus.net> wrote: *
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@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@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-tp6676013p667...
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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Maybe MySQL has a log of its own somewhere? On Aug 11, 2011 5:43 PM, "Avi Marcus" <avi@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@gmail.com> wrote:
the create stmt for the view must be offending it. Maybe you can dig up the error in your logs?
I didn't think to try it twice. But no, freeswitch@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@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@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@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@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
On Thu, Aug 11, 2011 at 5:18 PM, Avi Marcus <avi@avimarcus.net> wrote: *
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@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@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-tp6676013p667...
> 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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
I turned on verbose logging which is supposed to show failed error too, but I've got nothing. Perhaps the create isn't being triggered? Is there a way to see that debug in the fs_cli somehow? -Avi On Fri, Aug 12, 2011 at 1:45 AM, Anthony Minessale < anthony.minessale@gmail.com> wrote:
Maybe MySQL has a log of its own somewhere? On Aug 11, 2011 5:43 PM, "Avi Marcus" <avi@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@gmail.com> wrote:
the create stmt for the view must be offending it. Maybe you can dig up the error in your logs?
I didn't think to try it twice. But no, freeswitch@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@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@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@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@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
On Thu, Aug 11, 2011 at 5:18 PM, Avi Marcus <avi@avimarcus.net> wrote: *
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@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@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-tp6676013p667...
> > 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@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@hotmail.com > GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com > IRC: irc.freenode.net #freeswitch > > FreeSWITCH Developer Conference > sip:888@conference.freeswitch.org > googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@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@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (4)
-
Anthony Minessale
-
Avi Marcus
-
mazilo
-
Peter Olsson