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.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: [email protected]
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.

 

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

 

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

 

Thanks for the help.

 

Dwane

 

 

 

 

 

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to