[SOLVED] Changed MySQL root password and can't update ispcp

[SOLVED] Changed MySQL root password and can't update ispcp - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: [SOLVED] Changed MySQL root password and can't update ispcp (/thread-9930.html)

[SOLVED] Changed MySQL root password and can't update ispcp - sintax - 03-09-2010 10:05 AM

Hi,

I needed to change the MySQL root password due to a hack attempt. After this I tried updating ISPCP and it gives an error:
Update ispCP database schema: [failed]

How can I tell ISPCP what the new root password is WITHOUT having to reinstall ISPCP and all my domains??

Thanks,
Sintax

RE: Changed MySQL root password and can't update ispcp - gOOvER - 03-09-2010 10:21 AM

http://www.isp-control.net/documentation/doku.php?id=howto:ispcp:change_db_pass

For the Future: First take a look into teh Docu, then Open a Thread Wink

RE: Changed MySQL root password and can't update ispcp - sintax - 03-09-2010 10:47 AM

(03-09-2010 10:21 AM)gOOvER Wrote: http://www.isp-control.net/documentation/doku.php?id=howto:ispcp:change_db_pass

For the Future: First take a look into teh Docu, then Open a Thread

Here's my problem:
I had to change the root password for mysql AND then started the update process to 1.0.4. During this the updater complained about the database not being updatable. SO I followed the doc to reset the pass:
edited the /etc/ispcp/ispcp.conf by removing the DATABASE_PASSWORD = contents. Then ran the ispcp-db-passwd. Set it to the actual root password.

Then I checked the conf file and it updated with the proper pass.

Now here's the weird thing:
After this I ran the ispcp-updater again and it STILL complained about the password AND the /etc/ispcp/ispcp.conf REVERTED the DATABASE_PASSWORD to the old HASH.

The services were stopped before this started. It looks like it is STILL remembering the old pass and replacing it during the update. Is there any other place the old pass might've been stored? I also updated /tmp/ispcp/etc/ispcp/ispcp.conf but no luck.

Getting:
Stopping Services:......... [done]

ispCP main configuration file
Loading old ispCP configuration file: [done]
Update ispCP configuration file: [done]
Check ispCP configuration file: [done]

ispCP database
Update ispCP database schema: [failed]

FATAL: An error was occured during update process!
Correct it and re-run this program.

You can find help at http://isp-control.net/forum

Any ideas?

RE: [SOLVED] Changed MySQL root password and can't update ispcp - kilburn - 03-09-2010 07:01 PM

As the update process regenerates your /etc/ispcp/ispcp.conf file, it is moved to /etc/ispcp/ispcp.old.conf first, and the update process uses this one instead. Therefore, you just have to follow the change password procedure again, and then *manually* replace the "hash" (it's not a hash, but your password encrypted) in /etc/ispcp/ispcp.old.conf with the one that has been put in /etc/ispcp/ispcp.conf by the password changer. Then re-reun ispcp-update and everything will be ok.