Re: [Freeswitch-users] Using odbc in FS core

2009-11-23 Thread Mike Tkachuk
Title: Re[2]: [Freeswitch-users] Using odbc in FS core Hello Anthony, Is clear, thanks, I'll test and will let you know. Should I add 'core-db-dsn' parameter description to Wiki? Maybe we need to add this parameter also to sample conf files? Saturday, November 21, 2009 6:14:59 PM, you wrote

Re: [Freeswitch-users] Using odbc in FS core

2009-11-23 Thread Mike Tkachuk
Title: Re[2]: [Freeswitch-users] Using odbc in FS core Hello, Database schema creation is OK now. Cheers. Monday, November 23, 2009 1:45:28 PM, you wrote: Hello Anthony, Is clear, thanks, I'll test and will let you know. Should I add 'core-db-dsn' parameter description to Wiki

Re: [Freeswitch-users] Using odbc in FS core

2009-11-23 Thread Michael Jerris
Yes please On Nov 23, 2009, at 6:45 AM, Mike Tkachuk wrote: Hello Anthony, Is clear, thanks, I'll test and will let you know. Should I add 'core-db-dsn' parameter description to Wiki? Maybe we need to add this parameter also to sample conf files?

[Freeswitch-users] Using odbc in FS core

2009-11-21 Thread Mike Tkachuk
Hello Folks, I'm interesting in completely moving away from sqlite and use postgresql everywhere including core ( switch_core.c ) All other applications can use odbc without issues (sofia, limit, fifo etc), but as I see in core only sqlite3 supported. I correctly set 'core-db-dsn'

Re: [Freeswitch-users] Using odbc in FS core

2009-11-21 Thread Mike Tkachuk
Hello, Looks like the issue is not in multi statements in one request. Manually creating DB schema helped and everything started up. I will continue testing Also in code I see such construction: switch_cache_db_execute_sql(dbh, begin;delete from channels where hostname='';delete from

Re: [Freeswitch-users] Using odbc in FS core

2009-11-21 Thread Anthony Minessale
we had the code slightly out of order, you should update to latest trunk for the right version. The test of 2 deletes is to see if your odbc driver will fail when trying to execute 2 statements at once so I can properly fail over to sqlite because transactions are mandatory for a database running