Re: [Freeswitch-users] Using odbc in FS core
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? Maybe we need to add this parameter also to sample conf files? Saturday, November 21, 2009 6:14:59 PM, you wrote: > 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 GTALK/JABBER/PAYPAL:anthony.miness...@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:8...@conference.freeswitch.org iax:gu...@conference.freeswitch.org/888 googletalk:conf+...@conference.freeswitch.org pstn:213-799-1400 -- 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
Re: [Freeswitch-users] Using odbc in FS core
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: > 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 GTALK/JABBER/PAYPAL:anthony.miness...@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:8...@conference.freeswitch.org iax:gu...@conference.freeswitch.org/888 googletalk:conf+...@conference.freeswitch.org pstn:213-799-1400 -- 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
Re: [Freeswitch-users] Using odbc in FS core
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
[Freeswitch-users] Using odbc in FS core
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' parameter, but looks like the problem that latest psqlodbc_08_04_0100 don't support multiple statements in 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 ... So, does anyone have any clue how to us postgresql in the FS core? Thanks. -- 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
Re: [Freeswitch-users] how to avoid many "|" in bridge application?
Hello Max,
Don't improve that what's working well. ;)
Wednesday, August 26, 2009 8:44:48 AM, you wrote:
>>
>> Continue_on_fail and hangup_after_bridge like tony pointed out are what you
>> want if you don’t want to use the | delimiting ... I use these all the time
>> with gateway counts > 10 just stacking additional actions for each bridge
>> line
MI> Let's imagine that I need to call 1000,1001,1002 via gw1,gw2,gw3 by
MI> choosing first available. How dialplan would look like?
MI> continue_on_fail=True
MI> hangup_after_bridge=True
MI> bridge gw1/1000
MI> bridge gw1/1001
MI> bridge gw1/1002
MI> bridge gw2/1000
MI> bridge gw2/1001
MI> bridge gw2/1002
MI> bridge gw3/1000
MI> bridge gw3/1001
MI> bridge gw3/1002
MI> Is it easy to understand? From my point of view it's not. Compare to this:
MI> continue_on_fail=True
MI> hangup_after_bridge=True
MI> bridge ${get_avail_gw(gw1,gw2,gw3)}/1000
MI> bridge ${get_avail_gw(gw1,gw2,gw3)}/1001
MI> bridge ${get_avail_gw(gw1,gw2,gw3)}/1002
--
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
Re: [Freeswitch-users] Stops accepting calls when idle for four minutes
Hello Greg, Should be no problem - only few more bytes of bandwidth used. Friday, May 8, 2009 9:23:49 PM, you wrote: GT> That solved it! Is there any downside to this method of keeping the nat binding alive? GT> -- GT> Greg GT> On May 8, 2009, at 12:49 PM, Mike Tkachuk wrote: GT> Hello Greg, GT> It's a NAT box issue. Nat bindings expire if no activity. GT> Try adding a: GT> GT> to your gateway params. GT> But to be honest it's flowroute duty to keep a connection alive by GT> sending keepalives. GT> -- GT> 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
Re: [Freeswitch-users] Stops accepting calls when idle for four minutes
Hello Greg, It's a NAT box issue. Nat bindings expire if no activity. Try adding a: to your gateway params. But to be honest it's flowroute duty to keep a connection alive by sending keepalives. -- 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
Re: [Freeswitch-users] Transcoding G723
Hello Freeswitch-users, Check this one: http://freehg.org/u/deepwalker/fs_g729/ G.729 is not G.723 but may be interesting. IPP have also g.723 implementation, not too hard to port. That code is working OK for me on development servers. -- Mike ___ 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
