14 Jan
2016
14 Jan
'16
11:38 p.m.
Hello,
I’m attempting to deploy a homer sip capture server on SPARC and I’m seeing some strange
date related errors:
ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query:
Incorrect datetime value: '2052-06-12 16:21:06' for column 'date' at row 1
(1292)
Is there some sore of endianness issue?
Thanks for any assistance!
Regards,
Spencer
15 Jan
15 Jan
8:55 a.m.
Hello,
this looks like an issue on the SQL query syntax. What version of mysql
server do you run there?
Cheers,
Daniel
On 14/01/16 22:38, Spencer Thomason wrote:
Hello,
I’m attempting to deploy a homer sip capture server on SPARC and I’m seeing some strange
date related errors:
ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query:
Incorrect datetime value: '2052-06-12 16:21:06' for column 'date' at row 1
(1292)
Is there some sore of endianness issue?
Thanks for any assistance!
Regards,
Spencer
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Book: SIP Routing With Kamailio - http://www.asipto.com
http://miconda.eu
10:01 a.m.
Hi Daniel,
I’m running mysql 5.6.21. I haven’t had time to really do much debugging but I have setup
a sip capture server with the same config on both Linux and FreeBSD on x86. If you have
any idea of where to look, I’ll be happy to dig deeper.
It shouldn’t matter that the agents are running on x86 and the capture server is sparc
right?
Thanks!
Spencer
On Jan 14, 2016, at 10:55 PM, Daniel-Constantin Mierla
<miconda(a)gmail.com> wrote:
Hello,
this looks like an issue on the SQL query syntax. What version of mysql
server do you run there?
Cheers,
Daniel
On 14/01/16 22:38, Spencer Thomason wrote:
Hello,
I’m attempting to deploy a homer sip capture server on SPARC and I’m seeing some strange
date related errors:
ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query:
Incorrect datetime value: '2052-06-12 16:21:06' for column 'date' at row 1
(1292)
Is there some sore of endianness issue?
Thanks for any assistance!
Regards,
Spencer
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Book: SIP Routing With Kamailio - http://www.asipto.com
http://miconda.eu
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
19 May
19 May
12:12 a.m.
Hi Daniel,
I know its been some time since looking at this but I finally had the time to dig deeper.
It appears that the timestamps inserted by the sip trace module are in host order, not
network order. This obviously creates an issue when the endianess of the agent and
capture server do not match. I’m happy to create a pull request but I’m not sure what
byte order the timestamp is “supposed” to be for HEPv2. It appears that HEPv3/EEPv3
specifies uint16 and uint32 payloads as network byte order but I can’t find anything about
HEPv2.
Regards,
Spencer
On Jan 15, 2016, at 12:01 AM, Spencer Thomason
<spencer(a)whiteskycommunications.com> wrote:
Hi Daniel,
I’m running mysql 5.6.21. I haven’t had time to really do much debugging but I have
setup a sip capture server with the same config on both Linux and FreeBSD on x86. If you
have any idea of where to look, I’ll be happy to dig deeper.
It shouldn’t matter that the agents are running on x86 and the capture server is sparc
right?
Thanks!
Spencer
On Jan 14, 2016, at 10:55 PM, Daniel-Constantin
Mierla <miconda(a)gmail.com> wrote:
Hello,
this looks like an issue on the SQL query syntax. What version of mysql
server do you run there?
Cheers,
Daniel
On 14/01/16 22:38, Spencer Thomason wrote:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Hello,
I’m attempting to deploy a homer sip capture server on SPARC and I’m seeing some strange
date related errors:
ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query:
Incorrect datetime value: '2052-06-12 16:21:06' for column 'date' at row 1
(1292)
Is there some sore of endianness issue?
Thanks for any assistance!
Regards,
Spencer
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Book: SIP Routing With Kamailio - http://www.asipto.com
http://miconda.eu
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
3116
days inactive
3241
days old
3 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Spencer Thomason