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