by acls us

CoovaChilli test VM configuration Part II, 1 September 2010



CommuniG8 Limited is a small start-up IT consultancy.

In this article, we will list the installation procedure used to add Radius with MySQL to the CentOS 5 and CoovaChilli configuration build in Part I.



As part of a project to test building a Captive Portal for a Wireless Hotspot network, we needed to setup a virtual network with two Virtual Machines where one was the CoovaChilli Server and another could be used to run a web browser through the HotSpot so that we could test a number of configuration options. One such configuration included Radius with MySQL.


MySQL 5.0.77 Installation 

yum install mysql-server
chkconfig mysqld on
service mysqld start
Set root password? [Y/n] Y
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y


freeRadius2 2.1.7 with MySQL Support Installation

(******** = your closen password)

yum install freeradius2 freeradius2-mysql
radiusd -X
control-c when done
chkconfig radiusd on
mysql -uroot -p
GRANT ALL ON radius.* TO radius@localhost IDENTIFIED BY "*******";
mysql -uroot -p******** radius < /etc/raddb/sql/mysql/schema.sql
edit /etc/raddb/sql.conf - uncomment $INCLUDE sql.conf, set correct password
edit /etc/raddb/sites-available/default
uncomment "sql" and comment "files" in the authorize section
uncomment "sql" in the accounting section
uncomment "sql" in the post-auth section

service radiusd start

Add users to the radius.radcheck table
id - automatic
UserName - login name
Attribute - "Cleartext-Password"
Value - their password
Op - ":="



The configuration used above will allow the CoovaChilli Mini Portal to authorise a user added to a MySQL table. The next aricle will use Joomla! as a test bed for sending some requests to CoovaChilli so a network monitor can be used to observe the packets involved.



Richard Gate, CommuniG8 Limited
Ivy House
Rats Pen Lane
Castle Carlton

LN11 8JG


This email address is being protected from spambots. You need JavaScript enabled to view it.


 08450 041715