Current time: 11-06-2024, 02:29 AM Hello There, Guest! (LoginRegister)


Post Reply 
Update ispCP database schema ... FAILED
Author Message
michel128 Offline
Junior Member
*

Posts: 11
Joined: Feb 2010
Reputation: 0
Post: #11
RE: Update ispCP database schema ... FAILED
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 !


Attached File(s) Thumbnail(s)
   
05-15-2010 12:04 AM
Find all posts by this user Quote this message in a reply
roajayson Offline


Posts: 2
Joined: May 2010
Reputation: 0
Post: #12
RE: Update ispCP database schema ... FAILED
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
05-16-2010 04:02 PM
Find all posts by this user Quote this message in a reply
ericliang Offline


Posts: 3
Joined: Aug 2009
Reputation: 0
Post: #13
RE: Update ispCP database schema ... FAILED
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!
05-21-2010 08:17 PM
Find all posts by this user Quote this message in a reply
Discobear Offline
Junior Member
*

Posts: 11
Joined: Dec 2009
Reputation: 0
Post: #14
RE: Update ispCP database schema ... FAILED
(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!
05-24-2010 07:03 AM
Find all posts by this user Quote this message in a reply
michel128 Offline
Junior Member
*

Posts: 11
Joined: Feb 2010
Reputation: 0
Post: #15
RE: Update ispCP database schema ... FAILED
roajayson, your tip worked for me on a test version. I will try it soon on the life server.

Thank !
05-30-2010 01:03 AM
Find all posts by this user Quote this message in a reply
SebiF Offline


Posts: 1
Joined: Jun 2010
Reputation: 0
Post: #16
RE: Update ispCP database schema ... FAILED
(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!
06-03-2010 10:57 PM
Find all posts by this user Quote this message in a reply
gynox Offline
Banned

Posts: 5
Joined: Mar 2010
Post: #17
RE: Update ispCP database schema ... FAILED
I do everything from this post, and i get that same error again :-((

What can i do ?? please help
06-19-2010 08:00 AM
Find all posts by this user Quote this message in a reply
mr.x Offline
Development Team
*****
Dev Team

Posts: 232
Joined: Nov 2006
Reputation: 3
Post: #18
RE: Update ispCP database schema ... FAILED
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
06-19-2010 06:34 PM
Find all posts by this user Quote this message in a reply
catfish Offline
Newbie
*

Posts: 8
Joined: Jun 2008
Reputation: 0
Post: #19
RE: Update ispCP database schema ... FAILED
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
(This post was last modified: 08-30-2010 07:06 AM by catfish.)
08-30-2010 06:33 AM
Find all posts by this user Quote this message in a reply
avispa987 Offline
Junior Member
*****
Dev Team

Posts: 70
Joined: Oct 2007
Reputation: 0
Post: #20
RE: Update ispCP database schema ... FAILED
(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!!
06-10-2011 12:45 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)