[rt-users] Login Passwords Fail following upgrade to RT 4.0.0

[dfriend at qcol.net]

I am currently running RT 3.8.16 and all appears to be working fine. I
have decided to upgrade to RT 4.0.0. I am using mysql database. I did a
backup of the rt3 database and installed rt4. I restored the rt3 backup to
the rt4 database. All initially appears to be fine in that I can login and
view, create and edit tickets. If I log-off and attempt to login again, I
get an error that the password is invalid. I have tried logging in as root
and changing my user password and find that the password change fails
reporting that the root's current password is incorrect. I can manually
pull the original password from the RT3 database and post it to the users
record in the rt4 database and I can login fine using the original
password. However, if I log-out I cannot log back in because of a failed
password message. I did a fresh install of RT 4.0.0 and everything appears
to work fine but I do not have my prior tickets. I reviewed the users
table fields and compared it to the rt3 database fields. The rt3 password
field is varbinary(40) and the rt4 password field type id varchar(256).
There are a few other differences in the users database between rt3 & rt4.
I have tried to follow the README, UPGRADING & UPGRADING.mysql directions
but cannot find that the new database SCHEMA has changed during these
processes.

I am looking for understanding of which RT version the database schema
changed. Were the changes part of an RT3 upgrade that might not have
completed properly or is it new to RT4? I want to verify the upgrade
process was performed properly and possibly rerun that upgrade to verify
my database changes actually take effect. I would also need to know the
specific script or process makes these changes to the database so I can
verify it completes as expected. Is there a script to modify my old
database to the new SCHEMA?

Thanks,
Doug