Radius+SQL+Mikrotik YFI Hotspot Manager

Radius+SQL+Mikrotik YFI Hotspot Manager

1 of 6

http://www.forummikrotik.com/linux-support/23979-radius-sql-mikrotik-...

Radius+SQL+Mikrotik YFI Hotspot Manager Dear FMI saya mau coba gelar hasil testing Radius+SQL+Mikrotik YFI Hotspot Manager mohon maaf bila terdapat kekurangan dan kesalahan. mohon sekiranya dapat memberikan masukan langsung yuk om sekalian Update dan Upgrade dulu ubuntu nya >_ root@radius:~# update root@radius:~# upgrade

Instal LAMP fast track >_ root@radius:~# tasksel

INSTALL PAKET YANG DIBUTUHKAN >_ root@radius:~# apt-get install mysql-server php5-mysql php5-cli imagemagick php5-gd php5-curl language-pack-id phpmyadmin buildessential libmysqlclient15-dev libperl-dev libxml-simple-perl libmailsendmail-perl libssl-dev

Instalasi CakePHP >_ root@radius:~# wget -c https://github.com/cakephp/cakephp/archive /1.2.11.tar.gz

masuk ke dalam directory www >_ root@radius:~# cd /var/www

ekstrak paket yang tadi di donlot >_ root@radius:/var/www# tar xzvf /root/1.2.11.tar.gz

Enable mod rewrite, deflate, headers >_ root@radius:/var/www# a2enmod rewrite root@radius:/var/www# a2enmod deflate root@radius:/var/www# a2enmod headers

Pastikan output_buffering dan short open tag nya pada php.ini output_buffering = 4096 short_open_tag = On ( kl anda instal pada ubuntu 10.xx tdk perlu di rubah)

30/05/2013 12:52


2 of 6


output_buffering = 4096 short_open_tag = On ( kl anda instal pada ubuntu 10.xx tdk perlu di rubah) >_ root@radius:~# nano /etc/php5/apache2/php.ini

tambahkan pada bagian bawah /etc/apache2/apache2.conf

AllowOverride All #-------COMPRESS CONTENT----------# place filter 'DEFLATE' on all outgoing content SetOutputFilter DEFLATE # exclude uncompressible content via file type SetEnvIfNoCase Request_URI \.(?:exe|t?gz|jpg|png|pdf|zip|bz2|sit|rar)$ no-gzip #dont-vary # Keep a log of compression ratio on each request DeflateFilterNote Input instream DeflateFilterNote Output outstream DeflateFilterNote Ratio ratio LogFormat '"%r" %{outstream}n/%{instream}n (%{ratio}n%%)' deflate CustomLog /var/log/apache2/deflate.log deflate # Properly handle old browsers that do not support compression BrowserMatch ^Mozilla/4 gzip-only-text/html BrowserMatch ^Mozilla/4\.0[678] no-gzip BrowserMatch \bMSIE !no-gzip !gzip-only-text/html #---------------------------------#------ADD EXPIRY DATE------------ Header set Expires "Thu, 15 Apr 2015 20:00:00 GMT" #---------------------------------#--------Remove ETags -------------------FileETag none #----------------------------------------

>_ root@radius:~# nano /etc/apache2/apache2.conf

Restart Service apache nya >_ root@radius:~# /etc/init.d/apache2 restart

>_ root@radius:~# service apache2 restart

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Install YFI Cake Download Manual Download Yfi Cake >_ root@radius:~# wget http://nchc.dl.sourceforge.net/project/hotcakes /YFi%20CakePHP%20Application/Beta-5/yfi_cake-Beta-5.tar.gz

ekstrak >_ root@radius:~# tar xzvf yfi_cake-Beta-5.tar.gz

Pindahkan ke directory 2 >_ root@radius:~# mv yfi_cake /var/www/c2/

masuk ke dalam directory c2 >_

30/05/2013 12:52


3 of 6


masuk ke dalam directory c2 >_ root@radius:~# cd /var/www/c2

ekstrak yfi cake >_ root@radius:/var/www/c2# tar xzvf /root/yfi_cake-Beta-5.tar.gz

masuk ke mysql >_ root@radius:~# mysql -u root -p

membuat database >_ mysql> create database yfi;

>_ mysql>GRANT ALL PRIVILEGES ON yfi.* to 'yfi'@'127.0.0.1' IDENTIFIED BY 'yfi';

>_ mysql> GRANT ALL PRIVILEGES ON yfi.* to 'yfi'@'localhost' IDENTIFIED BY 'yfi';

>_ mysql> quit

>_ root@radius:~# mysql yfi -u root -p < /var/www/c2/yfi_cake/setup /db/yfi.sql

