Page Comparison

To test the RADIUS server directly, execute inside the VM:

...

Test

sudo radtest testuser1 password1 localhost 1812 testing123

check MySQL database

sudo mysql -u root -psecret radius

Code Block

title	mysql
collapse	true

me@server01:~$ sudo mysql -u root -psecret radius
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 220
Server version: 10.3.25-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [radius]>

List users

select * from radcheck;

Code Block

title	radcheck
collapse	true

MariaDB [radius]> select * from radcheck;
+----+-----------+--------------------+----+-----------+
| id | username  | attribute          | op | value     |
+----+-----------+--------------------+----+-----------+
|  1 | testuser1 | Cleartext-Password | := | password1 |
|  2 | testuser2 | Cleartext-Password | := | password2 |
+----+-----------+--------------------+----+-----------+
2 rows in set (0.000 sec)

SELECT id, username, attribute, value, op FROM radcheck ORDER BY id;

Code Block

title	list users

MariaDB [radius]> SELECT id, username, attribute, value, op FROM radcheck ORDER BY id;
+----+-----------+--------------------+-----------+----+
| id | username  | attribute          | value     | op |
+----+-----------+--------------------+-----------+----+
|  1 | testuser1 | Cleartext-Password | password1 | := |
|  2 | testuser2 | Cleartext-Password | password2 | := |
+----+-----------+--------------------+-----------+----+
2 rows in set (0.000 sec)

SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'testuser1' ORDER BY id;

SELECT id, username, attribute, value, op FROM radreply WHERE username = 'testuser1' ORDER BY id;

SELECT groupname FROM radusergroup WHERE username = 'testuser1' ORDER BY priority;

INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'testuser1','testpwd','Access-Accept', '2018-01-26 22:07:14');

...

Versions Compared

Old Version 10

New Version 11

Key

To test the RADIUS server directly, execute inside the VM: