[SR-Users] Sipcapture on SPARC

[Spencer Thomason]

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 at 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 at 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 at 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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users