After upgrade 4.0.7 -> 4.2.8 I only see SelfService?

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! :frowning:

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)

Btw, this might also be interesting…As you can see I think things should work for user “paf”, but only the SelfService web page is visible. Why?

mysql> select Groups.Name, Groups.id, Users.id, Users.Name from Users, Groups, GroupMembers where Groups.Name = “Privileged” and Groups.id = GroupMembers.GroupId and GroupMembers.MemberId = Users.id;
| Name | id | id | Name |
| Privileged | 4 | 12 | paf |
| Privileged | 4 | 30 | eva |
| Privileged | 4 | 1310 | billing |
| Privileged | 4 | 4282 | john |
| Privileged | 4 | 213790 | anders |
5 rows in set (0.76 sec)

PatrikOn 7 May 2016, at 16:26, Patrik Fältström wrote:

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! :frowning:

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

RT 4.4 and RTIR Training Sessions https://bestpractical.com/training

  • Washington DC - May 23 & 24, 2016

signature.asc (203 Bytes)