[Devel] [ openser-Bugs-1684821 ] Presence does not work with PostgreSQL Database

[SourceForge.net]

Bugs item #1684821, was opened at 2007-03-20 23:50
Message generated for change (Comment added) made by anca_vamanu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1684821&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: ver 1.2.x
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Steve (svarga)
>Assigned to: anca (anca_vamanu)
Summary: Presence does not work with PostgreSQL Database

Initial Comment:
Presence does not work when using PostgreSQL database. When the presence module creates the notify message the pidf.c routine throws the following error

PRESENCE:agregate_xmls: ERROR while parsing xml body message

which results in no notification message being sent.

To resolve this issue, I had to change the data type of the body column in the presentity table from text to bytea. Once this change was made to the table, presenece work properly when using X-Lite 3.0 SIP clients



----------------------------------------------------------------------

>Comment By: anca (anca_vamanu)
Date: 2007-03-21 09:36

Message:
Logged In: YES 
user_id=1614776
Originator: NO

Hello,

I have made the change in the PostgreSQL script.
Thank you for reporting and giving a solution.

Best regards, 

Anca Vamanu

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1684821&group_id=139143