Category Archives: computers

Bash script to automatically restart MySQL when website database connection is down

I’ve been noticing that periodically my MySQL service will hang and require a restart. It’s easy enough to SSH in and restart it, but I only catch it after the fact. So I wrote this little script which curls my website, sees that it’s down and restarts MySQL and shoots me an email with sSMTP. This only checks for the MySQL service not accepting connections from Apache. If there’s an error with Apache, or it’s not running this won’t do anything. Continue reading Bash script to automatically restart MySQL when website database connection is down

Change default font in Office 2010 (Outlook, Word, PowerPoint) by GPO

I was asked if it was possible to rebrand our Office apps so that by default, we’d all be compliant with corporate branding when composing email, PowerPoint presentations, and Word documents. If I didn’t get to do fun things with computers, that would actually sound like the worst thing ever. But this kind of stuff is neat, so yay me! Continue reading Change default font in Office 2010 (Outlook, Word, PowerPoint) by GPO

Why I’m a CA and you can too…

SSL Certificates are expensive, and most CAs aren’t that respectable anyhow, so why are we all using their certificates to prove we trust each other? I figure you’re here for one of two reasons. You’re either my friend and got here accidentally or you’re looking for computer advice; you either trust me because we’re friends, or you trust me enough to make your computer work better.
Continue reading Why I’m a CA and you can too…

Generate Certificate for TomatoUSB from Active Directory CA

I wanted to install a cert on my router so that I could stop getting shit for not trusting it when I log in. However, installing the cert on every device that I access it with. Since I’ve got all my computers on a domain, I can just install the CA role on my DC, so I don’t need to fuck around with an untrusted CA like StartCom who offer free certs, but still require you to install the CA chain, or buy a ridiculously overpriced cert from some random CA.
Continue reading Generate Certificate for TomatoUSB from Active Directory CA