Resources -> Documentation -> Presence -> Presence ServerPresence ServerFeatures
ArchitecturePresence Diagrame (click to enlarge) Module Description
ConfigurationThe architecture in the diagram corresponds to a full configuration, when no restrictions are imposed, with privacy permission rules handling enabled and the use of a general XCAP server. There is the possibility to simplify the scheme according to the needs and resources. This can be done by configuring the modules so that some connections are removed or others appear.
DatabasePresence Server requires 4 tables in database:
The first three tables are only used internally by the server. The xcap table is either used as a communication interface between the XCAP server (if the server is working in 'integrated_xcap' mode) or as a communication means between the xcap_client module which populates the table and presence_xml module which uses that information. The description of the tables presentity
CREATE TABLE `presentity` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(64) NOT NULL, `domain` varchar(64) NOT NULL, `event` varchar(64) NOT NULL, `etag` varchar(64) NOT NULL, `expires` int(11) NOT NULL, `received_time` int(11) NOT NULL, `body` blob NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `presentity_idx` (`username`,`domain`,`event`,`etag`) ) ENGINE=MyISAM; active_watchers
CREATE TABLE `active_watchers` ( `id` int(10) unsigned NOT NULL auto_increment, `presentity_uri` varchar(128) NOT NULL, `watcher_username` varchar(64) NOT NULL, `watcher_domain` varchar(64) NOT NULL, `to_user` varchar(64) NOT NULL, `to_domain` varchar(64) NOT NULL, `event` varchar(64) NOT NULL default 'presence', `event_id` varchar(64) default NULL, `to_tag` varchar(64) NOT NULL, `from_tag` varchar(64) NOT NULL, `callid` varchar(64) NOT NULL, `local_cseq` int(11) NOT NULL, `remote_cseq` int(11) NOT NULL, `contact` varchar(64) NOT NULL, `record_route` text, `expires` int(11) NOT NULL, `status` int(11) NOT NULL default '2', `reason` varchar(64) NOT NULL, `version` int(11) NOT NULL default '0', `socket_info` varchar(64) NOT NULL, `local_contact` varchar(128) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `active_watchers_idx` (`presentity_uri`,`callid`,`to_tag`,`from_tag`) ) ENGINE=MyISAM; watchers
CREATE TABLE `watchers` ( `id` int(10) unsigned NOT NULL auto_increment, `presentity_uri` varchar(128) NOT NULL, `watcher_username` varchar(64) NOT NULL, `watcher_domain` varchar(64) NOT NULL, `event` varchar(64) NOT NULL default 'presence', `status` int(11) NOT NULL, `reason` varchar(64) default NULL, `inserted_time` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `watcher_idx` (`presentity_uri`,`watcher_username`,`watcher_domain`,`event`) ) ENGINE=MyISAM; xcap
CREATE TABLE `xcap` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(64) NOT NULL, `domain` varchar(64) NOT NULL, `doc` blob NOT NULL, `doc_type` int(11) NOT NULL, `etag` varchar(64) NOT NULL, `source` int(11) NOT NULL, `doc_uri` varchar(128) NOT NULL, `port` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `account_doc_type_idx` (`username`,`domain`,`doc_type`,`doc_uri`), KEY `source_idx` (`source`) ) ENGINE=MyISAM; | News OpenSIPS 1.6.211th of March 2010
OpenSIPS 1.6.2 is brings new features... OpenSIPS Control Panel 4.008th of March 2010
OpenSIPS CP 4.0 comes with user provisioning... Conference on "OpenSIPS 2.0"5th of March 2010
VoIP Users Conference will host an audio conference OpenSIPS webinar25th of February 2010
Next webinars is Explaining the default script OpenSIPS 2.0 Design15th of February 2010
Design of OpenSIPS 2.0 is unveiled OpenSIPS webinar28th of January 2010
Next OpenSIPS webinars is SIP Introduction Building Telephony Systems with OpenSIPS 1.621st of January 2010
New edition is available... OpenSIPS 1.6.1 is released21st of December 2009
OpenSIPS 1.6.1 minor release is out... OpenSIPS Development Course17th of December 2009
OpenSIPS Devel Course for 2010... OpenSIPS Bootcamps 201009th of December 2009
2010 Schedule for Bootcamp events... User Location is faster13th of November 2009
USRLOC is 3 time faster than before... OpenSIPS Control Panel 3.030th of October 2009
OpenSIPS CP 3.0 major release is out... OpenSIPS 1.6.0 is released16th of October 2009
OpenSIPS 1.6.0 major release is out... OpenSIPS VoIP Service21th of September 2009
OpenSIPS project offers free VoIP services... OpenSIPS & Astricon21th of September 2009
OpenSIPS talks and exhibits at Astricon 2009... SVN freeze17th of September 2009
SVN trunk gets frozen to prepare 1.6 release... New types of script routes10th of September 2009
New additions to configuration file routes... STUN server7th of September 2009
OpenSIPS has now a built-in STUN server... Pseudovariable implementation extended3rd of September 2009
Added new operations for pvars to give more power to the script writer... OpenSIPS Asterisk Integration30th of August 2009
Tutorial for realtime integration... OpenSIPS 1.5.3 is released27th of August 2009
OpenSIPS 1.5.3 minor release is out... AAA and RADIUS support18th of April 2009
New AAA API and RADIUS enhancements in OpenSIPS OpenSIPS webinar4th of April 2009
Next OpenSIPS webinars is Types of Routs in OpenSIPS B2BUA3rd of August 2009
A B2BUA signaling implementation in OpenSIPS DB virtual23th of July 2009
A DB conn mixer for failover, parallel and LB Codec manipulation23th of July 2009
SDP codecs and priorities manipulation Memcached interfacing16th of July 2009
memcached support for memory caching API OpenSIPS 1.5.2 is released15th of July 2009
OpenSIPS 1.5.2 minor release is out... OpenSIPS@ClueCon14th of July 2009
OpenSIPS talks at ClueCon OpenSIPS webinar30th of June 2009
Next OpenSIPS webinars is Routing in SIP REGISTRAR enhancements29th of June 2009
REGISTRAR module becomes more flexible OpenSIPS free webinars01st of June 2009
OpenSIPS webinars program was launched OpenSIPS-CP 2.0 is released13rd of April 2009
OpenSIPS Control Panel 2.0 major release is out... OpenSIPS 1.5.1 is released13rd of April 2009
OpenSIPS 1.5.1 minor release is out... OpenSIPS 1.5.0 is released23rd of March 2009
OpenSIPS 1.5.0 major release is out... OpenSIPS 1.4.5 is released23rd of March 2009
OpenSIPS 1.4.5 minor release is out... OpenSIPS as Load Balancer4th of March 2009 OpenSIPS at Amoocon (AsteriskTAG)24th of February 2009 |