[Freeswitch-users] ODBC, FreeTDS, Microsoft SQL

[Tim Meade]

I've found a work around using the Microsoft SQL drivers instead of FreeTDS.

Following most of this:

                http://msdn.microsoft.com/en-us/library/hh568454.aspx

                and download here: http://www.microsoft.com/en-us/download/details.aspx?id=28160

Great install instructions:

                                http://blog.nhaslam.com/2011/12/12/sql-server-odbc-on-linux/


and setting the obc.ini to:

[freeswitch]
Driver   = SQL Server Native Client 11.0
Description =  FS SQL Tester
Trace = No
Server = 192.168.5.10
Port = 1433
Database = FSTester

All the tables are created properly.

Tim

From: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Tim Meade
Sent: Saturday, July 28, 2012 11:25 AM
To: FreeSWITCH Users Help
Subject: [Freeswitch-users] ODBC, FreeTDS, Microsoft SQL

We wanted to run some ODBC tests using a MSSQL backend.

We setup the ODBC with MySQL and everything worked great.   Then installed FreeTDS and configured it instead of MySQL.

When FS restarted, it created some of the required tables. Calls, complete, interfaces, nat, sip_presence, sip_recovery, sip_shared_apperance_subscriptions.

What it did not create was any of the registrations tables.

When a device tries to register, FS shows in the CLI:

012-07-28 09:43:48.892312 [INFO] switch_odbc.c:285 The connection has been re-established
2012-07-28 09:43:49.912319 [ERR] switch_odbc.c:494 ERR: [create index sr_sip_host on sip_registrations (sip_host)]
[STATE: 42000 CODE 1088 ERROR: [unixODBC][FreeTDS][SQL Server]Cannot find the object "sip_registrations" because it does not exist or you do not have permissions.
]
2012-07-28 09:43:49.912319 [ERR] switch_core_sqldb.c:487 SQL ERR [STATE: 42000 CODE 1088 ERROR: [unixODBC][FreeTDS][SQL Server]Cannot find the object "sip_registrations" because it does not exist or you do not have permissions.
]
create index sr_sip_host on sip_registrations (sip_host)
2012-07-28 09:43:49.912319 [CRIT] switch_odbc.c:280 The sql server is not responding for DSN freeswitch [STATE: 42000 CODE 1088 ERROR: [unixODBC][FreeTDS][SQL Server]Cannot find the object "sip_registrations" because it does not exist or you do not have permissions.
][244]

Seems the issue is that FS didn't create all the appropriate tables on start.   Has anyone else seen something like this?   I cannot find much on using FS with FreeTDS and MSSQL.

Thanks

Tim

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120728/5500fdab/attachment-0001.html