freeradius and MySQL 4.1.12-1

[Reza Toghraee]

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 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





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 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
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 at sita.be

- 
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html