I am not authenticating via tha the radius. I don't see anything in the
log file that indicates where it is failing.
I have posted the radius -x output, and the DB queries as queried by the
radius server. This is a freeradius with MySql, and
portslave-2002.10.21
Dose this look like a radius problem or is it trying to pass something
back to PS that PS dosen't like?
rad_recv: Access-Request packet from host 208.32.6.2:4110, id=234,
length=93
User-Name = "theusername"
NAS-Port-Type = Async
Acct-Session-Id = "10443402592669"
Framed-Protocol = 16777216
Service-Type = 33554432
User-Password = "thepassword"
NAS-IP-Address = 208.32.6.2
NAS-Port = 22
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
rlm_chap: Could not find proper Chap-Password attribute in request
modcall[authorize]: module "chap" returns noop
modcall[authorize]: module "mschap" returns notfound
rlm_realm: No '@' in User-Name = "theusername", looking up realm NULL
rlm_realm: No such realm NULL
modcall[authorize]: module "suffix" returns noop
radius_xlat: 'theusername'
rlm_sql (sql): sql_set_user escaped user --> 'theusername'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck
WHERE Username = 'theusername' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 2
radius_xlat: 'SELECT radgroupcheck.id,
radgroupcheck.GroupName,
radgroupcheck.Attribute,
radgroupcheck.Value,
radgroupcheck.op
FROM radgroupcheck,usergroup
WHERE usergroup.Username = 'theusername'
AND usergroup.GroupName = radgroupcheck.GroupName
ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT id,
UserName,
Attribute,
Value,
op
FROM radreply
WHERE Username = 'theusername'
ORDER BY id'
radius_xlat: 'SELECT radgroupreply.id,
radgroupreply.GroupName,
radgroupreply.Attribute,
radgroupreply.Value,
radgroupreply.op
FROM radgroupreply,
usergroup
WHERE usergroup.Username = 'theusername'
AND usergroup.GroupName = radgroupreply.GroupName
ORDER BY radgroupreply.id'
rlm_sql (sql): Released sql socket id: 2
modcall[authorize]: module "sql" returns ok
users: Matched DEFAULT at 152
modcall[authorize]: module "files" returns ok
modcall: group authorize returns ok
rad_check_password: Found Auth-Type System
auth: type "System"
modcall: entering group authenticate
modcall[authenticate]: module "unix" returns notfound
modcall: group authenticate returns notfound
auth: Failed to validate the user.
mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = 'theusername' ORDER BY id;
+----+--------------+-----------+-------------+----+
| id | UserName | Attribute | Value | op |
+----+--------------+-----------+-------------+----+
| 10 | theusername | Password | thepassword | == |
+----+--------------+-----------+-------------+----+
1 row in set (0.00 sec)
mysql> SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'theusername'
AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY
radgroupcheck.id;
+----+-------------+---------------+-------+----+
| id | GroupName | Attribute | Value | op |
+----+-------------+---------------+-------+----+
| 1 | PPP-DYNAMIC | NAS-Port-Type | Async | == |
+----+-------------+---------------+-------+----+
1 row in set (0.00 sec)
mysql> SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = 'theusername'
AND usergroup.GroupName = radgroupreply.GroupName ORDER BY
radgroupreply.id;
+----+-------------+--------------------+---------------------+----+
| id | GroupName | Attribute | Value | op |
+----+-------------+--------------------+---------------------+----+
| 5 | PPP-DYNAMIC | Framed-Compression | Van-Jacobson-TCP-IP | == |
| 6 | PPP-DYNAMIC | Framed-Protocol | PPP | == |
| 7 | PPP-DYNAMIC | Service-Type | Framed-User | == |
| 8 | PPP-DYNAMIC | Framed-MTU | 1500 | == |
+----+-------------+--------------------+---------------------+----+
4 rows in set (0.00 sec)
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
