RT email time

Juan_N_DLC · June 2, 2010, 6:13pm

Hi,

For some reazon my RT is sending the emails when any action is configured
with 4 hours of difference from the real time.

from GUI:
Dates https://srthr31/Ticket/ModifyDates.html?id=1934 Created: Wed Jun 02
14:10:24 2010
from email sent:
Created On: 2010-06-02 18:10:24

Any configuration should I need to look at? Can someone point me to where
look?
Thanks

Stefan_Hornburg · June 2, 2010, 7:31pm

Hi,

For some reazon my RT is sending the emails when any action is configured
with 4 hours of difference from the real time.

from GUI:
Dateshttps://srthr31/Ticket/ModifyDates.html?id=1934 Created: Wed Jun 02
14:10:24 2010
from email sent:
Created On: 2010-06-02 18:10:24

Any configuration should I need to look at? Can someone point me to where
look?

What about $Timezone setting in RT_SiteConfig.pm. Debian packages are using:

Set($Timezone, /bin/date +%Z);

Regards
Racke

LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

Juan_N_DLC · June 2, 2010, 7:40pm

Hi,

In my RT_SiteConfig.pm i have this:

Time Zone:

Set($Timezone , ‘America/Puerto_Rico’);On Wed, Jun 2, 2010 at 3:31 PM, Stefan Hornburg (Racke) racke@linuxia.dewrote:

On 06/02/2010 08:13 PM, Juan N. DLC wrote:

Hi,

For some reazon my RT is sending the emails when any action is configured
with 4 hours of difference from the real time.

from GUI:
Dateshttps://srthr31/Ticket/ModifyDates.html?id=1934 Created: Wed Jun
02

14:10:24 2010
from email sent:
Created On: 2010-06-02 18:10:24

Any configuration should I need to look at? Can someone point me to where
look?

What about $Timezone setting in RT_SiteConfig.pm. Debian packages are
using:

Set($Timezone, /bin/date +%Z);

Regards
Racke

–
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Juan_N_DLC · June 2, 2010, 7:46pm

yes, that is the problem I’m having. Any thoughts?On Wed, Jun 2, 2010 at 3:43 PM, Stefan Hornburg (Racke) racke@linuxia.dewrote:

On 06/02/2010 09:39 PM, Juan N. DLC wrote:

Hi,

I have this in my RT_SiteConfig.pm

Time Zone:

Set($Timezone , ‘America/Puerto_Rico’);

OK, so the times are showing up correctly in the RT web interface, but not
on email sent?
Maybe you need to tweak your system time zone as well!?

Regards
Racke

–
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

Stefan_Hornburg · June 2, 2010, 8:00pm

yes, that is the problem I’m having. Any thoughts?

Which distribution do you run? What is the output of date +%Z?

Regards
Racke

LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

Juan_N_DLC · June 2, 2010, 8:17pm

Racke,

weoms@SRTHR31:~$ /bin/date +%Z
AST

weoms@SRTHR31:~$ uname -a
Linux SRTHR31 2.6.31-16-generic-pae #53-Ubuntu SMP Tue Dec 8 05:20:21 UTC
2009 i686 GNU/Linux

weoms@SRTHR31:~$ cat /etc/issue
Ubuntu 9.10 \n \lOn Wed, Jun 2, 2010 at 4:00 PM, Stefan Hornburg (Racke) racke@linuxia.dewrote:

On 06/02/2010 09:46 PM, Juan N. DLC wrote:

yes, that is the problem I’m having. Any thoughts?

Which distribution do you run? What is the output of date +%Z?

Regards
Racke

–
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Stefan_Hornburg · June 2, 2010, 8:27pm

Racke,

weoms@SRTHR31:~$ /bin/date +%Z
AST

That should be the correct timezone for Puerto Rico (GMT - 4). Do you have the
same problem sending email for the command line (e.g. with mail from bds-mailx
package)? Which email server are you using?

