[Freeswitch-users] sip_presence

[Bob McCarthy]

Just using the freeswitch installation to install the core pgsql in accordance with the wiki.

sudo apt-get install libpq-dev
./configure --enable-core-pgsql-support

make – install et al

Made addition to
autoload_configs/switch.conf.xml as previously noted.


I also installed a pgsql client so that I could access the db:
sudo apt-get install postgresql-client

Any tips on how to see if postgres is running from freeswitch ?

ps auxwww | grep postgres shows postgres is not running under that name.

Bob


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

you would have to make sure postgres is setup and configured properly and running so you can access it from psql and from freeswitch itself.

On Apr 9, 2018, at 5:02 PM, Bob McCarthy <bob.mccarthy at westtel.com<mailto:bob.mccarthy at westtel.com>> wrote:

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

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