[rt-users] After upgrade 4.0.7 -> 4.2.8 I only see SelfService?

[Patrik Fältström]

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)

   Patrik

On 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! :-(
>
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 203 bytes
Desc: OpenPGP digital signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160508/d8cdc3c3/attachment.sig>