-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello everybody,
I have a very strange thing:
The time on my openser server and on my SIP clients is around: Thu Sep 27 19:22:07 CEST
2007
But when I look the sip_trace mysql request, it's written: '1516687-12-17
11:16:51'
It seems to be an error of parsing...
Have you got any idea who to fix it?
I have tried to add append_time() and to remove it, but it doesn't change anything...
Thanks,
Marc
T 172.24.0.8:56702 -> 172.24.3.1:3306 [AP]
.....insert into sip_trace
(msg,callid,method,status,fromip,toip,date,direction,fromtag,traced_user ) values
('SIP/2.0 180 Ringing\r\nVia: SIP/2.0/UDP
213.91.4.198;branch=z9hG4bK803a.25dd3be.0\r\nVia: SIP/2.0/UDP
62.210.194.120:1029;rport=1027;branch=z9hG4bK1364252036021976086\r\nFrom:
\"Polyconseil
TEST\"<sip:6710@sd-6444.dedibox.fr:5060;user=phone>;tag=c0a80101-81fe9a1\r\nTo:
<sip:jbchavanne@sip.wifirst.net;user=phone>;tag=c0a80101-f7fdd17\r\nCall-ID:
75359d5c-c0a80101-0-10(a)192.168.95.68\r\nCSeq: 1 INVITE\r\nAllow:
INVITE,ACK,BYE,CANCEL,OPTIONS,PRACK,SUBSCRIBE,NOTIFY,UPDATE,REFER,REGISTER,INFO\r\nContact:
<sip:jbchavanne@62.210.194.120:1049;user=phone>\r\nRecord-Route:
<sip:213.91.4.198;lr=on;ftag=c0a80101-81fe9a1>\r\nAllow-Events:
refer,dialog,message-summary,check-sync,talk,hold\r\nContent-Length:
0\r\n\r\n','75359d5c-c0a80101-0-10@192.168.95.68','','180','62.210.194.120:1037','udp:213.91.4.198:5060','1516687-12-17
11:16:51','in','c0a80101-81fe9a1','')
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla -
http://enigmail.mozdev.org
iD8DBQFG++hVqjpLE0HiOBYRAsL8AKCSrhtug5CSx+thLz4iaqpQJ8iaUQCglrWv
3aiquJBzx+a1V3+AS6Gt4Dk=
=jN+R
-----END PGP SIGNATURE-----