26 Nov
2015
26 Nov
'15
2:22 a.m.
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users