Installation wont pass step 2, authentication problem

[hugh_h]

Installation wont pass step 2, authentication problem

I get a message:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

I have this on winxp apache2.0.55, php4.4.2 and mysql 4.1.16-nt

[♥Vger]

The most common cause for installation getting stuck in step 2

is that most recent PHP installations have register_long_arrays = OFF

This needs to be turned to ON in the php.ini file (you will need to

restart your web server to get this change to take effect.)

 

Vger

[hugh_h]

There was no such line in my php.ini, I added it and there is no difference.

[hugh_h]

Maybe it?s something to do with MySQL version, a tried 5.0 and had the same problem, I didn?t find any info in manuala about MySQL version, is it any info abou that?

[Guest]

Try this...

Dev.Mysql.Com Documentation

 

Not quite sure why, but this fixes it for some people. Especially those installing on a local development system.

[spazz]

for me this worked in a .htaccess file inside the catalog folder.

 

 

php_flag register_long_arrays 1

 

 

 

however ,

 

php_flag register_long_arrays = 1 , made the page produce a 500 error.

 

 

I followed the instructions in the pdf, it's a shame register_long_arrays wasn't mentioned.

[scjakester]

I had the same problem. Go into MySQL (or install SQLyog for a pretty GUI) and execute this SQL string.

 

----------------------------------------------------------------------

 

SET PASSWORD FOR

'your_userID'@'your_host_IP' = OLD_PASSWORD('your_new_pwd');

 

----------------------------------------------------------------------

 

I reset the 'your_host_IP' to a '%' because I read somewhere that this means the client can connect from anywhere. Since this is a test environement for me, Fort Knox type security isn't a big deal.

 

Good luck to all who read the thread.

 

-Jake

[roka]

Installation wont pass step 2, authentication problem

I get a message:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

I have this on winxp apache2.0.55, php4.4.2 and mysql 4.1.16-nt

 

hey i think the problem is in mysql something about old passwords but im not exactly i had that problem once or twice check the mysql help forum on that search " OLD_PASSWORD" and you should find a solution there check google too...

[hugh_h]

SET PASSWORD FOR

'your_userID'@'your_host_IP' = OLD_PASSWORD('your_new_pwd');

thnax it solved problem completly

[galto]

I had the same problem. Go into MySQL (or install SQLyog for a pretty GUI) and execute this SQL string.

 

----------------------------------------------------------------------

 

SET PASSWORD FOR

'your_userID'@'your_host_IP' = OLD_PASSWORD('your_new_pwd');

 

----------------------------------------------------------------------

 

I reset the 'your_host_IP' to a '%' because I read somewhere that this means the client can connect from anywhere. Since this is a test environement for me, Fort Knox type security isn't a big deal.

 

Good luck to all who read the thread.

 

-Jake

 

WOW - I had this also out of NOWHERE and my site was down for 10 minutes while I resolved it. I was your POST that made me realize the problem (thanks a bunch). But I'd like to share with everyone in case this happens to anyone else.

 

The key is if you are using mysql 5 (or newer versions starting with 4.1) you need to run the OLD_PASSWORD command. More information is available here (http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html). It turns out that MySql improved hashing mechanism in MySQL 4.1 to provide better security and to reduce the risk of passwords being intercepted. But that means that applications that work off prior versions (I think OSCOMMERCE falls into that category) must run the OLD_PASSWORD command for the code to still work.

 

What is ironic in my situation is that I did do that command when I got OSCOMMERCE up and running several months ago. Today, all I was doing was allowing my MYSQL production user to access a test database I created. Just by doing that, I had to still run the OLD_PASSWORD command since I guess the new priviledges I gave my database user changed the HASHING mechanism. So I wanted to share with everyone.

 

My lesson learned is not to use my production Mysql user also for the test database (leave production as is - my mistake |-) ).

[wverboom]

Hi there,

 

I'm trying to install oscommerce on a windows 2003 server with IIS. I have the same error message...and tried everything allready.

Anyone know how to solve this?

 

Wouter