<div dir="ltr">On the sofia profiles the parameter name will be odbc-dsn not core-db-dsn.<div class="gmail_extra"><br></div><div class="gmail_extra">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.<br>
<br>Steve</div><div class="gmail_extra"><br></div><div class="gmail_extra"><br><div class="gmail_quote">On 18 July 2014 09:34, Nick Zaitsev <span dir="ltr"><<a href="mailto:nick.zaitsev@mail.ru" target="_blank">nick.zaitsev@mail.ru</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div style="FONT-FAMILY:'Calibri';COLOR:#000000;FONT-SIZE:12pt"><font face="Tahoma"><span><font style="FONT-SIZE:8.3pt">Good day to you!</font></span><font style="FONT-SIZE:8.3pt"><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span>Could
you advise me with Freeswitch, please?</span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span>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</span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span>I
add to external and internal sip profiles and sofia.conf.xml this:</span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span><param
name="track-calls" value="true"/></span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span><param
name="core-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user
password='password'"/></span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span>And
to switch.conf.xml at fsw1:</span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span><param
name="switchname" value="fsw1"/></span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span><param
name="track-calls" value="true"/></span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span><param
name="core-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user
password='password'"/></span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span><param
name="core-recovery-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name
user=user password='password'"/></span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span>and
at fsw2 the same,except hostname.</span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span>There
is not any errors, but the DB is empty.</span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span>What
I do wrong? Could you help me please?</span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
<span>Thank
you for your time,</span><br style="TEXT-ALIGN:left;TEXT-TRANSFORM:none;BACKGROUND-COLOR:rgb(255,255,255);TEXT-INDENT:0px;LETTER-SPACING:normal;FONT:11px/16px tahoma,arial,verdana,sans-serif,'Lucida Sans';WHITE-SPACE:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">
</font><span><font style="FONT-SIZE:8.3pt">Best
Regards.</font></span></font></div></div></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">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>
<br></blockquote></div><br></div></div>