we had the code slightly out of order, you should update to latest trunk for the right version.<br><br>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<br>
fail over to sqlite because transactions are mandatory for a database running core in odbc.<br><br><br><div class="gmail_quote">On Sat, Nov 21, 2009 at 6:02 AM, Mike Tkachuk <span dir="ltr"><<a href="mailto:mike@yes.net.ua">mike@yes.net.ua</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello,<br>
<br>
Looks like the issue is not in multi statements in one request.<br>
Manually creating DB schema helped and everything started up.<br>
I will continue testing<br>
<br>
Also in code I see such construction:<br>
> switch_cache_db_execute_sql(dbh, "begin;delete from channels where hostname='';delete from channels where hostname='';commit;", &err);<br>
Anyone can explain why to do such delete twice and in transaction?<br>
<br>
Thanks.<br>
<br>
<br>
<br>
Saturday, November 21, 2009 1:41:06 PM, you wrote:<br>
<br>
MT> Hello Folks,<br>
<br>
MT> I'm interesting in completely moving away from sqlite and use<br>
MT> postgresql everywhere including core ( switch_core.c )<br>
<br>
MT> All other applications can use odbc without issues (sofia, limit,<br>
MT> fifo etc), but as I see in core only sqlite3 supported.<br>
<br>
MT> I correctly set 'core-db-dsn' parameter, but looks like the problem<br>
MT> that latest psqlodbc_08_04_0100 don't support multiple statements in<br>
MT> one request that is often used in switch_core_sqldb.c:<br>
<div class="im"><br>
>> sql = switch_mprintf(<br>
>> "update channels set uuid='%q' where uuid='%q' and hostname='%q';"<br>
>> "update calls set caller_uuid='%q' where caller_uuid='%q' and hostname='%q';"<br>
>> "update calls set callee_uuid='%q' where callee_uuid='%q' and hostname='%q'",<br>
>> switch_event_get_header_nil(event, "unique-id"),<br>
>> ... SKIP ...<br>
<br>
</div>MT> So, does anyone have any clue how to us postgresql in the FS core?<br>
<br>
MT> Thanks.<br>
<br>
MT> --<br>
MT> Mike Tkachuk<br>
<div><div></div><div class="h5"><br>
<br>
<br>
--<br>
Mike Tkachuk<br>
<br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:213-799-1400<br>