[Freeswitch-users] sip_presence

[Bob McCarthy]

Thanks.  I’ll get that set up.

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

you still need to setup postgres server.

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

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<mailto: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

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org<mailto:consulting at freeswitch.org>
http://www.freeswitchsolutions.com<http://www.freeswitchsolutions.com/>

Official FreeSWITCH Sites
http://www.freeswitch.org<http://www.freeswitch.org/>
http://confluence.freeswitch.org<http://confluence.freeswitch.org/>
http://www.cluecon.com<http://www.cluecon.com/>

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org<mailto: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<http://www.freeswitch.org/>

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