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 <mailto: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 <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@freeswitch.org <mailto:consulting@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@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org <http://www.freeswitch.org/>