Your problem is another product (perhaps PHP) is also linked with the older libraries.
Only one version of the MySQL libraries can be loaded under Apache, and all products which use MySQL use that same library. This means you must ensure all products which use MySQL are compiled and linked with the same version of MySQL.
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi All:
I'm using MySQL 4.1.14 with Apache 2.0.52 and mod_auth_mysql 3.0 and I'm getting the following message in error_log when trying to authenticate users:
MySQL ERROR: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
I believe that the "client" here means mod_auth_mysql right ? Is anybody having this problem ?
Thank you ?
-- EF
efujii@miis.edu
Now, I found a previous post addressing this problem.
Indeed, I was using the old mysql libraries when compiling mod_auth_mysql.
However, after compiling with the new libraries, Apache refuses to load the module because of "symbol mysql_close: referenced symbol not found"
Anyway, I used the "SET PASSWORD" workaround and now it works.
Thank you,
-- EF
efujii@miis.edu
Eduardo,
Glad you got it partly working.
Your problem is another product (perhaps PHP) is also linked with the older libraries.
Only one version of the MySQL libraries can be loaded under Apache, and all products which use MySQL use that same library. This means you must ensure all products which use MySQL are compiled and linked with the same version of MySQL.
Jerry