Hi all, I have a Linux server in which OST v1.9.12 is running but now I need to migration this whole OST along with its MySQL database from LINUX to Windows Server 2016. Can anyone please provide me all the steps that how I can do this Migration successfully on windows server. If possible please share any informative video or document or any other portal/discussion links.
OST Migration from Linux to Windows Server 2016
Migrating osTicket from one server to another is relatively easy, but there are a few sticking points. At this point we assume that you already have a webserver setup and serving an empty site, and have PHP and MySQL/Maria installed.
- Back up the old database. You can do this in a number of ways, but the easiest is to simply export the database.
- Back up the old site files. You can do this a number of ways also, but if it were me I would SFTP into the server and download the site files.
note: if you are running the Attachments::Filesystem this step can take a significant amount of time depending on the number of attachments. - If you haven't yet, make sure that your webserver on the new Windows server works. You should at this point make sure that you have enabled the extensions that osTicket needs. You can look at the Admin panel -> Dashboard -> Information to get a list. In Windows you enable these in the php.ini file. You can check php by making a test.php and in it putting
<?php phpinfo(); ?>and then browsing to the site/test.php in a web browser. - Setup your DB User, and create the database. IF you use the same username/password, and database name you can save some time here. Make sure that you grant privileges to the new user to the database.
- Import the database from the backup you made.
- Put the site files into the new site from your site back up you made.
- Once they are there, try browsing to the site.
At this point the migration should be done. IF you have any issues check your PHP and [unknown] webserver error logs and report them here.
ntozier Hi Thanks for the response. But let me tell you one thing I don't have much knowledge in Migration so can please guide me or tell me the steps that how to take Backup up of the old database and site and also want to know how to import that database backup into my new server database. I have created a Windows 2016 Server and installed PHP on it along with Maria DB.
So, I need more help from you in Step No. 1, 2, 5, 6 & 7. Thanks again in advance.
If it were me I would:
On the Linux box you would use mysqldump to drop the db to a file. Open a command prompt and
mysqldump -u [username] –p[password] [database_name] > [dump_file.sql]
The parameters of the said command as follows:
[username] - the databases MySQL username.
[password] - the MySQL password for the user.
[database_name] - the Database name you want to take backup.
[dump_file.sql] - The name of backup dump file you want to generate. I usually use databasename_YYYYMMDD.sql.
On the windows server install MYSQL Workbench (from mysql). Transfer the .sql file you created from the Linux box to the Windows box. Launch MySQL Workbench, connect to the MySQL instance, and then click import. Select the file. (see MySQL workbench documentation or Google for more information.)
ntozier Hi Thanks for the support and as per your instructions I have imported MySQL database from Linux machine to Windows Machine and now I have copied OSTicketing php code folder in my Windows Server machine but now while am opening a login.php page am getting this error i.e.:
failed to connect to mailserver at localhost port 25 verify your smtp and smtp_port setting in php.ini or use ini_set()
Please help me on this. Thanks in Advance.
You appear to have your email configured to use localhost to send emails.
You would need to update your email config to use a mail server.
@ntozier#116048 I think so, Can you please guide me to configure mail server.Go to: Admin panel -> Emails -> Emails
Click on the email you want to configure.
Enter the settings for your mail sever.
Click Save Changes button.
5 days later
- Edited
ntozier I think so, Can you please help me about this more. As am not able to do this mail server configuration. Also wanted to know where to change is mail server setting on OST php code or in Windows server which am using to configure OST.
moderator note (ntozier): post edited to remove bad formatting.
ntozier I cannot do this as the OST application is not opening due to this error am getting this error on my login screen
You mention an error, but have not provided us with what it is.
ashutoshthakur3 Also wanted to know where to change is mail server setting on OST php code or in Windows server
To configure mail at the PHP level you would look at your PHP.ini for the section mail settings.
It is usually labelled [mail function]
The directives are SMTP, smtp_port,sendmail_from, and mail.add_x_header in the default php.ini that comes with PHP.
ntozier Hi Please find below screenshot even after setup of mail server on my windows server am still getting this error message on my login screen. Request you to please help me on this and tell me how to know the actual error behind this and resolve this.
Am not able to trace this error as there is no PHP Error Log generated for this.
There has to be an error some where.
If you do not see anything in the PHP error log, then check your webserver and mysql error logs
a month later
Hi Thanks for the help you provided. Now finally I have successfully Migrated my ongoing OSTicketing system from Linux to Windows. But now we need two helps 1st is I want to integrate MS Active Directory for user login and 2nd is how to Implement and create CRON Jobs to fetch mails from gmail.
Here I want to implement both these thing on my Windows Server. Request you to please help me on this.
ashutoshthakur3
Take a look at this post, it's little dated but it's same process for LDAP:
https://tmib.net/osticket-1-8-1-how-to-configure-the-ldap-authentication-and-lookup-plugin/
For CRON Job:
Create a .bat file
add to task scheduler whatEverYour.bat file.
C:\Program Files\PHP\YourPHPversion\php.exe -f c:\inetpub\YourOSticketPath\api\cron.php