cascade on docker (with mysql)

Setup:

• download the manual installation files for cascade (cascade-x.x.zip or ROOT.zip) [https://www.hannonhill.com/downloads/cascade/]
  • place the unzipped tomcat/webapps/ROOT folder inside the tomcat webapps directory ("./tomcat/webapps/ROOT")
• download the cascade sql file
  • place the sql file inside the mysql folder ("./mysql/cascade.sql")
• follow the manual installation instructions in cas/cascade-x.x/ManualConfiguration.txt
  • edit context.xml and server.xml to your liking, the mysql database will be reachable at the host: "mysql"
• edit docker-compose.yml, update the container name for the tomcat service with the hostname used in your license file
  • containter_name: <license host name>

Initial Run:

• docker-compose build (this will build your containers)
• docker-compose up -d(this will spin up your containers and run them in the background)
• cascade should now be accesible via the docker host ip on port 8080
  • you can use docker-compose up if you run into problems, this will attach the docker containers to your stdout and you should be able to see all the log output
  • finish cascade setup by uploading your license file

Notes:

• no longer needed (tomcat service definition should have a depends_on mysql), but keeping this here just in case:
  • on your initial run, mysql may not be done importing the cascade.sql by the time tomcat starts to launch the cascade tomcat webapp
  • so you might want to run docker-compose up mysql first and let it finish doing it's initial import before bringing up cascade (docker-compose up -d cas)

Personal upgrade/Other notes:

• container_name in docker-compose.yml is used to sync the cascade host name with your cascade license file obtained from HannonHill, make sure the hostname in the license file matches your container_name

  • this results in a side effect of limiting you to one cascade container with container_name, i.e.-- no clustering =(

• backup mysql database

  • from this directory:
  • docker exec <mysql container id> /usr/bin/mysqldump -u root --password=supersecret cascade > mysql/cascade.sql

• if you need ever need to rebuild the mysql container, use a previous mysql dump backup by placing the mysqldump output in ./mysql/cascade.sql

Upgrade cascade flow:

• copy new ROOT app into ./tomcat/webapps/ROOT

• use install instructions to update necessary conf files:

  • tomcat/conf/context.xml
  • tomcat/conf/server.xml
  • tomcat/conf/web.xml
  • custom asset factory plugins and publish triggers

• rebuild the new cascade version that tomcat uses:

  • docker-compose build tomcat
  • docker-compose up (add with -d for deamon mode)

• now with ssl!

  • the included server.xml has a working SSL config with local generated certificate
    • Place the cert and key in the ./tomcat/ssl folder, update server.xml config to reflect

      <Certificate certificateKeyFile="ssl/localhost-docker-key.pem"
                   certificateFile="ssl/localhost-docker-cer.pem"
                   certificateKeyPassword="changeit"
                   type="RSA" />
      

    • the docker-compose.yml is configured to reach the HTTPS listener on :8443