freeradius and MySQL 4.1.12-1
reza at raymehr.com
Sat Jul 23 09:31:19 CEST 2005
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;
From: freeradius-users-bounces at lists.freeradius.org
[mailto:freeradius-users-bounces at lists.freeradius.org] On Behalf Of
d.wintgens at sita.be
Sent: Friday, July 22, 2005 2:54 PM
To: freeradius-users at lists.freeradius.org
Subject: freeradius and MySQL 4.1.12-1
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 at 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 at 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
Wed Jul 20 16:25:37 2005 : Error: rlm_sql (sql): Failed to connect DB
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,
E-mail : d.wintgens at sita.be
List info/subscribe/unsubscribe? See
More information about the Freeradius-Users