[SR-Users] issue using sipcapture to pg database

[Pavlo Karbovnyk]

Hi David.
Convert to bytes like this:
select id, fromip,toip,time_stamp,  msg::bytea from sip_trace
Regards.
On Tue, 2015-11-24 at 16:59 +0100, david escartin wrote:
> hello how are you?
> 
> 
> i have a problem using sipcapture module
> i'm writing in postgres database some sip messages but the msg field
> is stored ina  strange format, 
> 
> \x5349502f322e30203438372052657175657374205465726d696e61746
> 5640d0a5669613a205349502f322e302f5544502037392e3137302e36342e3136383a
> 353038303b6272616e63683d7a39684734624b30583665375a70394e446533513b726
> 56365697665643d37392e3137302e36342e3136383b72706f72743d353038300d0a52
> 65636f72642d526f7574653a
> 203c7369703a3139302e3136362e3233322e3139333a393236323b7472616e73706f7
> 2743d7564703b6c723e2c3c7369703a37392e3137302e36382e3138363b6c723b6674
> 61673d394448397648374435444653653b6469643d3639612e616437393e0d0a43616
> c6c2d49443a2033323666333
> 037632d373138642d346164392d393234362d3333336432323466613439380d0a4672
> 6f6d3a2022313931373838393437363922203c7369703a31393137383839343736394
> 037392e3137302e36342e3136383e3b7461673d394448397648374435444653650d0a
> 546f3a203c7369703a313830
> 39323935373838374037392e3137302e36382e3138363a353036303b757365723d706
> 86f6e653e3b7461673d736263303830367974646c746f6c302d43432d33300d0a4353
> 65713a20383338353333383820494e564954450d0a5761726e696e673a20333939203
> 1302e31382e352e363420225
> 353313230303031463135364c3934345b30303030305d2043616e63656c2072656365
> 69766564206f6e20696e697469616c20696e76697465220d0a436f6e74656e742d4c6
> 56e6774683a20300d0a0d0a
> 
> do you know how to configure it to see it in ascii?
> 
> thanks a lot and regards
> david escartin
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
> list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20151125/62694afa/attachment.html>