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@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von hajime Gesendet: Samstag, 06. April 2013 22:21 An: freeswitch-users@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-tp75894... Sent from the freeswitch-users mailing list archive at Nabble.com. _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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