<html> <head> <meta http-equiv=Content-Type content="text/html; charset=utf-8"> </head> <body><font face="Georgia, Times New Roman, Times, serif"> <strong><h1>Radius mysql:</h1></strong> <p><strong><h2>Tasks quick how to:</h2></strong><br> Set OpenRadius server and add users. Use MySql for database.</p> <strong><h2>Instructions:</h2></strong> <ol> <li>Create two virtual machines - SimpleArbiter (use disc simpleArbiterDhcp) and RadiusServer. Discs for virtual machines are located on polz.si/media/uploads/kpov/virtualke.</li> <li>Use disks VPNCLient.vdi and SimpleArbiterVPN.vdi to create VMs.</li> <li>On both VMs set two network adapters - NAT and Internal.</li> <li>Login with username <strong>student</strong> and password <strong>student</strong> on both VMs.</li> </ol> <h3><u><strong><em>First: Set OpenRadius.</em></strong></u></h3> <ol> <li>Install OpenRadius on virtual machine RadiusServer (configuration: /etc/openradius/configuration and /etc/openradius/behaviour)</li> <li>Add user and assign him shared secret. Shared secret should be written in /etc/openradius/configuration file. (More info: <a href = "http://sites.e-advies.nl/openradius/doc-using-openradius.html"> http://sites.e-advies.nl/openradius/doc-using-openradius.html </a>)</li> <li>Use shared secret to connect form SimpleArbiter to RadiusServer.</strong></li> </ol> <u><strong><em><h3>Second: Install and set MySQL database on RadiusServer</h3></em></strong></u> <ol> <li>Use OpenRadius modul RadSQL to store users in database.</li> <li>Set MySQL server: sudo apt-get install mysql-server.</li> <li>Connect to MySQL server: mysql -u root -p.</li> <li>Create database: CREATE DATABASE <database-name>. Create table users with columns username and password.</li> </ol> </body> </html>