"Server Time" for timeclock

For complex topics that regular users would not be interested in. For power users and database administrators.

"Server Time" for timeclock

Postby drtech » Mon Mar 18, 2019 7:18 am

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).
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com
User avatar
drtech
 
Posts: 1601
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO

Re: "Server Time" for timeclock

Postby drtech » Mon Mar 18, 2019 7:29 am

also text message time seems to be tied to "Server time" and off in my case by 7 hours (CST + Daylight savings time)
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com
User avatar
drtech
 
Posts: 1601
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO

Re: "Server Time" for timeclock

Postby jsalmon » Mon Mar 18, 2019 9:16 am

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.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com
User avatar
jsalmon
 
Posts: 1486
Joined: Tue Nov 30, 2010 1:33 pm

Re: "Server Time" for timeclock

Postby drtech » Mon Mar 18, 2019 9:53 am

yes, that was it, had to restart the mysql service after fixing the server time. Thanks.
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com
User avatar
drtech
 
Posts: 1601
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO

Re: "Server Time" for timeclock

Postby jsalmon » Mon Mar 18, 2019 9:57 am

I'll see about getting this information into the following page in our manual.
https://www.opendental.com/manual/manage.html
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com
User avatar
jsalmon
 
Posts: 1486
Joined: Tue Nov 30, 2010 1:33 pm


Return to Advanced Topics

Who is online

Users browsing this forum: No registered users and 3 guests