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