Dear Simon,
I, was following all the mailing list with the subject (Problems with MySQL
Auth-Type), but I get a problem which I can't figure it out what's the cause,
I'm sure you can help me.
To help you understend what I have configured I'm putting the most relevant
parts of my configuration files and the most importants tables:
Radius.conf
authorize {
preprocess
# counter
# attr_filter
# eap
suffix
sql
# files
# mschap
}
authenticate {
pap
# pam
# unix
# ldap
# mschap
# eap
mysql> select * from radcheck;
+----+----------+-----------+-------+------+
| id | UserName | Attribute | Value | op |
+----+----------+-----------+-------+------+
| 1 | paulin | Password | 2135 | := |
| 2 | pmerida | Password | 2135 | := |
+----+----------+-----------+-------+------+
mysql> select * from radgroupcheck;
+----+-----------+-----------------+-------------+------+
| id | GroupName | Attribute | Value | op |
+----+-----------+-----------------+-------------+------+
| 1 | dynamic | Auth-Type | PAP | := |
| 2 | dynamic | Framed-Protocol | PPP | == |
| 3 | dynamic | Service-Type | Framed-User | == |
+----+-----------+-----------------+-------------+------+
mysql> select * from radgroupreply;
+----+-----------+--------------------+---------------------+------+------+
| id | GroupName | Attribute | Value | op | prio |
+----+-----------+--------------------+---------------------+------+------+
| 1 | dynamic | Framed-Compression | Van-Jacobsen-TCP-IP | := | 0 |
| 2 | dynamic | Framed-Protocol | PPP | := | 0 |
| 3 | dynamic | Service-Type | Framed-User | := | 0 |
| 5 | dynamic | Framed-MTU | 1500 | := | 0 |
+----+-----------+--------------------+---------------------+------+------+
mysql> select * from radreply;
Empty set (0.00 sec)
While I'm running in debug mode the server reply with this problem:
rad_recv: Access-Request packet from host 166.114.22.4:2178, id=11, length=46
User-Name = "paulin"
User-Password = "x~.>!\t>s7\330\031\251\353#\321/"
rad_rmspace_pair: User-Name now 'paulin'
rad_rmspace_pair: User-Password now '2135'
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
modcall[authorize]: module "suffix" returns ok
radius_xlat: 'paulin'
sql_escape in: 'paulin'
sql_escape out: 'paulin'
sql_set_user: escaped user --> 'paulin'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
UserName = 'paulin' ORDER BY id'
rlm_sql: Reserving sql socket id: 4
SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE UserName = 'paulin'
ORDER BY id
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.UserName = 'paulin' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.UserName = 'paulin' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
UserName = 'paulin' ORDER BY id'
SELECT id,UserName,Attribute,Value,op FROM radreply WHERE UserName = 'paulin'
ORDER BY id
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.UserName = 'paulin' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.UserName = 'paulin' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql: Pairs do not match [paulin]
rlm_sql: Released sql socket id: 4
modcall[authorize]: module "sql" returns notfound
modcall: group authorize returns ok
auth: No Auth-Type configuration for the request, rejecting the user
auth: Failed to validate the user.
Delaying request 0 for 1 seconds
Finished request 0
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
