Update ispCP database schema ... FAILED

[michel128]

Hello,

I've the problem on a Debian.

First install, some months ago, a 1.0.4. Now upgrading to 1.0.5 following http://isp-control.net/documentation/sta...de:debian.

During the ispcp-update, I have this screen.

While checking old and new config files I do not see any difference between them !

When I try to log in the admin panel, to ececute "System-Tools » iscPC-Databaseupdate" I've an error : Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

I did never changed the password so I'm sure it's the good one.

I do without any issue all mysql command from the shell.

What can I do ?

Thank for your reply !

[roajayson]

I was having the same problem and did the following and it worked. I haven't seen this posted anywhere else yet so let me know if it works for you guys as well.

First

Code:

nano /etc/ispcp/ispcp.conf

Remove the hash from DATABASE_PASSWORD so the line only reads as

Code:

DATABASE_PASSWORD =

Next you need to put in your current mysql password

Code:

/var/www/ispcp/engine/ispcp-db-passwd

Now for the important part you need to copy the new hash from DATABASE_PASSWORD = newhash

Code:

nano /etc/ispcp/ispcp.conf

Then replace the old hash in this file with the new hash you just copied

Code:

nano /etc/ispcp/ispcp.old.conf

And finally

Code:

perl ispcp-update

[ericliang]

I ran in the same problem while upgrading 1.0.4 to 1.0.5

It didn't connect to DB. Since I didn't know at that time the root password (and users wanted their email again) I decided to change to a password I know, ie resetted the MySQL root password to a different one.

This made hell break loose for me because, even though I set the password to new one (I used a PHP function I found while googling) and ispcp update completed fine, all POP3 passwords are now invalid.

This means that users need to log on to their CP and change their passwords.

I followed the upgrade instructions to the letter. This was the 3rd upgrade on ispcp on that system I think. The previous ones had no problems at all.

Can someone help me understand what went wrong? I don't know how ispcp works internally in order to try and fix things myself so if you know what happened in my case please let me know.

What I did was
1) try to upgrade - DB connection failed (password YES)
2) thought ispcp.conf password is plain text and tried to get on mysql from cmd using this pass - failed
3) ran mysql in no password - changed root password
4) found some PHP script that encrypted the password because I found out this was not the case. Added the encrypted (new) password in ispcp.conf and .old.
5) upgraded from 1.0.4 to 1.0.5 and it showed fine (took a long time to "change passwords" or some similar message)
6) web login worked fine.
7) pop3 logins failed with wrong password message.

Should ispcp survive? What was this "password regeneration" that paused installation for some time?

Should this happen? Should I had ran /var/www/ispcp/engine/ispcp-db-passwd? Would that fix things in my case?

Please tell me what I should have done because I have a fear now for next upgrade :-/

Thanks!

[Discobear]

(05-16-2010 04:02 PM)roajayson Wrote:  I was having the same problem and did the following and it worked. I haven't seen this posted anywhere else yet so let me know if it works for you guys as well.

First

Code:

nano /etc/ispcp/ispcp.conf

Remove the hash from DATABASE_PASSWORD so the line only reads as

Code:

DATABASE_PASSWORD =

Next you need to put in your current mysql password

Code:

/var/www/ispcp/engine/ispcp-db-passwd

Now for the important part you need to copy the new hash from DATABASE_PASSWORD = newhash

Code:

nano /etc/ispcp/ispcp.conf

Then replace the old hash in this file with the new hash you just copied

Code:

nano /etc/ispcp/ispcp.old.conf

And finally

Code:

perl ispcp-update

This tip working!

[michel128]

roajayson, your tip worked for me on a test version. I will try it soon on the life server.

Thank !

[SebiF]

(04-20-2010 11:53 PM)ctct Wrote:  Found the Problem.
The file 'var/www/ispcp/gui/include/ispcp-db-keys.php'

had an empty default setting in it:

$ispcp_db_pass_key = '{KEY}';

$ispcp_db_pass_iv = '{IV}';

I put the same values as '/var/www/ispcp/engine/ispcp-db-keys.pl' in the place holders and all is fine now!

Thanks

This is the only method that helped. I tried all the other methods that were mentioned in this thread before trying this.

Thank you, ctct! You made my day!

[gynox]

I do everything from this post, and i get that same error again :-((

What can i do ?? please help

[mr.x]

Hi,

(06-19-2010 08:00 AM)gynox Wrote:  I do everything from this post, and i get that same error again :-((

What can i do ?? please help

try to do it again step by step. Should solve the isse.

/Mr.X

[catfish]

it's working now however with the error msg below - any ideas?

Code:

    ispCP main configuration file
     Loading old ispCP configuration fileUse of uninitialized value $db_pass_key in length at /var/www/ispcp/engine/setup/../ispcp_common_methods.pl line 1713.
                                                    Done
     Update ispCP configuration file:Use of uninitialized value $db_pass_key in length at /var/www/ispcp/engine/setup/../ispcp_common_methods.pl line 1713.
Use of uninitialized value $db_pass_key in length at /var/www/ispcp/engine/setup/../ispcp_common_methods.pl line 1713.
                                                        Done
     Check ispCP configuration file:                                                         Done

    ispCP database
     Update ispCP database schema                                                            Done

[avispa987]

(05-16-2010 04:02 PM)roajayson Wrote:  I was having the same problem and did the following and it worked. I haven't seen this posted anywhere else yet so let me know if it works for you guys as well.

First

Code:

nano /etc/ispcp/ispcp.conf

Remove the hash from DATABASE_PASSWORD so the line only reads as

Code:

DATABASE_PASSWORD =

Next you need to put in your current mysql password

Code:

/var/www/ispcp/engine/ispcp-db-passwd

Now for the important part you need to copy the new hash from DATABASE_PASSWORD = newhash

Code:

nano /etc/ispcp/ispcp.conf

Then replace the old hash in this file with the new hash you just copied

Code:

nano /etc/ispcp/ispcp.old.conf

And finally

Code:

perl ispcp-update

THIS SAVED ME!!!! THANKS A LOT!!