Upgrading from version 3.3.x to 3.4.11

Please completely read these instructions BEFORE beginning your upgrade process.

Please note that the Connect Daily upgrader does not support skipping major versions.

• If you are using 2.5.x you will need to upgrade to 3.0.7.
• If you are using 3.0.x you need to upgrade to version 3.1.5.
• If you are using 3.1.x you need to upgrade to version 3.2.13.
• If you are using 3.2.x you need to upgrade to version 3.3.8.
• Finally, you can upgrade from any 3.3.x version to 3.4.11

Backup

SQL Database Users

Using the appropriate utility for your RDBMS, create a backup of your SQL Database.

Instructions for Default Windows Installations

If you used the Connect Daily downloader, then you should follow these steps to upgrade. If you are using a different engine, or OS, then skip to the "Generic Application Server Instructions".

1. Stop the Connect Daily service.
2. Run the Connect Daily Downloader and install the new version of Connect Daily. This will leave the old version intact.
3. Stop the Connect Daily service.
4. Copy any customized header/footer html files, as well as any modified CSS files from the old cdaily-x.x.x directory to the cdaily-3.4.11 directory.
5. If you are using MS Access, start a command shell and run the cdaily-3.4.11\WEB-INF\sql\Access\Update340.bat file. We have observed some issues with this script on Windows 2000 servers with certain versions of MDAC. If the upgrade script fails, please send a copy of the Access MDB file to MH Software and we will convert it for you.
   
   If you are using a different SQL database, run the file cdaily-3.4.11\WEB-INF\sql\Run340.bat
   
6. Start the Connect Daily Service.

Generic Application Service Upgrade Steps

1. Stop your application server.
2. Backup your cdaily-3.4.11/WEB-INF/configuration.properties file.
3. Backup any custom EMail templates or caption translation files you have created.
4. Remove the existing calendar application directory.
5. Extract the zip or WAR file containing Connect Daily into the appropriate directory for your application server.
6. Copy the configuration.properties file you saved in step 2 to the WEB-INF directory. If you are using MS Access, copy the calendar.mdb file you saved prior to beginning into the WEB-INF\SQL\Access directory.
7. Follow the instructions in the Database Updates section below.
8. If you copied your database JDBC driver JARs into the WEB-INF/lib directory, recopy them to the WEB-INF/lib.
9. If you are using your own translated caption files, refer to the Installation Guide and User manual for instructions on how to ensure you have all captions in your file.
10. Restart your application server.

Database Updates

SQL Database Users

1. BACKUP YOUR DATABASE BEFORE PERFORMING THESE STEPS
2. JNDI USERS:
   
   Edit your configuration.properties file. For the upgrade script to run, you must create a configuration.properties file that uses a standard JDBC Connect String. This is because the upgrade script will not have access to JNDI variables when it runs. For information on editing configuration.properties, refer to configuration.properties.
3. Edit either RUN340.SH or RUN340.Bat (depending upon your operating system). You must specify the SERVER_LIB_DIR variable as appropriate for your installation.
4. Run the WEB-INF/sql/run340.sh (UNIX) or WEB-INF/sql/RUN340.bat script.