you still need to setup postgres server.

On Apr 9, 2018, at 6:16 PM, Bob McCarthy <bob.mccarthy@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@lists.freeswitch.org] On Behalf Of Michael Jerris
Sent: Monday, April 09, 2018 3:07 PM
To: FreeSWITCH Users Help <freeswitch-users@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@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=&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
 
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org