Re: [rt-users] Restoring from backup -> admins lost privileges

[Christian Loos]

This implies that something is wrong with you backups.


Chris

Am 13.02.2015 um 08:04 schrieb Andrew Wippler:
> I had to restore my MySQL database from a backup. Once I restored the RT
> database, the privileged users no longer had rights.
> 
> I found the below snippets to remove/add super user to my account and
> verify privileged users, but they are stuck in self-service mode. How do
> I get the rights returned back to normal?
> 
> Granting rights:
> perl -I/usr/share/request-tracker4/lib/ -MRT -e'RT::LoadConfig; RT::Init;
>   my $u=RT::User->new($RT::SystemUser);
>   $u->Load("awippler");
>   ($val,$msg) = $u->PrincipalObj->GrantRight(Object=> $RT::System, Right
> => "SuperUser");
>   print "$msg\n"'
> 
> Finding privilege users: (my account is listed)
> #!/usr/bin/perl
> use lib "/usr/share/request-tracker4/lib";
> use RT;
> use RT::Users ;
> use warnings;
> RT::LoadConfig(); ## Loading RT config
> RT::Init(); ## Initialise RT
> 
> my $users = new RT::Users(RT_System);
> $users->LimitToPrivileged;
> 
> while ( $user = $users->Next) {
> print $user->Name ;
> }
> exit;
> 
> 
> Andrew Wippler | Director of IT | Lancaster Baptist Church | Dr. Paul
> Chappell, Pastor

[rt-users] Restoring from backup -> admins lost privileges

[Andrew Wippler]

I had to restore my MySQL database from a backup. Once I restored the RT 
database, the privileged users no longer had rights.

I found the below snippets to remove/add super user to my account and verify 
privileged users, but they are stuck in self-service mode. How do I get the 
rights returned back to normal?

Granting rights:
perl -I/usr/share/request-tracker4/lib/ -MRT -e'RT::LoadConfig; RT::Init;
  my $u=RT::User->new($RT::SystemUser);
  $u->Load("awippler");
  ($val,$msg) = $u->PrincipalObj->GrantRight(Object=> $RT::System, Right => 
"SuperUser");
  print "$msg\n"'

Finding privilege users: (my account is listed)
#!/usr/bin/perl
use lib "/usr/share/request-tracker4/lib";
use RT;
use RT::Users ;
use warnings;
RT::LoadConfig(); ## Loading RT config
RT::Init(); ## Initialise RT

my $users = new RT::Users(RT_System);
$users->LimitToPrivileged;

while ( $user = $users->Next) {
print $user->Name ;
}
exit;


Andrew Wippler | Director of IT | Lancaster Baptist Church | Dr. Paul Chappell, 
Pastor