<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=ks_c_5601-1987">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Fedora cor 5</FONT></DIV>
<DIV><FONT size=2>freeradius-1.1.7.tar.gz ==> rpmbuild -bb
Redhat\freeradius.spec<BR>radiusd.conf ==> option sql enable</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>options.pptpd <BR>plugin radius.so<BR>radius-config-file
/usr/local/etc/radiusclient/radiusclient.conf<BR>plugin radattr.so</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>mysql <BR>use raidius;</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>mysql> select * from
usergroup;<BR>+----------+-----------+----------+<BR>| UserName | GroupName |
priority |<BR>+----------+-----------+----------+<BR>| testuser |
pptpd | 1
|<BR>+----------+-----------+----------+<BR>1 row in set (0.00 sec)</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>mysql> select * from
radcheck;<BR>+----+----------+---------------+----+------------------------------------+<BR>|
id | UserName | Attribute | op |
Value
|<BR>+----+----------+---------------+----+------------------------------------+<BR>|
2 | testuser | User-Password | := | $1$GhlXfa4L$4MU8.SGVhavIVwTtWOWRV1
|<BR>+----+----------+---------------+----+------------------------------------+<BR>1
row in set (0.00 sec)</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>radiusd -xx </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>.............<BR>Thread spawned new child 1. Total threads in
pool: 1<BR>Thread spawned new child 2. Total threads in pool: 2<BR>Thread
spawned new child 3. Total threads in pool: 3<BR>Thread spawned new child 4.
Total threads in pool: 4<BR>Thread spawned new child 5. Total threads in pool:
5<BR>Thread pool initialized<BR>Listening on authentication *:1812<BR>Listening
on accounting *:1813<BR>Ready to process requests.<BR>Thread 1 waiting to be
assigned a request<BR>Thread 2 waiting to be assigned a request<BR>Thread 3
waiting to be assigned a request<BR>Thread 4 waiting to be assigned a
request<BR>Thread 5 waiting to be assigned a request<BR>rad_recv: Access-Request
packet from host 127.0.0.1:32772, id=237, length=69<BR>Thread 1 got
semaphore<BR>--- Walking the entire request list ---<BR>Waking up in 31
seconds...<BR>Threads: total/active/spare threads = 5/0/5<BR>Thread 1 handling
request 0, (1 handled so far)<BR>
Service-Type = Framed-User<BR>
Framed-Protocol = PPP<BR> User-Name =
"testuser"<BR> Calling-Station-Id =
"123.xx.xx.xx"<BR> NAS-IP-Address =
127.0.0.1<BR> NAS-Port = 0<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 <A href="mailto:'@'">'@'</A>
in User-Name = "testuser", 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
153<BR> users: Matched entry DEFAULT at line
172<BR> users: Matched entry DEFAULT at line 184<BR>
modcall[authorize]: module "files" returns ok for request
0<BR>radius_xlat: 'testuser'<BR>rlm_sql (sql): sql_set_user escaped user
--> 'testuser'<BR>radius_xlat: 'SELECT id, UserName, Attribute, Value,
op FROM
radcheck
<BR>WHERE Username =
'testuser' ORDER BY
id'<BR>rlm_sql (sql): Reserving sql socket id: 4<BR>radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,r
<BR>adgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Userna
<BR>me = 'testuser' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY
radgroupcheck
<BR>.id'<BR>radius_xlat: 'SELECT id, UserName, Attribute, Value,
op FROM
radreply
<BR>WHERE Username =
'testuser' ORDER BY
id'<BR>radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,r
<BR>adgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Userna
<BR>me = 'testuser' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY
radgroupreply
<BR>.id'<BR>rlm_sql (sql): Released sql socket id: 4<BR>
modcall[authorize]: module "sql" returns ok for request 0<BR>rlm_pap: Found
existing Auth-Type, not changing it.<BR> modcall[authorize]: module "pap"
returns noop 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>rlm_unix:
Attribute "User-Password" is required for authentication.<BR>
modcall[authenticate]: module "unix" returns invalid for request 0<BR>modcall:
leaving group authenticate (returns invalid) for request 0<BR>auth: Failed to
validate the user.<BR>Delaying request 0 for 1 seconds<BR>Finished request
0<BR>Going to the next request<BR>Thread 1 waiting to be assigned a
request</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </DIV></BODY></HTML>