DSL Router Troubles – ZyXEL Prestige and iolBB

Oh! The troubles I’ve seen! Every now and again my DSL router, a ZyXEL Prestige 623R-T1 would pack in and refuse to perform DNS requests. A mail to the ILUG on the matter didn’t help as nobody replied but I think I have come to a round about solution! Use a proxy server and caching name server!
So, I installed Squid and bind. Pointed my browser at Squid, /etc/resolv.conf at 127.0.0.1 and all seems fine!
I had previously noticed the router fail when I had opened a lot of browser tabs (6 web pages? Not much IMO) so I tried again with almost a dozen. Worked first time and because you’re seeing this, it’s still working!
Fingers crossed that it continues to work.

Iraq – EU supporter?

What if the US attacked Iraq to prop up the US Dollar? This article delves into that idea.

Iraq is a European Union beachhead in that confrontation. America had a monopoly on the oil trade, with the US dollar being the fiat currency, but Iraq broke ranks in 1999, started to trade oil in the EU’s euros, and profited. If America invades Iraq and takes over, It will hurl the EU and its euro back into the sea and make America’s position as the dominant economic power in the world all but impregnable.

The Referers are Gone but I'm still kicking!

The referer db table just got hosed but I’ve rebuilt it. Unfortunately your referer listing is going to be a little short for a few days until it fills again!
Anyway, I have the following running each night. Should have done this before.

#!/bin/sh

export d=`date +%u`
for i in `echo show tables |mysql -u username -ppassword b2`
do
    echo "check table $i"| mysql -u username -ppassword b2
done
mysqldump --opt -u username -ppassword b2 > backup/b2-$d.sql