Upgrade Using Installer

Pre-Requisites

1. Ensure the required environment variables listed below are set.
   1. CONNECTALL_HOME
   2. MULE_HOME
   3. JAVA_HOME
2. Download the ConnectALL installer file. Please reach out directly to your ConnectALL team to receive a link for this file.
3. Stop the ConnectALL core and Tomcat services.  If you did not stop the ConnectALL core and Tomcat services, the installer would do it for you; however, it is always a good practice to stop the services before any upgrade.
4. Ensure that,
   1. Your database is running, and
   2. You have taken a backup of your database before you start the upgrade.

Upgrade in Windows Environment

1. Double-click the ConnectALL installation file. The Open File – Security Warning screen will be displayed. 
2. Click Run. The installer informs you that ConnectALL is preparing the install4j wizard, which will guide you through the rest of the set-up process. A wizard is displayed when the preparation is complete.
3. Click Next. The License Agreement screen is displayed. By default, I do not accept the agreement will be selected. Only if you scroll down and read the complete agreement will you be allowed to click, ‘I accept the agreement’; and the Next button will be available to click. Otherwise, a warning message, ‘Please read the license first’, will be displayed and prompts you to complete reading the agreement. After reading the agreement, click Next to proceed.
   
4. The Select Destination Directory screen is displayed. You can proceed with the location shown by default or click Browse to select a location where you would like ConnectALL to be installed. If you are choosing a location, ensure that the path does not contain any spaces in it.
   
5. The following screen is displayed. Select the Upgrade option and click Next. 
   
6. The installer will inform that the server stop commands are issued and ‘DB backup may be REQUIRED!!!’ will be displayed. It would be best if you backed up your database manually to ensure data integrity. If you have not backed up, proceed once you have completed the backup. Continue with the upgrade if you have backed up and want to proceed.
   1. If you wish to back up your database before proceeding, select No and complete the manual backup of your database. 
   2. After the database has (or has not) been backed up, select Yes to continue with the installation.
7. Check the location of the Tomcat folder displayed on the screen, change it if you wish to, and click Next.
   
8. The installer displays the components to install/upgrade. Select ConnectALL (along with the other components you wish to upgrade) and click Next.
   
   
   1. Check the required option If you are upgrading ConnectALL Insights Analytics or ConnectALL Insights Database and Connection. If you have an existing ConnectALL Insights connection, note that after you confirm the backup folder (in the Select ConnectALL Backup folder location screen), the installer verifies the Insights version details and displays the current version and the available version. If you are on a lower version, read the information available here to upgrade. 
   2. Suppose you are upgrading Tomcat or ConnectALL core service. In that case, an information box is displayed that explains that the installation process upgrades only the ConnectALL installation. If a newer version of Tomcat or ConnectALL core service is required, you will be required to upgrade them manually.
      
9. Select the type of database to be configured, and click Next. (Now, If the services are not running, you may receive a notification. Start the database service and try again.)
   
   
10. Select the ConnectALL home folder location and click Next.
    
    
11. Select the ConnectALL backup folder location and click Next.
    
12. Provide the Insights Analytics Read Only User Account and click Next. (The below screen will appear only if you are upgrading ConnectALL Insights Analytics.)
    

13. The upgrade begins, and while installing, 'Database is up to date...' message is displayed. Click OK. The installer confirms the Insights version and displays the version of Insights. Click Next. (The Insights Version details screen appears only if you are upgrading Insights Analytics.)
14. The installation wizard then validates and displays all the available ports. You can change the ports if required. Otherwise click Next.
    
15. An installation summary is displayed. Review the information and click Next. 
    
    
16. You should see the option to finish once you have reached the end. Click Finish.
    

Upgrade in Linux Environment

To upgrade, 

1. Download the ConnectALL installation file to the required directory in your Linux system.
2. Initiate the installation using the downloaded ConnectALL installer file. The file would prompt you to confirm.
   
3. Press 'O' or the Enter button. This will start the ConnectALL upgrade, and the license agreement will be displayed.  If you want to cancel the installation, press 'C'.
4. Read the license agreement. The system will prompt you to press 'Enter' to proceed after it displays each point in the terms and conditions. 
   
5. Press '1' (yes) to accept the terms and conditions, when you arrive at the final page of Terms and Conditions; press '2' (No) if you want to disagree and review. 
   
6. The system displays the question, 'Where should ConnectALL be installed' and displays a path. Press the Enter key to proceed with installing in the displayed path. Otherwise, enter a location to install and press Enter.
   
7. Press 2 for the upgrade, as shown in the below image.
   
8. The installer offers to install the components and lists them. Select the components that you want to upgrade and proceed. You will be able to provide the database details for ConnectALL Insights Analytics, which will appear as the default data source. Also, ConnectALL's hierarchy plugin will be automatically installed when you select the ConnectALL Insights Analytics option.
   
   
9. If you have selected all the options, the installer recommends that you backup tomcat custom configurations, if any.
   
   
10. You will be prompted to choose a database.  Enter your choice and press Enter. In the below example, MySQL is chosen. ConnectALL allows you use the Azure SQL database also. If you are using Azure SQL, select the SQLServer option (this option works for both on-prem and Azure SQL). Select JTDS if you are using SQL Server (on-prem).
    Note: If you are using MySQL version 8, you have to configure the timezone in the MySQL my.cnf file as provided below and restart the MySQL service.

    # Set default time zone
    default-time-zone= '+00:00'

    Note: If you are selecting Oracle and PostgreSQL, Ensure that you have created a database schema in advance before you start the installation process. Further progression without creating the DB schema will lead to failure in the DB Connectivity test.
    

11. Select the driver for your DB.
         
    
12. Select the Insights Analytics installation location.
    
    
13. The installer will prompt you to backup. Provide a backup location.
    
    
14. Confirm if the ConnectALL Insights DB Configuration must use the ConnectALL DB Config. Provide a Read Only User Account and Password. 
    
    
15. You will get the following confirmations.
    
    Note:The upgrade begins, and while installing, 'Database is up to date...' message is displayed. Click OK. The installer confirms the Insights version and displays the version of Insights. Click Next. (The Insights Version details screen appears only if you are upgrading Insights Analytics.)
16. The ports are validated, and the following information is displayed.
    
    Note: The default ports will be made available. You can choose to continue with the same ports or, provide custom ports that will be validated before assignment to the respective services.
17. The following list of information is displayed, providing you with all the details about the upgrade.
    
    You have successfully upgraded ConnectALL in your Linux environment.