mySQL 4.1 client authentication

[sHORTYWZ]

Alright, I just upgraded to CentOS3.5 from Redhat9.

With RH9 I had PHP working just fine with mysql4.1 using the new passwords - hence, all of my users have new passwords stored.

After upgrading to CentOS I recompiled apache to include another aspell as it was requested by a user. Now I am having the famous "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client" error.

I have recompiled apache/php with easyapache more times than I can count trying different options. Use System mysql checked/unchecked, ran /scripts/mysqlup --force to refresh all of that stuff, still no luck.

It's simply not feasable for me to use old passwords at this point as that would require all my users to go back and reset their passwords - a nightmare I'm not willing to go through.

Anyone have any ideas? I am waiting for a reply from EZSM at the moment but want to see if anyone has any suggestions in the meantime.

Thanks.

[AndyReed]

This is NOT Cpanel problem and you should have searched MySQL Web site before posting this question. It is common to experience such problem when upgrading MySQL to v4.1. The solution is posted on MySQL Web site: http://dev.mysql.com/doc/mysql/en/old-client.html

[casey]

Did you compile php to use the system mysql or the mysql bundled with php? What does the relevant section of phpinfo() show?

[mynameislee]

Now I am having the famous "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client" error.

Hi sHORTYWZ,

There is an option to fix this in Tweak Settings.

"Use old style (4.0) passwords with mySQL 4.1"

Lee.

[sHORTYWZ]

None of you guys quite grasp my problem =)

phpinfo shows:
Client API version 3.23.49

I have checked use system mysql and recompiled - it should not be compiling 3.23.49, it should be compiling using the system mysql of 4.1.11.

Simply switching to old-passwords will not work for me as for the reasons stated in my original post..

Let me rephrase my original post to make my question a little more clear... the only thing that was actually a *question* in there was th is:

Why isn't the mysql module in php being compiled by easyapache picking up my system mysql?

[casey]

You should try compiling it manually. See if there are any errors in the compile.

[sHORTYWZ]

You should try compiling it manually. See if there are any errors in the compile.

Did a manual compile of PHP and everything is working peachy keen. Still curious as to why easyapache was ignoring the use system mysql option.

Thanks to the half of you that tried to help =)

[Sinewy]

if you tick 'use system mysql' in the php builder, it will insert --with-mysql=/usr into the php configure. That will make it use the MySQL 4.1 libraries and not the inbuilt 3.23 ones.

Using just --with-mysql will make it use the inbuilt 3.23 libraries which do not work with 4.1.

Regards,
Alan

[sHORTYWZ]

if you tick 'use system mysql' in the php builder, it will insert --with-mysql=/usr into the php configure. That will make it use the MySQL 4.1 libraries and not the inbuilt 3.23 ones.

Using just --with-mysql will make it use the inbuilt 3.23 libraries which do not work with 4.1.

Regards,
Alan

That's the thing, when I went and looked at a phpinfo afterwords, it wasn't showing the --with-mysql=/usr option. It was still using the regular option.

[rwoliver2]

I'm having the exact same problem on one of my servers. It has to be a bug in easyapache. I am manually compiling PHP 4.3.11 now with a fixed config line, so I'm crossing my fingers.

Rob

[rwoliver2]

A manual compile of PHP 4.3.11 did solve the problem, and now the new MySQL 4.1.x libs are working.

Does anyone know how to fix the buildapache script so that it will use the MySQL 4.1.x libs instead of the PHP built-in ones? The "Use System MySQL" link is just not working.

This is a fairly serious problem.

Rob

[gemby]

A manual compile of PHP 4.3.11 did solve the problem, and now the new MySQL 4.1.x libs are working.

Does anyone know how to fix the buildapache script so that it will use the MySQL 4.1.x libs instead of the PHP built-in ones? The "Use System MySQL" link is just not working.

This is a fairly serious problem.

Rob

Nope, leave it like this, we have to wait until cpanel guys fix damn thing, i posted yesterday link to old easyapache from my box and howto manual install, but, today this post is missing, do not know why moderator did it, but ok, if you think that this is safe, ok. I am allmost sure that i checked, and post was there, it was late, an i am not 120% sure, but i am now sure that post does not exist. I know that you cpanel guys do not work on weekends, but we have to work.

[Sinewy]

It works fine if you use the "Use system mysql" box ticked.

Regards,
Alan

[sHORTYWZ]

It works fine if you use the "Use system mysql" box ticked.

Regards,
Alan

Not with the latest version of easyapache - did you real the whole thread?

More information available here:
http://forums.cpanel.net/showthread.php?t=38290

[rwoliver2]

I've opened up a ticket on this issue, ticket # 104425

Hopefully we'll get a fix to buildapache soon. Very soon I hope

Rob