Last weekend, as I believe I mentioned, I got a bill from my ex-webhost, and decided that I wouldn’t be using their services any longer.
(It’s been an expensive month for computing, I fear. I had to pay the registration for yarinareth.net this month too, and I sprang for the cost-efficient seven-year deal. Then there’s the Netgear router that decided it didn’t want to work with my machines. Then hosting on top of that. Ouchies.)
I found a new host, signed up, and got the party rolling. Next day at work? I was having a really swell day browser-testing (everything except the font sizes worked in IE/Win, first go! how often does that happen?) when suddenly the browse-authors page died for no obvious reason.
Fixed that. (Part of learning a new system is learning where to look when things break. I’m definitely getting a crash course in that.) Then I hopped onto the admin pages in an idle moment, and suddenly my inbox was filling up with panic-button messages from DSpace.
It was a PostgreSQL problem. I know nothing of this PostgreSQL of which you speak. My boss good-humoredly shook a finger at me as he left and said “You better have that fixed by tomorrow morning!” I had an hour remaining in my workday. I assented, dubiously (knowing full well he didn’t mean it).
But I tell you what, I had that sucker fixed in another half-hour. Go me. Did you know that PostgreSQL commands have to be terminated in semicolons? ’Cuz I didn’t.
Got home to find a wireless cable router waiting for me. Nifty! Set it up. Connection between Macs and router kept dying. Not so much with the nifty. So I borrowed a router the next day, grinding my teeth rather, and damn if the same problem didn’t keep happening. This got me beyond tooth-grinding all the way to “the only thing keeping this machine from defenestration is the expense of replacing it.” I could jury-rig things such that David’s wireless-challenged G4 was the only machine in the house without access, and so I did.
But I am getting ahead of myself. As soon as I signed up for the new webhost, I promptly toddled over to ex-webhost’s CPanel and started downloading blog databases. Then I switched the DNS over to the new host. I got Li’s blog back up and running, for which Li was grateful, but then she asked, “So where did my August posts go, exactly?”
Er. What, now? I popped into phpMyAdmin and took a look. All the blog databases cut off cold after July 12. The blogs themselves were fine. Ergo, the blogs were not pointing to the same databases that CPanel and phpMyAdmin were. QED. No way I could check out the problem myself, much less fix it; my ex-hosts didn’t offer shell access.
I opened a support ticket. My ex-hosts took nearly three days to resolve it (though in their defense, the higher-up support guy I was eventually referred to was very polite and helpful), me chewing my fingernails to approximately my armpits the while. (Oh, hush up. Some of these DSpace posts are going to be fodder for an article soon, I think. Don’t want to lose them.)
Yes, indeed, they’d forgotten to move DNS pointers for the databases to the new machine. Here are your databases back, and thank you for your patience.
Whew.
A lot of search sweat today (mostly not through Google) found some band-aid fixes for my router problems, and so far things seem to be good. (Hold that thought, though. When the entire network stays up for 24 hours at a time? I’ll call it fixed.) Once I turn CavLec’s design into an actual WordPress theme (which I’ve been procrastinating on for months, but now I have to, because this green thing is just depressing), all should be well. Everybloggy else in the yarinareth.net universe is getting along fine (or if not, I haven’t heard about it).
Been a bad, bad week for me and computers, though. “AUGH! I HATE COMPUTERS!” I howled to Adrian in IM the other day.
“Congratulations, you have now achieved the base state of any good server administrator,” he told me. Yay. Or something.