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?).
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
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
I've been monitoring the cookies within firefox, and I cannot see
anything that is inconsistent as I move from one link to
another.....when the system logs me out, all that has changed is the
Content field in the cookie as you'd expect if you actually had logged
out.
Also the same URL information would exist for sqlite so if it were
cookie issues, you’d expect the same problem with sqlite.
I’ve also done some traces with mysql logging, but so far nothing that
I can pinpoint. It just logs out and closes the sesion…so far thats
all I see within the mysql log.
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
I've been monitoring the cookies within firefox, and I cannot see
anything that is inconsistent as I move from one link to
another.....when the system logs me out, all that has changed is the
Content field in the cookie as you'd expect if you actually had logged
out.
Also the same URL information would exist for sqlite so if it were
cookie issues, you’d expect the same problem with sqlite.
I’ve also done some traces with mysql logging, but so far nothing that
I can pinpoint. It just logs out and closes the sesion…so far thats
all I see within the mysql log.
Well, sort of solved. It remains a bit of a mystery. I did a system
update even though the test images were only 1 week old and the logout
issue went away. (I was using VM's to test with so I could do clean
installs whenever I needed to)
I now suspect that it had something to do with RT:Authen::ExternalAuth
more than RT…I neglected to mention that I was using it since it was
authenticating fine.