Not able to access admin privileges

[Dharshini]

Infos:

• Used Zammad version:
• Used Zammad installation type: (source, package, docker-compose, …) source
• Operating system: ubuntu
• Browser + version:

Expected behavior:

Able to access admin privileges with admin account, if i’m the admin I used to get the settings option.
*

Actual behavior:

• I’m not able to access the settings option, suddenly access got revoked none having the admin privileges now.

Steps to reproduce the behavior:

• Provide me the solution for the same.

[twonnecke]

Hi Dharshini,

Do you have administrative access to the server (like ssh)?
You should be able to manually add the desired user to the admin group by working on the database layer with rails.
https://docs.zammad.org/en/latest/admin/console/working-on-users.html#set-admin-rights-for-user

[Dharshini]

Hello twonnecke,

Yes I do have the admin privileges to login to the server(SSH).
I’m using operating system ubuntu 20.04, Could you please let me know how can do this?

Regards,
Dharshini

[twonnecke]

Hi Dharshini,

Please make sure to have a backup ready as we’re working on database layer. I’m not a member of the Zammad service team, just a regular IT admin, so you will be doing changes on your own risk.

Connect to your server using Putty and login as admin.
Access rails console by issuing command and find your user:

admin@ticket:~$ sudo zammad run rails c
[sudo] password for admin:
Loading production environment (Rails 6.1.7)
irb(main):001:0>

Find your user by login name (you could use lastname or email address to) and check that this is your user

irb(main):02:0> User.find_by(login: "enter your login name here")
=>
#<User:0x0000..........
 id: 296,
 organization_id: nil,
 login: "your login name here",
 firstname: "System",
 lastname: "Administrator",
 email: "system.administrator@email.de",
 ............

When you’re sure this is your user, issue following commands to add the user to Admin group only

irb(main):003:0> u = User.find_by(login: "enter your login name here")
=>
#<User:0x0000..........
...
irb(main):004:0> u.roles = Role.where(name: "Admin")
=>
[#<Role:0x0000..........
...
irb(main):005:0> u.save!
=> true

You now have administrative access only to Zammad.

Best regards

[MrGeneration]

Here’s the full scope from our documentation:
https://docs.zammad.org/en/latest/admin/console/working-on-users.html#set-admin-rights-for-user

Above approach will remove all roles configured to the user and might not be what you want.

[twonnecke]

That’s absolutely true. I thought I made this clear by “You now have administrative access only to Zammad” but I guess this might be read over quickly. Thanks for pointing this out.

[Dharshini]

Hi,

I’m using postgres db in my zammad how Can I achieve this?

[twonnecke]

By accessing the rails console:

sudo zammad run rails c

Then you have access to the database entries for zammad and can edit them with the help of the documentation posted by @MrGeneration.

[Dharshini]

Thanks much!! I’m able to resolve the issue.