Alright,
I have spent the better part of a day going through the list archives and I
believe that I have configured FreeRadius correctly for using MySQL for
authentication and accounting, however, I still get the following when trying
to authenticate a user:
rlm_sql: Pairs do not match [test1]
rlm_sql: Released sql socket id: 3
modcall[authorize]: module "sql" returns notfound
modcall: group authorize returns ok
auth: No authenticate method (Auth-Type) configuration found for the request:
Rejecting the user
auth: Failed to validate the user.
I have the following configured in radiusd.conf:
pap {
encryption_scheme = clear
}
authorize {
preprocess
suffix
sql
}
authenticate {
authtype PAP {
pap
}
}
preacct {
preprocess
suffix
}
accounting {
detail
sql
radutmp
}
session {
sql
}
I have the following configured in MySQL table 'radcheck':
+----+----------+---------------+-------+------+
| id | UserName | Attribute | Value | op |
+----+----------+---------------+-------+------+
| 1 | test1 | User-Password | test1 | == |
+----+----------+---------------+-------+------+
I have the following configured in MySQL table 'radgroupcheck':
+----+-----------+------------------+-------+------+
| id | GroupName | Attribute | Value | op |
+----+-----------+------------------+-------+------+
| 1 | DialUp | Simultaneous-Use | 1 | = |
| 3 | DialUp | Auth-Type | PAP | := |
+----+-----------+------------------+-------+------+
I have the following configured in MySQL table 'radgroupreply':
+----+-----------+--------------------+---------------------+------+------+
| id | GroupName | Attribute | Value | op | prio |
+----+-----------+--------------------+---------------------+------+------+
| 1 | DialUp | Service-Type | Framed-User | == | 0 |
| 2 | DialUp | Framed-Protocol | PPP | == | 0 |
| 3 | DialUp | Framed-IP-Address | 255.255.255.254 | = | 0 |
| 4 | DialUp | Framed-IP-Netmask | 255.255.255.255 | = | 0 |
| 5 | DialUp | Framed-Routing | None | = | 0 |
| 6 | DialUp | Framed-Compression | Van-Jacobson-TCP-IP | = | 0 |
| 7 | DialUp | Framed-MTU | 1500 | = | 0 |
| 10 | DialUp | Fall-Through | Yes | = | 0 |
+----+-----------+--------------------+---------------------+------+------+
Lastly, I have the following configured in MySQL table 'usergroup':
+----+----------+-----------+
| id | UserName | GroupName |
+----+----------+-----------+
| 1 | test1 | DialUp |
+----+----------+-----------+
From reading through the list archives from late July early August through
current, I believe my configuration are correct, with the exception of the
prio column, which I did find one post with MySQL that had a question
regarding prio, but it did not explain what that is for.
Please, any help that anybody can offer would be greatly appreciated.
Thank You.
--Josh Snyder
NetNITCO Systems Administration
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
