Migrate mysql database to mariadb

RickyDee

Good afternoon everyone, such a question, I have an old ubuntu 16.4 server with osticket 10 installed. I created a new server on ubuntu 22 and installed osticket 18 and I want to transfer the database from the old server to the new one, I exported and imported into the new error server was not present upon import. But when I connect on osticket there is no data. What's the problem or won't it work?

KevinTheJedi

RickyDee

You need to copy over your old include/ost-config.php file to the same folder on the new server. Then you update the MySQL/MariaDB information in that file to match the new server info. Once you do this you can login to osTicket on the new server and you will be presented with the Upgrader.

Cheers.

RickyDee

Thank you, I managed to migrate the database, but now there is another problem, the admin panel / scp does not work, it does not log in, error 500, the page is not accessible, what is causing this problem and how to fix it.
it disappeared after deleting the setep folder, but when you return it, you go into scp
more precisely scp/setting, but a new problem appears when you go to the personnel panel, error 500 appears.

KevinTheJedi

RickyDee

You need to check your error logs for related errors.

Cheers.

KevinTheJedi

RickyDee

By the way, you need to delete the setup/ folder as it's only needed for new installs. Since you just need to upgrade you need to remove the setup/ folder entirely.

Cheers.

ntozier

If you had any authentication plugins installed on the old site... make sure that you also install them on the new site.

RickyDee

Good evening everyone, another question: everything worked out in the test version. Now I started transferring the live database, did the same thing, but it says that the system is offline, how can I turn it on if I can’t access it through the admin panel in the browser?

RickyDee

I have already tried the options to enable via mysql UPDATE ost_config SET isonline='1'; and update ost_config SET value='1' WHERE key=isonline, no errors occurred and the system is still offline

KevinTheJedi

RickyDee

What message do you see specifically and where?

Cheers.

RickyDee

System offline
When you enter https or http mots satst now, in the test version I have my ip-address and enter like http://my ip and the system is written in offline mode, and if I enter http://my ip/scp and enter my login and password it says system offline

KevinTheJedi

RickyDee

You should be logging in as an Administrator. It could be that there is an Upgrade pending which puts the system Offline and requires an Administrator to login and run the Upgrader.

Cheers.

RickyDee

Good evening, I'm completely confused. It turns out I installed a new ubuntu server and installed everything that osticket required. If I create a new database, then through setup I create a new file ost-config.php and everything works fine. But I need a database from the old server, I import it to the new server in mysql, in the ost-config.php file I write the name of the database where I imported the old database in advance. I will provide in ost-config.php the login and password that root has in mysql. But still the database does not connect. It says the system is not available. I'm trying to enter logins and passwords from the old server but it doesn't work. I also tried to create a new administrator user through mysql, but I also can’t log into scp through the browser.
I'm at a dead end and can't understand what exactly I'm doing wrong, don't judge strictly, I just recently started learning Linux.

RickyDee

I log in through http://my ip, it says the system is not accessible, but when I go to http://my ip/scp it asks me to enter a login and password, but to my regret, not a single login and password is suitable and does not log in, maybe you can tell me how Correctly, through the command line or mysql, give or create an administrator user so that I can log into scp. Thank you for your answers and help.

KevinTheJedi

RickyDee

You don’t install and use that new installs config file. You simply unpack and place the new codebase on the new server (do not install), and as I mentioned before you copy the old config file, place it in the include/ folder on the new setup, import your database on the new server, and modify the config file to update any MySQL info that has changed (if any).

Be sure that in MySQL you set the new user you created to use mysql_native_password as the new MySQL authentication method doesn’t work with osTicket.

Cheers.

RickyDee

KevinTheJedi but by the way, I changed the password of the new user using the new system, maybe that’s why it doesn’t work. and the new user needs to be registered in the database or, for example, root who logs into mysql will suffice

KevinTheJedi

RickyDee

Do you mean you changed the MySQL user password? If so then update that in the config file.

If you mean you changed the Agent password then did you do that before or after you dumped the database? If you changed it after dumping then that means the new password is not included in the dump file so you will need to use the old password to login on the new system.

Also, you can use root MySQL user but it’s not recommended long-term and definitely not recommended for production use.

Cheers.