<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.17023" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> I try to authenticate freeradius
2.1.8 using mysql5.0.26. </FONT></DIV>
<DIV><FONT face=Arial size=2><U>Information of my system</U>:</FONT></DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>1. OS is SuSE Linux SLES10 SP2.</FONT></DIV>
<DIV><FONT face=Arial size=2>2. I have installed following RPM for FreeRadius
2.1.8:</FONT></DIV>
<DIV><FONT face=Arial size=2> #rpm -qa |grep
freeradius<BR>freeradius-server-utils-2.1.8-1.1<BR>freeradius-client-libs-1.1.6-4.1<BR>freeradius-server-2.1.8-1.1<BR>freeradius-client-devel-1.1.6-4.1<BR>freeradius-server-devel-2.1.8-1.1<BR>freeradius-client-1.1.6-4.1<BR>freeradius-server-debuginfo-2.1.8-1.1<BR>freeradius-server-libs-2.1.8-1.1<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>3. installed following MySQL RPM:</FONT></DIV>
<DIV><FONT face=Arial size=2> # rpm -qa |grep
mysql<BR>apache2-mod_auth_mysql-3.0.0-14.2<BR>mysql-5.0.26-12.18<BR>mysql-shared-5.0.26-12.18<BR>perl-DBD-mysql-3.0002-15.2<BR>php5-mysql-5.2.5-9.5<BR>mysql-client-5.0.26-12.18<BR></FONT></DIV>
<DIV><FONT face=Arial size=2> </FONT></FONT><FONT face=Arial
size=2></FONT></DIV></DIV>
<DIV><FONT face=Arial size=2>I have successfully installed the RPM for
freeradius and test for authentication using file "users"
is successful.</FONT></DIV>
<DIV><FONT face=Arial size=2><FONT color=#ff0000>When I tried to authenticate
via MySQL, it failed. There is no connection record to MySQL in log
file of MySQL</FONT>.</FONT></DIV>
<DIV><FONT face=Arial size=2><FONT color=#ff0000>Searching the WWW, I found out
there is a RPM named freeradius-mysql* for Red Hat FC. There is no such RPM for
SuSE in download website of freeradius.org.</FONT>
<DIV><FONT face=Arial size=2><FONT color=#ff0000> Is corresponding RPM
required for SLES10SP2? Where to download</FONT>? <FONT color=#ff0000>Or,
such functionality is already included in one of my installed
RPM?</FONT></FONT></DIV>
<DIV><FONT color=#ff0000><FONT face=Arial
size=2> </DIV></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2><U>Terminal 1 message</U>:</FONT></DIV>
<DIV><FONT face=Arial size=2># radtest user1 test1 localhost 1812
RAD7429secret<BR>Sending Access-Request of id 250 to 127.0.0.1 port
1812<BR> User-Name =
"user1"<BR> User-Password =
"test1"<BR> NAS-IP-Address =
158.182.158.61<BR> NAS-Port =
1812<BR>rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=250,
length=20<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><U>Terminal 2 message</U>:</DIV></FONT>
<DIV><FONT face=Arial size=2>Listening on authentication address * port
1812<BR>Listening on accounting address * port 1813<BR>Listening on command file
/var/run/radiusd/radiusd.sock<BR>Listening on proxy address * port 1814<BR>Ready
to process requests.<BR>rad_recv: Access-Request packet from host 127.0.0.1 port
32768, id=250, length<BR>=57<BR>
User-Name = "user1"<BR> User-Password
= "test1"<BR> NAS-IP-Address =
158.182.158.61<BR> NAS-Port =
1812<BR>+- entering group authorize {...}<BR>++[preprocess] returns
ok<BR>[auth_log] expand:
/var/log/radius/radacct/%{Client-IP-Address}/auth-deta<BR>il-%Y%m%d ->
/var/log/radius/radacct/127.0.0.1/auth-detail-20100428<BR>[auth_log]
/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d exp<BR>ands to
/var/log/radius/radacct/127.0.0.1/auth-detail-20100428<BR>[auth_log]
expand: %t -> Wed Apr 28 20:38:07 2010<BR>++[auth_log] returns ok<BR>++[chap]
returns noop<BR>++[mschap] returns noop<BR>[suffix] No <A
href="mailto:'@'">'@'</A> in User-Name = "user1", looking up realm
NULL<BR>[suffix] No such realm "NULL"<BR>++[suffix] returns noop<BR>[eap] No
EAP-Message, not doing EAP<BR>++[eap] returns noop<BR>++[unix] returns
notfound<BR>[sql] expand: %{User-Name} -> user1<BR><FONT
color=#0000ff>[sql] sql_set_user escaped user --> 'user1'<BR>rlm_sql (sql):
Ignoring unconnected handle 4..<BR>rlm_sql (sql): Ignoring unconnected handle
3..<BR>rlm_sql (sql): Ignoring unconnected handle 2..<BR>rlm_sql (sql): Ignoring
unconnected handle 1..<BR>rlm_sql (sql): Ignoring unconnected handle
0..<BR>rlm_sql (sql): There are no DB handles to use! skipped 5, tried to
connect 0<BR>++[sql] returns fail<BR></FONT>Using Post-Auth-Type Reject<BR>+-
entering group REJECT
{...}<BR>[attr_filter.access_reject] expand:
%{User-Name} -> user1<BR> attr_filter: Matched entry DEFAULT at line
11<BR>++[attr_filter.access_reject] returns updated<BR>Delaying reject of
request 0 for 1 seconds<BR>Going to the next request<BR>Waking up in 0.9
seconds.<BR>Sending delayed reject for request 0<BR>Sending Access-Reject of id
250 to 127.0.0.1 port 32768<BR>Waking up in 4.9 seconds.<BR>Cleaning up request
0 ID 250 with timestamp +10<BR>Ready to process requests.<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2><BR>---------------<BR>Cheers,<BR>Joe</FONT></DIV><BR>
<BR>
__________ Information from ESET Smart Security, version of virus signature database 5066 (20100427) __________<BR>
<BR>
The message was checked by ESET Smart Security.<BR>
<BR>
<A HREF="http://www.eset.com">http://www.eset.com</A><BR>
</BODY></HTML>