[rt-users] bizarre logouts with mysql on top level links

[Jesse Vincent]

On Tue 24.Mar'09 at 15:41:36 +1100, TN wrote:
> Hi all,
> 
> I have installed rt3.8.2 from debian sid, and it works fine using sqlite.
> 
> However when I configure it with mysql, I have random logouts occurring.
> I login as root. If I then just keep clicking along the LHS links 
> (Home/Simple Search/Tickets/Tools/Config etc etc) then anywhere from 2 
> or more clicks the system will revert straight back to the login screen 
> as if I had been logged out. If I instead just keep clicking the same 
> menu item over & over, it never logs out.
> 
> Also, if I go into the 'Configuration' level of the menu, and then start 
> randomly clicking in that level of the menu (Users/Groups/Queues etc) 
> then I can click forever and the system never logs out. If I then go 
> back to clicking the 'top' level menu again, it will log out after some 
> more clicks.
> 
> If I then go back to sqlite, and do the same tests, everything is fine 
> in sqlite. This seems to be only an issues with mysql.
> 
> I can't see any hints in syslog or apache logs or the mysql logs.

My rough guess is that you're ending up at different variants of your
host or domain name, which end up with different cookies

> 
> Any ideas ?
> 
> 
> ps. i configured rt3.8.2 to work with mysql by the following method 
> since there seems to be a configuration bug in the 'schema' action in 
> rt-setup-database which results in an error claiming that the 
> Attachments table already exists (as if the script is trying to execute 
> twice?).
> 
> rt-setup-database --datadir /usr/share/request-tracker3.8/etc --dba root 
> --prompt-for-dba-password --action create
> mysql -u root -p rt3 < /usr/share/request-tracker3.8/etc/schema.mysql
> rt-setup-database --datadir /usr/share/request-tracker3.8/etc --dba root 
> --prompt-for-dba-password --action acl
> rt-setup-database --datadir /usr/share/request-tracker3.8/etc --dba root 
> --prompt-for-dba-password --action coredata
> rt-setup-database --datafile 
> /usr/share/request-tracker3.8/etc/initialdata --dba root 
> --prompt-for-dba-password --action insert
> 
> All these perform without error, and a check of the db shows everything 
> is fine.
> 
> 
> Send instant messages to your online friends http://au.messenger.yahoo.com 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090324/13ccc6c6/attachment.sig>