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.
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
sip_subscriptions or sip_presence tables - am I mistaken, or are they only maintained in the sqlite db? I have the XML configuration param "core-db-dsn" set to my local PostgreSQL db but only see tables such as aliases, calls, channels, complete, interfaces, nat, recovery, registrations, and tasks. -- 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.
Sofia profiles also have their own dsn params for connection to RDBMS systems. <param name="odbc-dsn" value="XXXX"/> On Mon, Apr 8, 2013 at 12:27 PM, hajime <hajime9ma@gmail.com> wrote:
sip_subscriptions or sip_presence tables - am I mistaken, or are they only maintained in the sqlite db? I have the XML configuration param "core-db-dsn" set to my local PostgreSQL db but only see tables such as aliases, calls, channels, complete, interfaces, nat, recovery, registrations, and tasks.
-- 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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
participants (3)
-
Anthony Minessale
-
Gerald Weber
-
hajime