Wrong time inserted into sessions table on Pg 8.1.3

RT Developers
1

Hi.
I am testing out RT 3.6.0pre0, but i have the same
problem om 3.5.7.
i am using RT with Postgresgql 8.1.3 that does not run
on the same machine as apache.

when i log in (only tested with root) i get logged in,
then as soon as i click a link, the login screen is
presented to me, if i log in again, the same thing
happens again.

so, i had a look in the sessions table in the database
and found out that:
a. the time in the column lastupdated is exactly one
hour less then the real time.
b. the lastupdated column is not updated when i log in
a second time.

both the machines in question (web server and db
server), are running FC4 with all updates.
if i give the clock command they show,
[root@web]# clock
Sun 26 Feb 2006 10:41:41 AM CET -0.744519 seconds

[root@sql]# clock
Sun 26 Feb 2006 10:42:20 AM CET -0.626471 seconds

CET = central european time.
the clocks are not perfectly synchronized but still
not one hour apart.

for the current session i can see the following in the
sessions table:

rt3=# select lastupdated from sessions order by
lastupdated desc limit 1;
lastupdated
2006-02-26 09:40:16.497154
(1 row)

(as you can see, this is one hour wrong, compared to
the clock output).

if i manually insert a row into the sessions table i
get the following:

rt3=# start transaction;
START TRANSACTION
rt3=# insert into sessions(id, a_session)
values(‘123’, ‘B’);
INSERT 0 1
rt3=# select * from sessions order by lastupdated desc
limit 1;
id | a_session |
lastupdated
123 | B |
2006-02-26 10:46:51.59215
(1 row)

rt3=# rollback;
ROLLBACK

as you can see, the time is given correctly this time.
so it feels like something is happening within the
RT-code, something that tries to fix something with
the time but fails.

end of report
Karl

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

2

Hi.
I am testing out RT 3.6.0pre0, but i have the same
problem om 3.5.7.
i am using RT with Postgresgql 8.1.3 that does not run
on the same machine as apache.

when i log in (only tested with root) i get logged in,
then as soon as i click a link, the login screen is
presented to me, if i log in again, the same thing
happens again.

That’s probably due to accessing the machine with a URL your browser
won’t save a cookie for.

so, i had a look in the sessions table in the database
and found out that:
a. the time in the column lastupdated is exactly one
hour less then the real time.

It’s GMT.

3

Hi.
I am testing out RT 3.6.0pre0, but i have the same
problem om 3.5.7.
i am using RT with Postgresgql 8.1.3 that does not
run
on the same machine as apache.

when i log in (only tested with root) i get logged
in,
then as soon as i click a link, the login screen
is
presented to me, if i log in again, the same thing
happens again.

That’s probably due to accessing the machine with a
URL your browser
won’t save a cookie for.

i have tested with varios browsers (both inside and
outside the local network) and they all have the
cookie there.

can i try something else to track down the problem?

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

4

Hi.
I am testing out RT 3.6.0pre0, but i have the same
problem om 3.5.7.
i am using RT with Postgresgql 8.1.3 that does not
run
on the same machine as apache.

when i log in (only tested with root) i get logged
in,
then as soon as i click a link, the login screen
is
presented to me, if i log in again, the same thing
happens again.

That’s probably due to accessing the machine with a
URL your browser
won’t save a cookie for.

i have tested with varios browsers (both inside and
outside the local network) and they all have the
cookie there.

can i try something else to track down the problem?
I’m curious as to what happens when you login and then goto the
configuration page. You’ll need to login again but then I guess your
session will hold and you can go anywhere in RT.
Would you try that and report back?

Thanks,

Joop

Joop van de Wege JoopvandeWege@mococo.nl

5

I’m curious as to what happens when you login and
then goto the
configuration page. You’ll need to login again but
then I guess your
session will hold and you can go anywhere in RT.
Would you try that and report back?

Thanks,

Joop

Still the same problem. I see the following.
If the browser already has a cookie, then no updates
are made in the session table.

If the browser does not have a cookie, then a cookie
is created and a row is inserted into the sessions
table, this row contains a bad time, namly one hour
less then in the real world.

Could it be some module that RT depends on that fails?

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

6

i will try too have a look in the code.

which files are taking care of the session handing?
when a person is logged in or when the sesion is
checked, wich file is checking the cookies value
agains the database?
and, which file and function (or method) is updating
the sessions table in the database?

i would like to know this to be able to have a look at
this problem.

i tried to set my servers time to GMT, but the entry
in the database still showed one hour too little.
so it seems more and more to be a RT problem.

which modules are upgraded between 3.5.7 and 3.6.0pre0
(if any)?

Karl.

Still the same problem. I see the following.
If the browser already has a cookie, then no updates
are made in the session table.

If the browser does not have a cookie, then a cookie
is created and a row is inserted into the sessions
table, this row contains a bad time, namly one hour
less then in the real world.

Could it be some module that RT depends on that
fails?

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

7

forget my last message. the statement that sait i
changed to GMT was not valid, i did something wrong.

but,
i migth know what creates the problem with the erratic
time. i turned on full logging in postgresql and the
very first statement after connection says:

LOG: statement: SET TIME ZONE ‘GMT’

in my RT_Siteconfig.pm i have:
Set($Timezone , ‘CET’);

so wither my timezone is not understand by RT or not
by postgresql. according to postgresql CET i a valid
time zone. is there some problem with RT?

where in the RT documentation can i find the names of
the valid time zones?

Karl.

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around