{"type":"doc","content":[{"type":"paragraph"},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"localId":"724af7a0-af74-4054-87a4-1481e3035471"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Prerequisites","type":"text"}]},{"type":"paragraph","content":[{"text":"Before beginning installation get ready next things and settings:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"MySQL 8.0 with created scheme and user with access to it (MySQL security group should allow inbound rules from new EC2 instance, default port 3306)","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"-- Create schema script, character set and collation must be unchanged\nCREATE DATABASE `termweb_prod` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;\nCREATE USER 'termwebuser'@'%' IDENTIFIED BY 'sEcr3t!';\nGRANT ALL PRIVILEGES ON `termweb\\_prod`.* TO 'termwebuser'@'%';","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SMTP connection settings for sending emails","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Elasticsearch connection settings (ES security group should allow inbound rules from new EC2 instance, default ports 9200 and 9300)","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Elasticsearch server required for setup. See ","type":"text"},{"text":"TermWeb Requirements","type":"text","marks":[{"type":"link","attrs":{"href":"https://termweb.atlassian.net/wiki/spaces/T4D/pages/18874518"}}]},{"text":" for more information.","type":"text"}]}]}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Launch new Windows Server 2019","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For data storage will be enough 30-45GB depending on usage and log level","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Update everything after successful login and reboot.","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Configure Windows instance","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Configure swap file","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Calculate the swap space size (","type":"text"},{"text":"see","type":"text","marks":[{"type":"link","attrs":{"href":"https://aws.amazon.com/premiumsupport/knowledge-center/ec2-memory-swap-file/"}}]},{"text":"):","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"2 GB of RAM or less = swap size 2x the amount of RAM but never less than 32 MB","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"More than 2 GB of RAM but less than 32 GB = swap size 4 GB + (RAM – 2 GB)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"32 GB of RAM or more = swap size 1x the amount of RAM","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For current example use 2GB swap size.","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Install JDK","type":"text"}]},{"type":"paragraph","content":[{"text":"Download and install latest build of Open JDK Corretto 8 ","type":"text"},{"text":"https://corretto.aws/downloads/latest/amazon-corretto-8-x64-windows-jdk.msi","type":"text","marks":[{"type":"link","attrs":{"href":"https://corretto.aws/downloads/latest/amazon-corretto-8-x64-windows-jdk.msi"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Install Tomcat 9.0","type":"text"}]},{"type":"paragraph","content":[{"text":"Download and install Core version with Windows Service installer: ","type":"text"},{"text":"https://downloads.apache.org/tomcat/tomcat-9/v9.0.41/bin/apache-tomcat-9.0.41.exe","type":"text","marks":[{"type":"link","attrs":{"href":"https://downloads.apache.org/tomcat/tomcat-9/v9.0.41/bin/apache-tomcat-9.0.41.exe"}}]},{"text":", don’t install manager, host manger, examples or documentation. Choose for example C:\\tomcat folder for installation, or proceed with default.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":630,"id":"72297a8a-aeaa-4ded-b983-c5ffd44c482d","collection":"contentId-202899461","type":"file","height":470}}]},{"type":"paragraph","content":[{"text":"Specify JDK instead of JRE as Java VM:","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":620,"id":"4952a32e-58f7-49b3-bc88-167d5ebfc115","collection":"contentId-202899461","type":"file","height":384}}]},{"type":"paragraph","content":[{"text":"Leave other options with default values.","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Configure tomcat via link “Configure Tomcat” in Start menu","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set Initial memory pool and Maximum memory pool to 1024MB for server with 2GB of RAM this will be enough ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"wrap-right","width":30.0},"content":[{"type":"media","attrs":{"width":560,"id":"6a1377c8-b915-4d41-98b0-2fe3c063e396","collection":"contentId-202899461","type":"file","height":642}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add next java options to existing:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"-Dspring.config.name=termweb\n-Dspring.profiles.active=mysql,termweb3-search\n-Dfile.encoding=UTF-8\n-Duser.timezone=UTC\n-Dtermweb.home=C:\\twhome\n-verbose:gc","type":"text"}]},{"type":"paragraph"}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If you have plans to use many languages per dictionary and user groups, like 30 languages and 50 user groups (multiplication result greater than 1000), you need to change default tomcat’s maximum accepted parameter count:","type":"text"},{"type":"hardBreak"},{"text":"in a file ","type":"text"},{"text":"C:\\tomcat\\conf\\server.xml","type":"text","marks":[{"type":"code"}]},{"text":" change: ","type":"text"},{"type":"hardBreak"},{"text":"","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"to:","type":"text"},{"type":"hardBreak"},{"text":"","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Create TermWeb home folder","type":"text"}]},{"type":"paragraph","content":[{"text":"On previous step we pointed in Tomcat configuration TermWeb home folder as ","type":"text"},{"text":"C:\\twhome","type":"text","marks":[{"type":"code"}]},{"text":" so lets create it.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Configure launch of TermWeb with operating system startup","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Change startup type to Automatic or Automatic (Delayed Start) ","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Install and configure IIS","type":"text"}]},{"type":"paragraph","content":[{"text":"Open server manager and add new server roles:","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":754,"id":"d6b92300-9465-40b4-9887-8b1e48794fb0","collection":"contentId-202899461","type":"file","height":712}}]},{"type":"paragraph","content":[{"text":"Add latest versions of URL Rewrite and Application Request routing modules via Web Platform Installer from IIS Manager of website:","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":989,"id":"17591de4-5680-410f-b2e3-2a49d5cf2d42","collection":"contentId-202899461","type":"file","height":421}}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":996,"id":"97edb925-c9db-4935-922a-b98e77b2d205","collection":"contentId-202899461","type":"file","height":305}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Open ports 80 and 443 in Windows Firewall for any incoming connections in case if it not opened.","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1867,"id":"1ba15069-6bf1-457e-a585-33d107312ba1","collection":"contentId-202899461","type":"file","height":251}}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"Open Internet Information Services (IIS) Manager and configure Default Web Site:","type":"text"}]},{"type":"codeBlock","content":[{"text":"Site name: winsetup.termweb.eu\nPhysical path: C:\\inetpub\\wwwroot\\\nHost name: winsetup.termweb.eu\nBinding type: http","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":822,"id":"8f4ccdf1-1b0f-4873-9723-7464515b9751","collection":"contentId-202899461","type":"file","height":285}}]},{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Configure IIS to proxy Tomcat","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Enable proxy for server","type":"text"}]},{"type":"paragraph","content":[{"text":"Open Application Request Routing Cache for server by double clicking:","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":645,"id":"6ba2ba33-6e78-43bb-ae44-b9c49493fab7","collection":"contentId-202899461","type":"file","height":246}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Open Server Proxy Settings and tick on Enable proxy, other settings may remain with default values:","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":80.0},"content":[{"type":"media","attrs":{"width":1027,"id":"47b1129c-4ce2-40af-bede-9de893252a04","collection":"contentId-202899461","type":"file","height":1067}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Setup rewrite rules","type":"text"}]},{"type":"paragraph","content":[{"text":"You can do it manually by editing URL Rewrite table for website:","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1252,"id":"d0bcbc69-ea22-4191-a992-ebba4f583663","collection":"contentId-202899461","type":"file","height":501}}]},{"type":"paragraph","content":[{"text":"But we suggest to put file web.config to root folder of web site (","type":"text"},{"text":"C:\\inetpub\\wwwroot","type":"text","marks":[{"type":"code"}]},{"text":").","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n \n \n \n \n \n \n \n \n \n \n \n","type":"text"}]},{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Configure encryption for your website","type":"text"}]},{"type":"paragraph","content":[{"text":"Pickup certificate from your IT department or get from any company. One of non commercial companies provides it for free: ","type":"text"},{"text":"https://letsencrypt.org","type":"text","marks":[{"type":"link","attrs":{"href":"https://letsencrypt.org/"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Install TermWeb 4","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Unpack distributive","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Unpack ","type":"text"},{"text":"termweb-4.0.8-6.zip","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Unpack and move contents of ","type":"text"},{"text":"termweb4.war","type":"text","marks":[{"type":"code"}]},{"text":" (it’s regular zip archive) into tomcat webapps/ROOT folder (don’t forget to cleanup it first by removing all preinstalled files):","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"mysql-connector-j"},"legacyAnchorId":{"value":"TermWeb4installonWindows-mysql-connector-j"}},"macroMetadata":{"macroId":{"value":"1602d2f1dc3d26044b674cd15a792446"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"d6d5df58-92c2-42e2-a94a-3d48ecf88e53"}},{"text":"Download and install ","type":"text"},{"text":"mysql-connector-j","type":"text","marks":[{"type":"code"}]},{"text":" into ","type":"text"},{"text":"tomcat","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":"webapps/ROOT/WEB-INF/lib","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"Go to ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://dev.mysql.com/downloads/connector/j/"}},{"text":" and select platform independent version of connector compatible with MySQL version 8.0","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":920,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":920,"id":"90a3f772-0ff0-4df6-bd9a-4f1251a2a43f","collection":"contentId-202899461","type":"file","height":444}}]},{"type":"paragraph","content":[{"text":"Unzip and move file ","type":"text"},{"text":"mysql-connector-j-8.0.33.jar","type":"text","marks":[{"type":"code"}]},{"text":" it to lib folder mentioned before.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Unpack ","type":"text"},{"text":"termweb-ui.zip","type":"text","marks":[{"type":"code"}]},{"text":" archive and copy contents of ","type":"text"},{"text":"dist","type":"text","marks":[{"type":"code"}]},{"text":" folder into ","type":"text"},{"text":"C:\\inetpub\\wwwroot","type":"text","marks":[{"type":"code"}]},{"text":". ","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Create and configure termweb.properties","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create and open for editing the unit file by running this command:","type":"text"},{"type":"hardBreak"},{"text":"C:\\twhome\\termweb.properties","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"To be able to start successfully TermWeb you need to configure at least this properties:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"base.url=https://winsetup.termweb.eu\n\nspring.datasource.driverClassName=com.mysql.jdbc.Driver\nspring.datasource.url=jdbc:mysql://mysqlserver:3306/termweb_prod?autoReconnect=true&useUnicode=true&character_set_server=utf8mb4&connectionCollation=utf8mb4_general_ci&useSSL=false\nspring.datasource.username=twuser\nspring.datasource.password=password\n\nemail.smtp.server=smtpserver\nemail.smtp.port=587\nemail.smtp.user=user\nemail.smtp.password=secr3t\nemail.max.retry=3\n\n# Name of cluster\ntermweb.elasticsearch.cluster.name=es-cluster\ntermweb.elasticsearch.index-prefix=termweb4-winsetup\ntermweb.elasticsearch.address=172.1.1.2\ntermweb.elasticsearch.port=9200","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Run and test","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Restart IIS to see website","type":"text"},{"type":"hardBreak"},{"text":"Start tomcat, first launch will take about 2-5 minutes to create everything in database:","type":"text"},{"type":"hardBreak"},{"text":"Check tomcat logs for errors in file ","type":"text"},{"text":"C:\\tomcat\\logs\\catalina.out","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Login as administrator with default credentials (default credentials can be found in a file ","type":"text"},{"text":"/initial.conf","type":"text","marks":[{"type":"code"}]},{"text":")","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Configure log rotation for Tomcat","type":"text"}]},{"type":"paragraph","content":[{"text":"To avoid tomcat logs grow without limits we need to configure logrotate for it. Major log file to rotate there is ","type":"text"},{"text":"/logs/catalina.out","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Configure Monitoring for server status","type":"text"}]},{"type":"paragraph","content":[{"text":"We advise to configure tools on your choice which will monitor server status","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[448.0]},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Configure DB backups","type":"text"}]},{"type":"paragraph","content":[{"text":"Don’t forget to have DB backups on daily basis for example.","type":"text"}]}]}]}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"paragraph"},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"printable":{"value":"false"}},"macroMetadata":{"macroId":{"value":"4ad45c20-1a0a-4430-a2e8-db40ef3b3189"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"38104529-aeb2-4641-9535-e1dcd3c2acd6"}}]}]}],"version":1}

Browser not supported