EasyHotspot passed the Inaicta Elimination Round

I’ve registered EasyHotspot to INAICTA 2008 (Indonesia National ICT Awards). INAICTA is the annual appreciation event to development of ICT industry in Indonesia. This is my first experience in INAICTA.

Thx God EasyHotspot has passed the elimination round. Now we have 10 nominators, i dont know for sure what are they creating, but from their names its sounds good. The main objective in this event is i want to present EasyHotspot as best as i could and hopefully EasyHotspot become the “best” on this event. It is not how to win the battle, its how to win the war. EasyHotspot is not made for win the competitions, but to ease people who want to build a hotspot. Thats what i mean …

Actually EasyHotspot is not 100% made by me, there’s a lot of contribution from the community, from the idea, critics, bugs report, translation etc. It is so nice that i could share, communicate, and learn with others, its nice for me to contribute back to the Open Source community. Thanks ..

Yet another ID mirror

After ITS, now we have another mirror in Indonesia. Here’s another mirror from indonesia :

http://hostlx.spektrainfotek.com/ehdb-01.iso

thx to Mr. Ardho

EasyHotspot decimal problem (solved)

Since im get used to IDR (indonesian rupiah) currency im forgot to set the price field to become a FLOAT type.. some users like Rocco (italy) and Razza (spain) asked me about that .. so here’s a quick

from terminal :
$mysql -u easyhotspot -p
[password] = easyhotspot

use easyhotspot;
ALTER TABLE billingplan CHANGE price price FLOAT( 11 ) NOT NULL;
ALTER TABLE postplan CHANGE price price FLOAT( 11 ) NOT NULL;

describe billingplan;

describe postplan;
exit;

pheew .. theres anoter bugs solved, thx to you all guys ..

like this :

mysql> use easyhotspot;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ALTER TABLE billingplan CHANGE price price FLOAT( 11 ) NOT NULL;
Query OK, 2 rows affected (0.06 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE postplan CHANGE price price FLOAT( 11 ) NOT NULL;
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql>
mysql> describe billingplan;
+————–+————–+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+————–+————–+——+—–+———+—————-+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | UNI | NULL | |
| type | varchar(255) | NO | | NULL | |
| amount | int(255) | NO | | NULL | |
| price | float | NO | | NULL | |
| IdleTimeout | int(255) | NO | | NULL | |
| simultaneous | int(10) | NO | | NULL | |
| redirect_url | varchar(255) | NO | | NULL | |
| bw_upload | int(255) | NO | | NULL | |
| bw_download | int(255) | NO | | NULL | |
| created_by | varchar(255) | NO | | NULL | |
+————–+————–+——+—–+———+—————-+
11 rows in set (0.00 sec)

mysql>
mysql> describe postplan;
+——-+————–+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+——-+————–+——+—–+———+——-+
| id | int(255) | NO | PRI | NULL | |
| name | varchar(255) | NO | | NULL | |
| price | float | NO | | NULL | |
+——-+————–+——+—–+———+——-+
3 rows in set (0.00 sec)

mysql>


EasyHotspot Doc’s

Dear all, EasyHotspot Documentation is available.
We need your help to translate the documentation into another language, any help would be appreciated .. enjoy !
thx to ascii2412@yahoo.com for her contribution..

EasyHotspot on Pucak, West Java - Indonesia

Several days ago my friend called me and he asking me about EasyHotspot. The conversation went through until he told me there’s a Villa/Hotel interested to implement the EasyHotspot System. I said “sure, thats good ..” and then he asked me what devices needed to build the hotspot. After he knows the EasyHotspot requirements then he decide when to buy and implement the system.

Saturday (4 4 2008 ) is the D day … First, we bought the devices, and here they are :

• 1 PC (Celeron 3 Ghz, 512 Mb, 80 GB) , too much for EasyHotspot i think
• 2 pcs of Linksys WAP54 G
• 1 box of Tofu and Beef Roll (umm yummy …. )

After we have those devices, the best part took the place . Jakarta - Pucak took 3 hrs , 1.5 hrs trip, 0.5 hrs traffic jam, 1 hrs @ Cimory Resto .. Cimory Resto have a nice landscape view and also their fresh milk is good !

About 700 hrs we arrived at the Hotel. The air is quite cool and fresh … what a relief …
Since Bom2 needs to get back home as soon as possible, so we need to finish the job fast and start earlier …
Before we start to workin, here’s the scenario :
We need to connect 2 main sites, Office/Lobby and The Puri Kenanga area. We decided to use WDS mode for this scenario.

This is the “history” of working guys (eastimated time):

• unload the devices - 15 min



• installing EasyHotspot - 30 min



• patching EasyHotspot (ouch!) - 2 min
• configuring the APs (it could be faster if you RTFM , LOL!) - 20 min
• testing the system - 5 min



• testing the APs range - 10 min
• placing the server and APs at the proper place - 20 min

total : 1 hr and 42 minutes

So is everything done ? ummm not yet! We haven’t train the employees yet and i think we need to add this new features :

• no simultaneous use mode
• user current status
• postpaid BW management
• logoff url

Maybe on the next saturday we could go to Cimory again ! hueheueuheu …
Now we need to go home fast !

EasyHotspot ID mirror (?)

Yesterday i tried to add sitemap.xml on easyhotspot server (sourceforge.net). On the next day i try if its works, and unfortunately it is not yet. BUT i found this :

Thanks to ITS for your contribution to EasyHotspot

EasyHotspot Patch

Stayros Tzetzailidis told me that his user cant be automaticaly disconnected when they reached their limit. And i confirmed that bugs … To avaoid it simply remove the comments (”#”) from freeradius conf. Open /etc/freeradius/radiusd.conf and find ‘#noresetcounter’ and ‘#octetslimit’ in authorize section or you can download the patch and then replace the /etc/freeradius/radiusd.conf. Sorry for this bugs.

EasyHotspot first donation

Thanks to Stefano M. for his donation … its the first donation for EasyHotspot

EasyHotspot Documentation ?

There’s a lot of question about EasyHotspot Documentation since the first time it released. I would like to tell you guys that unfortunately theres no documentation YET except the README file. There’s a lot of things to be done right now especially my thesis. I will make a documentation as soon as possible. BUT if you want to help me to make EasyHotspot documentation ill be happy and many people out there

please visit : EasyHotspot Docs Page

If you have any question about it, please dont hesitate to contact me by Email, YM!, or even comments

Thanks

EasyHotspot Released !!!

Try EasyHotspot Beta release :

http://easyhotspot.sf.net