ispCP - Board - Support
Update ispCP database schema ... FAILED - 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: Update ispCP database schema ... FAILED (/thread-10465.html)

Pages: 1 2 3

Update ispCP database schema ... FAILED - ctct - 04-20-2010 03:47 AM

Hello Guys.
I've followed the Upgrade instructions acuratly severel times. Trying to Upgrade from 1.0.3 to 1.0.5.
I'm getting this error. I think it might have been a wrong setting in MySQL upgrade. I set the Anonymus user off and dissalowed remote access to root.
Are these setting ok?
I use root for my IspCP db access.

Any help would greatly be appreciated.

Code:
srv01:/tmp# vi ispcp-update-database.log
Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

Code:
srv01:/var/www/ispcp/engine/setup# perl ispcp-update

        Welcome to ispCP '1.0.5 OMEGA' Update Dialog.

        This program will update your current ispCP OMEGA installation on this
        server.
        Please make sure you did a backup of all your server data.

        NOTE: During the migration process some or all services might require to
        be shut down.

        WARNING: Only services that are not marked with 'NO' in your ispcp.conf
        configuration file will be processed by this program.

        Do you want to continue [Y/n]:

        NOTICE: Make sure you have read and performed all steps from
        docs/distro/INSTALL document (where distro is your linux distribution).

        Do you want to continue [Y/n/?]:

         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

Thanks

RE: Update ispCP database schema ... FAILED - BeNe - 04-20-2010 04:42 PM

Sure the MySQL-Root password is correct ?
Try it manually please via mysql,mysqladmin or PMA.

Greez BeNe

RE: Update ispCP database schema ... FAILED - gOOvER - 04-20-2010 04:55 PM

http://www.isp-control.net/documentation/howto:ispcp:change_db_pass

Start at Point 4 Wink

RE: Update ispCP database schema ... FAILED - ctct - 04-20-2010 08:13 PM

(04-20-2010 04:42 PM)BeNe Wrote:  Sure the MySQL-Root password is correct ?
Try it manually please via mysql,mysqladmin or PMA.

Greez BeNe

Yes it is correct.

(04-20-2010 04:55 PM)gOOvER Wrote:  http://www.isp-control.net/documentation/howto:ispcp:change_db_pass

Start at Point 4 Wink

I did that.

Thanks. Still bringing the same error.

RE: Update ispCP database schema ... FAILED - BeNe - 04-20-2010 08:51 PM

Some special chars in the Password ?

Greez BeNe

RE: Update ispCP database schema ... FAILED - ctct - 04-20-2010 09:26 PM

(04-20-2010 08:51 PM)BeNe Wrote:  Some special chars in the Password ?

Greez BeNe

Password is: [censored]

;-)

RE: Update ispCP database schema ... FAILED - ctct - 04-20-2010 11:53 PM

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

RE: Update ispCP database schema ... FAILED - theGrimm - 04-24-2010 05:07 AM

Hey guys i got the same Problem , i double ckecked my mysqlroot password and it works with mysql-pxxxxx
i followed this tutorial to change the password again http://www.isp-control.net/documentation/howto:ispcp:change_db_pass
but didn't help ...

in the db ky files there are the same passwords inside,nothing with default variables

what can i do ?

RE: Update ispCP database schema ... FAILED - rethus - 05-12-2010 03:01 AM

(04-24-2010 05:07 AM)theGrimm Wrote:  Hey guys i got the same Problem , i double ckecked my mysqlroot password and it works with mysql-pxxxxx
i followed this tutorial to change the password again http://www.isp-control.net/documentation/howto:ispcp:change_db_pass
but didn't help ...

in the db ky files there are the same passwords inside,nothing with default variables

what can i do ?

Same Problem here on 1.0.5
Have doing all "step by step" which are descriped here: http://isp-control.net/documentation/start:upgrade:debian

And got:
Quote:ispCP database
Update ispCP database schema Failed

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

Then i have tryed to login into mysql on server directly, which worked [mysql -uroot -p (than type my password)

After that i have delete the input of the VAR: "DATABASE_PASSWORD ="in /etc/ispcp/ispcp.conf

Then i have done a: /var/www/ispcp/engine/ispcp-db-passwd and enter my password which worked at mysql directly.

After that i look again into /etc/ispcp/ispcp.conf and see now a crypted password like: /J8OkbCjc1xAAdDqp3wcTg==

I close the file, and run
Code:
perl ispcp-update
in
Code:
/var/www/ispcp/engine/setup

Update abort with the error i've posted above.

NOW i look again into the file /etc/ispcp/ispcp.conf and i wonder, why DATABASE_PASSWORD = has no value.. such like before.

Can anybody help me to fix this problem?
####################
Have solve the problem and write it into the wiki (7.1 and 10.1)
http://isp-control.net/documentation/start:upgrade:debian

RE: Update ispCP database schema ... FAILED - cmendes0101 - 05-12-2010 03:48 PM

I'm having the same issue upgrading from 1.0.4. The last post pointing to "Have solve the problem and write it into the wiki (7.1 and 10.1)" did not work for me. Thanks