From owner-freebsd-questions Tue Oct 19 3:36:27 1999 Delivered-To: freebsd-questions@freebsd.org Received: from boom.calcasieu.com (boom.calcasieu.com [209.99.46.80]) by hub.freebsd.org (Postfix) with ESMTP id EFD94165FE for ; Tue, 19 Oct 1999 03:36:19 -0700 (PDT) (envelope-from dread@calcasieu.com) Received: from coypu.bb.calcasieu.com (coypu.bb.calcasieu.com [192.168.3.21]) by boom.calcasieu.com (8.9.3/8.9.3) with ESMTP id FAA25431; Tue, 19 Oct 1999 05:34:50 -0500 (CDT) Message-ID: X-Mailer: XFMail 1.3 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <1145CD545D54D211BCEB0060B067AD0614776E@RETINA> Date: Tue, 19 Oct 1999 05:34:49 -0500 (CDT) Organization: Calcasieu Lumber From: Don Read To: Mike Bartlett Subject: RE: TZ problem with MYSQL Cc: "freebsd-questions@freebsd.org" Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On 19-Oct-99 Mike Bartlett wrote: > 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? add in /usr/local/etc/rc.d/mysqld.sh : TZ="CDT6CST"; export TZ Regards, --- Don Read dread@calcasieu.com EDP Manager dread@texas.net Calcasieu Lumber Co. Austin TX -- Y2K is not a problem, W2K however ... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message