[Devel] latest cvs , missing column inserted_time
Adrian Georgescu
ag at ag-projects.com
Fri Dec 8 15:52:55 CET 2006
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
>>
More information about the Devel
mailing list