[Kamailio-Users] presence pres-rules and database watchers table

[Dubravko Caric]

Hi Juha,



----- Original Message ----
From: Juha Heinanen <jh at tutpro.com>
To: Dubravko Caric <dubravko_caric at yahoo.com>
Cc: kamailio users <users at lists.kamailio.org>
Sent: Tuesday, May 12, 2009 3:32:49 PM
Subject: [Kamailio-Users] presence pres-rules and database watchers table

Dubravko Caric writes:

>> is there any way to automatically change "reason" column from
>> "rejected" back to "NULL" or "allow" in watchers table after UAC#1
>> moves the UAC#2 from its blacklist to whitelist?
>> 
>> i see that kamailio (1.5.0) correctly reads index.xml file from
>> database, but "rejected" reason is still in the  watcher table until
>> I delete it manually and restart UAC.

> if ua2 was blocked by ua1, and then becomes un-blocked, the status of
> ua1 at ua2 does not change before ua2 sends a new subscribe.
> 
> are you saying that even when ua2 sends a new subscribe, it is still
> blocked?

i checked once more and the answer is yes. if you don't have this problems than I'm doing something wrong.

here is my setup so please advise 

1. in OpenXCAP I'm using "backend = Database"

2. eyebeam 1.5.19 sends xml documents to XCAP which correctly fills up "xcap" table in MySQL (contacts-resource-list.xml, index.xml,  resource-list.xml) and every change (eg. white/blacklist in index.xml) is updated and stored in xcap table

3. kamailio.cfg
modparam("presence|presence_xml", "db_url", "mysql://openser:openserrw@localhost/openser")
modparam("presence_xml", "force_active", 0)
modparam("presence_xml", "integrated_xcap_server", 1)
modparam("presence", "server_address", "sip:192.168.111.222:5060")

route [2] 
standard kamaililo.cfg for presence with just handle_publish(); and handle_subscribe(); .


Best regards

Dubravko