I went to do a blog entry last night.
And I couldn't log into the ol' blog here.
Which freaked me out. First thought, Hackers! Damn Hackers always messing with folks.
Nope, not hackers. The server was fine and so was the database.
Trouble shooting time.
Suspect #1, What changed recently?
Answer: I had installed a user profiles plug-in, testing it here before using it on the
Jaduka Blog. Well, I didn't like the results, so I un-installed it. That had to be what caused the problem. The user profile plug-in, fscked something up. Right?
I began by making a copy of my blog directory, in case I messed something up while trying to 'hack the gibson' here.
I then copied the 'include' directory from
Gina's Blog over my 'include' directory. Hoping that would fix it.
Nope, didn't fix it.
Now, I had to roll up my sleeves and look at the files themselves.
I started by tracking down how exactly
Serendipity handles login. I added some debug statements, and found that the SQL it was running was perfectly good. (Mind you I ran that exact SQL against the wrong database, so yeah, let me wipe the egg off my face.)
I decided that I needed to connect to the DB directly, so I commented out the serendipity_db_query function and wrote my own.
Nope, still the same thing. No login love.
Finally, I decide to just hack the login routine, and force the login of my user. Thinking that maybe if can at least login, I can make a new user. Uncomment the forced login, and see if that fixes it.
That worked. I was able to force the login and create a new user.
In doing so I looked at my old user. Hey, the username is wrong.
Apparently while I was dorking around with the userprofile plugin I modified my user record and had reversed the username and my real name that I use on this blog.
That is what made me notice that I was looking at the wrong database. (Wiping even more egg off my face.)
In the end, it was not the un-install, nor was it malicious hackers.
IT WAS USER ERROR.
I am human, I make mistakes (though not often).
At least I now have a slightly better understanding of the inner workings of Serendipity. Which will help when Buddha and I start coding plug-ins.
Laterz