Re: [rt-users] RT email time

[Kevin Falcone]

On Wed, Jun 09, 2010 at 12:08:04PM -0400, Juan N. DLC wrote:
>OK, so what will be the best approach to resolve my issue?

I still don't know what your issue is.  If your issue is that RT is
storing dates in the database in UTC then you really don't have an
approach other than 'rewrite RT'

-kevin

>On Wed, Jun 9, 2010 at 11:53 AM, Kevin Falcone 
> <[1]falc...@bestpractical.com> wrote:
> 
>  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][2]falc...@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][3]jmose...@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][4]juann@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][5]http://rtbook.bestpractical.com
>  >
>  > References
>  >
>  > Visible links
>  > 1. mailto:[6]falc...@bestpractical.com
>  > 2. mailto:[7]jmose...@corp.xanadoo.com
>  > 3. mailto:[8]juann@gmail.com
>  > 4. [9]http://rtbook.bestpractical.com/
>  >
>  > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>  > Buy a copy at [10]http://rtbook.bestpractical.com
> 
>  Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>  Buy a copy at [11]http://rtbook.bestpractical.com
> 
> References
> 
>Visible links
>1. mailto:falc...@bestpractical.com
>2. mailto:falc...@bestpractical.com
>3. mailto:jmose...@corp.xanadoo.com
>4. mailto:juann@gmail.com
>5. http://rtbook.bestpractical.com/
>6. mailto:falc...@bestpractical.com
>7. mailto:jmose...@corp.xanadoo.com
>8. mailto:juann@gmail.com
>9. http://rtbook.bestpractical.com/
>   10. http://rtbook.bestpractical.com/
>   11. http://rtbook.bestpractical.com/

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



pgp3iz5a91Ada.pgp
Description: PGP signature

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

Re: [rt-users] RT email time

[Juan N. DLC]

OK, so what will be the best approach to resolve my issue?

On Wed, Jun 9, 2010 at 11:53 AM, Kevin Falcone wrote:

> 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]
> falc...@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]
> jmose...@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@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:falc...@bestpractical.com
> >2. mailto:jmose...@corp.xanadoo.com
> >3. mailto:juann@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
>

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

Re: [rt-users] RT email time

[Kevin Falcone]

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]falc...@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]jmose...@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@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:falc...@bestpractical.com
>2. mailto:jmose...@corp.xanadoo.com
>3. mailto:juann@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



pgp2pVOCDLZij.pgp
Description: PGP signature

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

Re: [rt-users] RT email time

[Juan N. DLC]

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 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]
> jmose...@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@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
>

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

Re: [rt-users] RT email time

[Kevin Falcone]

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]jmose...@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@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.


pgpW8rsqI7jty.pgp
Description: PGP signature

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

Re: [rt-users] RT email time

[Kenneth Marshall]

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.
> 
> On Thu, Jun 3, 2010 at 11:46 AM, James Moseley 
> 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  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.
> >>
> >>

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

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

Re: [rt-users] RT email time

[Juan N. DLC]

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 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  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

Re: [rt-users] RT email time

[James Moseley]

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  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

Re: [rt-users] RT email time

[Juan N. DLC]

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  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 
> *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  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  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 
>>> *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 ; *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.d227d48...@srthr31.xxx.com>
>>> Date: Thu,  3 Jun 2010 00:35:45 +0400 (AST)
>>> From: we...@xxx.com (weoms)
>>> To: undisclosed-recipients:;
>>> Return-Path: we...@xxx.com
>>> X-OriginalArrivalTime: 02 Jun 2010 20:35:56. (UTC)
>>> FILETIME=[33A39E00:01CB0293]
>>>
>>>
>>> On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg (Racke) <
>>> ra...@linuxia.de> wrote:
>>>
>>>> On 06/02/2010 10:17 PM, Juan N. DLC wrote:
>>>>
>>>>> Racke,
>>>>>
>>>>> we...@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
>

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

Re: [rt-users] RT email time

