RE: freeradius newbie

10 Mar 2006

      Forgot one more thing:

You have to create the MySQL tables with the db_mysql.sql file e.g. FC4:
/usr/share/doc/freeradius-1.0.4/db_mysql.sql
Or download the source code, install it
(./freeradius-1.1.0/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql).
Use phpMyAdmin and this file to populate the tables.

  _____  

From: Gunther
Sent: Friday, March 10, 2006 1:25 AM
To: 'FreeRadius users mailing list'
Subject: RE: freeradius newbie

With FC4 you can either use the existing RPM (yum install ....) or the new
1.1.0 FreeRadius source code and compile it.
It actually compiles without any problems on FC4. The installation path
(make install) is a bit different from the RPM (/etc/raddb) 
path as the binaries/libraries (I guess) are installed in different
directories (/usr/local/etc/raddb), but that can be switch with a
./configure option

First install MySQL, FreeRadius, phpMyAdmin ...

You then edit the corresponding radiusd.conf file and modify it for sql
support.
The following examples might not be complete, but they are direct cut and
pastes from my files and it works fine.

radiusd.conf:
$INCLUDE  ${confdir}/sql.conf
authorize {
...
        #  Look in an SQL database.  The schema of the database
        #  is meant to mirror the "users" file.
        #
        #  See "Authorization Queries" in sql.conf
        sql
}

accounting {
...
        #  Log traffic to an SQL database.
        #
        #  See "Accounting queries" in sql.conf
        sql
}
session {
#       radutmp
        #
        #  See "Simultaneous Use Checking Querie" in sql.conf
        sql
}
post-auth {
        #  After authenticating the user, do another SQL qeury.
        #
        #  See "Authentication Logging Queries" in sql.conf
        sql
}

sql.conf:
        server = "localhost"
        login = "root"
        password = "rootpass"

To manage the MySQL DB you would use phpMyAdmin (www.
<http://www.phpmyadmin.net> phpmyadmin.net)

You can then start FreeRadius with 'service radiusd start'.

To get detailed debug information you can edit the /etc/init.d/radiusd file
and increase the debug level:
        daemon $RADIUSD -y -XXXX -d $CONFIGD

The -XXXX is the debug level. Debug information is written to STDout and you
can redirect it into a file
with e.g. 'service radiusd start >> radDebug.log'

Hope this helps!
Gunther

  _____  

From: Atkins, Dwane P
Sent: Friday, March 10, 2006 12:41 AM
To: freeradius-users@lists.freeradius.org
Subject: freeradius newbie

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.

1.	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. 

2.	Is there a GUI front-end that will allow us to https into the
FreeRadius Server and make changes to the mysql database? 

3.	Where would I find the debug documents that I read about when I
execute the radtest executable? 

Thanks for the help.

Dwane

 <mailto:atkinsd@uthscsa.edu>