[Freeswitch-users] sip_presence

[Bob McCarthy]

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='' options='-c
    client_min_messages=NOTICE' application_name='freeswitch'" />

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 at lists.freeswitch.org] On Behalf Of Michael Jerris
Sent: Monday, April 09, 2018 2:38 PM
To: FreeSWITCH Users Help <freeswitch-users at 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 at westtel.com<mailto:bob.mccarthy at westtel.com>> wrote:

How about using the pgsql built into the core ?

From: FreeSWITCH-users [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Michael Jerris
Sent: Monday, April 09, 2018 8:54 AM
To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org<mailto:freeswitch-users at 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 at westtel.com<mailto:bob.mccarthy at 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.
 \

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180409/1adc4f63/attachment-0001.html>