SIP headers storage in core or sofia database.
Hello ! I've set up an ODBC connection for core and sofia profile like this: <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /><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'" /> Using PgAdmin I see some tables was created in Postgres DB. I want to retrieve all SIP invite headers from this DB. What table should I look for this information if, of course, it is stored at all ? Thanks. Regards,Pavel.
Its not stored. What problem are you trying to solve? On Tue, Sep 1, 2015 at 7:25 AM, Pavel <my.post@hotmail.com> wrote:
Hello !
I've set up an ODBC connection for core and sofia profile like this:
<param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /> <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'" />
Using PgAdmin I see some tables was created in Postgres DB. I want to retrieve all SIP invite headers from this DB. What table should I look for this information if, of course, it is stored at all ?
Thanks.
Regards, Pavel.
_________________________________________________________________________ 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
-- *Brian West* brian@freeswitch.org *Twitter: @FreeSWITCH , @briankwest* http://www.freeswitchbook.com http://www.freeswitchcookbook.com Got Bugs? Report them here <https://freeswitch.org/jira>! | Reddit: /r/freeswitch <https://www.reddit.com/r/freeswitch> *T:*+19184209001 | *F:*+19184209002 | *M:*+1918424WEST (9378) *iNUM:*+883 5100 1420 9001 | *ISN:*410*543 | *Skype:*briankwest
Brian, thanks a lot for your reply. To put it short - I am willing to do some call visualization with simple web application based on some incoming INVITE sip header values.So I've been thinking, that watching for changes to sofia (or core) db is enough to represent my data.The ESL is probably a way to go, right ?Regards,Pavel. From: my.post@hotmail.com To: freeswitch-users@lists.freeswitch.org Subject: SIP headers storage in core or sofia database. Date: Tue, 1 Sep 2015 18:25:04 +0600 Hello ! I've set up an ODBC connection for core and sofia profile like this: <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /><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'" /> Using PgAdmin I see some tables was created in Postgres DB. I want to retrieve all SIP invite headers from this DB. What table should I look for this information if, of course, it is stored at all ? Thanks. Regards,Pavel.
You can do that with homer. Search web for "homer sipcapture" sent from my mobile, Giovanni Maruzzelli cell: +39 347 266 56 18 On Sep 1, 2015 4:40 PM, "Pavel" <my.post@hotmail.com> wrote:
Brian, thanks a lot for your reply. To put it short - I am willing to do some call visualization with simple web application based on some incoming INVITE sip header values. So I've been thinking, that watching for changes to sofia (or core) db is enough to represent my data. The ESL is probably a way to go, right ? Regards, Pavel.
------------------------------ From: my.post@hotmail.com To: freeswitch-users@lists.freeswitch.org Subject: SIP headers storage in core or sofia database. Date: Tue, 1 Sep 2015 18:25:04 +0600
Hello !
I've set up an ODBC connection for core and sofia profile like this:
<param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /> <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'" />
Using PgAdmin I see some tables was created in Postgres DB. I want to retrieve all SIP invite headers from this DB. What table should I look for this information if, of course, it is stored at all ?
Thanks.
Regards, Pavel.
_________________________________________________________________________ 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
participants (3)
-
Brian West
-
Giovanni Maruzzelli
-
Pavel