There is definitely a password problem. But it may be due to *where* your logging in from, rather than the password. Are FR and MySQL on the same box? Have you double checked with the mysql client that you can login to the database (on the machine where mysql is installed). From a command prompt just type "mysql -p", enter the password. If there is no error, something else more serious is amiss or you do not have radius@zzzzz configured in the DB where zzzzzz is the host where mysql is installed. Laker --- "Atkins, Dwane P" <ATKINSD@uthscsa.edu> wrote:

Why is it that when I run a radiusd -X, I always come back with errors on saying that it cannot connect to the mysql server:

rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked

rlm_sql (sql): Attempting to connect to radius@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 radius@localhost:radius

rlm_sql_mysql: Mysql error 'Access denied for user 'radius'@'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.

I have put this in my sql.conf like so:

# Connect info

server = "localhost"

login = "radius"

password = "xxxxxxxxx"

# Database table configuration

radius_db = "radius" <mailto:atkinsd@uthscsa.edu>

What am I doing wrong? I have followed a number of whitepapers to install this and most of them say the same thing.

I downloaded freeradius and mysql-server using the 'yum install' option. Now, when I do a ./configure on freeradius, do I need to do it with a -with-mysql option?

Should I try this on something other than FC4? I am opened to options.

Thanks

Dwane

...

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

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

On Mon, 2006-20-03 at 16:56 -0600, Atkins, Dwane P wrote:

Why is it that when I run a radiusd –X, I always come back with errors on saying that it cannot connect to the mysql server:

...snip...

rlm_sql_mysql: Couldn't connect socket to MySQL server radius@localhost:radius

rlm_sql_mysql: Mysql error 'Access denied for user 'radius'@'localhost' (using password: YES)'

...snip...

I have put this in my sql.conf like so:

# Connect info

server = "localhost"

login = "radius"

password = "xxxxxxxxx"

# Database table configuration

radius_db = "radius"

What am I doing wrong? I have followed a number of whitepapers to install this and most of them say the same thing.

I downloaded freeradius and mysql-server using the ‘yum install’ option. Now, when I do a ./configure on freeradius, do I need to do it with a –with—mysql option?

Should I try this on something other than FC4? I am opened to options.

First of all for stability, I would suggest FreeBSD. The Fedora Core Releases are, cutting edge with a short life span. First thing you should try is using the mysql command line to access the database with the credentials you put in the configuration file. bash> mysql -h localhost -u radius -p xxxxxxxxx If it lets you in try to connect to the db : mysql> \r radius If you can not get connected this way the problem is in your MySQL configuration.