My apologies for a silly post but I’m getting confused…
I am migrating from 3.8.4 to 4.01. I have a new server with 4.01 installed
and mostly set up how I want. I have pulled my database dumps into the new
instance, performed the steps in UPGRADING.mysql and run the script
/opt/rt4/sbin/rt-setup-database --prompt-for-dba-password --action upgrade
I’ve missed something and I’m sure I saw it when reading the docs but now
can’t figure out what I missed. After tweaking my set up I’ve tried
restoring from last nights 3.8.4 instance mysqldump and I have to manually
set the passwords in MySQL to log in as the RT user. For example:*
UPDATE Users SET Password=md5(‘password’) WHERE Name=‘user’;*
This lets the user log in - but only once, after a logout the user cannot
again log in. I believe there was a change in the hash used for passwords
and that there is a script I need to run to fix this but I cannot for the
life of me find this again.
Am I on the right track and what can I tell you to help figure out what I
Please and thanks.