LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-27-2006, 05:44 AM   #1
rubella
Member
 
Registered: Sep 2005
Location: Europe
Distribution: debian sarge
Posts: 65

Rep: Reputation: 15
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?

thx!
 
Old 02-28-2006, 06:08 AM   #2
timmeke
Senior Member
 
Registered: Nov 2005
Location: Belgium
Distribution: Red Hat, Fedora
Posts: 1,515

Rep: Reputation: 61
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?

http://dev.mysql.com/doc/refman/5.0/...e-support.html
...is taken from the manual of MySql 5.
I suppose other versions of MySql use similar time zone features.
 
Old 02-28-2006, 08:45 AM   #3
rubella
Member
 
Registered: Sep 2005
Location: Europe
Distribution: debian sarge
Posts: 65

Original Poster
Rep: Reputation: 15
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!
 
Old 02-28-2006, 09:28 AM   #4
timmeke
Senior Member
 
Registered: Nov 2005
Location: Belgium
Distribution: Red Hat, Fedora
Posts: 1,515

Rep: Reputation: 61
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
Code:
system-config-date
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql time difference textomat Programming 1 06-04-2005 02:05 PM
How To make MySql and Apache start at boot time? umeshz Red Hat 1 05-18-2004 02:00 PM
Starting Mysql server at booting time learner Linux - Software 2 09-22-2003 08:47 AM
PHP and MySQL - login elapse time Manuel-H Linux - General 0 08-08-2003 09:00 AM
accessing mysql from apache/mysql vher Linux - Newbie 1 01-17-2003 03:38 PM


All times are GMT -5. The time now is 07:48 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration