If it’s not one thing…

My MySQL server seems to actually be fixed. At least, I’ve not seen it go down for a while, and I think it’s much snappier. That might be because of something that changed in 2.8 of WordPress.

Unfortunately, now my SSH turns itself off, randomly. It doesn’t crash. It’s just like it’s not been turned on, so it must cleanly shut itself down at some point. I’ll check error logs later…

Last night’s happiness involved a gun, and some mutant rats

Just off the bat, I’m getting really annoyed my my mysqld dieing all the time. I’ve no idea what’s causing it, except that maybe WordPress (which seems to be the only affected thing at the moment) is a little too intensive for my 64Mb server.

Database dieing was the reason I didn’t do last night’s happiness update, but I’ll do it now.

Yesterday’s most happiest thing for me was probably getting Fallout 3 for my xbox. That game is freaking awesome. It seems huge and expansive, however I’m worried that – because things don’t respawn (at least, I don’t think they do. There’re still dead bodies lying around that I killed in-game days ago) – I’ll kill everything and then won’t be able to level up any more. Last night, the stupid Brotherhood of Steel guys killed half of the Raiders before I had a chance.

I only found out you can queue up attacks in the VAT thing a few hours into playing…

I bought Ghost Recon too, but I don’t really like it, so I’m putting it on ebay. I only need one bid to get my money back, to be fair, and I think people will be looking to collect as many game as they can during the holidays. Especially with people getting new xboxes and stuff for Christmas.

Committed to SVN

I decided to try Subversion out some more, and made it so Trinity’s live-dev and my offline-dev are both working from files from the same repository. Instead of FTPing all the files over to Trinity every time I make some changes (and I usually have to reupload all of them, since I can never remember which files I’ve changed), I can just commit them on my laptop, which uploads the changed files to the repo, and then checkout on Trinity’s version and every thing’s back up-to-date.

The one problem I’m having though is that Trinity’s version has a completely different password for the database than my local version does. In the past I’ve just never overwritten the database.php file, so both have the right password, but now all the changes are uploaded, so are the different passwords!

I need some way of saying “don’t commit the database file”. Or at even better, “don’t change this one line”.

Damnit

When deciding to use SVN to update my WordPress install, I forgot to backup my content folder. Now it’s gone. Damnit.

And because I told Google not to save index this blog, it didn’t cache anything either.

Oh, looks like I do keep good backups.

Phone posting and WordPress

The thought of adding more multimedia to this blog makes me happy. I’d do video, but I’m camera shy, so I figured the next best thing would be voice. Now I could do that manually, but where’s the fun in that so here’s what I want to be able to do:

  1. Phone somewhere. I’m guessing this’ll be my server.
  2. Get greeted by a lovely voice, saying hai.
  3. Enter a PIN number or something.
  4. The application/server records what I’m saying to an audio file, which it moves to my web directory.
  5. WordPress notices the file and shows it like a new posts.

I want all the above to be automatic from when I phone, so I don’t even have to be at a computer.

For those of you that don’t know (which I expect most of you don’t), I’m running a Debian virtual server. Since it’s a shared server, I can’t really do anything with hardware except for what’s already there, and I’m not sure what is. Let me know if I need anything, and I can find out.

I know there are programs like Asterisk that deal with VOIP, but I’m not exactly sure what they do, since I’ve never looked into this field. And also, I don’t know the technical name for what I want, so searching for it doesn’t do much help.

I don’t mind paying for phone calls, but I doubt that I’d be able to get a phone number for my server, right? I don’t mind using things like Skype to phone the server, but I guess there’ll need to be some other open source software to be able to do what I want.

Once the application stores the audio file, I can do all the WordPress work myself, so I won’t need help with that. It’s really just steps one through four that I need to learn how to do. Any pointers?