[Devel] latest cvs , missing column inserted_time

[Anca-Maria Vamanu]

Hi,

The log shows that there is was subscription stored  for that user.
So it might be that none of the watchers was online or there might be 
some other particular circumstances because I have just tested this 
scenario and it works fine.

Anca


Adrian Georgescu wrote:

> Yes, it works now with the new column and I encounter another and  
> maybe unrelated problem, when a Publish comes in :
>
> Dec  8 15:43:57 node03 /usr/local/openser/sbin/openser[12015]:  
> PRESENCE:query_db_notify: Could not get subs_dialog from database
> Dec  8 15:45:29 node03 /usr/local/openser/sbin/openser[12014]:  
> PRESENCE: get_subs_dialog:The query for subscribtion for [user]=  
> 31137113050,[domain]= budgetphone.nl for [event]= presence returned  
> no result
> Dec  8 15:45:29 node03 /usr/local/openser/sbin/openser[12014]:  
> PRESENCE:query_db_notify: Could not get subs_dialog from database
> Dec  8 15:45:29 node03 /usr/local/openser/sbin/openser[12014]:   
> PRESENCE:update_presentity:Error in notify() function
>
> The user that has published the status has 16 watchers.
>
> The PUBLISH message that causes notify the error is:
>
> #################################################################
> U 81.23.228.150:5060 -> 81.23.228.149:5060
> PUBLISH sip:31137113050 at 81.23.228.149 SIP/2.0.
> Record-Route: <sip:81.23.228.150;lr=on;ftag=636ec34e>.
> Via: SIP/2.0/UDP 81.23.228.150;branch=z9hG4bK349c.be6d0094.0.
> Via: SIP/2.0/UDP 82.134.150.33:45716;branch=z9hG4bK- 
> d87543-31160c544342f46f-1--d87543-;rport=45716.
> Max-Forwards: 69.
> Contact: <sip:31137113050 at 82.134.150.33:45716>.
> To: <sip:31137113050 at budgetphone.nl>.
> From: <sip:31137113050 at budgetphone.nl>;tag=636ec34e.
> Call-ID: YTI1ZjU2YjVhM2JiZDZmNjJiMjhjMGFkOTVjOGI4YWQ..
> CSeq: 386 PUBLISH.
> Expires: 3600.
> Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE,  
> SUBSCRIBE, INFO.
> Content-Type: application/pidf+xml.
> SIP-If-Match: a.1165146884.27960.375.
> User-Agent: X-Lite release 1006e stamp 34025.
> Event: presence.
> Content-Length: 492.
> .
> <?xml version='1.0' encoding='UTF-8'?><presence  
> xmlns='urn:ietf:params:xml:ns:pidf'  
> xmlns:dm='urn:ietf:params:xml:ns:pidf:data-model'  
> xmlns:rpid='urn:ietf:params:xml:ns:pidf:rpid'  
> xmlns:c='urn:ietf:params:xml:ns:pidf:cipid' entity='pres: 
> 31137113050 at budgetphone.nl'><tuple  
> id='tee6eb712'><status><basic>open</basic></status><rpid:user- 
> input>idle</rpid:user-input></tuple><dm:person  
> id='pae2d2173'><rpid:activities><rpid:unknown/></ 
> rpid:activities><dm:note>Idle</dm:note></dm:person></presence>
> #
> U 81.23.228.149:5060 -> 81.23.228.150:5060
> SIP/2.0 200 OK.
> Record-Route: <sip:81.23.228.150;lr=on;ftag=636ec34e>.
> Via: SIP/2.0/UDP 81.23.228.150;branch=z9hG4bK349c.be6d0094.0.
> Via: SIP/2.0/UDP 82.134.150.33:45716;branch=z9hG4bK- 
> d87543-31160c544342f46f-1--d87543-;rport=45716.
> To: <sip: 
> 31137113050 at budgetphone.nl>;tag=56c6360719b93fddb0c2e9da4bd79d91.4aca.
> From: <sip:31137113050 at budgetphone.nl>;tag=636ec34e.
> Call-ID: YTI1ZjU2YjVhM2JiZDZmNjJiMjhjMGFkOTVjOGI4YWQ..
> CSeq: 386 PUBLISH.
> Contact: <sip:81.23.228.149:5060>.
> Expires: 3600.
> SIP-ETag: a.1165146884.27960.375.
> Server: OpenSer (1.2.0-dev12-notls (i386/linux)).
> Content-Length: 0.
>
> On Dec 8, 2006, at 2:40 PM, Anca-Maria Vamanu wrote:
>
>>
>> Indeed one of the changes included adding a new column in watchers  
>> table .
>> Please take the updated script from:
>>
>> http://openser.org/dokuwiki/doku.php/presence:database-tables.
>>
>> Anca
>>
>> Adrian Georgescu wrote:
>>
>>> Latest cvs seem to require a new database schema for one of the   
>>> presence tables but I cannot find a reference for the missing  
>>> column  referred here:
>>>
>>> Dec  8 13:53:36 node03 /usr/local/openser/sbin/openser[12013]:   
>>> PRESENCE:query_db_notify: Could not get subs_dialog from database
>>> Dec  8 13:53:36 node03 /usr/local/openser/sbin/openser[12013]:    
>>> PRESENCE:update_presentity:Error in notify() function
>>> Dec  8 13:53:36 node03 /usr/local/openser/sbin/openser[12013]:   
>>> PRESENCE: handle_publish: sip-etag: [SIP-ETag: a.  
>>> 1165146884.27960.375  /34]
>>> Dec  8 13:53:36 node03 /usr/local/openser/sbin/openser[12014]:   
>>> PRESENCE: handle_publish: sip-etag: [SIP-ETag: a. 
>>> 1165582120.12014.6  / 32]
>>>
>>> Dec  8 13:53:42 node03 /usr/local/openser/sbin/openser[12015]:   
>>> submit_query: Unknown column 'inserted_time' in 'where clause'
>>>
>>> Dec  8 13:53:42 node03 /usr/local/openser/sbin/openser[12015]:   
>>> db_delete: Error while submitting query
>>> Dec  8 13:53:42 node03 /usr/local/openser/sbin/openser[12015]:   
>>> PRESENCE:msg_watchers_clean: ERROR cleaning pending  subscriptions
>>>
>>>
>>> Adrian
>>>
>>>
>>> _______________________________________________
>>> Devel mailing list
>>> Devel at openser.org
>>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>>
>
>