Hello, Because of the OVH disaster, I had to recover my VPS, unfortunately I had backups for all instead the /usr/local/ispconfig directory, So I had to reinstall ISPConfig. Then, after the install, I have deleted the ispconfig user and the dbispconfig database and restored everything from my backups. Of course it doesn't work because ispconfig during the reinstallation has written a new password in the config.inc.php. What can I do then ? What is the best strategy ? Changing the password in config.inc.php ? but how ? Kind regards Philippe
You could set the new mysql root password in server/lib/mysql_client.inc.php then reconfigure services with the ispconfig updater.
Thanks Jesse for the reply, but in fact I'm not talking about the root password, but about the ispconfig mysql user password.
Right, you either need to set the database to your old password so all your old config files work (easiest to do so using phpmyadmin?), or if the database and config.inc.php have a new password (those two must match), you can reconfigure services and it will set everything to your new password.
Thank Jesse, I did quite like you suggest, reinstall ispconfig let him work untill the end then drop the dbispconfig database only, keep the new ispconfig mysql user, recreate the dbisconfig database from my backup and it is working. At least the Ispconfig admin panel is able to show all my sites.