Category: Technology

Making a bash script terminate when a command returns an error

#!/bin/bash -e trap "echo ERROR HANDLING HERE." ERR echo "Starting" asdfasdf echo "End" Read More »
By halfgaar, 7 years ago, on January 21, 2013, at 14:01 | Comments closed

Chemical tin for circuit boards

For the record, about chemical tin PCB treatment: Seno Glans Tin Read More »
By halfgaar, 7 years ago, on January 20, 2013, at 16:01 | 2 comments

I need a Nanny for Google Chrome

I just installed Nanny for Google Chrome, which, like LeechBlock for Firefox, should help me to recoup some of the time that is now actively being stolen by YouLube and FaceLook. If I'm too weak on my own to push back technology to its proper servile place, then I might as well use technology to do some of the pushing for me. You're a tool, you damn computer, nothing more than that! Read More »
By Rowan Rodrik, 7 years ago, on January 17, 2013, at 12:01 | 1 comment

Making Linux less dumb about failed DNS servers

Whenever one of the servers in /etc/resolv.conf is unreachable, Linux/glibc/whatever isn't smart enough not to retry it for a while. This results in a lot of services becoming unavailable, because a lot of them do reverse lookups on all incoming connections (like SSH), which will hang for the time-out of the first DNS server query. Read More »
By halfgaar, 7 years ago, on December 28, 2012, at 18:12 | Comments closed

Some links about Macbook sleep problems

My wife's macbook sometimes keeps waking up when you close it; it gets stuck in an endless sleep-wakeup loop. Here are some links about it that I've had in my e-mail forever: Read More »
By halfgaar, 7 years ago, on December 20, 2012, at 11:12 | Comments closed

Getting munin to run every 10 minutes

Munin is kind of inefficient and on my P4 2Ghz, it running every 5 minutes is too often, and the munin processes keep dying because locks already exist. You can't increase the munin-cron script to 10 minute intervals, because then rrdtool will generate gaps. Read More »
By halfgaar, 7 years ago, on December 18, 2012, at 16:12 | 3 comments

Adding a clock in screen to avoid your ssh’s from being killed

The world is filled with stupid routers, which kill all connections that have no activity for a while (even a very short while). I keep loosing my SSH sessions because of this. To fix it, I added a clock in my GNU screen bar: Read More »
By halfgaar, 7 years ago, on October 31, 2012, at 11:10 | 5 comments

Trying to reduce MySQL InnoDB disk usage after major reduction of data

So, two days ago, I tried to shrink my MediaWiki database and it almost worked, except the MySQL process wouldn't shrink along with it. Read More »
By Rowan Rodrik, 7 years ago, on October 24, 2012, at 18:10 | 2 comments

Shrinking/compressing a MediaWiki database

As of late, I haven't had a lot of time to chase after spammers, so – despite of anti-spam captchas and everything – a couple of my wikis have been overgrowing with spam. One after the other I've been closing them down to anonymous edits, even closing down user registration alltogether, but some a little too late. Read More »
By Rowan Rodrik, 7 years ago, on October 24, 2012, at 16:10 | 1 comment

Converting all tables in MySQL DB to InnoDB

#!/bin/bash exit 1 dbname="eorder" echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t | mysql $dbname Read More »
By halfgaar, 8 years ago, on October 02, 2012, at 14:10 | 5 comments