Remote Authentication Dial In User Service (RADIUS) is a networking protocol that provides centralized Authentication, Authorization, and Accounting (AAA) management for computers to connect and use a network service. RADIUS was developed by Livingston Enterprises, Inc., in 1991 as an access server authentication and accounting protocol and later brought into the IETF standards. (Wikipedia)Uraian di atas adalah penjelasan singkat mengenai apa itu radius server. Ada banyak sekali aplikasi yang berfungsi sebagai Radius Server, antara lain: freeRADIUS, Network RADIUS, EliteAAA, RADIUS-VMS, GNU RADIUS, OpenRADIUS, BSDRadius, Alepo Radius Server, dan sebagainya. Di kalangan komunitas, freeRADIUS adalah yang paling banyak digunakan.

Pada distro Ubuntu, khususnya versi 9.10, paket freeradius sudah ada pada repository. Juga module atau dukungan untuk bekerja dengan MySQL, yang bernama freeradius-mysql. Juga paket mysql-server harus diinstall karena akan digunakan sebagai database bagi radius server. Sehingga untuk instalasinya cukup menggunakan perintah berikut:

sudo apt-get install mysql-server

sudo apt-get install freeradius freeradius-mysql

Kemudian dilanjutkan dengan konfigurasi freeRADIUS.

sudo nano /etc/freeradius/radiusd.conf

Pada baris:

proxy_requests  = yes

$INCLUDE proxy.conf

diganti menjadi:

proxy_requests  = no

$INCLUDE proxy.conf

Selanjutnya pengaturan sql pada freeRADIUS:

sudo nano /etc/freeradius/sql.conf

Pada baris berikut:

# Connection info:

server = “localhost”

login = “radius”

password = “radpass”

# Connection info:

server = “localhost”

login = “root”

password = “passwordrootmysql”

#readclients = yes

readclients = yes

sudo nano /etc/freeradius/sites-enabled/default

authorize{

accounting{

session{

post-auth{

sudo nano /etc/freeradius/clients.conf

client localhost {
ipaddr = 127.0.0.1
secret  = testing123
require_message_authenticator = no
nastype   = other

}

sudo /etc/init.d/freeradius restart

mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 40

Server version: 5.1.37-1ubuntu5 (Ubuntu)

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

mysql> create database radius;

Query OK, 1 row affected (0.00 sec)

mysql> quit

Bye

mysql -u root -p radius < /etc/freeradius/sql/mysql/schema.sql

Enter password:

mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 46

Server version: 5.1.37-1ubuntu5 (Ubuntu)

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

mysql> show databases;

+——————–+

| Database           |

+——————–+

| information_schema |

| mysql              |

| radius             |

+——————–+

3 rows in set (0.00 sec)

mysql> use radius;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

+——————+

| Tables_in_radius |

+——————+

| radacct          |

| radcheck         |

| radgroupcheck    |

| radgroupreply    |

| radpostauth      |

| radreply         |

| radusergroup     |

+——————+

7 rows in set (0.00 sec)

mysql> quit

Bye

mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 48

Server version: 5.1.37-1ubuntu5 (Ubuntu)

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

mysql> use radius

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> insert into radcheck

-> (id, username, attribute, op, value)

-> values

-> (“1″, “hendra”, “User-Password”, “:=”, “coba”);

Query OK, 1 row affected (0.00 sec)

mysql> select * from radcheck;

+—-+———-+—————+—-+——-+

| id | username | attribute     | op | value |

+—-+———-+—————+—-+——-+

|  1 | hendra   | User-Password | := | coba  |

+—-+———-+—————+—-+——-+

1 row in set (0.00 sec)

mysql> quit

Bye

radtest hendra coba 127.0.0.1 1812 testing123