Author Archives: David Goodwin
SSL Commands
I keep forgetting these one line OpenSSL commands – perhaps if they are here, I’ll remember — Create private key file : openssl genrsa -out server.key 2048 Create certificate signing request (to send to e.g. GoDaddy) – openssl req -new -key server.key -out server.csr Verify a certificate – openssl verify file.name To convert a .crt … Continue reading
Automated twitter compilation up to 01 May 2012
Arbitrary tweets made by TheGingerDog (i.e. David Goodwin) up to 01 May 2012
Checking PHP code for compatibility issues
One project I occassionally hack on is Xerte Toolkits. Yesterday on the mailing list it came up that someone was trying to use XOT with PHP4. After getting over some initial shock that people still use PHP4 (it was end-of-lifed in August 2008) I wondered how easy it would be to check the status of … Continue reading
Linux console dimming / screen saver
Our work server seems to enjoy crashing (at the moment) about once a day – but when I go to look at the console I can’t see anything because the screen has dimmed to black – and as the computer has locked up, I can’t wake the screen up to see if there is a … Continue reading
Netbeans vs Vim … round 1 … fight
So, I think I’ve changed ‘editor’. Perhaps this is a bit like an engineer changing their calculator or something. For the last 10 years, I’ve effectively only used ‘vim‘ for development of any PHP code I work on. I felt I was best served using something like vim – where the interface was uncluttered, everything … Continue reading
irssi – crapbuster (cleaning up the irc window)
Tired of seeing join/part/quits messages in your IRC window, and want a quick way to selectively get rid of it – then look no further – mkdir -p ~/.irssi/scripts cd ~/.irssi/scripts wget http://scripts.irssi.org/scripts/crapbuster.pl Then within IRSSI – /load crapbuster.pl /set crapbuster_levels JOINS PARTS QUITS NICKS CLIENTCRAP CRAP MODE TOPICS KICKS And then : /crapbuster Will … Continue reading
MySQL table defragmentation (python script)
I’ve written the below Python script to defragment MySQL database tables. This should work with both InnoDB and MyISAM table formats, and is just calling “OPTIMIZE TABLE blah.foo”. It rummages through the information_schema for tables which may be defragmented. You should be able to run it on any Debian based system without making any alterations. … Continue reading
Chocolate headed pirates
My son woke up at 6am crying quite loudly this morning – he’d been having a nightmare involving a Chocolate Headed Pirate being mean and nasty to him. Personally I think a chocolate headed pirate would be quite tasty – although perhaps it’d be a bit more than I could eat in one sitting (or … Continue reading
Automated twitter compilation up to 29 March 2012
Arbitrary tweets made by TheGingerDog (i.e. David Goodwin) up to 29 March 2012
Spring trip to Barcelona
Well, sort of random. As I don’t normally bother to upload any pictures and so on, I thought I might as well for once – and I said I’d send my father a postcard, but then failed to …. perhaps this will make up for it. I didn’t notice any postcard selling shops either – perhaps … Continue reading