Re: [OpenSER-Users] OpenXcap + Presence - sr-users

18 Feb 2008

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;

-- 
g,
Andreas M.