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 > <spen...@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 <mico...@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 _______________________________________________ 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
