On Fri, 16 Aug 2002 12:57:33 +0200
Konrad Mauz wrote:
> It would by very nice, if someone, who has a pure
> sql setup up and running could post a sample configuration,
> or a link.
>
> Regards,
> Konrad
$ ls -l /etc/raddb/*sql*
-rw-r--r-- 1 root root 8415 Jun 7 01:06 mssql.conf
-rw-r--r-- 1 root root 9740 Jun 7 01:06 postgresql.conf
-rw-r--r-- 1 root root 9740 Jul 23 00:57 sql.conf
mssql.conf and postgresql.conf are provided with freeradius
You need to make sure, if
$INCLUDE ${confdir}/sql.conf
is in /etc/raddb/radiusd.conf
authorize section of radiusd.conf goes here:
authorize {
preprocess
suffix
sql
files
}
files isn't really needed, but I couldn't find any way to provide
default parameters from SQL.
Here goes our accounting section:
accounting {
detail
unix
radutmp
# sql
# sradutmp
}
If you want to use SQL accounting with PostgreSQL, you will need to
edit your sql.conf. But we have found, that PostgreSQL accounting writes
wrong Nas-Port-IDs into our database, so we use detail accounting.
--
I have had compiled FreeRadius in such way:
$ ./configure --prefix=/usr \
--with-logdir=/var/log/radius \
--with-raddbdir=/etc/raddb \
--sysconfdir=/etc \
--with-rlm-sql-postgresql-include=/usr/include/pgsql
Then,
$ make
# make install
as postmaster (user postgres in RH-like distros)
$ createuser radius
$ createdb -U radius radius radius_database
$ psql radius radius \
</usr/local/src/freeradius/src/modules/rlm_sql/drivers/rlm_sql/postgresql/db_postgresql.sql
And then add users to your radius database.
Table radcheck contains passwords for these users;
And we use radreply table to provide fixed-ip to some users.
--
Balkin Ruslan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
