New server installation checklist - Revision history

Nenjin at 21:01, 7 December 2021

2021-12-07T21:01:20Z

← Older revision		Revision as of 16:01, 7 December 2021
Line 15:		Line 15:

	== Required (Every customer server needs the following done) ==		== Required (Every customer server needs the following done) ==
	*1. MySQL installed and configured.		*1. MySQL installed and configured. [https://wikido.isoftdata.com/index.php?title=Internal:MySQL_Server_Install Relevant wiki article.]
	*2. MySQL users created.		*2. MySQL users created.
	** Change the password for the root user (if this hasn't already been done)		** Change the password for the root user (if this hasn't already been done)
Line 26:		Line 26:
	** '''OPTIONAL''': For ITrack Pro, set up an ITrack Chromium user.		** '''OPTIONAL''': For ITrack Pro, set up an ITrack Chromium user.
	** If the yard does not currently have a Replikwando user, Brian will need to create one and permission it to the correct database first. The user should be created on db.isoftdata.com.		** If the yard does not currently have a Replikwando user, Brian 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.		*3. Replikwando current stable version and configuration. [https://wikido.isoftdata.com/index.php?title=Internal:Replikwando/Installation Relevant wiki article]
	*4. Image Synch 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)		** Python 3.xx (if there is no current installer with it bundled in.) (3.9.0 is our current version. JW 10/2021)
Line 40:		Line 40:
	*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.		*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.		*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.		*3. WAMP (if they use LX Pro, LXW or Workclock) and configuration. [https://wikido.isoftdata.com/index.php?title=Internal:Installing_WAMP Relevant wiki article.]
	*4. LX Pro or LXW (a.k.a ITrack Mobile) and/or Workclock, and configuration.		*4. LX Pro or LXW (a.k.a ITrack Mobile) and/or Workclock, and configuration. [https://wikido.isoftdata.com/index.php/Internal:Installing_the_LX_Enterprise_Framework Relevant wiki article.]
	*5. Report Commander/Print Queue.		*5. Report Commander/Print Queue.
	*6. OpenVPN (if they require our VPN solution.)		*6. OpenVPN (if they require our VPN solution.)
Line 52:		Line 52:
	*3. Unlocker.		*3. Unlocker.
	*4. Malwarebytes.		*4. Malwarebytes.

			== Finishing Up ==
			If this new server is replacing an old one, make sure to:
			*1. Stop the MySQL service and set it to "Disabled" in the Windows Services menu.
			*2. Stop the Replikwando Service and set it to "Disabled" in the Windows Services menu.
			*3. Stop the wampapache64 Service set it to "Disabled" in the Windows Services menu.
			*4. Stop the Image Synch and RPK scheduled tasks in Windows Scheduled Tasks and set them to "Disabled."
			*5. Remove the Report Commander license from the old server so it can be activated on the new one.

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

Nenjin: /* Minimum & Recommended Server Specs */

2021-10-08T20:59:33Z

Minimum & Recommended Server Specs

← Older revision		Revision as of 15:59, 8 October 2021
Line 7:		Line 7:
	*** Minimum CPU: Duo-Core at 2.4ghz.		*** Minimum CPU: Duo-Core at 2.4ghz.
	*** Recommended CPU: Quad-Core at 2.4ghz.		*** Recommended CPU: Quad-Core at 2.4ghz.
	*** Minimium Memory: 8 gigs		*** Minimium Memory: 8 gigs.
	*** Recommended Memory: 16+ ~~Gigs~~		*** Recommended Memory: 16+ gigs.
	*** Minimum Harddrive: 200 gig HDD.		*** Minimum Harddrive: 200 gig HDD (Pro) or 500 gig HDD (Enterprise.)
	*** Recommend Harddrive: 500 gig SSD.		*** Recommend Harddrive: 500+ gig SSD.
	*Ports Opened		*Ports Opened
	**Incoming TCP 9001 for Portainer/Docker		**Incoming TCP 9001 for Portainer/Docker

Nenjin: /* Required (Every customer server needs the following done) */

2021-10-08T20:56:55Z

Required (Every customer server needs the following done)

← Older revision		Revision as of 15:56, 8 October 2021
Line 25:		Line 25:
	** Email Relay user. (Requires Brian to set up the email relay user first on our end.)		** 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.		** '''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.		** If the yard does not currently have a Replikwando user, Brian 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.		*3. Replikwando current stable version and configuration.
	*4. Image Synch and configuration.		*4. Image Synch and configuration.

Nenjin: /* Minimum Server Specs */

2021-10-08T20:56:34Z

Minimum Server Specs

← Older revision		Revision as of 15:56, 8 October 2021
Line 1:		Line 1:
	Use this page in conjunction with [http://wikido.isoftdata.com/index.php/MySQL_Server_Install the MySQL Server installation guide] as a checklist for all the things our customers might need when setting up a new server.		Use this page in conjunction with [http://wikido.isoftdata.com/index.php/MySQL_Server_Install 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 ==		== Minimum & Recommended Server Specs ==
	*This list needs added to
	*OS:		*OS:
	**Ubuntu 18.x or later (doesn't work with Report Commander)		**Ubuntu 18.x or later (doesn't work with Report Commander)

Nenjin: /* Minimum Server Specs */

2021-10-08T20:56:09Z

Minimum Server Specs

← Older revision		Revision as of 15:56, 8 October 2021
Line 6:		Line 6:
	**Ubuntu 18.x or later (doesn't work with Report Commander)		**Ubuntu 18.x or later (doesn't work with Report Commander)
	**Windows Server 2016 or later		**Windows Server 2016 or later
			*** Minimum CPU: Duo-Core at 2.4ghz.
			*** Recommended CPU: Quad-Core at 2.4ghz.
			*** Minimium Memory: 8 gigs
			*** Recommended Memory: 16+ Gigs
			*** Minimum Harddrive: 200 gig HDD.
			*** Recommend Harddrive: 500 gig SSD.
	*Ports Opened		*Ports Opened
	**Incoming TCP 9001 for Portainer/Docker		**Incoming TCP 9001 for Portainer/Docker

Nenjin: /* Required (Every customer server needs the following done) */

2021-10-08T16:45:58Z

Required (Every customer server needs the following done)

← Older revision		Revision as of 11:45, 8 October 2021
Line 23:		Line 23:
	*3. Replikwando current stable version and configuration.		*3. Replikwando current stable version and configuration.
	*4. Image Synch 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~~)		** 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.) (2.0.4 is our current version. JW 6/~~2017~~.)		*** 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.		*5. Attachment Manager (Pro or Enterprise) and configuration.
	*6. SQLYog Community.		*6. SQLYog Community.

Rmccown: added server specs

2019-11-19T14:18:13Z

added server specs

← Older revision		Revision as of 09:18, 19 November 2019
Line 1:		Line 1:
	Use this page in conjunction with [http://wikido.isoftdata.com/index.php/MySQL_Server_Install the MySQL Server installation guide] as a checklist for all the things our customers might need when setting up a new server.		Use this page in conjunction with [http://wikido.isoftdata.com/index.php/MySQL_Server_Install 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) ==		== Required (Every customer server needs the following done) ==

Nenjin at 16:20, 29 October 2019

2019-10-29T16:20:48Z

← Older revision		Revision as of 11:20, 29 October 2019
Line 6:		Line 6:
	** Change the password for the root user (if this hasn't already been done)		** 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.)		** 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.		** HTPServices user.
	*** Replace function definers with the new MySQL username.
	** PrintQueue user (we usually name this mysql user auto_reporting).		** PrintQueue user (we usually name this mysql user auto_reporting).
	** LX user.		** LX user.

Codeman: Added some info about mysql users that need to be set up

2019-10-29T16:17:10Z

Added some info about mysql users that need to be set up

← Older revision		Revision as of 11:17, 29 October 2019
Line 4:		Line 4:
	*1. MySQL installed and configured.		*1. MySQL installed and configured.
	*2. MySQL users created.		*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.)		** 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.		** HTPServices user.
	** PrintQueue user.		*** Replace function definers with the new MySQL username.
			** 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.)		** Email Relay user. (Requires Brian to set up the email relay user first on our end.)
	*** ~~Replace function definers with~~ the ~~new MySQL username~~.		** '''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.		*3. Replikwando current stable version and configuration.
	** 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.
	*4. Image Synch 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)		** Python 3.xx (if there is no current installer with it bundled in.) (3.4.3 is our current version. JW 6/2017)

Nenjin at 15:57, 29 October 2019

2019-10-29T15:57:55Z

← Older revision		Revision as of 10:57, 29 October 2019
Line 10:		Line 10:
	*** Replace function definers with the new MySQL username.		*** Replace function definers with the new MySQL username.
	*3. Replikwando current stable version and configuration.		*3. Replikwando current stable version and configuration.
			** 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.
	*4. Image Synch 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)		** Python 3.xx (if there is no current installer with it bundled in.) (3.4.3 is our current version. JW 6/2017)