3.4.5 relogin problems

Hi all,

For some reason it seems our Request Tracker keeps insisting on logging
users in over and over again, say each time you click on a ticket or a
queue. This is RT 3.4.5 w/MySQL 4.1.14 and perl 5.8.7.
RT is called with fastcgi and Apache 2.0.54.

I’ve tried restarting MySQL and Apache to no avail. I can’t find any
errors in the logs. How can I troubleshoot this?

thanks
Chris Covington
IT
Plus One Health Management
75 Maiden Lane Suite 801
NY, NY 10038
646-312-6269
http://www.plusoneactive.com

Hi all,

For some reason it seems our Request Tracker keeps insisting on logging
users in over and over again, say each time you click on a ticket or a
queue. This is RT 3.4.5 w/MySQL 4.1.14 and perl 5.8.7.
RT is called with fastcgi and Apache 2.0.54.

I’ve tried restarting MySQL and Apache to no avail. I can’t find any
errors in the logs. How can I troubleshoot this?

Finally got something in the logs:

[Thu Apr 13 16:21:45 2006] [warn] FastCGI: server
“/var/www/localhost/rt-3.4.5/bin/mason_handler.fcgi” (pid 21434)
terminated by calling exit with status ‘1’
[Thu Apr 13 16:21:45 2006] [warn] FastCGI: server
“/var/www/localhost/rt-3.4.5/bin/mason_handler.fcgi” (uid 10015, gid
10197) restarted (pid 22132)

Chris Covington
IT
Plus One Health Management
75 Maiden Lane Suite 801
NY, NY 10038
646-312-6269
http://www.plusoneactive.com

I’m guessing that RT isn’t storing the sessions properly. Is there a way I can rebuild the sessions table (MySQL 4.1.14) w/o losing data?

Thanks

Chris Covington
IT
Plus One Health Management
75 Maiden Lane Suite 801
NY, NY 10038
646-312-6269
http://www.plusoneactive.com

I’m guessing that RT isn’t storing the sessions properly. Is there a way I can rebuild the sessions table (MySQL 4.1.14) w/o losing data?

It’s more likely an issue with the cookie RT is sending and your
browser, but the sessions table is safe to delete everything from. the
only consequence is that all currently logged in users will be logged
out.

It’s more likely an issue with the cookie RT is sending and your
browser, but the sessions table is safe to delete everything from. the
only consequence is that all currently logged in users will be logged
out.

You’re right, it’s a cookie problem. The site uses SSL and the problem
exists with lynx, IE, firefox, etc. on lots of different clients.
Cookies are offered:

www.plusone.com cookie:
RT_SID_plusone.com.443=6931da507474885e94770aafd4b8d24a

And once I accept and click on a different element like another queue,
I’m asked to login again. Strange… I’m not aware of any changes on
the RT server which would cause this to happen either. Suggestions?

Chris Covington
IT
Plus One Health Management
75 Maiden Lane Suite 801
NY, NY 10038
646-312-6269
http://www.plusoneactive.com

It’s more likely an issue with the cookie RT is sending and your
browser, but the sessions table is safe to delete everything from. the
only consequence is that all currently logged in users will be logged
out.

You’re right, it’s a cookie problem. The site uses SSL and the problem
exists with lynx, IE, firefox, etc. on lots of different clients.
Cookies are offered:

www.plusone.com cookie:
RT_SID_plusone.com.443=6931da507474885e94770aafd4b8d24a

And once I accept and click on a different element like another queue,
I’m asked to login again. Strange… I’m not aware of any changes on
the RT server which would cause this to happen either. Suggestions?

If I set RT to use:

Set($WebExternalAuth , ‘1’);
Set($WebFallbackToInternalAuth , ‘1’);
Set($WebExternalGecos , undef);
Set($WebExternalAuto , ‘1’);

And configure Apache to do the auth everyone works OK. How can I keep
the cookie-based system working?

Chris Covington
IT
Plus One Health Management
75 Maiden Lane Suite 801
NY, NY 10038
646-312-6269
http://www.plusoneactive.com

Chris-

We are experiencing the exact same problem with our RT installation.
See the post I made several days ago. I have not figured out the
problem either. We are experiencing Mason errors in our logs like the
ones below. We are running RT 3.5.6 and Apache 2.0.55 and Mason Ver
1.32 I have not received any idea where to start looking into this, but
our users are getting tired of having to login. We are also using
Apache to do a rewrite to ssl. Are you doing this as well?

If I figure it out I will let you know.

-Davin Flatten

[Mon Apr 10 15:26:45 2006] [error] [client xxx.xxx.xxx.xxx] FastCGI:
server “/www/webapps/rt3/bin/mason_handler.fcgi” stderr:
\tHTML::Mason::Commands::ANON(‘Title’, ‘Login’, ‘Focus’, ‘user’)
called at /usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135,
referer: https://xxx.xxx.xxx.xxx]/ecs-admin/rt3/Ticket/Display.html?id=919

[Mon Apr 10 15:26:45 2006] [error] [client xxx.xxx.xxx.xxx]] FastCGI:
server “/www/webapps/rt3/bin/mason_handler.fcgi” stderr:
\tHTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x2f8c290)’,
‘Title’, ‘Login’, ‘Focus’, ‘user’) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1251, referer:
https://xxx.xxx.xxx.xxx]/ecs-admin/rt3/Ticket/Display.html?id=919

[Mon Apr 10 15:26:45 2006] [error] [client xxx.xxx.xxx.xxx]] FastCGI:
server “/www/webapps/rt3/bin/mason_handler.fcgi” stderr: \teval {…}
called at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1245,
referer: https://xxx.xxx.xxx.xxx]/ecs-admin/rt3/Ticket/Display.html?id=919

[Mon Apr 10 15:26:45 2006] [error] [client xxx.xxx.xxx.xxx]] FastCGI:
server “/www/webapps/rt3/bin/mason_handler.fcgi” stderr:
\tHTML::Mason::Request::comp(‘undef’, ‘undef’, ‘Title’, ‘Login’,
‘Focus’, ‘user’) called at /www/webapps/rt3/share/html/Elements/Login
line 68, referer:
https://xxx.xxx.xxx.xxx]/ecs-admin/rt3/Ticket/Display.html?id=919

[Mon Apr 10 15:26:45 2006] [error] [client xxx.xxx.xxx.xxx]] FastCGI:
server “/www/webapps/rt3/bin/mason_handler.fcgi” stderr:
\tHTML::Mason::Commands::ANON(‘id’, 919) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135, referer:
https://xxx.xxx.xxx.xxx]/ecs-admin/rt3/Ticket/Display.html?id=919

Chris-

We are experiencing the exact same problem with our RT installation.
See the post I made several days ago. I have not figured out the
problem either. We are experiencing Mason errors in our logs like the
ones below. We are running RT 3.5.6 and Apache 2.0.55 and Mason Ver
1.32 I have not received any idea where to start looking into this, but
our users are getting tired of having to login. We are also using
Apache to do a rewrite to ssl. Are you doing this as well?

Yes I’m rewriting to SSL. To workaround the issue as I’ve mentioned
I’ve switched to WebExternalAuth. Perhaps Mason 1.32 is the problem?
Unfortunately I don’t recall if Mason was also upgraded around the same
time, but I would deduce so given that nothing else makes sense.
HTML-Mason 1.32 is also what I’m using.

Chris Covington
IT
Plus One Health Management
75 Maiden Lane Suite 801
NY, NY 10038
646-312-6269
http://www.plusoneactive.com