Having issues trying to access the db.

 

From the wiki PostgreSQL in the core, I have set:

   <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1

    dbname=freeswitch user=freeswitch password=&apos;&apos; options=&apos;-c

    client_min_messages=NOTICE&apos; application_name=&apos;freeswitch&apos;" />

 

but when I try to access the DB

 

è  psql -d freeswitch -U freeswitch

psql: could not connect to server: No such file or directory

        Is the server running locally and accepting

        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

 

freeswitch is on debian 9

 

From: FreeSWITCH-users [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Michael Jerris
Sent: Monday, April 09, 2018 2:38 PM
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] sip_presence

 

should work the same, yes.

 

On Apr 9, 2018, at 3:58 PM, Bob McCarthy <bob.mccarthy@westtel.com> wrote:

 

How about using the pgsql built into the core ?

 

From: FreeSWITCH-users [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Michael Jerris
Sent: Monday, April 09, 2018 8:54 AM
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] sip_presence

 

put it in odbc source and its easy to access.

 

On Apr 7, 2018, at 12:10 PM, Bob McCarthy <bob.mccarthy@westtel.com> wrote:

 

Is there any way to access the sip_presence db from the api ?  Have documented a memory leak in presence FS-10808 and I would like to troubleshoot its root cause.

 \