[Users] Presence and Postgresql

Anca-Maria Vamanu anca at voice-system.ro
Wed Mar 21 10:32:39 CET 2007


Hello,

Thank you for reporting and finding the solution. The change has been made.

Best regards,

Anca Vamanu

Stephen Varga wrote:

> 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
>>
>>
>>   
>
>
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>





More information about the sr-users mailing list