After migrating to new server User no longer has queues or Admin privledges

[ios]

I'm a bit at my wits end and here as a bit of last resort.

We have OTRS5 on an old Ubuntu 14 server and would like to migrate it to something more modern (Ubuntu 24) before we upgrade OTRS.

I got the apache, users, and MYSQL all set up. I run the backup script on the old server (get about 315GB in files) and then run the restore script on the new server. The database looks like its populated, I can login no problem but when I get in, I only l see the 3 specific tickets assigned to me so I now tickets are in there but I'm no longer assigned any queues and my admin permissions have dissapeared.

I've also ran:
# su - otrs
$ cd /opt/otrs/bin
$ ./otrs.Console.pl Maint::Config::Rebuild
$ ./otrs.Console.pl Maint::Cache::Delete
$ exit

and restarted apache.

Can anyone help provide how to rebuild the user permissions? We have quite a few and I would rather not do this manually if I don't have to.

any help would be appreciated.

[root]

Hi,

If the admin permission disappears, you have probably installed MySQL 8.0 or newer. Support for this version starts with Znuny 6.1

- Roy

[ios]

That is correct. It is the latest MySQL.

So do I upgrade my migrated OTRS to Znuny 6.1? and I'll have all my users with the right permissions back?

[root]

That is correct. It is the latest MySQL.

So do I upgrade my migrated OTRS to Znuny 6.1? and I'll have all my users with the right permissions back?

Technically, yes, but you can't upgrade the system with MySQL 8. Switch to MariaDB or an older MySQL version like 5.7 until you're at Znuny 6.1

- Roy

[ios]

Ok, I think I understand. So this is what I believe my upgrade path should be:

Origial OTRS5 (on Ubuntu14) -> Migrate to New Server OTRS5 (on Ubuntu 24.04 - with MariaDB)

After I get above working I can do the following:

New Server OTRS5 (on U24.04 w/ Maria DB) -> upgrade to Znuny 6.1 (MariaDB)

That's essentially my goal is to upgrade to Znuny 6.1 but since we have to train people on the new interface I want to do this in stages. I guess technically once I have Znuny6.1 I can migrate all data to MySQL? but would there really be a reason to if I have everything working?

[root]

Ok, I think I understand. So this is what I believe my upgrade path should be:

Origial OTRS5 (on Ubuntu14) -> Migrate to New Server OTRS5 (on Ubuntu 24.04 - with MariaDB)

After I get above working I can do the following:

New Server OTRS5 (on U24.04 w/ Maria DB) -> upgrade to Znuny 6.1 (MariaDB)

Yes, but the upgrade path is OTRS 5 => Znuny 6.0 => Znuny 6.1

I guess technically once I have Znuny6.1 I can migrate all data to MySQL? but would there really be a reason to if I have everything working?

This will work.

But I would at least upgrade to Znuny 6.5 since this is the current Long Term Version.


- Roy