radius+sql+mikrotik yfi hotspot manager

Radius+SQL+Mikrotik YFI Hotspot Manager

Dear FMIsaya mau coba gelar hasil testing Radius+SQL+Mikrotik YFI Hotspot Managermohon maaf bila terdapat kekurangan dan kesalahan.mohon sekiranya dapat memberikan masukanlangsung yuk om sekalian

Update dan Upgrade dulu ubuntu nya

>_

root@radius:~# updateroot@radius:~# upgrade

Instal LAMP fast track

>_

root@radius:~# tasksel

INSTALL PAKET YANG DIBUTUHKAN

>_

root@radius:~# apt-get install mysql-server php5-mysql php5-cliimagemagick php5-gd php5-curl language-pack-id phpmyadmin build-essential libmysqlclient15-dev libperl-dev libxml-simple-perl libmail-sendmail-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 rewriteroot@radius:/var/www# a2enmod deflateroot@radius:/var/www# a2enmod headers

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

>

Radius+SQL+Mikrotik YFI Hotspot Manager http://www.forummikrotik.com/linux-support/23979-radius-sql-mikrotik-...

1 of 6 30/05/2013 12:52

output_buffering = 4096short_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

>_

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 CakeDownload ManualDownload 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

>_

root@radius: # cd /var/www/c2

AllowOverride All

#-------COMPRESS CONTENT-----------# place filter 'DEFLATE' on all outgoing contentSetOutputFilter DEFLATE# exclude uncompressible content via file typeSetEnvIfNoCase Request_URI \.(?:exe|t?gz|jpg|png|pdf|zip|bz2|sit|rar)$ no-gzip#dont-vary# Keep a log of compression ratio on each requestDeflateFilterNote Input instreamDeflateFilterNote Output outstreamDeflateFilterNote Ratio ratioLogFormat '"%r" %{outstream}n/%{instream}n (%{ratio}n%%)' deflateCustomLog /var/log/apache2/deflate.log deflate# Properly handle old browsers that do not support compressionBrowserMatch ^Mozilla/4 gzip-only-text/htmlBrowserMatch ^Mozilla/4\.0[678] no-gzipBrowserMatch \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#----------------------------------------


2 of 6 30/05/2013 12:52

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 Viewerdownload 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


3 of 6 30/05/2013 12:52

coba login kedalam hotspot manager nya melalui browserBuka Web brower http://ipaddress-server/yfi

Administrator User : root | Pass : adminAccess Provider User : ap | Pass : apuser juga bisa liat masuk dengan menggunakan user dan pass nya masing-masing yang telahdibuatyang

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# ./configureroot@radius:~/freeradius-server-2.2.0# make && make installroot@radius:~/freeradius-server-2.2.0# ldconfigroot@radius:~/freeradius-server-2.2.0# cp /usr/local/sbin/rc.radiusd/etc/init.d/radiusdroot@radius:~/freeradius-server-2.2.0# update-rc.d radiusd start 80 2 34 5 . stop 20 0 1 6 .root@radius:~/freeradius-server-2.2.0# mv /usr/local/etc/raddb/usr/local/etc/raddb.origroot@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.gzroot@radius:/usr/local/etc# chown root.www-data /usr/local/etc/raddb/proxy.confroot@radius:/usr/local/etc# chmod 664 /usr/local/etc/raddb/proxy.confroot@radius:/usr/local/etc# chmod 644 /usr/local/etc/raddb/dictionaryroot@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 ChilliSpotATTRIBUTE ChilliSpot-OriginalURL 9 string#YFi Specific Attributes


4 of 6 30/05/2013 12:52

uncomment pada

>_

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

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

>_

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

Restart radius

>_

root@radius:~#service radiusd restartroot@radius:~# /etc/init.d/ radiusd restart

Langkah Pengetestan User1 Buat user

2. Test User

Mikrotik nya jng lupa di aktifkan radius nya

END-VENDOR ChilliSpotATTRIBUTE ChilliSpot-OriginalURL 9 string#YFi Specific AttributesATTRIBUTE Yfi-Voucher 40 stringATTRIBUTE Yfi-MAC-Reset 41 stringATTRIBUTE Yfi-Data 42 stringATTRIBUTE Yfi-Time 43 string#YFi Various CountersATTRIBUTE Max-Daily-Session 50 integerATTRIBUTE Max-Monthly-Session 51 integerATTRIBUTE Max-Weekly-Session 52 integerATTRIBUTE Max-All-Session 53 integer

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

client 0.0.0.0/0 {secret = testing123shortname = mikrotik1}


5 of 6 30/05/2013 12:52

Mikrotik nya jng lupa di aktifkan radius nya

>_

[admin@Mikrotik] > radius add service=hotspot address=10.10.10.43secret=testing123

* IP 10.10.10.43 adalah IP si Radius Server nya

Demikian

sumber yang memberi inspirasi dan contekan


6 of 6 30/05/2013 12:52

radius+sql+mikrotik yfi hotspot manager

Documents