Integrasi easyhotspot + freeradius and Hotspot MikroTik

Integrasi easyhotspot + freeradius and Hotspot MikroTik

First install ubuntu server first
Do not forget to install a LAMP
code :
sudo tasksel



Then LAMP continuously OK

Now we try

Install the required packages
code :
sudo apt -get -y install sysstat rrdtool snmp snmpd dbconfig libphp – adodb -common php5 – cli php5 – gd php5 – gmp – pear php – snmp php5 php5 – adodb make- rpm alien subversion nmap libnet – netmask – perl curl FreeRADIUS freeradius – mysql php5 – mcrypt – SSLeay perl openssl – perl libnet libauthen – pam – ​​perl libpam – ​​runtime libio – pty – perl unzip git -core

code :
cd / opt

sudo git clone git : //easyhotspot.git.sourceforge.net/gitroot/easyhotspot/easyhotspot

code :
mysql -u root -p
CREATE USER ‘ EasyHotspot ‘ @ ‘ % ‘ IDENTIFIED BY ‘ EasyHotspot ‘ ;
GRANT ALL PRIVILEGES ON * . * TO ‘ EasyHotspot ‘ @ ‘ % ‘
– > WITH GRANT OPTION ;
CREATE DATABASE hotspot ;
exit
code :
cd / opt / EasyHotspot / install /
mysql -u root -p hotspot < easyhotspot_opensource_2010-10-21.sql

edit /etc/freeradius/sql.conf
adjust the mysql database e
code :
sql {
#

# Set the database to one of:

#

# mysql, mssql, oracle, postgresql

#

database = “mysql”

#

# Which FreeRADIUS driver to use.

#

driver = “rlm_sql_${database}”

# Connection info:

server = “localhost”

#port = 3306

login = “easyhotspot”

password = “easyhotspot”

# Database table configuration for everything except Oracle

radius_db = “hotspot”

Edit /opt/easyhotspot/htdocs/system/application/config/database.php
adjust database
Code:
$db[‘default’][‘hostname’] = “localhost”;

$db[‘default’][‘username’] = “easyhotspot”;

$db[‘default’][‘password’] = “easyhotspot”;

$db[‘default’][‘database’] = “hotspot”;

$db[‘default’][‘dbdriver’] = “mysql”;

edit /etc/freeradius/clients.conf
Make sure there is a line like this

ipaddr = // Adjust the ip 10.1.0.1 in mikrotik
secret = EasyHotspot // Adjust the radius mikrotik
shortname = 10.1.0.1 // hostname proxy , if there are no contents with Ip

edit /etc/freeradius/radiusd.conf
uncheck # nang part $ INCLUDE sql.conf
This section also : $ INCLUDE sql / mysql / counter.conf
find sections instantiate
add :
code :
max_all_mb
noresetcounter

then the accounting, session and post-auth, find the section # sql continue uncheck # e

edit /etc/freeradius/sql/mysql/counter.conf
look for the words:
sqlcounter noresetcounter {
Blaa |blaâ |blaâ |
}

delete, and replace with:
Code:
sqlcounter noresetcounter {

counter-name = Session-Timeout

Check-name = Session-Timeout

reply-name = Session-Timeout

sqlmod-inst = sql

key = User-Name

reset = never

query = “SELECT SUM (Acctsessiontime) radacct FROM WHERE UserName = ‘% {% k}'”

}

sqlcounter max_all_mb {

counter-name = Max-All-MB

Check-name = Max-All-MB

reply-name = Chillispot-Max-Total-octets

sqlmod-inst = sql

key = User-Name

reset = never

query = “SELECT SUM (AcctInputOctets) / (1024 * 1024) + SUM (AcctOutputOctets) / (1024 * 1024) radacct FROM WHERE UserName = ‘% {% k}'”

}

stop radius
Code:
/etc/init.d/freeradius stop
check config radius
Code:
/ usr / sbin / freeradius -X
if no error start again radius server
Code:
/etc/init.d/freeradius start
create a symbolic link on a web server so that can be accessed

Code:
ln -s / opt / EasyHotspot / htdocs / var / www / hotspot

change user / group

Code:
chown -R www-data.www-data / var / www / hotspot

FreeRADIUS finished
then setting mikrotik
at the hotspot> server profiles
select the server profile
then on the radius, click the radius use

create radius:
Radius keep clicking on the + sign.
continue to browse ip ip in FreeRADIUS, and secret content according to the settings in FreeRADIUS

It is finished
now can create a voucher or user of EasyHotspot
Access from <! – m -> http: // ip-server-ip-udu -mikrotik-e / hotspot <! – m ->

original username: admin
e password: admin123

Sumber Article Information

Baca Juga Genghis Khan Split Channel Bandwith Motor Fast Without Cost Carburetor Setting Configuration Webhtb Ubuntu Securing Mikrotik From DDOS Setting Connections Invalid Click Adsense Membuat Game Sederhana Bermain Gitar Cara Mendaftar Google Adsense Cara Memelihara Aglaonema Budidaya Aglaonema Mastering Burung Beternak Burung Kenari Manfaat Sayur Dan Buah Cara Berhenti Merokok Cara Merawat Motor Asma Hiperemesis Graviadrium Tetanus Diabetes Rheumatik Tuberculosis Diare Kota Banyumas Hidup Sehat Meringankan Windows Memperbaiki File Membuat Batu Bacan Membuat Blog Seal Online Instal Komputer Dan Laptop Dragon Nest Age Of Empire II