Osticket migration to Debian 12

ceantuco

Hi,
I migrated our OSticket installation from Debian 10 to Debian 12 by exporting the database from old server to new server and copying all files from old server /var/www/html/osticket to new server /var/www/osticket. Gave the proper permissions.
I am able to login to the new server as admin; however, if I try to click on closed tickets, it just sits there for a minute and then the page refreshes; however, it does not take me to closed tickets. Also, if I click on 'Admin' panel and then I tried to click on 'Agent Panel' , the screen freezes and then it stays where I am.
Please see attached server config.
I had a similar issue back in 2021 when I attempted to migrate from CentOS 8 to Debian 11. I ended up migrating to Debian 10 which worked without issues.
Thanks for your help!

KevinTheJedi

ceantuco

Sounds like your new database is struggling to run a query or you have a fatal error. Check your PHP/webserver error logs for any related errors. If no errors then enable your MySQL slow query logs to see if it’s a long running query. If that’s the case then you need to look at older threads like this:

https://forum.osticket.com/d/104376-tickets-list-sql-query-hangs

Typically migrating to MySQL 8.0+ is the quickest resolution.

Cheers.

ceantuco

Hi Kevin,
Thanks for your reply. the current version of MySQL is 10.11.4. the old server runs 10.3.39 without issues.
Do you recommend using Ubuntu instead of Debian? This is the second time I try migrating to the latest version of Debian and I encounter this issue.
I will check the logs and the link you provided.
See old server config:

Thanks!

KevinTheJedi

ceantuco

MySQL doesn't have a version 10.x (yet); I assume you have MariaDB installed. So the first recommendation would be to switch to MySQL 8.0. If that doesn't work then you can try the other steps listed in the referenced thread(s).

Cheers.

ceantuco

Thanks for your reply Kevin. Which distro do you use to run osTicket?
Please advise.
Thank you!

KevinTheJedi

ceantuco

Any really. Traditionally I used CentOS Stream 9 but nowadays I use Ubuntu. It’s just a matter of personal preference.

Cheers.

ceantuco

Thanks!

ceantuco

@KevinTheJedi I reverted back to a snapshot before installing MariaDB and installed Mysql on Debian 12.
I have no issues loading closed tickets or browsing from admin panel to agent panel.
Thanks! Hopefully Oracle will keep MySQL free forever.

KevinTheJedi

ceantuco

I know right?! Idk why MariaDB is so shit out of the box compared to MySQL.. seems like you have to do a lot of optimizing, config changes, etc. for MariaDB nowadays. But could just be issues with certain OS, etc. so who knows.

Cheers.

ceantuco

yeah it sucks! it is weird because mariaDB worked with osTicket with Debian 10 but it slowed down with Debian 11 and 12. who knows but thanks! 🙂