Setting up the RADIUS database

First, you should create a new empty 'radius' database in SQL and a database user with permissions to that database. You could of course call the database and the user anything you like but you probably should stick with 'radius' for both to keep things simple.

Next up, you need to create the schema for your database. There is an SQL script file for each SQL type in doc/examples/ in your operating system's doc directory (or where you untar'd FreeRADIUS). On SUSE this is under /usr/share/doc/packages/freeradius/

Create MySQL Database

mysql -uroot -p
  CREATE DATABASE radius;
  GRANT ALL ON radius.* TO radius@localhost IDENTIFIED BY "radpass";
  exit

Note: use a more secure password that "radpass" in the above example

cd /usr/share/doc/packages/freeradius/doc/examples/
mysql -uroot -p radius < mysql.sql

Create PostgreSQL Database

su - postgres
createuser radius --no-superuser --no-createdb --no-createrole -P
createdb radius --owner=radius
exit

Note: choose a secure password when prompted for one by the createuser command.

cd /usr/share/doc/packages/freeradius/doc/examples/
psql -U radius radius < postgresql.sql

<< Prev - Next >>