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
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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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@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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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@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@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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-
Daniel-Constantin Mierla -
Spencer Thomason