Skip to main content

world timestamp is not matching for mysql

durangod
There is a 10m54 sec offset to my timestamp and its causing havoc with one of my site databases which monitors the difference. from ssh root when i use now it gives me the following
root@vulcan [/etc]# mysql -e "SELECT NOW();" +---------------------+ | NOW() | +---------------------+ | 2014-10-26 13:38:08 | +---------------------+
but the actual time is 13:48 on my pic and via [url=http://www.unixtimestamp.com/]Unix TimeStamp - Epoch Generator & Converter is 7:48 pm i set the server time in WHM and also synced it but still same issue. How do i make up (add that 10 min) to my system time? i normally use denver time so that is -6 i believe.

Comments

11 comments

Date Votes
  • durangod
    update: one thing i tried is via ssh i edited my.cnf like so
    default-time-zone = '-05:50'
    which since i normally do -06:00 via whm this now gives me the correct time when i do NOW however this still does not fix the issue because it still does not change mysql default timestamp. I also via whm synced it with the server but still no difference. so what now?
    0
  • durangod
    update it seems the NOW is not what i needed to change i need to change this
    mysql -e "SELECT UTC_TIMESTAMP();" +---------------------+ | UTC_TIMESTAMP() | +---------------------+ | 2014-10-26 23:11:34 | +---------------------+
    i need to add 10 min to that
    0
  • durangod
    so i have the command now i just need to firgure out where to put it..
    so i have the command now i just need to figure out where to put it mysql -e "SELECT CONVERT_TZ(UTC_TIMESTAMP(), @@session.time_zone, '+00:20');" +------------------------------------------------------------+ | CONVERT_TZ(UTC_TIMESTAMP(), @@session.time_zone, '+00:20') | +------------------------------------------------------------+ | 2014-10-27 06:03:57 | +------------------------------------------------------------+ which is correct now or i could do @@global i guess
    0
  • durangod
    so tell me why my server time is off please?
    0
  • durangod
    here is the error im getting from the third party script. We have determined that the issue is on the server side as the procon side has the correct UTC timestamp. [12:05:59 64] [AdKats] ERROR: Your PRoCon layer and database have a 10m54s UTC timestamp mismatch. UTC-Database:(10/26/2014 5:55:05 PM) UTC-Procon:(10/26/2014 6:05:59 PM)
    it has to be less than 5 min diff i believe.
    0
  • durangod
    i guess maybe i should open a ticket on this to find out whats up with my UTC on the server
    0
  • durangod
    ticket 5626203 done
    0
  • durangod
    ok i was told to check this out by support [url=http://superuser.com/questions/444733/linux-ntpd-and-ntpdate-service]Linux ntpd and ntpdate service - Super User From what i undestand the ntpd is in already on your system you just need to install it. And so i needed some instructions and took me a bit but i found these instructions which seem to be pretty good instructions so far, we will see what happens. [url=http://www.cyberciti.biz/faq/howto-install-ntp-to-synchronize-server-clock/]CentOS Linux Install and Configure NTP to Synchronize The System Clock
    0
  • durangod
    important!!! some things have changed since those instructions. it works good until you get to the pool server you can no longer use the pool.ntp.org server you will get a not permitted message in putty. i guess they are trying to keep it clean and healthy and faster so it says near the botton of this page about this. These are some of the changes. Here are two links.. [url=http://www.ntppool.org/join/configuration.html#management-queries]pool.ntp.org: the internet cluster of ntp servers and here is the link they offer of a list of servers to use [url=http://support.ntp.org/bin/view/Servers/WebHome]WebHome < Servers < NTP hope that helps of course nothing goes as planned in this business does it now.. [~]# ntpdate pool.ntp.org 28 Oct 04:07:37 ntpdate[17906]: step-systime: Operation not permitted [~]# /etc/network/if-up.d/ntpdate -bash: /etc/network/if-up.d/ntpdate: No such file or directory [~]# ntpdate 3.pool.ntp.org 28 Oct 04:17:02 ntpdate[18357]: step-systime: Operation not permitted [~]# ntpdate north-america.pool.ntp.org 28 Oct 04:17:38 ntpdate[18389]: step-systime: Operation not permitted [~]# ntpdate 1.north-america.pool.ntp.org 28 Oct 04:19:15 ntpdate[19476]: step-systime: Operation not permitted
    so now what lol
    0
  • durangod
    as it turns out this is something my server host has to do as i am on virtuoso
    0
  • cPanelMichael
    ]as it turns out this is something my server host has to do as i am on virtuoso

    Hello :) I am happy to see you were able to determine the best course of action. Feel free to update us with the outcome. Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post