[BlueOnyx:23067] Re: Time difference

[Ken Hohhof]

I once had a VoIP phone system where all the phones displayed the wrong time, off by a strange number of minuted.

Turned out it was getting time via NTP from a router that in turn was using an obscure public time server that was freerunning.

---- Original Message ----
From: "Franklin Werren" <fswerren at gmail.com>
Sent: 8/1/2019 2:42:44 PM
To: "BlueOnyx General Mailing List" <blueonyx at mail.blueonyx.it>
Subject: [BlueOnyx:23065] Re: Time difference

Did you check the hardware clock or is the battery on the motherboard weak or dead???

Just my 2 cents...


Sent from my iPhone
Franklin S Werren - N2JYG
PO Box 966
4017 Sherman - Ripley Rd
Sherman NY 14781-0966


> On Aug 1, 2019, at 2:40 PM, Colin Jack <colin at mainline.co.uk> wrote:
> 
> Hi Michael,
> 
>    Hi Colin,
> 
>> I wonder if anybody can help with a weird time problem?
>> 
>> Customer has a webpage which writes to a MySQL database (for employee clocking on and off).
>> 
>> This has been working fine for a couple of years and now they are seeing  a18- 20 minute difference between the time when the employee clocks in (showing on web page) and the time recorded on the database!
>> Server is not under any strain -- time zone is correct.
> 
>    Twenty minutes is also an odd time-delta. If it was in full hours I
>    might suspect that perhaps PHP or the server itself is operating on the
>    wrong time zone. But 20 minutes? That's really odd.
> 
> I agree - this is what is strange. My initial thought was time zones.
> 
>    The question here is: What generates the time stamps? Are these MySQL
>    time stamps or are they generated by PHP or another application and are
>    then inserted into MySQL as is?
> 
>    If they're MySQL time stamps, then I'd suggest to restart MySQLd. Maybe
>    it's internal clock is out of whack with the server time and a restart
>    of MySQLd will fix that.
> 
> I will ask the question. Restarting MYSQLd didn't make any difference. 
> A server reboot brought everything into line and then about an hour later it went back to a 20 minutes difference!!
> 
>    If it doesn't, then you'd need to find out what actually generates the
>    time stamps, because that's where the problem most likely comes from.
> 
> Many thanks
> 
> Colin 
> 
> 
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx

_______________________________________________
Blueonyx mailing list
Blueonyx at mail.blueonyx.it
http://mail.blueonyx.it/mailman/listinfo/blueonyx