Category Archives: Servers and Networking

A DD-WRT USB print server

If your router has a USB port and is running DD-WRT, you can turn it into a DD-WRT USB print server. It can still do wireless duty while it allows your computers to print to your wired USB printer over your wired or wireless network. It’s not very intuitive or user friendly, but it works. Here’s how to set it up with Windows 7. Other Windows versions will be about the same.

Continue reading A DD-WRT USB print server

Linksys EA6200 DD-WRT installation

I picked up a couple of refurbished Linksys EA6200 routers this past weekend. For whatever reason, DD-WRT isn’t officially supported on them, though it does seem to be a popular DD-WRT router. A lot of people make the upgrade far more difficult than they need to. With some simple hacks, Linksys EA6200 DD-WRT installation is pretty straightforward.

I came up with an 18-step process that I simplified just as much as I could. Unlike some methods I’ve seen, I don’t have you editing any binary files or creating custom startup scripts.

Continue reading Linksys EA6200 DD-WRT installation

When DD-WRT doesn’t work with Charter

I set up a DD-WRT router on Charter’s Spectrum broadband, and had a hard time getting it to work. It wouldn’t pull an IP address on the WAN side, or it would pull a 192.168 address rather than a Charter public address.

Here’s what I had to do to fix it.

Continue reading When DD-WRT doesn’t work with Charter

TP-Link TL-WR840n vs TL-WR841n

If you need an inexpensive DD-WRT compatible router, TP-Link is probably your best choice. But there are some big differences when you compare the TL-WR840n vs the TL-WR841n.

I’ve been running the TL-WR841n for more than two years, so I’m familiar with it. I’ve considered supplementing it with a secondary router, and the TL-WR840n was one I looked at.

Continue reading TP-Link TL-WR840n vs TL-WR841n

You might need a new router

Do you need a new router? If your Internet is slow after upgrading to a faster service, and if your wifi range and reception is poor, or your Internet connection just generally misbehaves a lot, you might need a new router.

Even the New York Times, of all places, has published articles extolling the virtues of new routers. If your wi-fi at home is bad, they say, think about picking up a TP-Link Archer C7 router. I like the Asus RT-AC66U myself,  but in my experience, and the experience of my colleagues, a new router makes a huge difference.

When one longtime friend upgraded to a TP-Link Archer, he told me his wi-fi improved so much his wired network was suddenly struggling to keep up with it.

Continue reading You might need a new router

DD-WRT needs to be saved, but I won’t bet on it happening

A college classmate asked me if there’s anything to the stories that DD-WRT might potentially get locked out due to new FCC regulations.

Unfortunately the answer is yes, there may be something to it.

Continue reading DD-WRT needs to be saved, but I won’t bet on it happening

Resources for learning SQL

Whether you’re a sysadmin, an analyst, or use a computer for something else professionally–even if you’re not a database administrator or developer–SQL is a useful skill to know. I’ve gotten by for 20 years without knowing much more SQL other than simple SELECT statements, but those days are rapidly winding down–if I want to be good at my current job, I’m going to have to take some time to learn SQL. If you’re in the same boat, here are some resources for learning SQL.

Here are two resources:

http://pgexercises.com/

https://sqlschool.modeanalytics.com/the-basics/introduction/

SQL is the underlying language behind Oracle, Microsoft SQL, MySQL, PostgresSQL, and probably a few other databases I’m forgetting. If you’re doing something beyond Microsoft Access, it’s probably using some kind of SQL. Each implementation has its own quirks but the basics remain the same between all of them.

Using a router as a switch

Most of us have an old router like a Linksys WRT54G laying around, or if we don’t, it’s very easy to find one–the nearest garage sale or thrift store is a good bet–but sometimes all we need is a switch, to hook up a couple more computers or other devices to a wired connection. Using a router as a switch wastes some of its capabilities, but it’s easy to do.

Continue reading Using a router as a switch