Instal YFI Viewer download manual >_ root@radius:~# wget http://nchc.dl.sourceforge.net/project/hotcakes /YFi%20Viewer%20Component/Beta-5/yfi-Beta-5.tar.gz

ekstrak >_ root@radius:~# tar xzvf yfi-Beta-5.tar.gz

Pindahkan hasil ekstrak ke /var/www >_ root@radius:~# mv yfi /var/www/

memberikan hak group >_ root@radius:~# chown -R www-data.www-data /var/www/

>_ root@radius:~# reboot

coba login kedalam hotspot manager nya melalui browser

30/05/2013 12:52


4 of 6


coba login kedalam hotspot manager nya melalui browser Buka Web brower http://ipaddress-server/yfi Administrator User : root | Pass : admin Access Provider User : ap | Pass : ap user juga bisa liat masuk dengan menggunakan user dan pass nya masing-masing yang telah dibuat yang

kl ga muncul halaman login nya coba cek hak user group nya belum selesai om, sekarang kita lanjut install FreeRadius nya Instalasi FreeRadius >_ root@radius:~# wget -c ftp://ftp.freeradius.org/pub/freeradius /freeradius-server-2.2.0.tar.gz

ekstrak >_ root@radius:~# tar xzvf freeradius-server-2.2.0.tar.gz

masuk kedalam hasil extrakan nya >_ root@radius:~# cd freeradius-server-2.2.0/

installasi >_ root@radius:~/freeradius-server-2.2.0# ./configure root@radius:~/freeradius-server-2.2.0# make && make install root@radius:~/freeradius-server-2.2.0# ldconfig root@radius:~/freeradius-server-2.2.0# cp /usr/local/sbin/rc.radiusd /etc/init.d/radiusd root@radius:~/freeradius-server-2.2.0# update-rc.d radiusd start 80 2 3 4 5 . stop 20 0 1 6 . root@radius:~/freeradius-server-2.2.0# mv /usr/local/etc/raddb /usr/local/etc/raddb.orig root@radius:~/freeradius-server-2.2.0# cp /var/www/c2/yfi_cake/setup /radius/raddb.tar.gz /usr/local/etc/ root@radius:~/freeradius-server-2.2.0# cd /usr/local/etc/ root@radius:/usr/local/etc# tar -xzvf raddb.tar.gz root@radius:/usr/local/etc# chown root.www-data /usr/local/etc/raddb /proxy.conf root@radius:/usr/local/etc# chmod 664 /usr/local/etc/raddb/proxy.conf root@radius:/usr/local/etc# chmod 644 /usr/local/etc/raddb/dictionary root@radius:/usr/local/etc# ldconfig

tambahkan pada bagian bawah file /usr/local/share/freeradius/dictionary.chillispot >_ root@radius:~# nano /usr/local/share/freeradius/dictionary.chillispot

END-VENDOR ChilliSpot ATTRIBUTE ChilliSpot-OriginalURL 9 string

30/05/2013 12:52


5 of 6


END-VENDOR ChilliSpot ATTRIBUTE ChilliSpot-OriginalURL 9 string #YFi Specific Attributes ATTRIBUTE Yfi-Voucher 40 string ATTRIBUTE Yfi-MAC-Reset 41 string ATTRIBUTE Yfi-Data 42 string ATTRIBUTE Yfi-Time 43 string #YFi Various Counters ATTRIBUTE Max-Daily-Session 50 integer ATTRIBUTE Max-Monthly-Session 51 integer ATTRIBUTE Max-Weekly-Session 52 integer ATTRIBUTE Max-All-Session 53 integer uncomment pada

#home_server virtual.example.com { # virtual_server = virtual.example.com

>_ root@radius:~# nano /usr/local/etc/raddb/proxy.conf

Tambahkan pada bagian paling bawah /usr/local/etc/raddb.client.conf

client 0.0.0.0/0 { secret = testing123 shortname = mikrotik1 }

>_ root@radius:~#nano /usr/local/etc/raddb/clients.conf

Restart radius >_ root@radius:~#service radiusd restart root@radius:~# /etc/init.d/ radiusd restart

Langkah Pengetestan User 1 Buat user

2. Test User

30/05/2013 12:52


6 of 6


Mikrotik nya jng lupa di aktifkan radius nya >_ [admin@Mikrotik] > radius add service=hotspot address=10.10.10.43 secret=testing123

* IP 10.10.10.43 adalah IP si Radius Server nya Demikian sumber yang memberi inspirasi dan contekan

30/05/2013 12:52

Radius+SQL+Mikrotik YFI Hotspot Manager

Recommend Documents