Hi,

Followed the diff forum threads and have managed to link the Freeradius to look for users from a Mysql DB but am still not able to successfully authenticate users in this setup.I get the following error on receiving a user request

Received Access-Request Id 24 from 10.127.6.21:59169 to 10.127.6.244:1645 length 76

User-Name = 'test'

User-Password = 'test'

NAS-IP-Address = 10.127.6.21

Service-Type = Administrative-User

Calling-Station-Id = '10.120.92.40'

NAS-Port-Type = Virtual

(1) # Executing section authorize from file /etc/raddb/sites-enabled/default

(1) authorize {

(1) [preprocess] = ok

(1) [chap] = noop

(1) [mschap] = noop

(1) [digest] = noop

(1) suffix : No '@' in User-Name = "test", looking up realm NULL

(1) suffix : No such realm "NULL"

(1) [suffix] = noop

(1) eap : No EAP-Message, not doing EAP

(1) [eap] = noop

(1) sql : EXPAND %{User-Name}

(1) sql : --> test

(1) sql : SQL-User-Name set to 'test'

rlm_sql (sql): Reserved connection (4)

(1) sql : EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id desc

(1) sql : --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test' ORDER BY id desc

rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test' ORDER BY id desc'

rlm_sql: Failed to create the pair: Invalid vendor name in attribute name "Password"

rlm_sql (sql): Error parsing user data from database result

(1) ERROR: sql : SQL query error

But the user exists in the DB as we can see from the following output :

SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test' ORDER BY id desc;

+----+----------+-----------+-------+----+

+----+----------+-----------+-------+----+

+----+----------+-----------+-------+----+

2 rows in set (0.00 sec)

I have attached the configuration files along with this mail. Any help in this would be very much appreciated.

Senthil KSK