Regards
Racke

LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

Juan_N_DLC · June 2, 2010, 8:39pm

I’m using postfix from box and relay with domain ms-exchange server.

i did a sendmail test to my email and checked the Internet headers from
email:

for jcruz@xxx.com; Wed, 2 Jun 2010 18:30:53 -0400
Received: by SRTHR31.xxx.com (Postfix, from userid 1001)
id D227D48318; Thu, 3 Jun 2010 00:35:50 +0400 (AST)
subject: time test
Message-Id: 20100602203550.D227D48318@SRTHR31.xxx.comDate: Thu, 3 Jun 2010 00:35:45 +0400 (AST)
From: weoms@xxx.com (weoms)
To: undisclosed-recipients:;
Return-Path: weoms@xxx.com
X-OriginalArrivalTime: 02 Jun 2010 20:35:56.0000 (UTC)
FILETIME=[33A39E00:01CB0293]

Jason_Maderios2 · June 2, 2010, 9:07pm

Juan,

Time is a pain - Generally I do the following and it works well.

Set system clock to UTC
Set the correct timezone in the OS
Setup and run ntpd
Set the default Timezone according to RT Docs.

In CentOS / RH world this is accomplished by running the setup utility.

Ubuuntu search led me to : UbuntuTime - Community Help Wiki

I scanned the doc and it covers steps 1 to 3.

Regards,

Jason MaderiosFrom: Juan N. DLC
Sent: Wednesday, June 02, 2010 12:39 PM
To: RT-Users@lists.bestpractical.com
Subject: Re: [rt-users] RT email time

I’m using postfix from box and relay with domain ms-exchange server.

i did a sendmail test to my email and checked the Internet headers from email:

for jcruz@xxx.com; Wed, 2 Jun 2010 18:30:53 -0400
Received: by SRTHR31.xxx.com (Postfix, from userid 1001)
id D227D48318; Thu, 3 Jun 2010 00:35:50 +0400 (AST)
subject: time test
Message-Id: 20100602203550.D227D48318@SRTHR31.xxx.com
Date: Thu, 3 Jun 2010 00:35:45 +0400 (AST)
From: weoms@xxx.com (weoms)
To: undisclosed-recipients:;
Return-Path: weoms@xxx.com
X-OriginalArrivalTime: 02 Jun 2010 20:35:56.0000 (UTC) FILETIME=[33A39E00:01CB0293]

Juan_N_DLC · June 3, 2010, 2:02am

Jason,

Thank you for the input I will try this and give update later.On Wed, Jun 2, 2010 at 5:07 PM, Jason Maderios jmaderios@kpu.net wrote:

Juan,

Time is a pain - Generally I do the following and it works well.

Set system clock to UTC

Set the correct timezone in the OS

Setup and run ntpd

Set the default Timezone according to RT Docs.

In CentOS / RH world this is accomplished by running the setup utility.

Ubuuntu search led me to : UbuntuTime - Community Help Wiki

I scanned the doc and it covers steps 1 to 3.

Regards,

Jason Maderios

From: Juan N. DLC juann.dlc@gmail.com
Sent: Wednesday, June 02, 2010 12:39 PM
To: RT-Users@lists.bestpractical.com
Subject: Re: [rt-users] RT email time

I’m using postfix from box and relay with domain ms-exchange server.

i did a sendmail test to my email and checked the Internet headers from
email:

for jcruz@xxx.com; Wed, 2 Jun 2010 18:30:53 -0400
Received: by SRTHR31.xxx.com (Postfix, from userid 1001)
id D227D48318; Thu, 3 Jun 2010 00:35:50 +0400 (AST)
subject: time test
Message-Id: 20100602203550.D227D48318@SRTHR31.xxx.com
Date: Thu, 3 Jun 2010 00:35:45 +0400 (AST)
From: weoms@xxx.com (weoms)
To: undisclosed-recipients:;
Return-Path: weoms@xxx.com
X-OriginalArrivalTime: 02 Jun 2010 20:35:56.0000 (UTC)
FILETIME=[33A39E00:01CB0293]

