[Freeswitch-users] sip_presence

[Michael Jerris]

you still need to setup postgres server.

> On Apr 9, 2018, at 6:16 PM, Bob McCarthy <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>
> 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 <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 <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/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180409/cae2cec2/attachment-0001.html>