Is there any way to access the sip_presence db from the api ? Have documented a memory leak in presence FS-10808 and I would like to troubleshoot its root cause. Bob McCarthy
put it in odbc source and its easy to access.
On Apr 7, 2018, at 12:10 PM, Bob McCarthy <bob.mccarthy@westtel.com> wrote:
Is there any way to access the sip_presence db from the api ? Have documented a memory leak in presence FS-10808 and I would like to troubleshoot its root cause.
Bob McCarthy
How about using the pgsql built into the core ? From: FreeSWITCH-users [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Michael Jerris Sent: Monday, April 09, 2018 8:54 AM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] sip_presence put it in odbc source and its easy to access. On Apr 7, 2018, at 12:10 PM, Bob McCarthy <bob.mccarthy@westtel.com<mailto:bob.mccarthy@westtel.com>> wrote: Is there any way to access the sip_presence db from the api ? Have documented a memory leak in presence FS-10808 and I would like to troubleshoot its root cause. Bob McCarthy
should work the same, yes.
On Apr 9, 2018, at 3:58 PM, Bob McCarthy <bob.mccarthy@westtel.com> wrote:
How about using the pgsql built into the core ?
From: FreeSWITCH-users [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Michael Jerris Sent: Monday, April 09, 2018 8:54 AM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] sip_presence
put it in odbc source and its easy to access.
On Apr 7, 2018, at 12:10 PM, Bob McCarthy <bob.mccarthy@westtel.com <mailto:bob.mccarthy@westtel.com>> wrote:
Is there any way to access the sip_presence db from the api ? Have documented a memory leak in presence FS-10808 and I would like to troubleshoot its root cause. \
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 From: FreeSWITCH-users [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Michael Jerris Sent: Monday, April 09, 2018 2:38 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] sip_presence should work the same, yes. On Apr 9, 2018, at 3:58 PM, Bob McCarthy <bob.mccarthy@westtel.com<mailto:bob.mccarthy@westtel.com>> wrote: How about using the pgsql built into the core ? From: FreeSWITCH-users [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Michael Jerris Sent: Monday, April 09, 2018 8:54 AM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@lists.freeswitch.org>> Subject: Re: [Freeswitch-users] sip_presence put it in odbc source and its easy to access. On Apr 7, 2018, at 12:10 PM, Bob McCarthy <bob.mccarthy@westtel.com<mailto:bob.mccarthy@westtel.com>> wrote: Is there any way to access the sip_presence db from the api ? Have documented a memory leak in presence FS-10808 and I would like to troubleshoot its root cause. \
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 <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
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 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
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/>
Thanks. I’ll get that set up. From: FreeSWITCH-users [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Michael Jerris Sent: Monday, April 09, 2018 5:06 PM To: FreeSWITCH Users Help <freeswitch-users@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@westtel.com<mailto: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<mailto: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 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 UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org<http://www.freeswitch.org/>
participants (2)
-
Bob McCarthy
-
Michael Jerris