[Freeswitch-users] Presence in ODBC/PgSQL?

[Gerald Weber]

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.

Thanks,
Hajime



--
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
http://www.freeswitchsolutions.com

 

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org