[Freeswitch-users] SQL ERR while running freeswitch

[Tim Meade]

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 at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Archana Venugopan
Sent: Tuesday, October 30, 2012 1:53 PM
To: freeswitch-users at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121030/6315f323/attachment-0001.html