Hi,
while trying to use sipcapture together with PostgreSQL I've found that it
stores the "\r\n" in SIP messages as "\015\012", though not without a
lot
of noise in the PostgreSQL log files.
For every line inserted in PostgreSQL I get:
[0] WARNING: nonstandard use of \\ in a string literal at character 763
[0] HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
[0] STATEMENT: insert into sip_capture
(date,micro_ts,method,reply_reason,ruri,ruri_user,from_user,from_tag,to_user,to_tag,pid_user,contact_user,auth_user,callid,callid_aleg,via_1,via_1_branch,cseq,reason,content_type,auth,user_agent,source_ip,source_port,destination_ip,destination_port,contact_ip,contact_port,originator_ip,originator_port,proto,family,rtp_stat,type,node,msg)
values ('2013-01-24
15:27:43',1359037663218925,'OPTIONS','','sip:129.240.253.134','','keepalive','533cb9e91f4b999cf76861cbb9ed54ed-149d','','','','','','5001ed5d-6979@127.0.0.1','','SIP/2.0/UDP
129.240.253.197;branch=z9hG4bKae6f.d4a02ac7.0','z9hG4bKae6f.d4a02ac7.0','10
OPTIONS','','','','kamailio (3.3.3
(i386/linux))','129.240.253.197',5060,'129.240.253.134',5060,'',0,'',0,1,2,'',1,'voipt1:21','OPTIONS
sip:129.240.253.134 SIP/2.0\\015\\012Via: SIP/2.0/UDP
129.240.253.197;branch=z9hG4bKae6f.d4a02ac7.0\\015\\012To:
sip:129.240.253.134\\015\\012From:
sip:keepalive@edgetest.voip.uio.no;tag=533cb9e91f4b999cf76861cbb9ed54ed-149d\\015\\012CSeq:
10 OPTIONS\\015\\012Call-ID: 5001ed5d-6979(a)127.0.0.1\\015\\012Content-Length:
0\\015\\012User-Agent:
kamailio (3.3.3 (i386/linux))\\015\\012\\015\\012')
Kamailio as of latest git on the 3.3 branc +
3e580e1ee24f9b9ec4b1fa151b23ebc84f3db1cb. Same warnings when linked with
both PostgreSQL 8.4.13 and 9.1.1.
According to Alexandr Dubovikov MySQL stores '\r\n' as '\r\n'.
--
Øyvind Kolbu