[BlueOnyx:24492] Re: setting MariaDB root password stops RoundCube on vsites

[Michael Stauber]

Hi Ed,

> I reset the root/localhost password to phpMyAdmin with SQL commands
> directly from a shell session, with these commands:

The MySQL or MariaDB password should ideally only be changed through the
BlueOnyx GUI under "Server Management" / "Network Services" / "MariaDB".
There is a "Change Password" tab.

The GUI needs to know the "root" password of MariaDB or MySQL, otherwise
it cannot perform some functions.

To tell the GUI the new "root" password after manual changes you use the
same GUI page. Enter the current "root" password in the "Server" tab on
the same page and save the changes.

Likewise, for Web Applications such as RoundCube the "Web Applications"
installer also needs to know the "root" password of MariaDB.

Go to "Server Management" / "Web Applications" / "Setup SQL" and enter
the new password there as well. Save the changes.

If RoundCube refuses to work afterwards, undeploy RoundCube from that
Vsite and redeploy it into that Vsite. That's less hassles than editing
all config.php files manually.

-- 
With best regards

Michael Stauber