Radius mysql:

Quick how to:


Setup the OpenRadius server and add users. Use MySql as the database.

Instructions:
  1. Create two virtual machines - SimpleArbiter (use the simpleArbiterDhcp.vdi disk) and RadiusServer. Discs for virtual machines are located on polz.si/media/uploads/kpov/virtualke.
  2. Create another two virtual machines using the disks VPNCLient.vdi and SimpleArbiterVPN.vdi.
  3. Setup both VMs so that they use two network adapters - NAT and Internal network.
  4. Login with the username student and password student on both VMs.

Part one: Setup OpenRadius.

  1. Install OpenRadius on the RadiusServer VM (configuration files are: /etc/openradius/configuration and /etc/openradius/behaviour)
  2. Add a user and assign him a shared secret. This should be configured in the /etc/openradius/configuration file. (More info: http://sites.e-advies.nl/openradius/doc-using-openradius.html )
  3. Create a connection from SimpleArbiter to RadiusServer using the secret you configured.

Part two: Install and setup a MySQL database on RadiusServer
  1. OpenRadius can use the module RadSQL to store users in database.
  2. Setup a MySQL server: sudo apt-get install mysql-server.
  3. Connect to the MySQL server: mysql -u root -p.
  4. Create a database: CREATE DATABASE . Create a table users with columns username and password.