Outage, again

Like I’ve said before, the Inanis.net server is wonky. When I reboot after security updates, it won’t restart the web and database services. I have to start them manually. If I forget… my site stays down until I remember.

I need to just rebuild the box, but time doesn’t permit that right now.

Sorry for the outage, folks!

Yeah, that wasn’t supposed to happen…

Really, all I did was install some updates and somehow (read: it’s my fault), the swap file on the server went away and then the server refused to boot. I fixed it, so it’s all good.

Long story short: I made changes to try to fix something and I made it worse. The server has been upgraded about a billion times and really just needs a clean install. I just have to figure out how to do that seamlessly. Easier said than done.

Dumping MySQL and Moving It

So, does anyone out there who follows my blog know how to take the ENITRE OPERATIONAL STATE, including GRANTS (or permissions, or whatever you call them), usernames and associated passwords and all the table/db data and move it from one MySQL server to another and get it to work?

I am trying to move Inanis.net to a new platform and I can’t seem to get the MySQL permissions to work correctly. I use the command mysqldump -u root --all-databases  > filename.sql to dump the data from the old box and something similar to pop it into the new box. I then copy my entire web directory (all the php apps like wordpress and mediawiki sit there) into the same location on the new box. I navigate to any of the web apps and get complaints about the webapps’ permission being denied because my damn SQL username/password combos are invalid.

So, isn’t this -all-databases trick supposed to dump the entire frigging system state, or does it do everything but users and permissions? If the case is the latter, that is the most asinine, inane thing I have seen in a while.

Or maybe I’m just dumb, tired, old, inexperienced or a mix of them all. Maybe I just forgot to do a FLUSH PRIVILEGES after my import- I dunno.

Leave ideas in the comments. Right now, I must go to sleep and dream about another day sitting behind a desk making money, all the while desiring just to get home to the SO and watch Jeopardy.

Ubuntu 8.10 Again… and Inanis Glass 1.3

I have Ubuntu 8.10 installed again to give SimCity 4 another go. All updates installed, repository Wine installed, unofficial nVidia 180.11 driver installed (because 180.22 killed X so bad I couldn’t even get a tty login. Go figure.) I even got the monitor working pretty quickly. I hacked some stuff that “should” make SC4 run faster.

SimCity 4 still doesn’t run as fast as in Windows. It’s almost passable, but not quite. I’ll keep playing for a week and see what happens.

Oh, and Inanis Glass 1.3 is almost complete. Bugs fixed, features added and translate-ability coming soon. I may even be able to throw in some of the translations for free, with the help of those who volunteered their translation skills, of course.

Oh, and finally – Looks like the Inanis.net server has stabilized. The probable culprit: no swap partition. If it goes down again after this, I swear I am going to blow a gasket.

USB Linux – Device Testing

I wanted to try out a USB linux distro to see if it is useful to me for work/diagnostics/geeking out. Well, I have two devices to use and I wanted to test their performance. I ran SteelBytes HD Speed on both devices, and on my hard drives to get an idea of their respective speeds, so I can choose the right (read: fastest) device. I was surprised not by the USB devices, but by my hard drives. Continue reading