-----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@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','')
On Thursday 27 September 2007, Marc LEURENT wrote:
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...
Hello Marc,
probably this is related to the folowing Bug/commit in svn trunk:
r2679 | henningw | 2007-08-30 13:18:48 +0200 (Do, 30 Aug 2007) | 3 lines
- fix data type for time value, this is a time_t and not an int - Bug 1783705
I'll do tomorow a backport to 1.2.
Cheers,
Henning
Hi Marc,
There was recently an issue with sip_trace identified below.
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1783705...
Are you running on a 64-bit machine ?
Regards, Norm
Marc LEURENT wrote:
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@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','')
_______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Yes... A debian Linux krusty 2.6.18-5-amd64 #1 SMP Thu Aug 30 01:14:54 UTC 2007 x86_64 GNU/Linux
I'm reading your URL... Thanks
Norman Brandinger a écrit :
Hi Marc,
There was recently an issue with sip_trace identified below.
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1783705...
Are you running on a 64-bit machine ?
Regards, Norm
Marc LEURENT wrote:
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@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','')
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Thanks!!
Have a nice day
Henning Westerholt a écrit :
On Thursday 27 September 2007, Marc LEURENT wrote:
Yes... A debian Linux krusty 2.6.18-5-amd64 #1 SMP Thu Aug 30 01:14:54 UTC 2007 x86_64 GNU/Linux
I've backported the patch. If you update from branch 1.2 this bug should be fixed.
Cheers,
Henning
-
Henning Westerholt -
Marc LEURENT -
Norman Brandinger