[Jason Maderios]

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 
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  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  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 
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 ; 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.d227d48...@srthr31.xxx.com>
Date: Thu,  3 Jun 2010 00:35:45 +0400 (AST)
From: we...@xxx.com (weoms)
To: undisclosed-recipients:;
Return-Path: we...@xxx.com
X-OriginalArrivalTime: 02 Jun 2010 20:35:56. (UTC) 
FILETIME=[33A39E00:01CB0293]



On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg (Racke)  
wrote:

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

Racke,

we...@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

Re: [rt-users] RT email time

[Juan N. DLC]

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  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  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 
>> *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 ; *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.d227d48...@srthr31.xxx.com>
>> Date: Thu,  3 Jun 2010 00:35:45 +0400 (AST)
>> From: we...@xxx.com (weoms)
>> To: undisclosed-recipients:;
>> Return-Path: we...@xxx.com
>> X-OriginalArrivalTime: 02 Jun 2010 20:35:56. (UTC)
>> FILETIME=[33A39E00:01CB0293]
>>
>>
>> On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg (Racke) > > wrote:
>>
>>> On 06/02/2010 10:17 PM, Juan N. DLC wrote:
>>>
>>>> Racke,
>>>>
>>>> we...@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

Re: [rt-users] RT email time

[Juan N. DLC]

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  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 
> *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 ; *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.d227d48...@srthr31.xxx.com>
> Date: Thu,  3 Jun 2010 00:35:45 +0400 (AST)
> From: we...@xxx.com (weoms)
> To: undisclosed-recipients:;
> Return-Path: we...@xxx.com
> X-OriginalArrivalTime: 02 Jun 2010 20:35:56. (UTC)
> FILETIME=[33A39E00:01CB0293]
>
>
> On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg (Racke) 
> wrote:
>
>> On 06/02/2010 10:17 PM, Juan N. DLC wrote:
>>
>>> Racke,
>>>
>>> we...@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

Re: [rt-users] RT email time

[Jason Maderios]

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 
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 ; 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.d227d48...@srthr31.xxx.com>
Date: Thu,  3 Jun 2010 00:35:45 +0400 (AST)
From: we...@xxx.com (weoms)
To: undisclosed-recipients:;
Return-Path: we...@xxx.com
X-OriginalArrivalTime: 02 Jun 2010 20:35:56. (UTC) 
FILETIME=[33A39E00:01CB0293]



On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg (Racke)  
wrote:

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

Racke,

we...@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

Re: [rt-users] RT email time

[Juan N. DLC]

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 ; *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.d227d48...@srthr31.xxx.com>
Date: Thu,  3 Jun 2010 00:35:45 +0400 (AST)
From: we...@xxx.com (weoms)
To: undisclosed-recipients:;
Return-Path: we...@xxx.com
X-OriginalArrivalTime: 02 Jun 2010 20:35:56. (UTC)
FILETIME=[33A39E00:01CB0293]


On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg (Racke) wrote:

> On 06/02/2010 10:17 PM, Juan N. DLC wrote:
>
>> Racke,
>>
>> we...@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

Re: [rt-users] RT email time

[Stefan Hornburg (Racke)]

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

Racke,

we...@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

Re: [rt-users] RT email time

[Juan N. DLC]

Racke,

we...@srthr31:~$ /bin/date +%Z
AST

we...@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

we...@srthr31:~$ cat /etc/issue
Ubuntu 9.10 \n \l


On Wed, Jun 2, 2010 at 4:00 PM, Stefan Hornburg (Racke) wrote:

> 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
>

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

Re: [rt-users] RT email time

[Stefan Hornburg (Racke)]

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

Re: [rt-users] RT email time

[Juan N. DLC]

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

On Wed, Jun 2, 2010 at 3:43 PM, Stefan Hornburg (Racke) wrote:

> 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
>
>

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

Re: [rt-users] RT email time

[Juan N. DLC]

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) wrote:

> 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:
>> Dates   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
>

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

Re: [rt-users] RT email time

[Stefan Hornburg (Racke)]

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:
Dates   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

[rt-users] RT email time

[Juan N. DLC]

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   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

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