[SR-Users] sipcapture + db_postgres gives lots of warnings on PostgreSQL server

[Øyvind Kolbu]

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 at 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 at edgetest.voip.uio.no;tag=533cb9e91f4b999cf76861cbb9ed54ed-149d\\015\\012CSeq:
10 OPTIONS\\015\\012Call-ID: 5001ed5d-6979 at 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