Wireless Hotspot in B&B

keizer

A friend of mine has a B&B and just got boradband installed.

Now he would like to set up a hotspot and charge guests to use broadband while staying there.

Has anyone done this - any ideas?

Thanks.

watty

www.fon.com

There was an offer here...

Or contact your ISP

Access

A relitive of mine owns a guesthouse in Killarney and he has done this... Very simple really... He charges €5 per day and just gives the WEP login password to the guest who pays. (He changes the WEP password every few days).

keizer

Thanks for replies so far, but I think he wants to have it set up properly, as in guest comes in, start laptop and it connects to his hotspot and they are charged for usuage via credit card.

Anyone know of software for this, an example woulf be what is being used at dublin and cork airports.

zilog_jones

If he wants it in any way secure, he'd have have to use WEP or WPA which will involve having to give a key to any users - there's no way that can be done automatically, and it's an easy way of knowing who's using it.

axer

http://www.wi-fitechnology.com/viewthread653.html wrote:

A howto for DD-WRT, Chillispot and FreeRadius.
********Warning ********
Following these instructions will invalidate your Linksys warranty. You do so at your own risk. These instructions assume that you have an understanding of Linux, PHP MySQL and Apache. If you brick your AP you might get it back by holding down the reset pin for 20 seconds, unplug the power while still holding down the reset button for another 20 seconds and then plugging the power back in while still keeping the reset button held in for a further 20 seconds. This should bring it back to the defaults of whatever firmware you have installed. You should be able to login to 192.168.1.1
*******End of Warning********
Feel free to copy or use this information in any way you like'

What you will need:-

a) DD-WRT
Download the latest version here http://brainslayer.braincontrol.org/dd-wrt.v22.zip

b) FreeRadius
Download the latest version here ftp://ftp.freeradius.org/pub/radius/old/freeradius.1.0.3.ta r.gz

c) phpMyPrepaid
Download the latest version here http://jabali.net/~carl/phpMyPrepaid.0.1.3RC2.tar
also download the radiusd.conf file from http://jabali.net/~carl/

d) Linsys WRT54G AP

e) You will also need PHP, Apache, MySQL amd MySql Delopment Modules,(These need to be setup first.) some patience, plenty of beer and cigarettes.

Step 1 DD-WRT/Chillispot Configuration

Configure the WRT-54G with the standard Linksys software and the use the upgrade firmware module to install the dd-wrt package on the AP.
*******IMPORTANT******* Use your cable connection to do the upgrade. NOT the wireless connection
Reboot the AP and login to your new firmare.
Set Dynamic configuration DHCP
Disable DHCP (Chillispot will manage DHCP for your clients.)
Change the Local IP of the AP to 192.168.10.1.
Set your gateway and DNS addresses.
Update changes and log back in to the new IP address.

Go to the administration page.
Enable Chillispot
Enter the IP address of your Radius server
Enter the DNS
Enter the redirect URL eg https://123.123.123.123/cgi-bin/hotspotlogin.cgi/ (MAke sure that the address ends in / and is https.)
Enter a shared key. (This can be anything you like, but keep a note of it you will need it later.)
Set DHCP Interface to Lan+Wlan
Enter a NAS id (Your name for your AP)
Enter a UAM secret (This is the password that Chilli will use to talk to hotspotlogin.cgi)
Save your settings and reboot the AP. Please give the AP about 10 minutes to reboot and initialise all the new services.

Step 2 FreeRadius Configuration.

Untar the FreeRadius tar file and enter its directory.
Type ./configure --with-experimental-modules
make
login as root and type make install
When this is finished copy the radiusd.conf file that you downloaded earlier to /usr/local/etc/raddb/
You should not need to edit radiusd.conf
Edit /usr/local/etc/raddb/sql.conf and in the SQL section make these changes
Quote:
# Database type
# Current supported are: rlm_sql_mysql, rlm_sql_postgresql,
# rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds
driver = "rlm_sql_mysql"

# Connect info
server = "localhost"
login = "yourlogin"
password = "your password"

# Database table configuration
radius_db = "radius"


Edit the /usr/local/etc/raddb/clients.conf file and enter the details of your NAS (AP)
Quote:
client xxx.xxx.xxx.xxx { (This is the address of your NAS or WRT54G )
secret = xxxxxxx (The secret you entered in the Chilli Config)
shortname = private-network-9 (This can be any name)
nastype = other
( If you want to set up several AP's with one secret the IP address above should be 0.0.0.0/0 )
}


Step 3 hotspotlogin.cgi
Copy hotspotlogin.cgi from http://chillispot.org to /var/www/cgi-bin
Edit the file and change the secret to the UAM secret that you entered in the Chillispot configuration on the WRT54G

Step 4 phpMyPrepaid and MySQL

Extract the phpMyPrepaid file to a directory on your webserver eg /var/www/html/myprepaid
Create a MySQL database called radius and create a user and password for it. Use a script called db_mysql.db that you will find in the phpMyPrepaid download to create the database tables.
Edit the dbconnect.php file in the phpMyPrepaid directory and enter the username and password for your MySQL radius database. IMPORTANT Save this file behind your web directory or your passwords will be easy to hack.
Edit config.inc.php and change the line that points to dbconnect to wherever you have saved dbconnect.php
In your web browser got to http://yoursite.com/whereveryouputphpmyprepaid/ and create some tickets. Check your database to see if the users have been setup in radcheck. Launch FreeRadius as root with this command radiusd -xxyx -l stdout. Pick a user and password from your database and try to login from a wireless client. If you can then it is time for step 5. If not go back to step 1 and check everything.


Step 5 Have a cup of coffee and unwind. If all is well you have finished. I'll keep an eye on this post and do my best to help anyone with problems.

.

wasim21k

thats good one but not eay one.

Xennon

As some one who used to travel alot, I feel that charging for BB access in B&Bs and hotels to be penny pinching. TBH, when I found a place that had free BB, I revisited that place.

Also I would be interested in the legality of reselling bandwidth.

Dave_W