Radius mysql:

Tasks quick how to:


Set OpenRadius server and add users. Use MySql for database.

Instructions:

  1. Create two virtual machines - SimpleArbiter (use disc simpleArbiterDhcp) and RadiusServer. Discs for virtual machines are located on polz.si/media/uploads/kpov/virtualke.
  2. Use disks VPNCLient.vdi and SimpleArbiterVPN.vdi to create VMs.
  3. On both VMs set two network adapters - NAT and Internal.
  4. Login with username student and password student on both VMs.

First: Set OpenRadius.

  1. Install OpenRadius on virtual machine RadiusServer (configuration: /etc/openradius/configuration and /etc/openradius/behaviour)
  2. Add user and assign him shared secret. Shared secret should be written in /etc/openradius/configuration file. (More info: http://sites.e-advies.nl/openradius/doc-using-openradius.html )
  3. Use shared secret to connect form SimpleArbiter to RadiusServer.

Second: Install and set MySQL database on RadiusServer

  1. Use OpenRadius modul RadSQL to store users in database.
  2. Set MySQL server: sudo apt-get install mysql-server.
  3. Connect to MySQL server: mysql -u root -p.
  4. Create database: CREATE DATABASE . Create table users with columns username and password.