This is driving me nuts!

I know we’ve discussed this before, but I’m still having a problem with
empty tickets. Simply moving the transaction to the correct directory fixes
the problem, but every night I have 5-10 tickets to move in this manner and
it’s getting old.

Does anyone have any idea how to correct this time shift that is occuring?

For those that are unfamiliar with this, it seems that the date put into
the SQL database is on a different time zone than the rest of the machine.
and anything that is recieved between 9pm and 12 pm my time gets put into
the directory for today, but recorded as being in the directory for
tomorrow.

Any suggetions at all? I’ve looked at everything I can think of related to
time on that server.

Jason
Split infinity

FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!

Timezone problems

If you have a problem with SELECT NOW()' returning values in GMT and not your local time, you have to set theTZ’ environment variable to
your current timezone. This should be done for the environment in which
the server runs, for example in safe_mysqld' ormysql.server’. *Note
Environment variables::.On Wed, 23 May 2001, Split infinity Tech Support wrote:

I know we’ve discussed this before, but I’m still having a problem with
empty tickets. Simply moving the transaction to the correct directory fixes
the problem, but every night I have 5-10 tickets to move in this manner and
it’s getting old.

Does anyone have any idea how to correct this time shift that is occuring?

For those that are unfamiliar with this, it seems that the date put into
the SQL database is on a different time zone than the rest of the machine.
and anything that is recieved between 9pm and 12 pm my time gets put into
the directory for today, but recorded as being in the directory for
tomorrow.

Any suggetions at all? I’ve looked at everything I can think of related to
time on that server.

Jason
Split infinity


FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

As a followup try using;

–timezone=#
Set the timezone (the TZ) variable to the value of this parameter.

with safe_mysql scriptOn Wed, 23 May 2001, Split infinity Tech Support wrote:

I know we’ve discussed this before, but I’m still having a problem with
empty tickets. Simply moving the transaction to the correct directory fixes
the problem, but every night I have 5-10 tickets to move in this manner and
it’s getting old.

Does anyone have any idea how to correct this time shift that is occuring?

For those that are unfamiliar with this, it seems that the date put into
the SQL database is on a different time zone than the rest of the machine.
and anything that is recieved between 9pm and 12 pm my time gets put into
the directory for today, but recorded as being in the directory for
tomorrow.

Any suggetions at all? I’ve looked at everything I can think of related to
time on that server.

Jason
Split infinity


FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Did that, no help

/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --timezone=PDT >/dev/null
2>&1 &

is the command in the init script that starts MySQL

Still loging as Eastern time, 3 hours ahead

Also, is there any way to fix this listserv so that replies are sent to the
list and not to both the user and the list, I have no need for two copies
of each reply.

Jason
Split Infinity

As a followup try using;

–timezone=#
Set the timezone (the TZ) variable to the value of this parameter.

with safe_mysql script

I know we’ve discussed this before, but I’m still having a problem with
empty tickets. Simply moving the transaction to the correct directory
fixes
the problem, but every night I have 5-10 tickets to move in this manner
and
it’s getting old.

Does anyone have any idea how to correct this time shift that is
occuring?

For those that are unfamiliar with this, it seems that the date put
into
the SQL database is on a different time zone than the rest of the
machine.
and anything that is recieved between 9pm and 12 pm my time gets put
into
the directory for today, but recorded as being in the directory for
tomorrow.

Any suggetions at all? I’ve looked at everything I can think of related
to
time on that server.

Jason
Split infinity


FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!

Make sure your config.pm file specifies the proper timezone in it. It has
a default of US/Eastern. It should be set to your server timezone.

-RobertOn Wed, May 23, 2001 at 11:08:03AM -0700, Split infinity Tech Support wrote:

Did that, no help

/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --timezone=PDT >/dev/null
2>&1 &

is the command in the init script that starts MySQL

Still loging as Eastern time, 3 hours ahead

Also, is there any way to fix this listserv so that replies are sent to the
list and not to both the user and the list, I have no need for two copies
of each reply.

Jason
Split Infinity

Now for some dumb questions on my side…

You checked your systems TZ or timezone setting? I assume you are
on linux?

Also, shouldn’t the timezone value be PST8PDT ?

This is linux, RH7.0 to be exact. there is no default TZ setting for normal
logins, system time is set using PDT. I tried changing to PST8PDT with no
effect.

Jason
Split infinity

There is no mention of timezones in config.pm

Jason
Split infinity

Make sure your config.pm file specifies the proper timezone in it. It has
a default of US/Eastern. It should be set to your server timezone.

-Robert

Did that, no help

/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --timezone=PDT
/dev/null
2>&1 &

is the command in the init script that starts MySQL

Still loging as Eastern time, 3 hours ahead

Also, is there any way to fix this listserv so that replies are sent to
the
list and not to both the user and the list, I have no need for two
copies
of each reply.

