<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE>@font-face {
font-family: Fixedsys;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-WEIGHT: normal; COLOR: windowtext; FONT-STYLE: normal; FONT-FAMILY: "Times New Roman"; TEXT-DECORATION: none
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0in
}
UL {
MARGIN-BOTTOM: 0in
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=871463605-10032006><FONT face=Arial
color=#0000ff size=2>Forgot one more thing:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=871463605-10032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=871463605-10032006><FONT face=Arial
color=#0000ff size=2>You have to create the MySQL tables with the
</FONT></SPAN><SPAN class=871463605-10032006><FONT face=Arial color=#0000ff
size=2>db_mysql.sql file e.g. FC4:
/usr/share/doc/freeradius-1.0.4/db_mysql.sql</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=871463605-10032006><FONT face=Arial
color=#0000ff size=2>Or </FONT></SPAN><SPAN class=871463605-10032006><FONT
face=Arial color=#0000ff size=2>download the source code, install it
</FONT></SPAN><SPAN class=871463605-10032006><FONT face=Arial color=#0000ff
size=2>(./freeradius-1.1.0/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=871463605-10032006><FONT face=Arial
color=#0000ff size=2>Use phpMyAdmin and this file to populate the
tables.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Gunther<BR><B>Sent:</B> Friday, March
10, 2006 1:25 AM<BR><B>To:</B> 'FreeRadius users mailing
list'<BR><B>Subject:</B> RE: freeradius newbie<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=168060605-10032006>With FC4 you can either use the existing RPM (yum
install ....) or the new 1.1.0 FreeRadius source code and compile
it.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=168060605-10032006>It actually compiles without any problems on FC4. The
installation path (make install) is a bit different from the RPM (/etc/raddb)
</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=168060605-10032006>path as the </SPAN></FONT><FONT face=Arial
color=#0000ff size=2><SPAN class=168060605-10032006>binaries/libraries (I
guess) are installed in different directories (/usr/local/etc/raddb), but that
can be switch with a</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=168060605-10032006>./configure option</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>First install MySQL, FreeRadius, phpMyAdmin
...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>You then edit the corresponding radiusd.conf file and
modify it for sql support.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>The following examples might not be complete, but they
are direct cut and pastes from my files and it works fine.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>radiusd.conf:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>$INCLUDE ${confdir}/sql.conf<BR>authorize
{</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2> # Look
in an SQL database. The schema of the
database<BR> # is meant to
mirror the "users" file.<BR>
#<BR> # See "Authorization
Queries" in sql.conf<BR>
sql<BR>}</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>accounting {</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>...<BR> #
Log traffic to an SQL database.<BR>
#<BR> # See "Accounting
queries" in sql.conf<BR>
sql<BR>}</DIV></FONT></SPAN>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>session {</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>#
radutmp</FONT></SPAN></DIV>
<DIV><SPAN class=168060605-10032006><FONT face=Arial color=#0000ff
size=2>
#<BR> # See "Simultaneous Use
Checking Querie" in sql.conf<BR>
sql<BR>}</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>post-auth {</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2> # After
authenticating the user, do another SQL
qeury.<BR>
#<BR> # See "Authentication
Logging Queries" in sql.conf<BR>
sql<BR>}</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2> </DIV></FONT></SPAN>
<DIV dir=ltr align=left><SPAN class=168060605-10032006><FONT face=Arial
color=#0000ff size=2>sql.conf:</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff
size=2> server =
"localhost"<BR> login =
"root"<BR> password =
"rootpass"<BR></FONT></DIV><FONT face=Arial color=#0000ff size=2></FONT><FONT
face=Arial color=#0000ff size=2></FONT><FONT face=Arial color=#0000ff
size=2></FONT>
<DIV><BR><SPAN class=168060605-10032006><FONT face=Arial color=#0000ff
size=2>To manage the MySQL DB you would use phpMyAdmin (<FONT
face="Times New Roman" color=#008000><A
href="http://www.phpmyadmin.net">www.<B>phpmyadmin</B>.net</A>)</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=168060605-10032006><FONT color=#008000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><SPAN
class=168060605-10032006><FONT face=Arial color=#0000ff size=2>You can then
start FreeRadius with 'service radiusd
start'.</FONT></SPAN></SPAN></SPAN></DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><SPAN
class=168060605-10032006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></SPAN></SPAN> </DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><SPAN
class=168060605-10032006><FONT face=Arial color=#0000ff size=2>To get detailed
debug information you can edit the /etc/init.d/radiusd file and increase the
debug level:</FONT></SPAN></SPAN></SPAN></DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><SPAN
class=168060605-10032006><FONT face=Arial color=#0000ff
size=2> daemon $RADIUSD -y -XXXX -d
$CONFIGD</FONT></SPAN></SPAN></SPAN></DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><SPAN
class=168060605-10032006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></SPAN></SPAN> </DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><SPAN
class=168060605-10032006><FONT face=Arial color=#0000ff size=2>The -XXXX is
the debug level. Debug information is written to STDout and you can redirect
it into a file</FONT></SPAN></SPAN></SPAN></DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><SPAN
class=168060605-10032006><FONT face=Arial color=#0000ff size=2>with e.g.
'service radiusd start >>
radDebug.log'</FONT></SPAN></SPAN></SPAN></DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><SPAN
class=168060605-10032006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></SPAN></SPAN> </DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><FONT
face=Arial color=#0000ff size=2>Hope this helps!</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=168060605-10032006><SPAN class=168060605-10032006><FONT
face=Arial color=#0000ff size=2>Gunther</FONT></SPAN></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Atkins, Dwane P<BR><B>Sent:</B>
Friday, March 10, 2006 12:41 AM<BR><B>To:</B>
freeradius-users@lists.freeradius.org<BR><B>Subject:</B> freeradius
newbie<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">Thank you for this mailing list. I am trying
to install Freeradius on a FC4 device. I am also trying to use the
MySql database function. I am having problems getting a good
install. So, as usual, I have a few questions for you
all.</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<OL style="MARGIN-TOP: 0in" type=1>
<LI class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">Is there a good document that I can follow that
will give me step-by-step instructions to install freeradius on Fedora
4? I would even do FreeBSD if need be but I am more familiar with
the FC 4 processes.</SPAN></FONT> </LI></OL>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<OL style="MARGIN-TOP: 0in" type=1 start=2>
<LI class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">Is there a GUI front-end that will allow us to
https into the FreeRadius Server and make changes to the mysql
database?</SPAN></FONT> </LI></OL>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<OL style="MARGIN-TOP: 0in" type=1 start=3>
<LI class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">Where would I find the debug documents that I read
about when I execute the radtest executable?</SPAN></FONT> </LI></OL>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">Thanks for the help.</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">Dwane</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Fixedsys color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Fixedsys"><A
href="mailto:atkinsd@uthscsa.edu"></A></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>