Hi,
I upgraded my Debian system from Wheezy to Jessie, and as part of the RT4 was upgraded from 4.0.7 to 4.2.8.
I did the update of the database which worked without any errors, but when I log in I only see the SelfService.
So it seems I have lost my power!
I have seen one post from a person that had a similar error, but that âresolved itselfâ after he logged in as root, which I can not do as I do not have any root user. I.e. I only know of the user of myself (âpafâ) that should have all rights possible.
I try to find out what in the database I must change to get this power back, but do not understand. Things looks good where I look.
What I found was this:
http://www.gossamer-threads.com/lists/rt/users/128641
The closest information abut users in the database I can find here:
http://requesttracker.wikia.com/wiki/RecoverRootPassword
Here is btw information about âmyselfâ and my system:
mysql> SELECT * FROM Users WHERE Name=ârootâ;
Empty set (0.00 sec)
mysql> select id,name from Users where name = âpafâ;
| id | name |
| 12 | paf |
1 row in set (0.00 sec)
mysql> SELECT * FROM Principals WHERE id=12;
| id | PrincipalType | ObjectId | Disabled |
| 12 | User | 12 | 0 |
1 row in set (0.00 sec)
mysql> SELECT * from Groups, GroupMembers where GroupMembers.groupid = Groups.id and Groups.name = âPrivilegedâ and GroupMembers.memberid = 12;
| id | Name | Description | Domain | Type | Instance | Creator | Created | LastUpdatedBy | LastUpdated | id | GroupId | MemberId | Creator | Created | LastUpdatedBy | LastUpdated |
| 4 | Privileged | Pseudogroup for internal use | SystemInternal | Privileged | 0 | 0 | NULL | 0 | NULL | 7 | 4 | 12 | 0 | NULL | 0 | NULL |
1 row in set (0.00 sec)
Patrik
signature.asc (203 Bytes)