Jason
Split Infinity


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!

What version of RT? I have this in my config.pm:

$Timezone is used to convert times entered by users into GMT and back again

It should be set to a timezone recognized by your local unix box.

$Timezone = ‘US/Arizona’;

But, I’m using the latest 1.3 release.

-RobertOn Wed, May 23, 2001 at 11:32:22AM -0700, Split infinity Tech Support wrote:

There is no mention of timezones in config.pm

Jason
Split infinity

I suspect that your sendmail is running with a different concept of the current
timezone than your apache.

Has the box ever changed timezones?

what’s the content of /etc/timezone?

Oh, and none of the lists hosted on fsck.com will be configured for
Reply-To-List.

    -jesseOn Wed, May 23, 2001 at 11:08:03AM -0700, Split infinity Tech Support wrote:

Did that, no help

/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --timezone=PDT >/dev/null
2>&1 &

is the command in the init script that starts MySQL

Still loging as Eastern time, 3 hours ahead

Also, is there any way to fix this listserv so that replies are sent to the
list and not to both the user and the list, I have no need for two copies
of each reply.

Jason
Split Infinity

As a followup try using;

–timezone=#
Set the timezone (the TZ) variable to the value of this parameter.

with safe_mysql script

On Wed, 23 May 2001, Split infinity Tech Support wrote:

I know we’ve discussed this before, but I’m still having a problem with
empty tickets. Simply moving the transaction to the correct directory
fixes
the problem, but every night I have 5-10 tickets to move in this manner
and
it’s getting old.

Does anyone have any idea how to correct this time shift that is
occuring?

For those that are unfamiliar with this, it seems that the date put
into
the SQL database is on a different time zone than the rest of the
machine.
and anything that is recieved between 9pm and 12 pm my time gets put
into
the directory for today, but recorded as being in the directory for
tomorrow.

Any suggetions at all? I’ve looked at everything I can think of related
to
time on that server.

Jason
Split infinity


FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

And I’m told we do share some common rituals. Our “flame war” is apparently
held in person in their land and called “project meeting”.
-Alan Cox [on “Suits”]

I suspect that your sendmail is running with a different concept of the
current
timezone than your apache.

Has the box ever changed timezones?

Nope, it was installed for the sole purpose of running RT. Never had to
change timezones.

what’s the content of /etc/timezone?

That file does not exist.

Oh, and none of the lists hosted on fsck.com will be configured for
Reply-To-List.

Why is that? It seems the most logical way to do it. I mean, it would be
one thing if the list even had the “Mailing-list” headers so properly
equiped mail readers could just reply to list, but they aren’t there so one
must either reply to all (seems to be everyone’s prefered method) or reply
and change the To: field. That’s just silly to me.

Jason
Split infinity

I’m using 1.0.7

I plan on using RT2 as soon as there is a way to convert the existing
ticket history, I hear that’s in the works.

Jason
Split infinity

What version of RT? I have this in my config.pm:

$Timezone is used to convert times entered by users into GMT and back

again

It should be set to a timezone recognized by your local unix box.

$Timezone = ‘US/Arizona’;

But, I’m using the latest 1.3 release.

-Robert

There is no mention of timezones in config.pm

Jason
Split infinity

FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!

what’s the content of /etc/timezone?

That file does not exist.

Or whatever redhat’s system timezone configuration is.

Oh, and none of the lists hosted on fsck.com will be configured for
Reply-To-List.

Why is that?

http://www.unicom.com/pw/reply-to-harmful.html

Modern MUAs are capable of doing the right thing for list replies, however
this is a debate that WILL NOT happen on this list. If anyone would
care to debate this point, send me personal mail and I’d be happy to set up
reply-to-list-discussion@lists.fsck.com.

Jason
Split infinity


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Any e-mail sent to the SLA will immediately become the intellectual property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.

tzconfig is the program that you run on redhat I believe.

Micah

what’s the content of /etc/timezone?

That file does not exist.

Or whatever redhat’s system timezone configuration is.

Oh, and none of the lists hosted on fsck.com will be configured for
Reply-To-List.

Why is that?

http://www.unicom.com/pw/reply-to-harmful.html

Modern MUAs are capable of doing the right thing for list replies, however
this is a debate that WILL NOT happen on this list. If anyone would
care to debate this point, send me personal mail and I’d be happy to set up
reply-to-list-discussion@lists.fsck.com.

Jason
Split infinity


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Any e-mail sent to the SLA will immediately become the intellectual property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Micah Anderson
Collective Technologies
www.colltech.com

“To be and not to do is not to be at all”

Did that, no dice

Jason
Split infinity> On Wed, 23 May 2001, Jesse wrote:

tzconfig is the program that you run on redhat I believe.

Micah

On Wed, May 23, 2001 at 01:56:23PM -0700, Split infinity Tech Support wrote:

