[Devel] latest cvs , missing column inserted_time

[Adrian Georgescu]

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
>>