Hello shell> mysql Client does not support authentication protocol requested by server; consider upgrading MySQL client To solve this problem, you should use one of the following approaches: Upgrade all client programs to use a 4.1.1 or newer client library. When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password. Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function: mysql> SET PASSWORD FOR -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); Alternatively, use UPDATE and FLUSH PRIVILEGES: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES; http://dev.mysql.com/doc/mysql/en/old-client.html Regards Reza -----Original Message----- From: freeradius-users-bounces@lists.freeradius.org [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of d.wintgens@sita.be Sent: Friday, July 22, 2005 2:54 PM To: freeradius-users@lists.freeradius.org Subject: freeradius and MySQL 4.1.12-1 Hi, I have a Suse 9.2 server with the 64-bits 4.1.12-1 MySQL version (I need the MySQL 4.1 database for another applications). I want to have a radius server on this server. The freeradius-1.0.0-5.5.x86_64.rpm package is installed and the radius database is created and filled correctly. The radius configuration files are OK to ask sql before files. The database server/login/password/radius_db are set in the sql.conf file. When I make a test with radtest, I can see in the radius log : Wed Jul 20 16:25:37 2005 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none? Wed Jul 20 16:25:37 2005 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Wed Jul 20 16:25:37 2005 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/radius Wed Jul 20 16:25:37 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Wed Jul 20 16:25:37 2005 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius Wed Jul 20 16:25:37 2005 : Error: rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' Wed Jul 20 16:25:37 2005 : Error: rlm_sql (sql): Failed to connect DB handle #0 Wed Jul 20 16:25:37 2005 : Info: Ready to process requests. I think that's typically the error occured if a 4.0.x client try to connect a 4.1.x database with the 4.0 protocol. My question : How update the MySQL client version of freeradius to 4.1 protocol ? Thanks in advance, Didier Wintgens E-mail : d.wintgens@sita.be - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html