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.

Minimum Server Specs

• This list needs added to
• OS:
  • Ubuntu 18.x or later (doesn't work with Report Commander)
  • Windows Server 2016 or later
• Ports Opened
  • Incoming TCP 9001 for Portainer/Docker

Required (Every customer server needs the following done)

• 1. MySQL installed and configured.
• 2. MySQL users created.
  • Change the password for the root user (if this hasn't already been done)
  • 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.)
    • Replace function definers with the new MySQL username.
  • HTPServices user.
  • PrintQueue user (we usually name this mysql user auto_reporting).
  • LX user.
  • Email Relay user. (Requires Brian to set up the email relay user first on our end.)
  • OPTIONAL: For ITrack Pro, set up an ITrack Chromium user.
  • If the yard does not currently have a Replikwando user, Brian or Cody will need to create one and permission it to the correct database first. The user should be created on db.isoftdata.com.
• 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.9.0 is our current version. JW 10/2021)
    • MySQL Python Connector (if there is no current installer with it bundled in.) (8.0.26 is our current version. JW 10/2021.)
• 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.