How to: Turn a wireless router into an access point

When I purchased my Linksys BEFSX41 I had two spare wireless routers a D-Link WBR-1310 and a WBR-2310 respectively. What to do? Turn them into wireless AP's (access points) of course! Increase your wireless coverage, look cool!

 

First thing's first, set up DHCP on your main router. For me it's the BEFSX41. Set your DHCP range, for example 192.168.0.150-199 giving you some room for wireless devices.


Now login to your router (most likely 192.168.x.1) which is converting to an AP, the WBR-1310/2310 for me. Turn DHCP off and set the router IP to below or above the DHCP range. So for example, 192.168.0.149, 192.168.0.200 etc.

Once you have configured your AP, plug the ethernet cable into one of the LAN ports, not the WAN port. See below.


Check the LAN connection then check the AP wireless connection.


This method can work with more access points as well (in my case, two AP's).

What now? Well, if you have two [802.11b/g] AP's set them to non-overlapping channels. Change them to either channels 1, 6 or 11. For more info see here.

 

Comments, ideas and so forth are appreciated :)

How to: Use seperate local MySQL DB

This was quite frustrating for me. I tried everything; why doesn't it connect to to the database? I finally figured it out: wrong IP. Anyway, here are some tricks that I used to get Server A to connect to Server B, with MySQL.
 

First things first. Change your bind-address. For Debian, edit your my.cnf in /etc/mysql
Change the bind-address to your local LAN IP. Restart MySQL with:

 

/etc/init.d/mysql restart

 

 

Now to tackle MySQL...

 

mysql -u root -p
<password>

Create the user and assign privileges:

Note, 192.168.0.100 should be the clients IP, not the servers.

CREATE USER 'user1'@'192.168.0.100' IDENTIFIED BY 'pass1';


GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'192.168.0.100';


GRANT ALL ON *.* TO 'user1'@'192.168.0.100';

And finally create the database:

create database databasename;

 I'm no SQL guru, so please correct me if I messed up ;)

Hope that helps!