Initial Installation - Revision history

Anw: Added details of Easysoft ODBC-ODBC Bridge Installation

2018-06-20T10:29:09Z

Added details of Easysoft ODBC-ODBC Bridge Installation

← Older revision		Revision as of 12:29, 20 June 2018
Line 3:		Line 3:

	==Installation Procedure==		==Installation Procedure==
	Please note: These installation notes are draft and should be used as guidelines ~~at this stage~~.		Please note: These installation notes are draft and should be used as guidelines - each version of Windows and the applications contained therein are configured differently.

			{{Note}} For datamining from legacy systems (i.e. 4.14 WMS on AIX using C-ISAM files), additional installation files are required specified in the following [[Easysoft ODBC-ODBC Bridge Installation]] section.

	Install MySQL database.		Install MySQL database.

Anw: Updated with Timeout changes

2018-06-04T08:54:50Z

Updated with Timeout changes

← Older revision		Revision as of 10:54, 4 June 2018
Line 109:		Line 109:
	* Stop the default web site (as it will be using port 80)		* Stop the default web site (as it will be using port 80)
	* Create a new web site named CALIDUS Vision, pointing to the virtual directory where you installed the Vision application. Ensure you enable the ability to execute scripts). Accept the standard Application Pool if this is the first install. If multiple installs on this machine, consider using the same pool for both.		* Create a new web site named CALIDUS Vision, pointing to the virtual directory where you installed the Vision application. Ensure you enable the ability to execute scripts). Accept the standard Application Pool if this is the first install. If multiple installs on this machine, consider using the same pool for both.
			* Set the Idle Timeout on the Application Pool to your required value, in minutes, through Advanced Settings.
	* Set the port for the application. Note: If there are other sites or web servers on the machine, you may need to change this or them away from the standard port 80. That includes the Default Web Site for IIS - change it 8080 if there are no other web servers on the machine (for example Apache, which defaults to port 8080) or 8081.		* Set the port for the application. Note: If there are other sites or web servers on the machine, you may need to change this or them away from the standard port 80. That includes the Default Web Site for IIS - change it 8080 if there are no other web servers on the machine (for example Apache, which defaults to port 8080) or 8081.
	* Change the properties of the new Website ('''Advanced Settings''').Change the connection timeout to ~~300~~ seconds.		* Change the properties of the new Website ('''Advanced Settings'''). Change the connection timeout to your required timeout in seconds.
	* Ensure that Daily '''Logging''' is enabled - use the Advanced tab or '''Select Fields''' button to ensure that all elements are being reported. The information contained in these logs will be used for bandwidth and system efficiency.		* Ensure that Daily '''Logging''' is enabled - use the Advanced tab or '''Select Fields''' button to ensure that all elements are being reported. The information contained in these logs will be used for bandwidth and system efficiency.
	* For IIS 6.0 or greater, ensure that Parent Paths are enabled, by enabling the flag 'Enable Parent Paths' from the web site's properties/Home Directory/Configuration/Options screen ('''ASP''' option).		* For IIS 6.0 or greater, ensure that Parent Paths are enabled, by enabling the flag 'Enable Parent Paths' from the web site's properties/Home Directory/Configuration/Options screen ('''ASP''' option).

Anw: Added details of setting script debuuging to True, to see errors.

2018-05-24T10:04:40Z

Added details of setting script debuuging to True, to see errors.

← Older revision		Revision as of 12:04, 24 May 2018
Line 127:		Line 127:
	* On Vision Site, Authentication, select ''Anonymous Authentication'', click ''Edit...'', select 'Application pool identity', then '''OK'''.		* On Vision Site, Authentication, select ''Anonymous Authentication'', click ''Edit...'', select 'Application pool identity', then '''OK'''.
	This should allow the system to run.		This should allow the system to run.


			{{Note}} If you want to see the proper errors on the system when it stops, then you need to set the following setting:
			* On Vision Site, ASP, select ''Debugging Properties'', '''Send Errors to Browser...''', set to ''True'' then '''Apply'''.

Anw: Updated with latest installer file.

2018-04-06T11:24:22Z

Updated with latest installer file.

← Older revision		Revision as of 13:24, 6 April 2018
Line 71:		Line 71:

	Install the Vision package. The latest version can be found in the project driver under ''\_Installers\Installer''.		Install the Vision package. The latest version can be found in the project driver under ''\_Installers\Installer''.
	* ~~File used~~: IN110627Vision.zip		* Latest version: IN180406Vision.zip
			* Previous version: IN110627Vision.zip
	{{Note}} Install the Vision application files away from the root drive.		{{Note}} Install the Vision application files away from the root drive.

Anw: Updated to reflect IIS 6.X differences.

2018-01-23T14:03:42Z

Updated to reflect IIS 6.X differences.

← Older revision		Revision as of 16:03, 23 January 2018
Line 121:		Line 121:
	* Windows Explorer to ..\MySQL Datafiles, right-click, Properties, Security, Edit, Add, "IUSR", OK. {{Note}} If not found, use Advanced, Name Starts With IUSR, Find Now, double-click on the user.		* Windows Explorer to ..\MySQL Datafiles, right-click, Properties, Security, Edit, Add, "IUSR", OK. {{Note}} If not found, use Advanced, Name Starts With IUSR, Find Now, double-click on the user.
	* Click IUSR added, click Full Control, Apply, OK, OK.		* Click IUSR added, click Full Control, Apply, OK, OK.

			{{Warning}} On IIS 6.1, this may not work. In this case, when you attempt to connect to the system through the browser, you receive an error 401.3 (Authentication error). In this case:
			* Check the application Pool, Advanced settings. In '''Identity''', should be set to "ApplicationPoolIdentity".
			* On Vision Site, Authentication, select ''Anonymous Authentication'', click ''Edit...'', select 'Application pool identity', then '''OK'''.
			This should allow the system to run.


	Load the database structure through the MySQL Workbench.		Load the database structure through the MySQL Workbench.

Anw: Updated instructions from latest install 16/10/2017

2017-10-16T13:13:38Z

Updated instructions from latest install 16/10/2017

← Older revision		Revision as of 15:13, 16 October 2017
Line 17:		Line 17:
	MySQL Workbench Installation Notes:		MySQL Workbench Installation Notes:
	* {{Note}} Workbench requires a number of Microsoft redistributable files to be installed, that may require the machine to be rebooted. These may be downloaded on demand as part of the Workbench install. The files are:		* {{Note}} Workbench requires a number of Microsoft redistributable files to be installed, that may require the machine to be rebooted. These may be downloaded on demand as part of the Workbench install. The files are:
	** wic_x86_enu.exe		** wic_x86_enu.exe (not required on most machines - try the vcredist first)
	** vcredist_x86.exe or vcredist_x64.exe		** vcredist_x86.exe or vcredist_x64.exe (Studio 2013 version)
	** dotNetFx45_Full_setup.exe		** dotNetFx45_Full_setup.exe (may not be required on some machines)
	* Install the files in this sequence.		* Install the files in this sequence.
	* Install workbench to default directory.		* Install workbench to default directory.

Anw: Updated instructions from latest install 16/10/2017

2017-10-16T11:00:07Z

Updated instructions from latest install 16/10/2017

← Older revision		Revision as of 13:00, 16 October 2017
Line 16:		Line 16:

	MySQL Workbench Installation Notes:		MySQL Workbench Installation Notes:
	* {{Note}} Workbench requires a number of Microsoft redistributable files to be installed, that may require the machine to be rebooted. The files are:		* {{Note}} Workbench requires a number of Microsoft redistributable files to be installed, that may require the machine to be rebooted. These may be downloaded on demand as part of the Workbench install. The files are:
	** wic_x86_enu.exe		** wic_x86_enu.exe
	** vcredist_x86.exe or vcredist_x64.exe		** vcredist_x86.exe or vcredist_x64.exe
	** ~~dotNetFx40_Client_x86_x64~~		** dotNetFx45_Full_setup.exe
	* Install the files in this sequence.		* Install the files in this sequence.
	* Install workbench to default directory.		* Install workbench to default directory.

Anw: Updated instructions from latest install 16/10/2017

2017-10-16T10:45:56Z

Updated instructions from latest install 16/10/2017

← Older revision		Revision as of 12:45, 16 October 2017
Line 8:		Line 8:

	Files used:		Files used:
	* mysql-5.1.45-win32.msi		* mysql-enterprise-gpl-5.1.46sp1-win32.msi
	* mysql-workbench-~~gpl~~-5.2.~~35.1~~-~~win32~~.msi		* mysql-workbench-community-6.3.3-winx64.msi
	* mysql-connector-odbc-5.1.6-win32.msi		* mysql-connector-odbc-5.1.11-win32.msi

	{{Note}} the latest MySQL Enterprise binaries should be used - download from MySQL as required.		{{Note}} the latest MySQL Enterprise binaries should be used - download from MySQL as required.
Line 26:		Line 26:

	MySQL Connector Installation Notes:		MySQL Connector Installation Notes:
	* {{Note}} Microsoft Windows Server 2008 (and any other 64bit version) require the 64bit versions of the ODBC connectors - the latest file is mysql-connector-odbc-5.1.8-winx64.msi)		* {{Note}} Microsoft Windows Server 2008 (and any other 64bit version) require the 64bit versions of the ODBC connectors - the latest file is mysql-connector-odbc-5.1.11-winx64.msi)
	* Complete install to default directory.		* Complete install to default directory.

Anw: Updated instructions from latest install 08/09/2017

2017-09-08T15:35:09Z

Updated instructions from latest install 08/09/2017

← Older revision		Revision as of 17:35, 8 September 2017
Line 167:		Line 167:
	If the system is running on a 64bit version of Windows (natively 7/2008+), the ODBC drivers may not be found, as evidenced by an error when running these scripts. Also, they will not be visible in ''Administrative Tools/Data Sources (ODBC)/System DSN''. If they are visible when executing ''c:\windows\syswow64\odbcad32.exe'', then the items must be scheduled differently. Set them up as follows:		If the system is running on a 64bit version of Windows (natively 7/2008+), the ODBC drivers may not be found, as evidenced by an error when running these scripts. Also, they will not be visible in ''Administrative Tools/Data Sources (ODBC)/System DSN''. If they are visible when executing ''c:\windows\syswow64\odbcad32.exe'', then the items must be scheduled differently. Set them up as follows:
	* "c:\windows\syswow64\wscript.exe" "{name of script}"		* "c:\windows\syswow64\wscript.exe" "{name of script}"

	In certain version of Windows, this will request that the script name be added as a parameter instead of in the program to be run - this also works.		In certain version of Windows, this will request that the script name be added as a parameter instead of in the program to be run - this also works.

			{{Note}} Windows 2012: Also specify the ''Start In'' folder, but DO NOT enclose in quotes.

Anw at 10:19, 8 September 2017

2017-09-08T10:19:39Z

← Older revision		Revision as of 12:19, 8 September 2017
Line 58:		Line 58:
	* Re-start the service.		* Re-start the service.
	'''This must be done before any tables are created within the database.'''		'''This must be done before any tables are created within the database.'''

			MySQL Workbench Configuration:
			* Edit/Preferences
			* SQL Editor
			* Disable Safe Updates


Line 127:		Line 132:
	These files can also be loaded through the following command:		These files can also be loaded through the following command:
	<pre>>mysql.exe --host=127.0.0.1 --user=root --password={password} --default-character-set=utf8 --comments <{SQL file}</pre>		<pre>>mysql.exe --host=127.0.0.1 --user=root --password={password} --default-character-set=utf8 --comments <{SQL file}</pre>


			{{Note}} If you have any updates or patches to install, do this now.