Alan & Alan, Here is excerpts from the clients.conf file: client 127.0.0.1 { secret = testing123 shortname = localhost nastype = other # localhost isn't usually a NAS... Users atkinsd Auth-Type := Local, User-Password == "cisco123" Reply-Message = "Hello, %u" mysql> select * from radcheck; +----+----------+-----------+----+----------+ | id | UserName | Attribute | op | Value | +----+----------+-----------+----+----------+ | 2 | atkinsd | Password | == | cisco123 | +----+----------+-----------+----+----------+ 1 row in set (0.00 sec) This is from radiusd -X rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to atkinsd@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server atkinsd@localhost:radius rlm_sql_mysql: Mysql error 'Access denied for user 'atkinsd'@'localhost' (using password: YES)' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Thanks Dwane -----Original Message----- From: Atkins, Dwane P Sent: Friday, March 17, 2006 9:22 AM To: 'freeradius-users@lists.freeradius.org' Subject: Re: Freeradius & Mysql initial install My mistake on the working. I had checked the clients.conf and it was correct. Does the login user need to have an account on the local radius server? In other words, do I need to create a user in mysql and link it to the radius database and ALSO complete a useradd statement on the Fedora box? No matter how I try it, I cannot get it to see past the shared key of the localhost. Thanks for all your help. Dwane
"Atkins, Dwane P" <ATKINSD@uthscsa.edu> wrote:
This is from radiusd -X ... rlm_sql_mysql: Mysql error 'Access denied for user 'atkinsd'@'localhost' (using password: YES)'
You do realize that this has nothing to do with shared secrets? You've mistyped the password in sql.conf. Alan DeKok.
Hi,
rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server atkinsd@localhost:radius rlm_sql_mysql: Mysql error 'Access denied for user 'atkinsd'@'localhost' (using password: YES)'
this message means that the radius service was unable to talk to the mysql database 'radius' using the credentials you supplied. so either 'atkinsd' is unable to access the mysql database from localhost, or your password for accessing the DB is wrong. either way, its a mysql issue so try accessing mysql from the command line using the mysql tool and see what happens when you try connecting to that database with the user and password you think you should be using. alan
participants (3)
-
A.L.M.Buxey@lboro.ac.uk -
Alan DeKok -
Atkins, Dwane P