what’s the content of /etc/timezone?

That file does not exist.

Or whatever redhat’s system timezone configuration is.

Oh, and none of the lists hosted on fsck.com will be configured for

Reply-To-List.

Why is that?

http://www.unicom.com/pw/reply-to-harmful.html

Modern MUAs are capable of doing the right thing for list replies,
however
this is a debate that WILL NOT happen on this list. If anyone would
care to debate this point, send me personal mail and I’d be happy to
set up
reply-to-list-discussion@lists.fsck.com.

Jason
Split infinity


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Any e-mail sent to the SLA will immediately become the intellectual
property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than
seven
years.


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


Micah Anderson
Collective Technologies
www.colltech.com

“To be and not to do is not to be at all”

FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!

I’d suggest poking around the mysql documentation, I know that postgres
allows you to set timezone’s and format’s, I only assume mysql does too.

-Feargal.

Done that too, still no dice.

Jason
Split infinity

FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!

When mail comes into that box, what timezone does the Recieved line have in
the headers?On Wed, May 23, 2001 at 03:48:00PM -0700, Split infinity Tech Support wrote:

I’d suggest poking around the mysql documentation, I know that postgres
allows you to set timezone’s and format’s, I only assume mysql does too.

-Feargal.

Done that too, still no dice.

Jason
Split infinity


FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

“If IBM wanted to make clones, we could make them cheaper and faster than
anyone else!” - An IBM Rep. visiting Vassar College’s Comp Sci Department.

When mail comes into that box, what timezone does the Recieved line have
in
the headers?

This was in the directory May/23

FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!

Not the Date: header, but the last Recieved line.On Thu, May 24, 2001 at 08:33:10AM -0700, Split infinity Tech Support wrote:

When mail comes into that box, what timezone does the Recieved line have
in
the headers?

This was in the directory May/23

Date: 24 May 2001 05:17:40 -0000


FREE Web Site Monitoring for ALL! 100% FREE!
http://www.ServerRat.com/tag/
Notifies you via: ICQ, AIM and EMAIL!


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Any e-mail sent to the SLA will immediately become the intellectual property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.

Here are all the Received lines on that particular email

Received: from userland.splitinfinity.net (userland.splitinfinity.net
[216.188.106.2])
by tracker.splitinfinity.net (8.11.0/8.11.0) with SMTP id
f4O5GTb09641
for tech-rt@tracker.splitinfinity.net; Wed, 23 May 2001 22:16:29
-0700
Received: (qmail 30196 invoked by uid 533); 24 May 2001 05:16:29 -0000
Delivered-To: splitinfinity.com-tech@splitinfinity.com
Received: (qmail 30192 invoked by uid 533); 24 May 2001 05:16:29 -0000
Received: from unknown (HELO mail2.rdc2.bc.home.com) (24.2.10.85)
by smtp.splitinfinity.net with SMTP; 24 May 2001 05:16:29 -0000
Received: from cr1035069a ([24.76.66.217]) by mail2.rdc2.bc.home.com
(InterMail vM.4.01.03.20 201-229-121-120-20010223) with SMTP
id 20010524051641.STUF13487.mail2.rdc2.bc.home.com@cr1035069a
for tech@splitinfinity.com; Wed, 23 May 2001 22:16:41 -0700

Jason
Split Infinity

Here are all the Received lines on that particular email

Received: from userland.splitinfinity.net (userland.splitinfinity.net
[216.188.106.2])
by tracker.splitinfinity.net (8.11.0/8.11.0) with SMTP id
f4O5GTb09641
for tech-rt@tracker.splitinfinity.net; Wed, 23 May 2001 22:16:29
-0700
Received: (qmail 30196 invoked by uid 533); 24 May 2001 05:16:29 -0000
Delivered-To: splitinfinity.com-tech@splitinfinity.com
Received: (qmail 30192 invoked by uid 533); 24 May 2001 05:16:29 -0000
Received: from unknown (HELO mail2.rdc2.bc.home.com) (24.2.10.85)
by smtp.splitinfinity.net with SMTP; 24 May 2001 05:16:29 -0000
Received: from cr1035069a ([24.76.66.217]) by mail2.rdc2.bc.home.com
(InterMail vM.4.01.03.20 201-229-121-120-20010223) with SMTP
id 20010524051641.STUF13487.mail2.rdc2.bc.home.com@cr1035069a
for tech@splitinfinity.com; Wed, 23 May 2001 22:16:41 -0700

I’ve seen this happen when using qmail and Mailman together.
qmail isn’t honoring TZ somewhere and mailing list email ended up
with a -0000 timezone. The admin I was working with gave up and we
switched back to sendmail which was what we were trying to convert
from. (I have since seen the light and joined the PostFix crowd for
all new installations unless we’re using smarthost/nullclient .cfs.)

–clark