<div dir="ltr"><crying></crying><div><br></div><div>I have search string odbc in each config file and added the line for connecting to psql </div><div><br></div><div><div> 549 vi autoload_configs/switch.conf.xml </div><div> 550 vi sip_profiles/internal.xml </div><div> 551 vi autoload_configs/directory.conf.xml </div><div> 552 vi autoload_configs/voicemail.conf.xml </div><div> 553 vi autoload_configs/easyroute.conf.xml </div><div> 554 vi autoload_configs/db.conf.xml </div><div> 555 vi sip_profiles/internal.xml </div><div> 556 vi autoload_configs/db.conf.xml </div><div> 557 vi autoload_configs/cidlookup.conf.xml </div><div> 558 vi autoload_configs/lcr.conf.xml </div><div> 559 vi autoload_configs/nibblebill.conf.xml </div><div> 560 vi autoload_configs/callcenter.conf.xml </div><div> 561 vi jingle_profiles/server.xml </div><div> 562 vi sip_profiles/internal-ipv6.xml </div><div> 563 vi sip_profiles/internal-ipv6.xml </div><div> 564 vi skinny_profiles/internal.xml </div></div><div><br></div><div>this is the line I have added (not to all files, the ones that asks for odbc-dsn:</div><div><br></div><div><div> <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div></div><div><br></div><div>I started freeswitch again, and now it don't turns on and postgresql logs are crazy!</div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><br>- Blackhold<br><a href="http://blackhold.nusepas.com" target="_blank">http://blackhold.nusepas.com</a><br>@blackhold_<br>~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs)<br><°((( ><</div></div>
<br><div class="gmail_quote">2018-05-25 2:17 GMT+02:00 Michael Jerris <span dir="ltr"><<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">core-db-dsn in switch.conf.xml covers the core db, there is additional settings for mod_sofia, and a var to set for some things in mod_verto. That probably covers most of it. Each module is different and has settings for things like this.<br>
<span class="im HOEnZb"><br>
> On May 24, 2018, at 8:13 PM, Blackhold <<a href="mailto:blackholdmailer@gmail.com">blackholdmailer@gmail.com</a>> wrote:<br>
> <br>
> wich string I have to add?<br>
> <br>
> <param name="core-db-dsn" value="pgsql://hostaddr=127.0.<wbr>0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE'" /><br>
> <br>
> or<br>
> <br>
> <param name="odbc-dsn" value="pgsql://hostaddr=127.0.<wbr>0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /><br>
> <br>
> ?<br>
> <br>
> for example for file conf/sip_profiles/internal.<wbr>xml:231<br>
> <br>
> wich modules needs db connection?<br>
> <br>
> thanks!<br>
<br>
<br>
</span><div class="HOEnZb"><div class="h5">______________________________<wbr>______________________________<wbr>_____________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.<wbr>freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.<wbr>org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.<wbr>freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/<wbr>mailman/listinfo/freeswitch-<wbr>users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a></div></div></blockquote></div><br></div>