RT email time

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

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

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

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

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

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

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

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]

Juan,

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

  1. Set system clock to UTC
  2. Set the correct timezone in the OS
  3. Setup and run ntpd
  4. 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 : https://help.ubuntu.com/community/UbuntuTime

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]

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.

  1. Set system clock to UTC
  2. Set the correct timezone in the OS
  3. Setup and run ntpd
  4. 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 : https://help.ubuntu.com/community/UbuntuTime

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

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.

  1. Set system clock to UTC
  2. Set the correct timezone in the OS
  3. Setup and run ntpd
  4. 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 : https://help.ubuntu.com/community/UbuntuTime

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

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.

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.

  1. Set system clock to UTC
  2. Set the correct timezone in the OS
  3. Setup and run ntpd
  4. 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 : https://help.ubuntu.com/community/UbuntuTime

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

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.

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.

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

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.

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

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

  1. mailto:falcone@bestpractical.com
  2. mailto:jmoseley@corp.xanadoo.com
  3. mailto:juann.dlc@gmail.com
  4. http://rtbook.bestpractical.com/

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

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

  1. mailto:falcone@bestpractical.com
  2. mailto:jmoseley@corp.xanadoo.com
  3. mailto:juann.dlc@gmail.com
  4. 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