New server installation checklist

Use this page in conjunction with the MySQL Server installation guide as a checklist for all the things our customers might need when setting up a new server.

Required (Every customer server needs the following done)

• 1. MySQL installed and configured.
• 2. MySQL users created.
  • Regular MySQL User. Replace the testuser account if it exists with an appropriately secure one. (Client workstations will need the new credentials as well if an old password is being upgraded.)
  • HTPServices user.
    • Replace function definers with the new MySQL username.
• 3. Replikwando current stable version and configuration.
• 4. Image Synch and configuration.
  • Python 3.xx (if there is no current installer with it bundled in.) (3.4.3 is our current version. JW 6/2017)
    • MySQL Python Connector (if there is no current installer with it bundled in.) (2.0.4 is our current version. JW 6/2017.)
• 5. Attachment Manager (Pro or Enterprise) and configuration.
• 6. SQLYog Community.
• 7. Import pre-existing data OR set up new Pro (Auto/Truck/MX), Enterprise or Presage database.
• 8. Create necessary Windows scheduled tasks (Image Synch primarily.)
• 9. Tortoise SVN. (Many of our services now rely on it to get updated efficiently.)
• 10. PHP Rolling Backups

Optional (If the customer/we require it)

• 1. Put a primary installation (Pro, Enterprise, Presage) on the server, either for our use or if the customer purchased one and wants it there.
• 2. Quickbooks, Quickbooks SDK, QBFC. Configuring Quickbooks gets done at a later date.
• 3. WAMP (if they use LX Pro, LXW or Workclock) and configuration.
• 4. LX Pro or LXW (a.k.a ITrack Mobile) and/or Workclock, and configuration.
• 5. Report Commander/Print Queue.
• 6. OpenVPN (if they require our VPN solution.)
• 7. MySQL supported components (PHP Rolling Backups, UDF Thumbnailer)
• 8. Car-part for Auto Yards and configuration.

Nice to have (These aren't required but can be helpful in doing our jobs)

• 1. 7-zip.
• 2. Notepad++.
• 3. Unlocker.
• 4. Malwarebytes.

Once these steps are completed, please proceed to the Customer Deployment article (pending) to finish the customer deployment.