Yes, I do have the TZ configured in my RT_SiteConfig.pm<br><br># Time Zone:<br>Set($Timezone , 'America/Puerto_Rico');<br><br>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.<br>
<br><div class="gmail_quote">On Thu, Jun 3, 2010 at 11:10 AM, Jason Maderios <span dir="ltr"><<a href="mailto:jmaderios@kpu.net">jmaderios@kpu.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div style="padding-left: 10px; padding-right: 10px; padding-top: 15px;" name="Compose message area">
<div><font face="Calibri">Juan,</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">I believe that is correct behavior - Have you set the TZ
in RT_Siteconfig?</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">Example:</font></div>
<div><font face="Calibri">Set($Timezone , 'America/Anchorage')</font><font face="Calibri"></font></div>
<div><br></div>
<div><font face="Calibri">Regards,</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">Jason Maderios</font></div>
<div style="font: 10pt Tahoma;">
<div><br></div>
<div style="background: none repeat scroll 0% 0% rgb(245, 245, 245);">
<div><b>From:</b> <a title="juann.dlc@gmail.com" href="mailto:juann.dlc@gmail.com" target="_blank">Juan N. DLC</a> </div>
<div><b>Sent:</b> Thursday, June 03, 2010 5:48 AM</div><div><div></div><div class="h5">
<div><b>To:</b> <a title="RT-Users@lists.bestpractical.com" href="mailto:RT-Users@lists.bestpractical.com" target="_blank">RT-Users@lists.bestpractical.com</a>
</div>
<div><b>Subject:</b> Re: [rt-users] RT email time</div></div></div></div></div><div><div></div><div class="h5">
<div><br></div>Jason,<br><br>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.<br><br>But thanks for the information you
posted.<br><br>
<div class="gmail_quote">On Wed, Jun 2, 2010 at 10:02 PM, Juan N. DLC <span dir="ltr"><<a href="mailto:juann.dlc@gmail.com" target="_blank">juann.dlc@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">Jason,<br><br>Thank you for the input I will try this and
give update later.
<div>
<div></div>
<div><br><br>
<div class="gmail_quote">On Wed, Jun 2, 2010 at 5:07 PM, Jason Maderios <span dir="ltr"><<a href="mailto:jmaderios@kpu.net" target="_blank">jmaderios@kpu.net</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div style="padding-left: 10px; padding-right: 10px; padding-top: 15px;" name="Compose message area">
<div>
<div><font face="Calibri">Juan,</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">Time is a pain - Generally I do the following and it
works well.</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">1. Set system clock to UTC</font></div>
<div><font face="Calibri">2. Set the correct timezone in the OS
</font></div>
<div><font face="Calibri">3. Setup and run ntpd</font></div>
<div><font face="Calibri">4. Set the default Timezone according to RT
Docs.</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">In CentOS / RH world this is accomplished by running
the setup utility. </font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">Ubuuntu search led me to : <a href="https://help.ubuntu.com/community/UbuntuTime" target="_blank">https://help.ubuntu.com/community/UbuntuTime</a></font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">I scanned the doc and it covers steps 1 to
3.</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">Regards,</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">Jason Maderios</font></div>
<div><font face="Calibri"></font> </div></div>
<div style="font: 10pt Tahoma;">
<div><br></div>
<div style="background: none repeat scroll 0% 0% rgb(245, 245, 245);">
<div><b>From:</b> <a title="juann.dlc@gmail.com" href="mailto:juann.dlc@gmail.com" target="_blank">Juan N. DLC</a> </div>
<div><b>Sent:</b> Wednesday, June 02, 2010 12:39 PM</div>
<div>
<div><b>To:</b> <a title="RT-Users@lists.bestpractical.com" href="mailto:RT-Users@lists.bestpractical.com" target="_blank">RT-Users@lists.bestpractical.com</a> </div>
<div><b>Subject:</b> Re: [rt-users] RT email time</div></div></div></div>
<div><br></div>
<div>
<div></div>
<div>I'm using postfix from box and relay with domain ms-exchange
server.<br><br>i did a sendmail test to my email and checked the Internet
headers from email:<br><br>for <<a href="mailto:jcruz@xxx.com" target="_blank">jcruz@xxx.com</a>>; <b style="background-color: rgb(255, 255, 102);">Wed, 2 Jun 2010 18:30:53
-0400</b><br>Received: by <a href="http://SRTHR31.xxx.com" target="_blank">SRTHR31.xxx.com</a> (Postfix, from userid
1001)<br> id D227D48318; <b style="background-color: rgb(255, 255, 102);">Thu, 3 Jun 2010 00:35:50
+0400 (AST)</b><br>subject: time test<br>Message-Id: <<a href="mailto:20100602203550.D227D48318@SRTHR31.xxx.com" target="_blank">20100602203550.D227D48318@SRTHR31.xxx.com</a>><br>Date:
Thu, 3 Jun 2010 00:35:45 +0400 (AST)<br>From: <a href="mailto:weoms@xxx.com" target="_blank">weoms@xxx.com</a> (weoms)<br>To:
undisclosed-recipients:;<br>Return-Path: <a href="mailto:weoms@xxx.com" target="_blank">weoms@xxx.com</a><br>X-OriginalArrivalTime: 02 Jun 2010
20:35:56.0000 (UTC) FILETIME=[33A39E00:01CB0293]<br><br><br>
<div class="gmail_quote">On Wed, Jun 2, 2010 at 4:27 PM, Stefan Hornburg
(Racke) <span dir="ltr"><<a href="mailto:racke@linuxia.de" target="_blank">racke@linuxia.de</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div>On 06/02/2010 10:17 PM, Juan N. DLC wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">Racke,<br><br>weoms@SRTHR31:~$ /bin/date
+%Z<br>AST<br><br></blockquote><br></div>That should be the correct
timezone for Puerto Rico (GMT - 4). Do you have the<br>same problem
sending email for the command line (e.g. with mail from
bds-mailx<br>package)? Which email server are you using?
<div>
<div></div>
<div><br><br>Regards<br> Racke<br><br>--
<br>LinuXia Systems => <a href="http://www.linuxia.de/" target="_blank">http://www.linuxia.de/</a><br>Expert Interchange Consulting
and System Administration<br>ICDEVGROUP => <a href="http://www.icdevgroup.org/" target="_blank">http://www.icdevgroup.org/</a><br>Interchange Development
Team<br><br><br>Discover RT's hidden secrets with RT Essentials from
O'Reilly Media.<br>Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br></div></div></blockquote></div><br></div></div>
<p></p>
<hr>
<div>
<p></p><br>Discover RT's hidden secrets with RT Essentials from O'Reilly
Media.<br>Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a></div></div><br><br>Discover
RT's hidden secrets with RT Essentials from O'Reilly Media.<br>Buy a copy at
<a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br></blockquote></div><br></div></div></blockquote></div><br>
</div></div><p>
</p><hr><div class="im">
<p></p><br>Discover RT's hidden secrets with RT Essentials from O'Reilly
Media.<br>Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a></div></div>
<br><br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br></blockquote></div><br>