[Users] Presence and Postgresql

[Stephen Varga]

Humberto,

I am testing a similar setup and was experiencing the same issue with 
X-lite. After a bunch of digging and testing over the weekend I was 
finally able to make presence work when using postgres db. The column 
body in the presentity table needs to be changed from the data type text 
to bytea. Once I did that presence was working properly.

HTH,
Steve

H Quintana wrote:
> Hi everybody,
>
> I'm using Xlite 3.0 and postgresql 8.2.3, the
> information about the presentity is properly stored in
> the table.
>
> The query brings the value for the field "body" but
> after the "conversion" to string the value is empty.
>
> Is Someone running the presence module with postgres?
>
> The log is at:
>
> http://cut.and.paste.org/index.php?id=952
>
> I added this to notify.c in the line 514:
>
> DBG("PRESENCE:NOTIFY:Body array n=%d,
> content:<%.*s>\n", i, body_array[i]->len,
> body_array[i]->s);
>
> and in the log you will find:
>
> 0(14253) PRESENCE:NOTIFY:Body array n=0, content:<>
>
> before the line:
>
> 0(14253) PRESENCE:agregate_xmls: ERROR while parsing
> xml body message
>
>
> Thanks for your help,
>
>
> Humberto Quintana
>
>
>
>
>
>  
> ____________________________________________________________________________________
> TV dinner still cooling? 
> Check out "Tonight's Picks" on Yahoo! TV.
> http://tv.yahoo.com/
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>
>