Configure Mikrotik as a Hotspot Server

 

There are many posts on how to configure Mikrotik as hotspot. But I am sure this is not the result of a cheat sheet. Even if some of section are the same, it was fate. Mikrotik is a friendly operation system, and is very easy to configured. Enough to know the concept of network, plus with a Winbox, then you will easily configure the Mikrotik, in accordance with your wishes. I configured wireless outdoor of mikrotik, as a hotspot. I forget the type of the mikrotik. It's been a long time. And now for the post on this blog, I configure the mikrotik hotspot again, but this time, the mikrotik is installed inside vmware.

Let’s begin.

Upgrade Squid Proxy Server, 3.1.22 to 3.3.3

A few days ago, suddenly, my squid proxy server (squid version 3.1.22 as transparent proxy) does not work or hangs. Weird... I've checked everything, but no luck. These are I have done,

1. check with command, ps ax | grep squid, ... ok.
2. check in /var/log/error.log,...no error, running well.
3. check on the firewall, shorewall, normal.
4. check router mikrotik, good.

How does a Hotspot Billing System Work ?

This is a great blog post, about the theory or explanation of how a hotspot billing system works. Do not just make it but do not understand how it works a hotspot billing system. Even with the understanding of the theory, this will greatly help us in making a billing system, and will easily fix it if there is damage. This is not my post original, but I copy it from blog’s Om Rafequl. Thanks Om.

PhpMyPrepaid on Fedora 18

After installed YFI and Easyhotspot as hotspot system billing, it's time to try another hotspot system billing, and I use Fedora 18 as Operating System. Phpmyprepaid, is interface hotspot system billing designed to work with a MySQL database and FreeRadius. Phpmyprepaid has not developed yet. The final version is phpmyprepaid 0.4-RC3, came out in April 2009. It is the oldest than others. (CMIIW)

Let's to begin.

As usually, after  installing fedora 18 with minimalist package, continue to configure network. Make sure some variable is exist.

How to Fix PhpMyPrepaid 0.4.rc3

 

This is story of my experiment, when install phpmyprepaid 0.4.rc3, on fedora 18. And another "friends" who been installed, were FreeRADIUS version: 2.2, Chillispot version: 1.1, Mysql Server version: 5.5.30. and Apache/2.4.4 (Fedora). It was very difficult to install. A lot of errors that I got. Probably, phpmyprepaid is too old, has long been abandoned, and no support with new things.

let's see list error, so if you find the error again, you know how to fix that…

a little review of Fedora 18

This is a little review of fedora 18, when I install phpmyprepaid as hotspot billing system in fedora 18. Of course, I consider this interesting and important to build a server.

Repolist

#yum repolist

Easyhotspot in Centos 6.4 + CoovaChilli 1.3.0

In this section, I explain how to modify easyhotspot by adding coovachilli, in Centos 6.4. Usually, installing coovachilli can fix the problem of EasyHotspot login failed which sometimes happens. Before you continue reading this post, look at section easyhotspot with centos 6.4, in this blog. I assume you have been through 2 stages, (1)install apache, php, mysql, and (2) install web easyhotspot.

Install Freeradius 2.1.12.

Actually the same as before in easyhotspot with centos 6.4 section, just a few different configurations. I explain it all so as not to confuse.

yum install freeradius freeradius-mysql freeradius-utils

chkconfig --level 235 radiusd on

Easyhotspot in Centos 6.4

Actually a lot of to discuss about making this hotspot. But I see it is not discussed fully. And mostly use Ubuntu. I will explain how to make easyhotspot in centos 6.4, based on my experiment.

I divide it into 4 parts, to make it more easily understood.

1. Install Apache, PHP and Mysql.
2. Install Web Easyhotspot.
3. Install Freeradius 2.1.12.
4. Install Chillispot. 

 1.         Install Apache, PHP and Mysql.

