"Server Time" for timeclock

[drtech]

I just set up an lxc container as a virtual machine for my mysql server, but I am finding the "server time" in manage is getting UTC time and not my set timezone. The rest of the program operates as expected and the time stamps are in the correct timezone. How is the "server time" listed in manage different and where exactly does it draw the time? (This may be an lxc container issue, but I am trying to figure out why it isn't working as it did when I ran a normal virtual machine instead of an lxc container).

[drtech]

also text message time seems to be tied to "Server time" and off in my case by 7 hours (CST + Daylight savings time)

[jsalmon]

The "Server Time" is a reflection of the time reported by your MySQL server. You can run the following query manually and it should match what is displayed within the Manage module:

Code: Select all

SELECT NOW()

If you need to adjust your server time, or have already done so, then you should restart your MySQL service afterwards so that MySQL is made aware of the Date/Time manipulation that was just performed at the OS level.

[drtech]

yes, that was it, had to restart the mysql service after fixing the server time. Thanks.

[jsalmon]

I'll see about getting this information into the following page in our manual.
https://www.opendental.com/manual/manage.html