Good day to you! Could you advise me with Freeswitch, please? I have load balancer (opensips) in front of 2 Freeswitch (fsw1 and fsw2) servers, each with their own hostname. The load balancing works fine, but the shared database did not work. I use PostgreSQL I add to external and internal sip profiles and sofia.conf.xml this: <param name="track-calls" value="true"/> <param name="core-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user password='password'"/> And to switch.conf.xml at fsw1: <param name="switchname" value="fsw1"/> <param name="track-calls" value="true"/> <param name="core-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user password='password'"/> <param name="core-recovery-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user password='password'"/> and at fsw2 the same,except hostname. There is not any errors, but the DB is empty. What I do wrong? Could you help me please? Thank you for your time, Best Regards.
Sure,I did that.but there is not any packets from freeswitches to the db. and there is not any errors. From: Avi Marcus Sent: Friday, July 18, 2014 1:13 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Freeswitch shared registration ᐧ Hmm, did you restart the profiles after this edit? -Avi
In case you didn't see my earlier message, your configuration is wrong. On SIP profiles the parameter is named 'odbc-dsn' not 'core-db-dsn'. Unknown parameters are (silently) ignored. On 18 July 2014 11:38, Nick Zaitsev <nick.zaitsev@mail.ru> wrote:
Sure,I did that.but there is not any packets from freeswitches to the db. and there is not any errors. *From:* Avi Marcus <avi@avimarcus.net> *Sent:* Friday, July 18, 2014 1:13 PM *To:* FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> *Subject:* Re: [Freeswitch-users] Freeswitch shared registration
ᐧ Hmm, did you restart the profiles after this edit? -Avi
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
Oh,I see thank you very much. It helps)) From: Steven Ayre Sent: Friday, July 18, 2014 4:16 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Freeswitch shared registration In case you didn't see my earlier message, your configuration is wrong. On SIP profiles the parameter is named 'odbc-dsn' not 'core-db-dsn'. Unknown parameters are (silently) ignored. On 18 July 2014 11:38, Nick Zaitsev <nick.zaitsev@mail.ru> wrote: Sure,I did that.but there is not any packets from freeswitches to the db. and there is not any errors. From: Avi Marcus Sent: Friday, July 18, 2014 1:13 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Freeswitch shared registration ᐧ Hmm, did you restart the profiles after this edit? -Avi _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com 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
On the sofia profiles the parameter name will be odbc-dsn not core-db-dsn. Don't worry about the odbc in the name. It works fine with pgsql, the name just harks back to when DSNs were only for ODBC. Steve On 18 July 2014 09:34, Nick Zaitsev <nick.zaitsev@mail.ru> wrote:
Good day to you! Could you advise me with Freeswitch, please? I have load balancer (opensips) in front of 2 Freeswitch (fsw1 and fsw2) servers, each with their own hostname. The load balancing works fine, but the shared database did not work. I use PostgreSQL I add to external and internal sip profiles and sofia.conf.xml this: <param name="track-calls" value="true"/> <param name="core-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user password='password'"/>
And to switch.conf.xml at fsw1: <param name="switchname" value="fsw1"/> <param name="track-calls" value="true"/> <param name="core-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user password='password'"/> <param name="core-recovery-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user password='password'"/> and at fsw2 the same,except hostname.
There is not any errors, but the DB is empty. What I do wrong? Could you help me please? Thank you for your time, Best Regards.
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
participants (3)
-
Avi Marcus
-
Nick Zaitsev
-
Steven Ayre