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 core in odbc. On Sat, Nov 21, 2009 at 6:02 AM, Mike Tkachuk <m...@yes.net.ua> wrote: > 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 channels where hostname='';commit;", &err); > Anyone can explain why to do such delete twice and in transaction? > > Thanks. > > > > Saturday, November 21, 2009 1:41:06 PM, you wrote: > > MT> Hello Folks, > > MT> I'm interesting in completely moving away from sqlite and use > MT> postgresql everywhere including core ( switch_core.c ) > > MT> All other applications can use odbc without issues (sofia, limit, > MT> fifo etc), but as I see in core only sqlite3 supported. > > MT> I correctly set 'core-db-dsn' parameter, but looks like the problem > MT> that latest psqlodbc_08_04_0100 don't support multiple statements in > MT> one request that is often used in switch_core_sqldb.c: > > >> sql = switch_mprintf( > >> "update channels set uuid='%q' where uuid='%q' and hostname='%q';" > >> "update calls set caller_uuid='%q' where caller_uuid='%q' and > hostname='%q';" > >> "update calls set callee_uuid='%q' where callee_uuid='%q' and > hostname='%q'", > >> switch_event_get_header_nil(event, "unique-id"), > >> ... SKIP ... > > MT> So, does anyone have any clue how to us postgresql in the FS core? > > MT> Thanks. > > MT> -- > MT> Mike Tkachuk > > > > -- > Mike Tkachuk > > > _______________________________________________ > 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_miness...@hotmail.com <msn%3aanthony_miness...@hotmail.com> GTALK/JABBER/PAYPAL:anthony.miness...@gmail.com<paypal%3aanthony.miness...@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:8...@conference.freeswitch.org <sip%3a...@conference.freeswitch.org> iax:gu...@conference.freeswitch.org/888 googletalk:conf+...@conference.freeswitch.org<googletalk%3aconf%2b...@conference.freeswitch.org> pstn:213-799-1400
_______________________________________________ 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