Inanis.net

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!

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.

My CoLo changed their network configuration last night and took down my server for an extended period of time. The server was functional the entire time, but simply inaccessable due to network changes. It’s obviously working now. Sorry about that, I didn’t know it was going to happen, otherwise I would have worked with them to mitigate the issue.

In other news, I updated my Wiki software a week or so ago for the Computer Museum and Lego thing to fix some security issues in the software. What I forgot to do was to put back in the setting that prevents unregistered edits from the Wikis . .. and then they got spammed by WikiSpamBots. I put the setting back and removed the spam. Meh.

Life goes on. We live, we learn.

Updated the wiki codebase on Inanis.net to the newest version, just in case that’s the cause of my outages. I also got some of the network equipment where the server lives replaced, so if all is good, the site shouldn’t go down again. But, I’ve said that before so we shall see.

Inanis.net is now running WordPress 2.7, in case anyone wanted to know. I am sorry I haven’t gotten to any of the comments or email lately More »