Unable to install 6

[jwb888]

Hi all

 

There didn't seem to be an update patch for 5.whatever to 6.0 so I overwrote the files with the full install, and then went to go to domain.com/clients/admin as per the documentation.

 

Unfortunately I got this:

 

Critical Error

SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

 

I couldn't afford to keep it in that state so had to restore my backup to 5.whatever but does anybody have any idea what this error might mean I'm doing wrong?

 

Thanks

TL

[cyberoptik]

Go to the install directory (/install) and that will pull up the install process. I had this same issue, however the install did not work for me (waiting on support for almost 6 hours now to help me out).

[jwb888]

Hi

 

Thanks for helping, but yes I did the same thing and like you install didn't even show up.

 

I guess I'll need to log support too, although I have a feeling they are pretty busy right now. Maybe I'll save my upgrade for a week or two to let them iron out the bugs.

 

Thanks again

TL

[owengreaves]

Hi There,

 

I ran into this with a different spin, I got the same error trying to run the installer, how I fixed the problem was the following:

 

I went into phpmyadmin in cPanel, removed (deleted) the privileged user to the whmcs database, I then added the privileged user again, same name & same password as I have in the configuration.php file in whmcs root directory.

 

That's it, I was then able to carry on with the installer. Be patient with the installer, it takes a few seconds / minutes to finish the upgrade.

 

The error is a mysql error, the installer couldn't connect to the database, but by deleting and adding the privileged user to the database solved the problem I was having.

 

Hope that helps,

 

Owen

[WHMCS John]

Hi,

 

This error could suggest that MySQL on your server is using MySQL's old_password method for hashing MySQL user passwords.

 

You can check by looking up your mysql user's stored password hash. If it's 16 characters then your password is hashed using the pre-MySQL 4.1 method, and is probably what's causing your error. If it's 40 characters then your hash uses MySQL's current hashing method, and we'll have to see what else might be causing it.

 

That error's coming from the PDO-MySQL extension when WHMCS tries to make the PDO connection. MySQL changed password hashing methods in version 4.1, and later versions of the PHP mysqlnd driver (v5.3.x) won't connect with the older method.

 

Unless you have an extremely legacy app that can't be touched then you should migrate away from old_password hashes in MySQL.

Then generate new MySQL user passwords so a new hash is generated (or create a new user and assign to the database

Finally you can attempt the upgrade to v6.0 again and it should be successful.

[9DollarDomains]

Hi. Just to add my 2c - I had the same issue when upgrading from 5.3.10 -> 6.2.2 which was this error...

 

SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

 

So based on the explanation above, I went into WHM, did a MANAGE DATABASE USERS, and changed the password for the user. I just changed it to the same existing password from the configuration.php file, but I'm assuming that stored in from old-hash to new-hash in the process, and (even though I haven't had any actual old hash since the 1970's) that worked for me.