From owner-freebsd-questions Tue Oct 19 2:43:18 1999 Delivered-To: freebsd-questions@freebsd.org Received: from ctb-mesg1.saix.net (ctb-mesg1.saix.net [196.25.240.73]) by hub.freebsd.org (Postfix) with ESMTP id 3C7D8164EE for ; Tue, 19 Oct 1999 02:43:14 -0700 (PDT) (envelope-from cataract@eye2eye.net) Received: from saix.net (cbs53-01-p229.wc.saix.net) by ctb-mesg1.saix.net (Sun Internet Mail Server sims.3.5.1999.03.02.17.58.p5) with SMTP id <0FJU0014ZGBYK4@ctb-mesg1.saix.net> for freebsd-questions@freebsd.org; Tue, 19 Oct 1999 11:43:12 +0200 (SAT) Received: from retina.eye2eye.net [192.168.62.1] by eye2eye.net [127.0.0.1] with SMTP (MDaemon.v2.7.SP0.R) for ; Tue, 19 Oct 1999 11:37:27 +0200 Received: by RETINA with Internet Mail Service (5.0.1459.74) id ; Tue, 19 Oct 1999 11:36:41 +0200 Date: Tue, 19 Oct 1999 11:36:40 +0200 From: Mike Bartlett Subject: TZ problem with MYSQL To: "'freebsd-questions@freebsd.org'" Message-id: <1145CD545D54D211BCEB0060B067AD0614776E@RETINA> MIME-version: 1.0 X-Mailer: Internet Mail Service (5.0.1459.74) Content-type: text/plain; CHARSET=US-ASCII X-MDaemon-Deliver-To: freebsd-questions@freebsd.org Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi all, I'm having a problem right now with mysql as you will see in the paste below (should explain everything) mysql> select now() -> ; +---------------------+ | now() | +---------------------+ | 1999-10-19 09:07:57 | +---------------------+ 1 row in set (0.00 sec) bash-2.03# date Tue Oct 19 11:11:18 SAST 1999 The below paste is from the MYSQL manual. If you have a problem with SELECT NOW() returning values in GMT and not your local time, you have to set the TZ environment variable to your current timezone. This should be done for the environment in which the server runs, for example in safe_mysqld or mysql.server. I've added TZ=SAST export SAST to my mysql.server. I've also put those two lines in my mysql.sh in rc.d, but they seem to be having no effect. Any idea what the problem may be here? Regards Mike Bartlett To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message