Hi all,
I'm trying to make openser work with presence. I'm having few problems making it work. I've attached the openser.cfg that I'm using. The dump I get from the server is as follows.
1(5115) submit_query: Unknown column 'remote_cseq' in 'field list' 1(5115) db_insert: Error while submitting query 1(5115) PRESENCE:update_subscription: ERROR while storing new subscription 1(5115) PRESENCE:update_presentity: ERROR occured 1(5115) PRESENCE:handle_subscribe: ERROR while updating database 4(5125) ERROR:check_content_type: invalid type for a message 4(5125) ERROR: extract_body: content type mismatching 4(5125) ERROR: force_rtp_proxy2: can't extract body from the message
Here's what the UA is doing. The UA upon registration is sending a SUBSCRIBE followed by PUBLISH. The server then forwards the PUBLISH. Now, Isn't the server supposed to send NOTIFY ? And what about the error messages resulting from the database operations ?
Thank you in advance kumar
On Sunday 08 July 2007, KUMAR wrote:
Hi all,
I'm trying to make openser work with presence. I'm having few problems making it work. I've attached the openser.cfg that I'm using. The dump I get from the server is as follows.
1(5115) submit_query: Unknown column 'remote_cseq' in 'field list' 1(5115) db_insert: Error while submitting query 1(5115) PRESENCE:update_subscription: ERROR while storing new subscription 1(5115) PRESENCE:update_presentity: ERROR occured 1(5115) PRESENCE:handle_subscribe: ERROR while updating database 4(5125) ERROR:check_content_type: invalid type for a message 4(5125) ERROR: extract_body: content type mismatching 4(5125) ERROR: force_rtp_proxy2: can't extract body from the message
Hello Kumar,
i guess you are using svn trunk. I've made a fix in the db setup script in rev 2366 for an error that could related to the "remote_cseq" db error you see. Check your database if the recieved_time col in presentity table and the remote_cseq col in active_watchers are present or perhaps missspelled.
This was reported in the mail "Presence Module and XCAP Issues" on 18.06.
Cheers,
Henning
-
Henning Westerholt -
KUMAR