On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg (Racke) racke@linuxia.dewrote:

On 06/02/2010 10:17 PM, Juan N. DLC wrote:

Racke,

weoms@SRTHR31:~$ /bin/date +%Z
AST

That should be the correct timezone for Puerto Rico (GMT - 4). Do you have
the
same problem sending email for the command line (e.g. with mail from
bds-mailx
package)? Which email server are you using?

Regards
Racke

–
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Juan_N_DLC · June 3, 2010, 1:48pm

Jason,

I have my system setup like it should for my area, even installed webmin to
set the system clock and the hardware clock the same to see if that works
and nothing. The problem is MySQL that is using UTC time instead AST like I
want to.

But thanks for the information you posted.On Wed, Jun 2, 2010 at 10:02 PM, Juan N. DLC juann.dlc@gmail.com wrote:

Jason,

Thank you for the input I will try this and give update later.

On Wed, Jun 2, 2010 at 5:07 PM, Jason Maderios jmaderios@kpu.net wrote:

Juan,

Time is a pain - Generally I do the following and it works well.

Set system clock to UTC

Set the correct timezone in the OS

Setup and run ntpd

Set the default Timezone according to RT Docs.

In CentOS / RH world this is accomplished by running the setup utility.

Ubuuntu search led me to : UbuntuTime - Community Help Wiki

I scanned the doc and it covers steps 1 to 3.

Regards,

Jason Maderios

From: Juan N. DLC juann.dlc@gmail.com
Sent: Wednesday, June 02, 2010 12:39 PM
To: RT-Users@lists.bestpractical.com
Subject: Re: [rt-users] RT email time

I’m using postfix from box and relay with domain ms-exchange server.

i did a sendmail test to my email and checked the Internet headers from
email:

for jcruz@xxx.com; Wed, 2 Jun 2010 18:30:53 -0400
Received: by SRTHR31.xxx.com (Postfix, from userid 1001)
id D227D48318; Thu, 3 Jun 2010 00:35:50 +0400 (AST)
subject: time test
Message-Id: 20100602203550.D227D48318@SRTHR31.xxx.com
Date: Thu, 3 Jun 2010 00:35:45 +0400 (AST)
From: weoms@xxx.com (weoms)
To: undisclosed-recipients:;
Return-Path: weoms@xxx.com
X-OriginalArrivalTime: 02 Jun 2010 20:35:56.0000 (UTC)
FILETIME=[33A39E00:01CB0293]

On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg (Racke) <racke@linuxia.de wrote:

On 06/02/2010 10:17 PM, Juan N. DLC wrote:

Racke,

weoms@SRTHR31:~$ /bin/date +%Z
AST

That should be the correct timezone for Puerto Rico (GMT - 4). Do you
have the
same problem sending email for the command line (e.g. with mail from
bds-mailx
package)? Which email server are you using?

Regards
Racke

–
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Jason_Maderios2 · June 3, 2010, 3:10pm

Juan,

I believe that is correct behavior - Have you set the TZ in RT_Siteconfig?

Example:
Set($Timezone , ‘America/Anchorage’)

Regards,

Jason MaderiosFrom: Juan N. DLC
Sent: Thursday, June 03, 2010 5:48 AM
To: RT-Users@lists.bestpractical.com
Subject: Re: [rt-users] RT email time

Jason,

I have my system setup like it should for my area, even installed webmin to set the system clock and the hardware clock the same to see if that works and nothing. The problem is MySQL that is using UTC time instead AST like I want to.

But thanks for the information you posted.

Juan_N_DLC · June 3, 2010, 3:19pm

Yes, I do have the TZ configured in my RT_SiteConfig.pm

Time Zone:

Set($Timezone , ‘America/Puerto_Rico’);

