[Users] Presence and Postgresql

[H Quintana]

Thanks Stephen.  It's working now.

Best regards,

Humberto

--- Stephen Varga <varga at zbzoom.net> 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
> >
> >
> >   
> 
> 



 
____________________________________________________________________________________
Looking for earth-friendly autos? 
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
http://autos.yahoo.com/green_center/