This wiki describes the migration from RHEL6 to RHEL7, but the same procedures can be used to rebuild the VM.
Create a base VM by following the instructions at Making a Red Hat RHEL Virtual Machine from a Base Image
Follow the steps at Apache Security. When requesting the certificate make sure to associate it with all alias' assigned to igppticket.ucsd.edu as well as the name of the development server.
Helpspot requires php 5.6+ and mysql 5.7+
Note: this step is required because our Red Hat satellite doesn't have a repository with these packages. If you are going through this at a later date you should double check if they are available through act-rhns
To install PHP 5.6 we need to install the IUS Community repository (https://ius.io/GettingStarted/)
Install the needed PHP packages
Install the MySQL repository (https://dev.mysql.com/downloads/repo/yum/)
Install the needed MySQL packages
Start and enable MySQL and check to make sure it's properly set
Update the MySQL root user password and complete setup (Check 1Password). The temporary password is located in /var/log/mysqld.log
Create Helpspot database and user and grant permissions (check settings.php for the password). Also increase maximum packet size for database import.
Restart Apache so that it recognizes PHP and MySQL
Increase MySQL log file size. An error can occur on import if an item is greater than 10% of the total log file size.
*** At this point put the current Helpspot server in maintenance mode if you are performing a migration ***
On the previous Helpspot instance
Dump and transfer the database(this may take a while):
Copy the database to the new instance:
Copy the /var/www/html directory to the new instance
On the new Helpspot instance
Temporarily increase the max packet size and import the database
Copy the html files to the /var/www/html directory
Modify the /var/www/html/config.php file to reflect the new hostname, make sure the user and password are correct
Install the IonCube package that Helpspot requires (http://www.ioncube.com/loader_download.php)
Add the following line to the bottom of /etc/php.ini
Navigate to https://hostname.ucsd.edu/loader-wizard.php.
The installer will run, when prompted select that this is a local install.
Once the installation has finished, remove the loader-wizard.php file
Restart the server, navigate to https://hostname.ucsd.edu/admin.php Helpspot should now be installed, make sure the tickets reflect the tickets present on the old server prior to putting it in maintenance mode.