I have been trying full time for the last few days to "migrate" osTicket from one Synology to another. I understand it should be relatively simple. The hardware is identical. The version of osTicket is identical. I have tried to set things up as closely as possible between the old and new Synology backend, keeping paths and plug-ins the same. I have at least two hurdles. 1. The root sql password is not the same between the two (and I don't understand if there is anything that is specifying the password in osTicket (per step 5 above)). 2. Importing the 522MB osTicket.sql database using phpMyAdmin keeps timing out. It says that it will pick up where it left off, but there has to be a better way. (I've been resuming the import over and over for hours.)
step 1 - is done.
step 2 - seems ok. (if I install a fresh copy of osTicket, it redirects me to the setup page.)
step 3 - I've saved the osTicket folder and overwritten the same on the new host
step 4 - I exported osTicket.sql (522 MB). As mentioned above, importing it seems to be a losing proposition. Maybe it is working, but there is nothing other than messages like, "Previous import timed out, after resubmitting will continue from position 344919620." I have no idea how to tell how many "positions" are left.
step 5 - root was the user on the old install, but, as mentioned above, the password are different. There was apparently a complexity requirement change since we originally installed osTicket on the old host. I do think that the "new" root user has access to the SQL, since it is the same account that is being used for the import.
step 6 - trying it with the partial SQL import results in things like, "405 Not Allowed" , "Error: Contact system admin" , or just a plain old "HTTP Error 500".
