[Freeswitch-users] SQL ERR while running freeswitch

Thu Nov 1 00:55:12 MSK 2012

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 at 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 at lists.freeswitch.org [mailto:
> freeswitch-users-bounces at 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 at 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 at lists.freeswitch.org [mailto:
> freeswitch-users-bounces at 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 at lists.freeswitch.org [mailto:
> freeswitch-users-bounces at 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 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****
>
> ** **
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at 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 at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121031/612ae15c/attachment-0001.html 