<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>Quick how to:</h2></strong><br> Setup the OpenRadius server and add users. Use MySql as the database.</p> <strong><h2>Instructions:</h2></strong> <ol> <li>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.</li> <li>Create another two virtual machines using the disks VPNCLient.vdi and SimpleArbiterVPN.vdi.</li> <li>Setup both VMs so that they use two network adapters - NAT and Internal network.</li> <li>Login with the username <strong>student</strong> and password <strong>student</strong> on both VMs.</li> </ol> <h3><u><strong><em>Part one: Setup OpenRadius.</em></strong></u></h3> <ol> <li>Install OpenRadius on the RadiusServer VM (configuration files are: /etc/openradius/configuration and /etc/openradius/behaviour)</li> <li>Add a user and assign him a shared secret. This should be configured in the /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>Create a connection from SimpleArbiter to RadiusServer using the secret you configured.</strong></li> </ol> <u><strong><em><h3>Part two: Install and setup a MySQL database on RadiusServer</h3></em></strong></u> <ol> <li>OpenRadius can use the module RadSQL to store users in database.</li> <li>Setup a MySQL server: sudo apt-get install mysql-server.</li> <li>Connect to the MySQL server: mysql -u root -p.</li> <li>Create a database: CREATE DATABASE <database-name>. Create a table <strong>users</strong> with columns <strong>username</strong> and <strong>password</strong>.</li> </ol> </body> </html>