The column body in the presentity table needs to be
changed from the
data type text to bytea.
Steve
Hildebrando Trannin wrote:
Hi,
I'm using OpenSER with Postgresql. Is there a problem when use this
database? If yes, could you send me the mail that reports this error?
Thanks, Hildebrando
-----Mensagem original-----
De: users-bounces(a)openser.org [mailto:users-bounces@openser.org] Em
nome de
Anca-Maria Vamanu
Enviada em: terça-feira, 20 de março de 2007 14:11
Para: users(a)openser.org
Assunto: Re: [Users] ENC: Presence Module - Eyebeam 1.5
Hello,
I have tested using this document. There was no error. So for sure
there is no problem with the format of the document.
The problem is somewhere else. I am thinking it might be related to
the problem reported in a previous mail that had to do with the
database.
Are you by any chance using postgresql?
Best regards,
Anca Vamanu
Hildebrando Trannin wrote:
Hi all,
I configured the presence module in OpenSER v1.2 and it looks like
ok. But when tested with EyeBeam 1.5 (buil 30037) it doesn’t work. I
used the WireShark to see the SIP messages and observed that in
NOTIFY messages there aren’t PIDF document, neither message body.
Furthermore, OpenSER didn’t parse xml BODY from PRESENTITY table
when try to build notify. The PIDF document that EyeBeam creates and
the error that OpenSER gave me when try to parser this document are
below. Can someone help me with this problem? Is it a bug from OpenSER?
Regards,
Hildebrando
* *
*PIDF Document*
<?xml version="1.0" encoding="UTF-8" standalone="no"
?>
<pr:presence xmlns:pr="urn:ietf:params:xml:ns:pidf"
entity="sip:hildebrando@voip.maritaca"
xmlns:caps="urn:ietf:params:xml:ns:pidf:caps"
xmlns:cipid="urn:ietf:params:xml:ns:pidf:cipid"
xmlns:counterpath="www.counterpath.com/presence/ext"
xmlns:dm="urn:ietf:params:xml:ns:pidf:data-model"
xmlns:rpid="urn:ietf:params:xml:ns:pidf:rpid">
<pr:tuple id="se43ac217">
<pr:status>
<pr:basic>open</pr:basic>
</pr:status>
<pr:note>Busy</pr:note>
<rpid:user-input
last-input="2007-03-19T19:21:49Z">active</rpid:user-input>
<pr:timestamp>2007-03-19T19:21:49Z</pr:timestamp>
</pr:tuple>
<dm:person id="p0d4e4429">
<rpid:activities>
<rpid:busy/>
</rpid:activities>
<dm:note>Busy</dm:note>
</dm:person>
</pr:presence>
*OpenSER Error*
* *
2(6498) Chegou um PUBLISH de (hildebrando) para
(sip:hildebrando@voip.maritaca <mailto:sip:hildebrando@voip.maritaca>)
2(6498) PRESENCE:update_presentity: querying presentity
2(6498) PRESENCE:get_subs_dialog:querying database table =
active_watchers
2(6498) PRESENCE:get_p_notify_body: querying presentity
2(6498) PRESENCE:agregate_xmls: ERROR while parsing xml body message
2(6498) PRESENCE:notify:dialog informations:
2(6498)
[p_user]= hildebrando [p_domain]= voip.maritaca
[w_user]= gustavo [w_domain]= voip.maritaca
2(6498) [event]= presence
[staus]= active
[expires]= 3340
2(6498) [to_tag]= 10.6503.1174328485.15
[from_tag]= 80746145**
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users