sipcapture + db_postgres gives lots of warnings on PostgreSQL server
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@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
participants (1)
-
Øyvind Kolbu