[OpenSIPS-Users] Problem with sip_trace storage, maybe a bug?

[Bogdan-Andrei Iancu]

Hi Brian,

opensips siptrace module inserts the message as text blob. My guess is 
that your issue is psql related (as in mysql you do not have this 
problem) - maybe the "select" function prints the BLOBs in hexa....I do 
not think it is a hexa storage, but a hexa display.

Regards,
Bogdan

opensipslist at encambio.com wrote:
> Hello list,
>
> I'm using:
>
>   Solaris 11 x86 (nv-b91)
>   OpenSIPS 1.6.4 with TLS
>
> ...and am logging dialogs with the siptrace module.
>
> The problem is that every time I want to look at the traced messages
> in the sip_trace table, I do:
>
>   $ psql opensips opensips
>   opensips=> select * from sip_trace where fromip = 'tcp:1.2.3.4:5678';
>   id | time_stamp | callid | traced_user | msg | method | ...
>   1234 | 2011-02-03 | ... | | \x494e56495445207369703a...
>
> As you can see, the 'msg' column ASCII text is stored as hex values.
> The next thing I do is use my mouse to cut and paste the message
> (extremely long and tedious) to the window in:
>
>   http://www.dolcevie.com/js/converter.html
>
> ...which translates '\x494e56495445207369703a' to 'INVITE sip:'.
>
> This way of debugging is not acceptable at all, and I want to
> see the ASCII text of the SIP message directly (without converting.)
>
> How can I read the siptrace logs in this way?
>
> Is it a bug that OpenSIPS stores the ASCII message text in hex?
>
> Regards,
> Brian
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS Event - expo, conf, social, bootcamp
2 - 4 February 2011, ITExpo, Miami,  USA
OpenSIPS solutions and "know-how"