LIke I said, the GUI time is working fine, the problem is MySQL, when
creating a ticket it set the Creation Time 4 hours after the real time.On Thu, Jun 3, 2010 at 11:10 AM, Jason Maderios jmaderios@kpu.net wrote:

Juan,

I believe that is correct behavior - Have you set the TZ in RT_Siteconfig?

Example:
Set($Timezone , ‘America/Anchorage’)

Regards,

Jason Maderios

From: Juan N. DLC juann.dlc@gmail.com
Sent: Thursday, June 03, 2010 5:48 AM
To: RT-Users@lists.bestpractical.com
Subject: Re: [rt-users] RT email time

Jason,

I have my system setup like it should for my area, even installed webmin to
set the system clock and the hardware clock the same to see if that works
and nothing. The problem is MySQL that is using UTC time instead AST like I
want to.

But thanks for the information you posted.

On Wed, Jun 2, 2010 at 10:02 PM, Juan N. DLC juann.dlc@gmail.com wrote:

Jason,

Thank you for the input I will try this and give update later.

On Wed, Jun 2, 2010 at 5:07 PM, Jason Maderios jmaderios@kpu.net wrote:

Juan,

Time is a pain - Generally I do the following and it works well.

Set system clock to UTC

Set the correct timezone in the OS

Setup and run ntpd

Set the default Timezone according to RT Docs.

In CentOS / RH world this is accomplished by running the setup utility.

Ubuuntu search led me to : UbuntuTime - Community Help Wiki

I scanned the doc and it covers steps 1 to 3.

Regards,

Jason Maderios

From: Juan N. DLC juann.dlc@gmail.com
Sent: Wednesday, June 02, 2010 12:39 PM
To: RT-Users@lists.bestpractical.com
Subject: Re: [rt-users] RT email time

I’m using postfix from box and relay with domain ms-exchange server.

i did a sendmail test to my email and checked the Internet headers from
email:

for jcruz@xxx.com; Wed, 2 Jun 2010 18:30:53 -0400
Received: by SRTHR31.xxx.com (Postfix, from userid 1001)
id D227D48318; Thu, 3 Jun 2010 00:35:50 +0400 (AST)
subject: time test
Message-Id: 20100602203550.D227D48318@SRTHR31.xxx.com
Date: Thu, 3 Jun 2010 00:35:45 +0400 (AST)
From: weoms@xxx.com (weoms)
To: undisclosed-recipients:;
Return-Path: weoms@xxx.com
X-OriginalArrivalTime: 02 Jun 2010 20:35:56.0000 (UTC)
FILETIME=[33A39E00:01CB0293]

On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg (Racke) < racke@linuxia.de> wrote:

On 06/02/2010 10:17 PM, Juan N. DLC wrote:

Racke,

weoms@SRTHR31:~$ /bin/date +%Z
AST

That should be the correct timezone for Puerto Rico (GMT - 4). Do you
have the
same problem sending email for the command line (e.g. with mail from
bds-mailx
package)? Which email server are you using?

Regards
Racke

–
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

James_Moseley · June 3, 2010, 3:46pm

I believe RT, by design, uses the UTC timestamp when storing data in the
database.

JamesOn Thu, Jun 3, 2010 at 10:19 AM, Juan N. DLC juann.dlc@gmail.com wrote:

Yes, I do have the TZ configured in my RT_SiteConfig.pm

Time Zone:

Set($Timezone , ‘America/Puerto_Rico’);

LIke I said, the GUI time is working fine, the problem is MySQL, when
creating a ticket it set the Creation Time 4 hours after the real time.

Juan_N_DLC · June 9, 2010, 1:01pm

So then, there is no way to change this? other than move my server local
time 4 hours behind the real time? That would affect the RT GUI too.On Thu, Jun 3, 2010 at 11:46 AM, James Moseley jmoseley@corp.xanadoo.comwrote:

I believe RT, by design, uses the UTC timestamp when storing data in the
database.

–
James

