From 8081a5520a441b43a8a7a73f3a90c7aacfaa8e10 Mon Sep 17 00:00:00 2001 From: Timotej Lazar Date: Sun, 24 Feb 2019 21:05:27 +0100 Subject: Move everything one level up --- tasks/radius_mysql_pam/howtos/en/index.html | 34 ++++++++++++++++++++++++ tasks/radius_mysql_pam/howtos/si/index.html | 40 +++++++++++++++++++++++++++++ 2 files changed, 74 insertions(+) create mode 100644 tasks/radius_mysql_pam/howtos/en/index.html create mode 100644 tasks/radius_mysql_pam/howtos/si/index.html (limited to 'tasks/radius_mysql_pam/howtos') diff --git a/tasks/radius_mysql_pam/howtos/en/index.html b/tasks/radius_mysql_pam/howtos/en/index.html new file mode 100644 index 0000000..ac53a1f --- /dev/null +++ b/tasks/radius_mysql_pam/howtos/en/index.html @@ -0,0 +1,34 @@ + + + + + + + +

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. +
  2. Create another two virtual machines using the disks VPNCLient.vdi and SimpleArbiterVPN.vdi.
    3. +
  3. Setup both VMs so that they use two network adapters - NAT and Internal network.
    4. +
  4. Login with the username student and password student on both VMs.
    5. +
+ +

Part one: Setup OpenRadius.

+
    +
  1. Install OpenRadius on the RadiusServer VM (configuration files are: /etc/openradius/configuration and /etc/openradius/behaviour)
    2. +
  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. +
  3. Create a connection from SimpleArbiter to RadiusServer using the secret you configured.
    4. +
+

Part two: Install and setup a MySQL database on RadiusServer

 +
    +
  1. OpenRadius can use the module RadSQL to store users in database.
    2. +
  2. Setup a MySQL server: sudo apt-get install mysql-server.
    3. +
  3. Connect to the MySQL server: mysql -u root -p.
    4. +
  4. Create a database: CREATE DATABASE . Create a table users with columns username and password.
    5. +
+ + + diff --git a/tasks/radius_mysql_pam/howtos/si/index.html b/tasks/radius_mysql_pam/howtos/si/index.html new file mode 100644 index 0000000..612cce9 --- /dev/null +++ b/tasks/radius_mysql_pam/howtos/si/index.html @@ -0,0 +1,40 @@ + + + + + + + +

Radius mysql:

 +

Naloga na hitro:


+ Postaviti je treba RADIUS strežnik in podatkovno bazo.
+ Za RADIUS strežnik uporabite FreeRADIUS, za podatkovno bazo pa MySQL. +

+

Navodila:


+ 1. Ustvarite dva navidezna računalnika z imenom SimpleArbiter in RadiusServer.
+ Za SimpleArbiter uporabite simpleArbiterDhcp, za RadiusServer pa lahko uporabite poljubno virtualko.
+ ( virtualke dobiš na polz.si/media/uploads/kpov/virtualke)
+ 2. Z VirtualBoxom (ali ostalim programom za virtualne računalnike) ustvarite dva virtualna računalnika in jim kot disk za shranjevanje podajte simpleArbiterDhcp.vdi ter base-student-console-2014.vdi.
+ 3. Na obeh nastavite dva omrežna vmesnika (NAT in Internal) in jih zaženite.
+ 4. Na oba VM-a se prijavite z uporabnikom student in geslom vaje .

+

Prvi del naloge: Postavi OpenRadius.

+ 1. Namesti FreeRadius na virtualki RadiusServer z ukazom "sudo apt-get install freeradius".
+ ( pomembni sta dve konfiguracijski datoteki /etc/openradius/configuration in /etc/openradius/behaviour
+ 2. Dodaj uporabnika in mu dodaj skupno skrivnost v /etc/openradius/configuration datoteko (več o dodajanju lahko izveš na: "http://sites.e-advies.nl/openradius/doc-using-openradius.html"
+ 3. Nato se z to skrivnostjo povežete iz SimpleArbiter na RadiusServer
+ + Namestimo freeradius z ukazom apt-get install freeradius-mysql + V datoteku /etc/freeradius/client.conf spremenimo skrivnost (secret) + Nato pa v datoteki /etc/freeradius/users dodamo uporabnika + + +

Drugi del naloge: Namestitev in vzpostavitev baze MySQL na RadiusServer

+ 1. Pri OpenRadius-u imamo modul RadSQL, s katerim lahko vzpostavimo hranjenje uporabnikov v bazi
+ 2. Namestimo MySQL server z ukazom "sudo apt-get install mysql-server"
+ 3. VNato se prijavimo v Mysql server z ukazom mysql -u root -p
+ 4. Bazo ustvarimo z ukazom primer: + CREATE DATABASE kwhbRgJY; + GRANT ALL ON kwhbRgJY.* To MajaNovak80@localhost IDENTIFIED BY "y06gmo2Z"; + + + -- cgit v1.2.1