Hi all, I have been facing issues while running freeswitch and I am facing with the below errors and I have installed the latest version of git. I have configured /etc/odbc.ini with the username and password. 012-10-29 16:53:22.108686 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Auto Generating Table! 2012-10-29 16:53:22.108761 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_registrations] [drop table sip_registrations] 2012-10-29 16:53:22.111151 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111246 [DEBUG] sofia.c:2413 Creating agent for internal 2012-10-29 16:53:22.111424 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111485 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_subscriptions] [DROP TABLE sip_subscriptions] 2012-10-29 16:53:22.112236 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Please do guide me on this. Many thanks. Regards, Archana
I know it's simple, but did you restart Freeswitch after configuring odbc.ini so that FS would create the appropriate tables? From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Archana Venugopan Sent: Tuesday, October 30, 2012 1:53 PM To: freeswitch-users@lists.freeswitch.org Subject: [Freeswitch-users] SQL ERR while running freeswitch Hi all, I have been facing issues while running freeswitch and I am facing with the below errors and I have installed the latest version of git. I have configured /etc/odbc.ini with the username and password. 012-10-29 16:53:22.108686 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Auto Generating Table! 2012-10-29 16:53:22.108761 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_registrations] [drop table sip_registrations] 2012-10-29 16:53:22.111151 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111246 [DEBUG] sofia.c:2413 Creating agent for internal 2012-10-29 16:53:22.111424 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111485 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_subscriptions] [DROP TABLE sip_subscriptions] 2012-10-29 16:53:22.112236 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Please do guide me on this. Many thanks. Regards, Archana
Hi, As per the installation procedure after changing odbc.ini I ran this command /usr/local/freeswitch/bin/freeswitch After which I got this error. Regards, Archana From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Tim Meade Sent: 30 October 2012 18:42 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] SQL ERR while running freeswitch I know it's simple, but did you restart Freeswitch after configuring odbc.ini so that FS would create the appropriate tables? From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Archana Venugopan Sent: Tuesday, October 30, 2012 1:53 PM To: freeswitch-users@lists.freeswitch.org Subject: [Freeswitch-users] SQL ERR while running freeswitch Hi all, I have been facing issues while running freeswitch and I am facing with the below errors and I have installed the latest version of git. I have configured /etc/odbc.ini with the username and password. 012-10-29 16:53:22.108686 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Auto Generating Table! 2012-10-29 16:53:22.108761 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_registrations] [drop table sip_registrations] 2012-10-29 16:53:22.111151 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111246 [DEBUG] sofia.c:2413 Creating agent for internal 2012-10-29 16:53:22.111424 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111485 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_subscriptions] [DROP TABLE sip_subscriptions] 2012-10-29 16:53:22.112236 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Please do guide me on this. Many thanks. Regards, Archana
Hi, Database connection is executed [root@squay-laptop-1 log]# isql -v SMEPBX smepbx smeswitch +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> But still when I run freeswitch I am getting SQL ERR errors. Can someone please help me out, this looks so peculiar for me. Many thanks. Regards, Archana From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Archana Venugopan Sent: 31 October 2012 08:46 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] SQL ERR while running freeswitch Hi, As per the installation procedure after changing odbc.ini I ran this command /usr/local/freeswitch/bin/freeswitch After which I got this error. Regards, Archana From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Tim Meade Sent: 30 October 2012 18:42 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] SQL ERR while running freeswitch I know it's simple, but did you restart Freeswitch after configuring odbc.ini so that FS would create the appropriate tables? From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Archana Venugopan Sent: Tuesday, October 30, 2012 1:53 PM To: freeswitch-users@lists.freeswitch.org Subject: [Freeswitch-users] SQL ERR while running freeswitch Hi all, I have been facing issues while running freeswitch and I am facing with the below errors and I have installed the latest version of git. I have configured /etc/odbc.ini with the username and password. 012-10-29 16:53:22.108686 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Auto Generating Table! 2012-10-29 16:53:22.108761 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_registrations] [drop table sip_registrations] 2012-10-29 16:53:22.111151 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111246 [DEBUG] sofia.c:2413 Creating agent for internal 2012-10-29 16:53:22.111424 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111485 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_subscriptions] [DROP TABLE sip_subscriptions] 2012-10-29 16:53:22.112236 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Please do guide me on this. Many thanks. Regards, Archana
Hi, To give you further information. This is my version FreeSWITCH Version 1.2.3+git~20121004T033301Z~94664868a8 (1.2.3; git at commit 94664868a8 on Thu, 04 Oct 2012 03:33:01 Z) Regards, Archana From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Archana Venugopan Sent: 31 October 2012 12:40 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] SQL ERR while running freeswitch Hi, Database connection is executed [root@squay-laptop-1 log]# isql -v SMEPBX smepbx smeswitch +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> But still when I run freeswitch I am getting SQL ERR errors. Can someone please help me out, this looks so peculiar for me. Many thanks. Regards, Archana From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Archana Venugopan Sent: 31 October 2012 08:46 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] SQL ERR while running freeswitch Hi, As per the installation procedure after changing odbc.ini I ran this command /usr/local/freeswitch/bin/freeswitch After which I got this error. Regards, Archana From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Tim Meade Sent: 30 October 2012 18:42 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] SQL ERR while running freeswitch I know it's simple, but did you restart Freeswitch after configuring odbc.ini so that FS would create the appropriate tables? From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Archana Venugopan Sent: Tuesday, October 30, 2012 1:53 PM To: freeswitch-users@lists.freeswitch.org Subject: [Freeswitch-users] SQL ERR while running freeswitch Hi all, I have been facing issues while running freeswitch and I am facing with the below errors and I have installed the latest version of git. I have configured /etc/odbc.ini with the username and password. 012-10-29 16:53:22.108686 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Auto Generating Table! 2012-10-29 16:53:22.108761 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_registrations] [drop table sip_registrations] 2012-10-29 16:53:22.111151 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111246 [DEBUG] sofia.c:2413 Creating agent for internal 2012-10-29 16:53:22.111424 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX'] Auto Generating Table! 2012-10-29 16:53:22.111485 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_subscriptions] [DROP TABLE sip_subscriptions] 2012-10-29 16:53:22.112236 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Please do guide me on this. Many thanks. Regards, Archana
Probably some permission problem on the user, check error logs in your db. On Wed, Oct 31, 2012 at 10:05 AM, Archana Venugopan <a.venugopan@mundio.com>wrote:
Hi,****
** **
To give you further information. This is my version****
** **
FreeSWITCH Version 1.2.3+git~20121004T033301Z~94664868a8 (1.2.3; git at commit 94664868a8 on Thu, 04 Oct 2012 03:33:01 Z)****
** **
Regards,****
Archana****
** **
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *On Behalf Of *Archana Venugopan *Sent:* 31 October 2012 12:40
*To:* FreeSWITCH Users Help *Subject:* Re: [Freeswitch-users] SQL ERR while running freeswitch****
** **
Hi,****
Database connection is executed****
[root@squay-laptop-1 log]# isql -v SMEPBX smepbx smeswitch****
+---------------------------------------+****
| Connected! |****
| |****
| sql-statement |****
| help [tablename] |****
| quit |****
| |****
+---------------------------------------+****
SQL>****
** **
But still when I run freeswitch I am getting SQL ERR errors. Can someone please help me out, this looks so peculiar for me. ****
Many thanks.****
** **
** **
Regards,****
Archana****
** **
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *On Behalf Of *Archana Venugopan *Sent:* 31 October 2012 08:46 *To:* FreeSWITCH Users Help *Subject:* Re: [Freeswitch-users] SQL ERR while running freeswitch****
** **
Hi,****
As per the installation procedure after changing odbc.ini I ran this command****
** **
/usr/local/freeswitch/bin/freeswitch****
** **
After which I got this error.****
** **
Regards,****
Archana****
** **
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *On Behalf Of *Tim Meade *Sent:* 30 October 2012 18:42 *To:* FreeSWITCH Users Help *Subject:* Re: [Freeswitch-users] SQL ERR while running freeswitch****
** **
I know it’s simple, but did you restart Freeswitch after configuring odbc.ini so that FS would create the appropriate tables?****
** **
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *On Behalf Of *Archana Venugopan *Sent:* Tuesday, October 30, 2012 1:53 PM *To:* freeswitch-users@lists.freeswitch.org *Subject:* [Freeswitch-users] SQL ERR while running freeswitch****
** **
Hi all,****
** **
I have been facing issues while running freeswitch and I am facing with the below errors and I have installed the latest version of git. I have configured /etc/odbc.ini with the username and password.****
** **
012-10-29 16:53:22.108686 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations]****
[delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname=' squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%']****
Auto Generating Table!****
2012-10-29 16:53:22.108761 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_registrations]****
[drop table sip_registrations]****
2012-10-29 16:53:22.111151 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions]****
[delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX']****
Auto Generating Table!****
2012-10-29 16:53:22.111246 [DEBUG] sofia.c:2413 Creating agent for internal ****
2012-10-29 16:53:22.111424 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions]****
[delete from sip_subscriptions where hostname='squay-laptop-1.squay.com' and full_to='XXX']****
Auto Generating Table!****
2012-10-29 16:53:22.111485 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_subscriptions]****
[DROP TABLE sip_subscriptions]****
2012-10-29 16:53:22.112236 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations]****
[delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname=' squay-laptop-1.squay.com' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%']****
** **
Please do guide me on this. Many thanks.****
** **
Regards,****
Archana****
** **
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
participants (3)
-
Anthony Minessale
-
Archana Venugopan
-
Tim Meade