I was trying to find a way to remove a user from a Roller blog server. The Roller Web interface seemed a bit confusing, and didn't give me a clue how to remove a user. This led me to try to remove the user directly from the Roller database. I connected to the remote Roller database using SSH and OpenOffice/LibreOffice Base, as shown in the previous post. Now I have a direct access to Roller tables and records in the remote MySQL database.
I opened every table and only found two tables that seem related to user records. They are rolleruser and userrole. To remove a user, I did these things as follows.
- Remove the record from the userrole database that are related to the user you want to remove.
- Remove the record from the rolleruser database that are related to the user you want to remove.
Warning: directly manipulating Roller database may screw your blog(s). Luckily, I am just starting to set up a Roller blog server, so I don't have many blog posts there yet. Check your blog on the Web after you removed the user from database.