<br><font size=2 face="sans-serif">ian, just review your radiusd.conf (authenticate
and authorize sections) because you sql IS going ok.....</font>
<br>
<br><tt><font size=2> modcall[authorize]: module "sql" returns
ok for request 0</font></tt>
<br>
<br><font size=2 face="sans-serif">but your "unix" IS not</font>
<br>
<br><tt><font size=2>modcall[authenticate]: module "unix" returns
notfound for request 0</font></tt>
<br>
<br><font size=2 face="sans-serif">just leave "sql" in your auth
section if you plan to do it tha way</font>
<br><font size=2 face="sans-serif"><br>
Hernan Antolini<br>
<br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>Ian Truelsen <ian.truelsen@gmail.com></b>
</font>
<br><font size=1 face="sans-serif">Sent by: freeradius-users-bounces+antolini=ar.ibm.com@lists.freeradius.org</font>
<p><font size=1 face="sans-serif">01/01/07 07:32 PM</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
FreeRadius users mailing list <freeradius-users@lists.freeradius.org></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">Freeradius Mailing List <freeradius-users@lists.freeradius.org></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">MySQL authentication problem</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><tt><font size=2>radiusd: FreeRADIUS Version 1.1.3, for host i686-pc-linux-gnu,
built on<br>
Dec 26 2006 at 01:46:55<br>
mysql Ver 14.12 Distrib 5.0.30, for pc-linux-gnu (i686) using readline<br>
5.2<br>
<br>
I thought that I had everything configured properly for MySQL<br>
authentication, but when I try to do a test with radtest, the test user<br>
is not authenticated and there is no log of activity to the MySQL<br>
database. Anyway, here is the output of radiusd -X and, at the end, the<br>
population of my database:<br>
<br>
rad_recv: Access-Request packet from host 192.168.182.1:2053, id=7,<br>
length=55<br>
User-Name = "ian"<br>
User-Password = "test"<br>
NAS-IP-Address = 255.255.255.255<br>
NAS-Port = 1812<br>
Processing the authorize section of radiusd.conf<br>
modcall: entering group authorize for request 0<br>
modcall[authorize]: module "preprocess" returns ok for
request 0<br>
modcall[authorize]: module "chap" returns noop for request
0<br>
modcall[authorize]: module "mschap" returns noop for request
0<br>
rlm_realm: No '@' in User-Name = "ian", looking
up realm NULL<br>
rlm_realm: No such realm "NULL"<br>
modcall[authorize]: module "suffix" returns noop for request
0<br>
rlm_eap: No EAP-Message, not doing EAP<br>
modcall[authorize]: module "eap" returns noop for request
0<br>
users: Matched entry DEFAULT at line 152<br>
modcall[authorize]: module "files" returns ok for request
0<br>
radius_xlat: 'ian'<br>
rlm_sql (sql): sql_set_user escaped user --> 'ian'<br>
radius_xlat: 'SELECT id, UserName, Attribute, Value, op
FROM<br>
radcheck WHERE Username = 'ian'
ORDER BY id'<br>
rlm_sql (sql): Reserving sql socket id: 4<br>
radius_xlat: 'SELECT<br>
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'ian' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'<br>
radius_xlat: 'SELECT id, UserName, Attribute, Value, op
FROM<br>
radreply WHERE Username = 'ian'
ORDER BY id'<br>
radius_xlat: 'SELECT<br>
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = 'ian' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'<br>
rlm_sql (sql): Released sql socket id: 4<br>
modcall[authorize]: module "sql" returns ok for request
0<br>
modcall: leaving group authorize (returns ok) for request 0<br>
rad_check_password: Found Auth-Type System<br>
auth: type "System"<br>
Processing the authenticate section of radiusd.conf<br>
modcall: entering group authenticate for request 0<br>
modcall[authenticate]: module "unix" returns notfound
for request 0<br>
modcall: leaving group authenticate (returns notfound) for request 0<br>
auth: Failed to validate the user.<br>
Login incorrect: [ian/test] (from client brentwood port 1812)<br>
Delaying request 0 for 1 seconds<br>
Finished request 0<br>
<br>
<br>
mysql> select * from radcheck<br>
-> ;<br>
+----+----------+-----------+----+-------+<br>
| id | UserName | Attribute | op | Value |<br>
+----+----------+-----------+----+-------+<br>
| 1 | Password | == | te |
| <br>
| 2 | ian | Password | == | test |
<br>
+----+----------+-----------+----+-------+<br>
2 rows in set (0.01 sec)<br>
<br>
Any thoughts on why this is not working would be greatly appreciated.<br>
<br>
-- <br>
Ian Truelsen<br>
s/v Sting<br>
Email: ian.truelsen@gmail.com<br>
AIM: ihtruelsen<br>
MSN: ihtruelsen@hotmail.com<br>
Google Talk: ian.truelsen@gmail.com<br>
<br>
- <br>
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<br>
</font></tt>
<br>