[Freeswitch-users] ODBC, FreeTDS, Microsoft SQL

[Tim Meade]

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/ea235ea8/attachment-0001.html