OpenProject can't login admin because email invalid

Linux howto's, compile information, information on whatever we learned on working with linux, MACOs and - of course - Products of the big evil....
Post Reply
Site Admin
Posts: 443
Joined: Fri Aug 29, 2003 9:29 pm

OpenProject can't login admin because email invalid

Post by gilthanaz »

NOTE: Whatever you do, we're not responsible if you break things by using fixes we found.

After everything was set up, i wanted to log on with the admin/admin creds. You are forced to change the password, so i entered the data and wanted to continue. I got the error that an email must be set to continue. However, there is no e-mail field to configure, so i can't change the password, so i can't log in to enter an email addy...

There was a step in the installer that asked for the admins email address. I left that blank, which lead to an empty entry in the user database field for email for that user, causing the admin account to be broken.


You can modify the field in the database directly. For this, you need the mysql root password. You can find it in /etc/openproject/installer.dat - using this login, you should be able to open a sql connection, modify the problematic field, and finally log in + change the pwd to recover admin rights.

As root, execute:

Code: Select all

    mysql openproject -p<password from installer.dat file>
In mysql, execute:

Code: Select all

    mysql> UPDATE users SET mail='your@address.example' WHERE id = '1';
    mysql> commit;
The other option is to run:

Code: Select all

openproject reconfigure
And re-do the configuration that prompts for the admin mail address.

You should then be able to log on with admin/admin and do the initial password reset to be able to access the system!
Post Reply