Content
logins all disabled after ubuntu OS upgrade
Added by Keenan Troll about 1 year ago
Hello, I am grasping for ideas to resolve a rather unique situation I am in.
I recently upgraded an ubuntu server to 20.04, and openproject appears to be running fine except now every account gets the error "Invalid user or password or the account is blocked..."
Sadly, the openproject installation is a Bitnami Stack (I know I know, shame on me, sorry) for version 8.2.1, so it's unclear how the problem was caused or how to go about fixing it. Since all of the dependencies are siloed into their own installations within the bitnami stack, I can't invoke the ruby console or openproject CLI as normal (although the necessary dependencies and binaries all do seem to exist in those folders).
I have root access into the mysql database and can see all of the user accounts and their hashed passwords in there. I can also see the global settings and whatnot, and manually edit anything. But, I cannot figure out a way to fix this issue.
I can restore the server boot drive to before the OS upgrade was performed, and hopefully that will restore the old installation to its working state, and from there I can do the migration to "properly" installed recent version and re-do the OS upgrade...
But if anyone here can think of a way to force my way in, and rebuild the login credentials somehow, I'd much rather do that. It seems there must be a way since I have root access to the database and filesystem, I just can't see how it would be done. I can provide screenshots from phpmyadmin if that helps... Thanks in advance to anyone who can help out!