summaryrefslogtreecommitdiff
path: root/kpov_judge/tasks/radius_mysql_pam/howtos/en/index.html
blob: ac53a1fc3487a216970312d41a73dbb66208d248 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
<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>