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

[TN]

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.

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