[OpenSER-Users] Strange Time Format

Marc LEURENT lftsy at free.fr
Thu Sep 27 19:28:53 CEST 2007


-----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 at sd-6444.dedibox.fr:5060;user=phone>;tag=c0a80101-81fe9a1\r\nTo:
<sip:jbchavanne at sip.wifirst.net;user=phone>;tag=c0a80101-f7fdd17\r\nCall-ID: 75359d5c-c0a80101-0-10 at 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 at 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 at 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-----




More information about the Users mailing list