Hello, still playing arround with presence and xcap, another thing i would like to know is following query that i can see in my sql logs:
username,domain,doc_type,etag,doc_uri,port from xcap where source=1
Q: What does the "source" value stand for, because currently all data records have a value of "0"
Also trying currently with "inetgrated xcap_server="0" " but with "xcap_client" module, also with no success...
Presence status keeps always pending....
Any hints ?
r,
Andreas M.
Andreas M. schrieb:
Hello, i installed OSER 1.3-SVN and openxcap-0.9.9 (does not work with OSER 1.2 :) )
XCAP Server is running, also openser, but i can´t see any presence status, clients sends publish but no notifys are sent out.
i´m using latest eyebeam clients, i can also see that privacy rules are updated in the xcap database, but subscribtion status is always pending.
i can see that xcap doc is loaded through a query, but status is pending. Had a long time presence running mit "force_active = 1", but now i want to introduce also xcap functionality.
Where can i start to debug ?
r, Andreas M.
presence config: ## presence module
modparam("presence", "db_url","mysql://xx:xx@127.0.0.1/presence") modparam("presence", "presentity_table", "presentity") modparam("presence", "active_watchers_table", "active_watchers") modparam("presence", "watchers_table", "watchers") modparam("presence", "clean_period", 100) modparam("presence", "to_tag_pref", 'mango') modparam("presence", "expires_offset", 10) modparam("presence", "max_expires", 3600) modparam("presence", "server_address", "sip:10.0.0.1:5065") modparam("presence", "fallback2db", 1)
modparam("presence_xml", "db_url","mysql://xxx:xxx@127.0.0.1/presence") modparam("presence_xml", "xcap_table", "xcap") modparam("presence_xml", "force_active", 0) modparam("presence_xml", "pidf_manipulation", 0) modparam("presence_xml", "integrated_xcap_server", 1)
also i can see following query in my sql log, that does not work (field does not exists)
select id from watchers where inserted_time<1202992297 AND subs_status='pending'
source: 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 AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;