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
signature.asc
Description: OpenPGP digital signature
--------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016