We've got a MSSQL server that I was hoping to put to use as an ODBC data source for FS. I can connect via ODBS to the database from the FS box and run queries using tsql. FS also appears to be able to connect to the database, as it creates several tables when it starts up. After successfully creating tables, it appears to run a test query, receives an error from which it concludes that transactions are not supported and then disables ODBC. Is MSSQL expected to work with ODBC and FS? It does successfully create tables. Does this mean that FS disabling ODBC is a bug that should be reported in jira? Is there something I should be setting in the config other than <param name="core-db-dsn" value="DSN:USERID:PASSWORD" /> Thanks, Peter Log snippet below: 2010-10-05 15:37:33.169737 [INFO] switch_core_sqldb.c:1275 Opening DB 2010-10-05 15:37:33.234702 [ERR] switch_odbc.c:427 ERR: [begin;delete from channels where hostname='';delete from channels where hostname='';commit;] [STATE: 42000 CODE 102 ERROR: [FreeTDS][SQL Server]Incorrect syntax near ';'. ] 2010-10-05 15:37:33.234775 [ERR] switch_core_sqldb.c:404 SQL ERR [STATE: 42000 CODE 8180 ERROR: [FreeTDS][SQL Server]Statement(s) could not be prepared. ] begin;delete from channels where hostname='';delete from channels where hostname='';commit; 2010-10-05 15:37:33.234796 [ERR] switch_core_sqldb.c:1326 Transactions not supported on your DB, disabling ODBC 2010-10-05 15:37:33.235916 [INFO] switch_core_sqldb.c:1275 Opening DB Thanks, Peter
This is a known issue, and is waiting for submittal. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/ODBC-and-MSSQL-tp5605076p56055... Sent from the freeswitch-users mailing list archive at Nabble.com.
Hi Peter, If your so inclined please test the patch here: http://jira.freeswitch.org/browse/FS-2050 and please let me know how it works for you. After patching and building remove commented -> <!-- --> -Jeff -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/ODBC-and-MSSQL-tp5605076p56114... Sent from the freeswitch-users mailing list archive at Nabble.com.
I'm certainly interested. It may take me a couple of days to get to it. I'll let you know how it goes for me. Peter On 10/7/2010 7:46 AM, Jeff Lenk wrote:
Hi Peter,
If your so inclined please test the patch here: http://jira.freeswitch.org/browse/FS-2050
and please let me know how it works for you.
After patching and building remove commented -> <!-- -->
-Jeff
Hi Jeff - The initial test looks good. Patched, compiled, and started on two different FreeBSD boxes. Tables appear to have been created on the database correctly. I'll do some further testing today and then try it on a live system after that. Thanks for putting this together! Peter On 10/7/2010 7:46 AM, Jeff Lenk wrote:
Hi Peter,
If your so inclined please test the patch here: http://jira.freeswitch.org/browse/FS-2050
and please let me know how it works for you.
After patching and building remove commented -> <!-- -->
-Jeff
Thanks Peter, btw that patch was committed yesterday to git with some minor modifications which do not change any functionality(MSSQL). It also preserves previous table compatibility for non MSSQL based instances of fs. -Jeff -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/ODBC-and-MSSQL-tp5605076p56628... Sent from the freeswitch-users mailing list archive at Nabble.com.
:) I must have looked at the Jira yesterday before you made the commit. I'll try the current git. Thanks again. Peter On 10/22/2010 9:13 AM, Jeff Lenk wrote:
Thanks Peter,
btw that patch was committed yesterday to git with some minor modifications which do not change any functionality(MSSQL). It also preserves previous table compatibility for non MSSQL based instances of fs.
-Jeff
Hi Jeff - I've been running a build from 10/22 with the MSSQL ODBC code. By and large it is working great. Periodically though, I get the following message. [DEBUG] switch_core_sqldb.c:715 SQL Retry [Unable to Set AutoCommit Off.] The message repeats very rapidly for 10 seconds, and then it's quite for a while longer again. Any thoughts on what is causing this, or weather it is even a real concern, or what should be done? Is this the sort of thing that should be reported in Jira instead of here? Thanks, Peter On 10/22/2010 9:13 AM, Jeff Lenk wrote:
Thanks Peter,
btw that patch was committed yesterday to git with some minor modifications which do not change any functionality(MSSQL). It also preserves previous table compatibility for non MSSQL based instances of fs.
-Jeff
Strange I will look into it! Sure open a Jira and assign it to me so I dont forget. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/ODBC-and-MSSQL-tp5605076p57095... Sent from the freeswitch-users mailing list archive at Nabble.com.
participants (2)
-
Jeff Lenk
-
Peter Hinman