On Thu, Jun 3, 2010 at 10:19 AM, Juan N. DLC juann.dlc@gmail.com wrote:

Yes, I do have the TZ configured in my RT_SiteConfig.pm

Time Zone:

Set($Timezone , ‘America/Puerto_Rico’);

LIke I said, the GUI time is working fine, the problem is MySQL, when
creating a ticket it set the Creation Time 4 hours after the real time.

Kenneth_Marshall · June 9, 2010, 1:10pm

So then, there is no way to change this? other than move my server local
time 4 hours behind the real time? That would affect the RT GUI too.

I believe RT, by design, uses the UTC timestamp when storing data in the
database.

–
James

Yes, I do have the TZ configured in my RT_SiteConfig.pm

Time Zone:

Set($Timezone , ‘America/Puerto_Rico’);

LIke I said, the GUI time is working fine, the problem is MySQL, when
creating a ticket it set the Creation Time 4 hours after the real time.

You should be able to set the time_zone for your MySQL database
when it starts and/or the database connection. Then you will be able
to retrieve/set the correct values. (Not a MySQL expert.)

Cheers,
Ken

Kevin_Falcone · June 9, 2010, 2:57pm

So then, there is no way to change this? other than move my server local time 4 hours behind
the real time? That would affect the RT GUI too.

Juan

As James correctly stated, RT stores dates in the database in GMT and
converts them for display in the UI. If you want to pull data
directly from the DB, you will have to do your own conversion.
If you are pulling from the API or the UI and getting the wrong date
then that would be interesting.

-kevin> On Thu, Jun 3, 2010 at 11:46 AM, James Moseley <[1]jmoseley@corp.xanadoo.com> wrote:

 I believe RT, by design, uses the UTC timestamp when storing data in the database.

 --
 James

 On Thu, Jun 3, 2010 at 10:19 AM, Juan N. DLC <[2]juann.dlc@gmail.com> wrote:

   Yes, I do have the TZ configured in my RT_SiteConfig.pm

   # Time Zone:
   Set($Timezone , 'America/Puerto_Rico');

   LIke I said, the GUI time is working fine, the problem is MySQL, when creating a ticket it
   set the Creation Time 4 hours after the real time.

Juan_N_DLC · June 9, 2010, 3:31pm

Thank you for all your replays,

For correction, I’m not trying to tdo queries to my RT DB, my problem is
that for some reason between RT and MySQL is a time_zone problem. my RT GUI
have the correct time/date but MySQL is using UTC time, 4 hours ahead the
real time.On Wed, Jun 9, 2010 at 10:57 AM, Kevin Falcone falcone@bestpractical.comwrote:

On Wed, Jun 09, 2010 at 09:01:34AM -0400, Juan N. DLC wrote:

So then, there is no way to change this? other than move my server
local time 4 hours behind
the real time? That would affect the RT GUI too.

Juan

As James correctly stated, RT stores dates in the database in GMT and
converts them for display in the UI. If you want to pull data
directly from the DB, you will have to do your own conversion.
If you are pulling from the API or the UI and getting the wrong date
then that would be interesting.

-kevin
On Thu, Jun 3, 2010 at 11:46 AM, James Moseley <[1] jmoseley@corp.xanadoo.com> wrote:
 I believe RT, by design, uses the UTC timestamp when storing data in
the database.
 --
 James

 On Thu, Jun 3, 2010 at 10:19 AM, Juan N. DLC <[2] juann.dlc@gmail.com> wrote:

   Yes, I do have the TZ configured in my RT_SiteConfig.pm

   # Time Zone:
   Set($Timezone , 'America/Puerto_Rico');

   LIke I said, the GUI time is working fine, the problem is MySQL,
when creating a ticket it
   set the Creation Time 4 hours after the real time.
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Kevin_Falcone · June 9, 2010, 3:53pm

