Current time: 06-21-2018, 01:24 AM Hello There, Guest! (LoginRegister)


Post Reply 
Update ispCP database schema ... FAILED
Author Message
ctct Offline
Newbie
*

Posts: 9
Joined: May 2009
Reputation: 0
Post: #1
Update ispCP database schema ... FAILED
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
04-20-2010 03:47 AM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #2
RE: Update ispCP database schema ... FAILED
Sure the MySQL-Root password is correct ?
Try it manually please via mysql,mysqladmin or PMA.

Greez BeNe
04-20-2010 04:42 PM
Visit this user's website Find all posts by this user Quote this message in a reply
gOOvER Offline
Banned

Posts: 3,564
Joined: Jul 2007
Post: #3
RE: Update ispCP database schema ... FAILED
http://www.isp-control.net/documentation...ge_db_pass

Start at Point 4 Wink
04-20-2010 04:55 PM
Visit this user's website Find all posts by this user Quote this message in a reply
ctct Offline
Newbie
*

Posts: 9
Joined: May 2009
Reputation: 0
Post: #4
RE: Update ispCP database schema ... FAILED
(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...ge_db_pass

Start at Point 4 Wink

I did that.

Thanks. Still bringing the same error.
(This post was last modified: 04-20-2010 08:14 PM by ctct.)
04-20-2010 08:13 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #5
RE: Update ispCP database schema ... FAILED
Some special chars in the Password ?

Greez BeNe
04-20-2010 08:51 PM
Visit this user's website Find all posts by this user Quote this message in a reply
ctct Offline
Newbie
*

Posts: 9
Joined: May 2009
Reputation: 0
Post: #6
RE: Update ispCP database schema ... FAILED
(04-20-2010 08:51 PM)BeNe Wrote:  Some special chars in the Password ?

Greez BeNe

Password is: [censored]

;-)
(This post was last modified: 05-23-2010 04:29 AM by RatS.)
04-20-2010 09:26 PM
Find all posts by this user Quote this message in a reply
ctct Offline
Newbie
*

Posts: 9
Joined: May 2009
Reputation: 0
Post: #7
RE: Update ispCP database schema ... FAILED
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
04-20-2010 11:53 PM
Find all posts by this user Quote this message in a reply
theGrimm Offline
Newbie
*

Posts: 6
Joined: Oct 2007
Reputation: 0
Post: #8
RE: Update ispCP database schema ... FAILED
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...ge_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 ?
04-24-2010 05:07 AM
Find all posts by this user Quote this message in a reply
rethus Offline
Junior Member
*

Posts: 202
Joined: May 2009
Reputation: 3
Post: #9
Question RE: Update ispCP database schema ... FAILED
(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...ge_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/sta...ade: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/sta...ade:debian
(This post was last modified: 06-24-2010 02:55 AM by rethus.)
05-12-2010 03:01 AM
Find all posts by this user Quote this message in a reply
cmendes0101 Offline
Junior Member
*

Posts: 16
Joined: Dec 2009
Reputation: 0
Post: #10
RE: Update ispCP database schema ... FAILED
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
05-12-2010 03:48 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)