Hi Forum,
Today I tried to update our live system osTicket, version 1.14.3, to the current stable version 1.18.1.
Here's what I did:
Exported the database from the old system using MySQL Dump.
Set up an Ubuntu 22.04 Linux server following this guide:
https://computingforgeeks.com/how-to-install-osticket-on-ubuntu-linux/.
I performed the initial setup just like I did five years ago when I first set up osTicket, using the same admin user, the same database name, the same database owner, and the same password. I just did not yet log in for the first time, with the new admin user.
- To import the mySQL-dump, I ran the following MySQL commands: "use osticket; --> source /path/to/file.sql;"
Now, when I try to log in with my admin user at "http://Server-IP/scp/login.php", I get stuck at the login screen.
I enter my username and password, click "Log In," "Verify" briefly appears for half a second, and then the input fields are empty again.
When I go to "http://Server-IP," it says "System is offline." I've tried the suggested database check ("isonline=1") in the forum, but it didn't improve the situation.
Before that, I had a problem with access rights to the mysql DB --> I created a user 'root' for MariaDB and gave it a secure PW. The user for the osticket-DB is named "osticket-owner". So after I imported my old mySQL-dump, I tried to login at "http://Server-IP/scp/login.php", which just showed "Not Found; The requested URL was not found on the server.
I also granted both 'root' and 'osticket-owner' in MariaDB "SUPER and PROCESS ON . TO 'both users'@'localhost';
Then I changed the corresponding entries in "...\include\ost-config.php", so now, at least, the login screen is shown.
Do you have any ideas on what I could try?
