[Freeswitch-users] Connecting freeswitch to postgresql

[Blackhold]

<crying></crying>

I have search string odbc in each config file and added the line for
connecting to psql

  549  vi autoload_configs/switch.conf.xml
  550  vi sip_profiles/internal.xml
  551  vi autoload_configs/directory.conf.xml
  552  vi autoload_configs/voicemail.conf.xml
  553  vi autoload_configs/easyroute.conf.xml
  554  vi autoload_configs/db.conf.xml
  555  vi sip_profiles/internal.xml
  556  vi autoload_configs/db.conf.xml
  557  vi autoload_configs/cidlookup.conf.xml
  558  vi autoload_configs/lcr.conf.xml
  559  vi autoload_configs/nibblebill.conf.xml
  560  vi autoload_configs/callcenter.conf.xml
  561  vi jingle_profiles/server.xml
  562  vi sip_profiles/internal-ipv6.xml
  563  vi sip_profiles/internal-ipv6.xml
  564  vi skinny_profiles/internal.xml

this is the line I have added (not to all files, the ones that asks for
odbc-dsn:

    <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'" />

I started freeswitch again, and now it don't turns on and postgresql logs
are crazy!



- Blackhold
http://blackhold.nusepas.com
@blackhold_
~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres
mateixos quan siguem forts (Xirinacs)
<°((( ><

2018-05-25 2:17 GMT+02:00 Michael Jerris <mike at jerris.com>:

> 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.
>
> > On May 24, 2018, at 8:13 PM, Blackhold <blackholdmailer at gmail.com>
> wrote:
> >
> > wich string I have to add?
> >
> > <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1
> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c
> client_min_messages=NOTICE'" />
> >
> > or
> >
> > <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'" />
> >
> > ?
> >
> > for example for file conf/sip_profiles/internal.xml:231
> >
> > wich modules needs db connection?
> >
> > thanks!
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180525/42e94520/attachment.html>