If I create a user without assigning a role to it, the user is created in the database, but when I try to view the users in the "Manage Users page" I can only see the users that have a role assigned to them.
I believe this happens because the Portal application is executing a query, specifically, a query that does an INNER JOIN between the cmsuser, cmsuserroles and cmsroles tables. Because the operation is an INNER JOIN a user that has no role assigned to it (no entries in the cmsuserroles table for the specific user id) will not be returned by the query and it will not show up in the webpage.
So can you try the following commands in the portals privileged shell :
>> mysql -e "SELECT * FROM lrs.cmsusers AS u LEFT JOIN (lrs.cmsuserroles AS ur INNER JOIN
lrs.cmsroles AS r ON ur.roleid=r.id ) ON u.id=ur.uid\G" > /home/ssgconfig/allUsersWithRoles.txt
This is a query that should return all users and if they have any information on the cmsuserroles table attach it to the output.
Also, just to make sure can you also execute this command:
>> mysql -e "SELECT * FROM lrs.cmsusers\G" > /home/ssgconfig/allUsers.txt
Both query should return the missing user.
You can use the following query to add a connection between the missing user (user id=) and the cmsuser role (role id=):
>> INSERT INTO lrs.cmsuserroles(uid,roleid) VALUES (<value>,<value>);
I would suggest you take a backup of the database before you do any direct changes, especially if this is a live production system.