Kevin Falcone <falcone bestpractical.com> writes:
Pg puts sessions in the DB, sqlite puts sessions on the filesystem, so
there really isn’t much of a comparision there.
Normally accessing RT through an alias RT doesn’t know about results
in redirects to the wrong hostname and cookies aren’t sent.
As I usually advise when this comes up, you need to look at what
cookies RT is sending you and what cookies are sent back to RT to
begin untangling it. Anything else is speculation.
-kevin
Thanks for the tip. I took the following steps, to no effect. Can you suggest
anything else I might look for?
- remove all cookies, there were 2.
- change configuration to 1.2.3.4 everywhere, restart apache.
- sudo -u postgres psql -d rtdb -c “delete from sessions;” 73 rows.
- browse to http://1.2.3.4/rt, login, check cookie, one created
each link-login cycle, below:
rtdb=# select id, lastupdated from sessions;
id | lastupdated
(0 rows)
login, click link, login,
rtdb=# select id, lastupdated from sessions;
id | lastupdated
177274163d2d9e5c63d9206e59be8e7a | 2011-03-24 22:39:02.782436
2ae80cdb59debb85a8bd5e1586f94be1 | 2011-03-24 22:39:12.454886
96ec379e94a5aefa5ce9d6c2359ff8a3 | 2011-03-24 22:39:21.660138
(3 rows)
Cookie
http://1.2.3.4/rt/
1 cookie
Name RT_SID_test_it.80
Value 96ec379e94a5aefa5ce9d6c2359ff8a3
Host 10.132.3.17
Path /rt
Secure No
Expires At End Of Session
$ sudo cat /etc/request-tracker3.8/RT_SiteConfig.d/50-debconf
THE BASICS:
Set($rtname, ‘test_it’);
Set($Organization, ‘rt.acme.com’);
Set($CorrespondAddress , ‘rt@server1.acme.com’);
Set($CommentAddress , ‘rt-comment@server1.acme.com’);
THE WEBSERVER:
Set($WebPath , “/rt”);
#Set($WebBaseURL , “http://server1.acme.com”);
Set($WebBaseURL , “http://1.2.3.4”);
$ tail -n 1 /etc/apache2/apache2.conf
ServerName tickets
$ tail -n 5 /etc/apache2/sites-available/default
Include /etc/request-tracker3.8/apache2-modperl2.conf
RedirectMatch ^/$ /rt