I assume the PC is installed with centos 6.4. In my experiments, centos installed in a minimalist package. Configure the network interface. (Watch carefully, I use 2 lan card, which happened to be detected as eth1 and eth2. Eth1 to use static ip, and the ip dhcp eth2. So please do adjustments IP address, in accordance with the conditions in your network, I know you can do it).

 vi /etc/sysconfig/network-scripts/ifcfg-eth1

httpd: apr_sockaddr_info_get() failed for "hostname"

I found error, when I have installed mod_ssl

Starting httpd: httpd: apr_sockaddr_info_get() failed for NGERI

How to fix,

edit /etc/hosts

In the end, add line

Cache Youtube Video with Squid 3.3.2 and Nginx

Note :

source : http://aacable.wordpress.com/2012/08/13/youtube-caching-with-squid-nginx/

I change some command, according with my network environment, and my experience.

( Update January 2th, 2014). Look at another posting, cache youtube video with storeurl method.  http://myconfigure.blogspot.com/2014/01/caching-youtube-with-storeurlpl-method.html

I assume you've installed :
1. Ubuntu 12.10,
2. Squid 3.3.2
3. Mikrotik, options to make it better
All of the above is installed and running nomally.If you have not installed some of the things mentioned above. Stop reading this section, and look for the section on this blog, about how to install squid. For example, you can read the
"Transparent Proxy with Squid 3.3.2 on Ubuntu 12.10 + Shorewall + Mikrotik".

Ok. Let's begin.

1. Add some command line at squid.conf

Add

Transparent Proxy with Squid 3.3.2 on Ubuntu 12.10 + Shorewall + Mikrotik

 

This post explains how to setup a transparent proxy (intercept proxy) by combining mikrotik and squid eksternal. Look at a network above. a mikrotik as router, coupled with a proxy server (squid as transparent proxy). In the previous article has been discussed about this network. You can read at "Ubuntu 12.10 + Squid (Transparent Proxy) + Shorewall + Mikrotik". But the squid that was used is version 3.1.23. If you replace it with squid version 3.2.8 or 3.3.2, would be an error. The reason is, the proxy misrepresented the "redirect".
So.  If you want to use squid 3.2.8 or 3.3.2 as a transparent proxy, in a network as above, then there are some things that should be changed, the configuration on the router mikrotik and the Squid.
A few steps below, would be similar to the steps at "Transparent Proxy Server, Squid 3.3.2 / 3.2.8 on Ubuntu 12.10 + Shorewall"
We begin by configuring the Ethernet.

vi /etc/network/interfaces

Transparent Proxy Server, Squid 3.3.2 / 3.2.8 on Ubuntu 12.10 + Shorewall

Squid 3.1.xx (latest version 3.1.23), is a very simple and is used to make transparent / intercept. While the squid 3.3.2 / 3.2.8, to make transparent / intercept configuration is a bit different from the version of squid 3.1.23.  In this blog, I will explain how to create a transparent / intercept in two ways, the first is squid as well as a router, and the second, Mikrotik as a router coupled with squid external. Let's get to start, a transparent proxy server with squid as well as router.

Network configuration.
After installing the new Ubuntu, configure the ethernet. In my case, Ethernet to the Internet is dhcp, and another ethernet to the LAN, using the IP address 10.10.10.1. Of course, customize your network environment.

vi /etc/network/interfaces

Squid 3.3.2 / 3.2.8 : Example Squid.conf

#WELCOME TO SQUID
#       ----------------------------

acl snmppublic snmp_community public

acl bamboe src 192.168.10.0/24

#uncomment noway url, if necessary.
#acl noway url_regex -i "/etc/squid/noway"

acl SSL_ports port 443

acl Safe_ports port 80          # http

acl Safe_ports port 1935          # http

acl Safe_ports port 21          # ftp

acl Safe_ports port 443         # https

acl Safe_ports port 70          # gopher

acl Safe_ports port 210         # wais

acl Safe_ports port 1025-65535  # unregistered ports

acl Safe_ports port 280         # http-mgmt

acl Safe_ports port 488         # gss-http

acl Safe_ports port 591         # filemaker

acl Safe_ports port 777         # multiling http