I have to move the ostickets database to a different server/mysql installation. I've copied the database, and changed all the connection parameters, yet I am unable to login to ostickets from the new database. I expect it has to do with "define('SECRET_SALT','H0haklsdkja.....dskl;dsafkjlD');" in the configuration file, but can find no way to regenerate that to work with then new mysql server that the database is on (presuming that's the problem)
do you have the old config file?Just user that and update the db username, db password, and db name.If you do not... then you will have to reset the admin accounts password manually and then you will be able to update the rest for other users in the admin panel.http://www.tmib.net/content/recover-reset-admin-account-passowrd-osticket
Stupid question, but how did you transfer/copy the database?
Asking since I would do this the following way:
- Export the existing database (e.g
via the command line or phpmyadmin)
- Import the database on the new server
- Lookup the username and password info for the database connection from /include/ost-config.php
- Recreate the same user on the new MySQL server and grant access for the imported database
- Create a copy of the osTicket installation directory
- Change the /include/ost-config.php in the copy and point to the new server
- Done.
Note, I have not yet done this myself with different servers, but that's kinda my procedure to setup a copy from our live osTicket system on the same server.
God I feel stupid...due to an earlier problem of the software not being able to create ost_ticket__cdata , I had copied that table from my test machine, and was copying structure only (God I'm an idiot)But, on a different note, the reason I was doing this is because osTickets can't run on a database that is using Replication.CREATE TABLE ... SELECT is forbidden when ENFORCE_GTID_CONSISTENCY = 1.
