Header.inc.php and mysql access

[rsteinmetz70112]

After an issue with my egroupware server I am unable to access the egroupware mysql database. I think the problem maybe the password for the mysql server.

The header.inc.php has the correct mysql database name and user name. The db_pass appears to be a hash of the database user password. Is that correct?

I can change the user password on the database, but how can I generate the hash to update header.inc.php, or am I missing something?

[RalfBecker]

The header.inc.php has the correct mysql database name and user name. The db_pass appears to be a hash of the database user password. Is that correct?

No, the database password must be in cleartext, it can NOT be a hash. It might look like a hash, because we create a random one normally.

Anyway, if you have the mysql root password, you can run the following SQL to set again the password for the user egroupware:

GRANT ALL ON egroupware.* TO egroupware@localhost identified by '<password>';

Replacing <password> with the value you have in your header.inc.php for db_pass.

how can I generate the hash to update header.inc.php, or am I missing something?

The header- or config password ist most easy to generate again with setup:

1. open the header.inc.php with a texteditor (eg. vi) and replace the header_admin_password with {plain}Secret123 and the same for the config_passwd
2. use Secret123 to log into the header-admin (lower setup login) and set your desired password, which will be automatically hashed

Ralf

[rsteinmetz70112]

As always thank you for your prompt response.

I will change the password for the mysql egroupware user and edit the header.inc.php file appropriately.

I have the the header and config passwords so I am good there.