[Freeswitch-users] Presence in ODBC/PgSQL?

Gerald Weber gerald.weber at besharp.at
Sun Apr 7 12:33:37 MSD 2013

FreeSWITCH offers presence out oft he box, if you have it enabled in the sofia profile, the tables  are already there.
Table names starting with sip_ like sip_subscriptions or sip_presence (the table you are looking for)

The problem is that the sip_presence table is always empty for me, because of the code checking for
various things like multiple reigstrations, etc. I'm currenlty working on an patch/alternative solution.

When i figured this out, i plan to put presence into the list_users command so you have an overview of all your
users in the directory at a glance.

-----Ursprüngliche Nachricht-----
Von: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] Im Auftrag von hajime
Gesendet: Samstag, 06. April 2013 22:21
An: freeswitch-users at lists.freeswitch.org
Betreff: [Freeswitch-users] Presence in ODBC/PgSQL?

My first question in the mailing list, so hope you can bear over with me :-)

Been trawling through the mailing list and google alas not yet found a sound solution to get presence data stored in a database - say I'd like to expose the users' online status via a web page ( I'd like to avoid having to install Kamailio which could manage this for me ).

Is the simplest option to subscribe to events (Mod event socket) and write them myself into a database? Or is there an easier way to achieve this.
If you could provide me some pointers I'd really appreciate it.


View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Presence-in-ODBC-PgSQL-tp7589475.html
Sent from the freeswitch-users mailing list archive at Nabble.com.

Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org


Official FreeSWITCH Sites

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org

Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list