-   Linux - Newbie (
-   -   apache or mysql time (

rubella 02-27-2006 04:44 AM

apache or mysql time
hey all

on my ubuntu apache/mysql server, time is running with 6 houres of difference... like my server is living in another timezone...

i use a ntp-server to correct time and when i do 'date' i see the correct time... when i insert queries with timestamps into the databank, i have 6 houres of difference...

someone an idea how to fix this? is there somewhere else living a timezone?


timmeke 02-28-2006 05:08 AM

First of all, NTP will set the correct date and time, but you'll need to configure your local timezone too.
Secondly, the difference of exactly 6 hours isn't due perhaps to the fact that MySql uses UTC standard times by default, for instance?
In other words, what is the time difference between your zone and the UTC zone?

Furthermore, have you checked out the MySql manual on Time zone settings? taken from the manual of MySql 5.
I suppose other versions of MySql use similar time zone features.

rubella 02-28-2006 07:45 AM

hey tim! thx voor de reply! check ik zeker uit! ;)

does someone knows how i can change the timezone without using the base-setup? thx!

timmeke 02-28-2006 08:28 AM

You're welcome, rubella.

On my RH8 box, I click with right mouse button on the date/time in the Gnome panel.
Then I select "adjust date & time" from the context menu that appears.
After supplying the root password, I can change the date, time, whether or not NTP is to be used as well as the timezone.

The program

seems to bring up the same configuration GUI.

Maybe there's some graphical config for that in your menu too. Personnally, I haven't worked with Debian yet, so I can't provide more practical help.

All times are GMT -5. The time now is 11:38 AM.