Archive for August, 2009
Monitoring SSL certificate expiration with ssl-cert-check
Posted by evan in Uncategorized on August 31, 2009
I was about to write a script using OpenSSL to monitor the SSL certificate expiration dates for a few servers when it dawned on me that someone had probably done this already.
The ssl-cert-check shell script takes a list of hosts/ports and prints out the expiration date (and how many days away that date is). It can also be configured to email a message for any certificates expiring in less than N days for easy cronibility (?). Seems lovely!
QuakeLive?
Posted by evan in Uncategorized on August 21, 2009
QuakeLive? Really?
Doesn’t run on my desktop, I guess due to being 64-bit. Very sad…
Read the rest of this entry »
Amazon changed their API
Posted by evan in Uncategorized on August 18, 2009
All requests to the Amazon API have to be signed now, and since I don’t even use my stuff I didn’t bother changing it, so all my old Amazon store code is dead now. But fortunately they made it really easy to setup a fake storefront for stuff I like:
http://astore.amazon.com/evanhoffmasho-20
Wee…
Migrating RT from mysql to postgresql.
Posted by evan in Uncategorized on August 6, 2009
So I wanted to move our old RT 3.6 system to a new VM running a clean CentOS 5.3 x86 install and RT 3.8. I got RT installed but the 3.6 system was running on MySQL, which sucks (still), and I wanted to move it to Postgres, which rules (more and more each day). So Googling for “migrate rt from mysql to postgresql” brought me here. I tried the procedure listed there but it wasn’t quite working for me. my2pg.pl and mysql2postgresql.perl both caused segfaults when I tried to run them. I realized I was on my own, and it wasn’t really that bad.