ispCP - Board - Support
lost ispcp db-key-files during upgrade :( - 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: lost ispcp db-key-files during upgrade :( (/thread-13353.html)



lost ispcp db-key-files during upgrade :( - nachtarbeit - 05-06-2011 04:21 PM

i lost the ispcp db-keys files during update (did a backup to /tmp/, but lost them during an accidential reboot O_O )
i was trying to upgrade from 1.0.2 to latest stable.

i found 2 years old ispcp-backups in the ispcp/backup folder, but couldn find any keys Sad

what to do now ? Sad

please help, its really urgent.


RE: lost ispcp db-key-files during upgrade :( - nachtarbeit - 05-07-2011 12:25 AM

can anybody help ?
when i change the ispcp mysql passwd, will i have to change other passwrds like email oder ftp ?


[solved] RE: lost ispcp db-key-files during upgrade :( - nachtarbeit - 05-09-2011 03:56 AM

to generate a new password for a successfull update, do following:

1. follow the upgrade howto (for debian: http://isp-control.net/documentation/start/upgrade/debian )

2. in step 5 leave out the backup of ispcp-db-keys.pl and ispcp-db-keys.php - as they are gone

3. open file /var/www/ispcp/engine/ispcp-db-passwd. search for:
Code:
} else {
                $upass_current = read_password('Please Enter Your Current Password:');
               if ($upass_current ne $check_with) {
                       print STDERR ">>> Entered password does not match. Please try again !\n";
                       return (1, '');
               }
                $upass = read_password('Please Enter Your New Database Password:');

and comment these lines as following:

Code:
} else {
                $upass_current = read_password('Please Enter Your Current Password:');
#               if ($upass_current ne $check_with) {
#                       print STDERR ">>> Entered password does not match. Please try again !\n";
#                       return (1, '');
#               }
                $upass = read_password('Please Enter Your New Database Password:');


3. before step 9 of the upgrade-howto, set a new mysql-password and/or new mysql-user for ispcp - to do so, follow the how-to: http://isp-control.net/documentation/howto/ispcp/change_db_pass

4. now open the /etc/ispcp.conf, copy the db_password to clipboard (strg+c)

5. open /etc/ispcp.old.conf, replace the old db_password with the copied one (strg+v)

6. now continue with step 9 of the upgrade-howto.
the upgrade now should work !

have luck!