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.
  • 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.)
    • 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. 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.