For correction, I’m not trying to tdo queries to my RT DB, my problem is that for some reason
between RT and MySQL is a time_zone problem. my RT GUI have the correct time/date but MySQL is
using UTC time, 4 hours ahead the real time.

RT stores dates in MySQL in UTC. It then converts on display.

-kevin> On Wed, Jun 9, 2010 at 10:57 AM, Kevin Falcone <[1]falcone@bestpractical.com> wrote:

 On Wed, Jun 09, 2010 at 09:01:34AM -0400, Juan N. DLC wrote:
 > So then, there is no way to change this? other than move my server local time 4 hours
 behind
 > the real time? That would affect the RT GUI too.

 Juan

 As James correctly stated, RT stores dates in the database in GMT and
 converts them for display in the UI. If you want to pull data
 directly from the DB, you will have to do your own conversion.
 If you are pulling from the API or the UI and getting the wrong date
 then that would be interesting.
 -kevin
 > On Thu, Jun 3, 2010 at 11:46 AM, James Moseley <[1][2]jmoseley@corp.xanadoo.com> wrote:
 >
 > I believe RT, by design, uses the UTC timestamp when storing data in the database.
 >
 > --
 > James
 >
 > On Thu, Jun 3, 2010 at 10:19 AM, Juan N. DLC <[2][3]juann.dlc@gmail.com> wrote:
 >
 > Yes, I do have the TZ configured in my RT_SiteConfig.pm
 >
 > # Time Zone:
 > Set($Timezone , 'America/Puerto_Rico');
 >
 > LIke I said, the GUI time is working fine, the problem is MySQL, when creating a ticket it
 > set the Creation Time 4 hours after the real time.

 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at [4]http://rtbook.bestpractical.com

References

Visible links

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Juan_N_DLC · June 9, 2010, 4:08pm

OK, so what will be the best approach to resolve my issue?On Wed, Jun 9, 2010 at 11:53 AM, Kevin Falcone falcone@bestpractical.comwrote:

On Wed, Jun 09, 2010 at 11:31:28AM -0400, Juan N. DLC wrote:

For correction, I’m not trying to tdo queries to my RT DB, my problem
is that for some reason
between RT and MySQL is a time_zone problem. my RT GUI have the
correct time/date but MySQL is
using UTC time, 4 hours ahead the real time.

RT stores dates in MySQL in UTC. It then converts on display.

-kevin
On Wed, Jun 9, 2010 at 10:57 AM, Kevin Falcone <[1] falcone@bestpractical.com> wrote:
 On Wed, Jun 09, 2010 at 09:01:34AM -0400, Juan N. DLC wrote:
 > So then, there is no way to change this? other than move my server
local time 4 hours
 behind
 > the real time? That would affect the RT GUI too.

 Juan

 As James correctly stated, RT stores dates in the database in GMT
and
 converts them for display in the UI. If you want to pull data
 directly from the DB, you will have to do your own conversion.
 If you are pulling from the API or the UI and getting the wrong date
 then that would be interesting.
 -kevin
 > On Thu, Jun 3, 2010 at 11:46 AM, James Moseley <[1][2] jmoseley@corp.xanadoo.com> wrote:
 >
 > I believe RT, by design, uses the UTC timestamp when storing data
in the database.
 >
 > --
 > James
 >
 > On Thu, Jun 3, 2010 at 10:19 AM, Juan N. DLC <[2][3] juann.dlc@gmail.com> wrote:
 >
 > Yes, I do have the TZ configured in my RT_SiteConfig.pm
 >
 > # Time Zone:
 > Set($Timezone , 'America/Puerto_Rico');
 >
 > LIke I said, the GUI time is working fine, the problem is MySQL,
when creating a ticket it
 > set the Creation Time 4 hours after the real time.

 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at [4]http://rtbook.bestpractical.com
References

Visible links

mailto:falcone@bestpractical.com

mailto:jmoseley@corp.xanadoo.com

mailto:juann.dlc@gmail.com

http://rtbook.bestpractical.com/
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com