{"type":"doc","content":[{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Get required files from the Installer Repo:","type":"text"}]},{"type":"paragraph","content":[{"text":"https://bitbucket.pcr.com/projects/PCR/repos/install360/browse/lib?at=refs%2Fheads%2Fcentos8","type":"text","marks":[{"type":"link","attrs":{"href":"https://bitbucket.pcr.com/projects/PCR/repos/install360/browse/lib?at=refs%2Fheads%2Fcentos8"}}]},{"type":"hardBreak"},{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Extract and copy the application files to the Apache web directory:","type":"text"}]},{"type":"codeBlock","content":[{"text":"# extract the archive\ntar -xzvf ./external/pcr360.tar.gz\n\n# create the applicaton directory\nmkdir -p /var/www/pcr360/prod\nmkdir -p /var/www/pcr360/configs\n\n# move the extracted files to the app\nmv ./pcr360/* /var/www/pcr360/prod\n\n# create data and misc folders\nmkdir -p /var/www/pcr360/prod/logs /var/www/pcr360/prod/data/cache /var/www/pcr360/prod/data/cache/page\nmkdir -p /var/www/pcr360/prod/data/tmp/prod /var/www/pcr360/prod/data/cache/prod /var/www/pcr360/prod/data/session/prod\nmkdir -p /var/www/pcr360/prod/data/archive /var/www/pcr360/prod/data/emails /var/www/pcr360/prod/data/errors /var/www/pcr360/prod/data/reports /var/www/pcr360/prod/data/reports/historical /var/www/pcr360/prod/data/search\nmkdir -p /var/www/pcr360/prod/data/uploads /var/www/pcr360/prod/data/uploads/importfiles /var/www/pcr360/prod/data/uploads/vh\nmkdir -p /var/www/pcr360/data/outbound /var/www/pcr360/data/inbound /var/www/pcr360/data/outbound-test /var/www/pcr360/data/inbound-test\n\n# copy default vh data to the vh import directory\ntar -xzvf vhdata.tar.gz -C /var/www/pcr360/prod/data/uploads/vh\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set file permissions","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Allow read/write access to the PCR user for the entire folder","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Allow read/write access to Apache for the data and logs folders","type":"text"}]},{"type":"codeBlock","content":[{"text":"# set file permissions\nchown -R pcr:pcr /var/www/pcr360/prod\nchown -R apache:pcr /var/www/pcr360/prod/data /var/www/pcr360/prod/logs /var/www/pcr360/data\nfind /var/www/pcr360/prod -type f -exec chmod 644 {} +\nfind /var/www/pcr360/data -type f -exec chmod 664 {} +\nfind /var/www/pcr360/prod/data -type f -exec chmod 664 {} +\nfind /var/www/pcr360/prod/logs -type f -exec chmod 664 {} +\nfind /var/www/pcr360/prod -type d -exec chmod 755 {} +\nfind /var/www/pcr360/data -type d -exec chmod 775 {} +\nfind /var/www/pcr360/prod/data -type d -exec chmod 775 {} +\nfind /var/www/pcr360/prod/logs -type d -exec chmod 775 {} +\nchown apache:pcr /var/www/pcr360/prod/external/syschk.sh /var/www/pcr360/prod/external/ssl-cert-info.sh\nchmod 700 /var/www/pcr360/prod/external/syschk.sh /var/www/pcr360/prod/external/ssl-cert-info.sh\n\n# set acl permissions\nsetfacl -Rm g:apache:rwx /var/www/pcr360/prod/data\nsetfacl -Rm u:pcr:rwx /var/www/pcr360/prod/data\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set SE Linux Permissions","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Give Apache read access to the entire application folder","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Give Apache write access to the data and logs folders","type":"text"}]},{"type":"codeBlock","content":[{"text":"# set selinux permission\nchcon -t httpd_sys_content_t /var/www/pcr360/prod -R\nchcon -t httpd_sys_rw_content_t /var/www/pcr360/prod/logs -R\nchcon -t httpd_sys_rw_content_t /var/www/pcr360/prod/data -R\nchcon -t httpd_sys_rw_content_t /var/www/pcr360/data -R\nchcon -t httpd_sys_content_t /var/www/pcr360/test -R\nchcon -t httpd_sys_rw_content_t /var/www/pcr360/test/logs -R\nchcon -t httpd_sys_rw_content_t /var/www/pcr360/test/data -R\nchcon -t httpd_sys_rw_content_t /var/www/pcr360/data -R\n\n # allow apache to excute external programs like java and wkhtmltopdf\nsetsebool -P httpd_execmem on","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create the PCR-360 configuration INI file. ","type":"text"},{"text":"NOTE","type":"text","marks":[{"type":"strong"}]},{"text":": \"<>\" indicates a value that needs to be filled in. For example: ","type":"text"},{"text":"","type":"text","marks":[{"type":"strong"}]},{"text":" could be replaced with ","type":"text"},{"text":"mysql.pcr.com","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"http://mysql.pcr.com"}}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"MySQL","type":"text"}]},{"type":"codeBlock","content":[{"text":"cat > /var/www/pcr360/configs/pcr360.ini << INI\n[default]\n[manatee : default]\n[team360 : default]\n[team360oracle : default]\n[team360mysql : default]\n[servicedesk : default]\n[training : default]\n\n[prod : default]\n; the license key is available from PCR\nlicenseKey = \"\"\n\nconstants.SERV_HOST_NAME_CRON = \"\"\nconstants.ERROR_REPORT_EMAIL = \"help@\"\nconstants.IMPORT_FILES_PATH = \"//data/inbound/\"\nconstants.EXPORT_PATH = \"//data/outbound/\"\nconstants.PDF_CONVERTER_PATH = \"\"\nconstants.RUNTIME_DEBUG_ALLOWED = true\n\n; This section is for MySQL Databases\nresources.multidb.default.adapter = Pdo_Mysql\nresources.multidb.default.host = \nresources.multidb.default.dbname = \nresources.multidb.default.username = \nresources.multidb.default.password = \"\"\n\nresources.multidb.metadata.adapter = Pdo_Mysql\nresources.multidb.metadata.host = \nresources.multidb.metadata.dbname = \nresources.multidb.metadata.username = \nresources.multidb.metadata.password = \"\"\n\nresources.multidb.report.adapter = Pdo_Mysql\nresources.multidb.report.host = \nresources.multidb.report.dbname = \nresources.multidb.report.username = \nresources.multidb.report.password = \"\"\n\nresources.multidb.archive.adapter = Pdo_Mysql\nresources.multidb.archive.dbname = \nresources.multidb.archive.host = \nresources.multidb.archive.username = \nresources.multidb.archive.password = \"\"\n\n; CRYSTAL REPORTS\n; MySQL\ncrystal.jdbc.type = mysql\ncrystal.jdbc.host = \ncrystal.jdbc.username = \ncrystal.jdbc.password = \"\"\ncrystal.jdbc.dbname = \ncrystal.jdbc.port = 3306\n\n; EMAIL\nemail.DISPLAY_NAME = \"PCR-360 Admin\"\nemail.EMAIL = \"pcr360@\"\nemail.OUTGOING_TRANSPORT_TYPE = \"SENDMAIL\"\n;email.OUTGOING_HOST = \"\"\n;email.OUTGOING_PORT = \"\"\n;email.OUTGOING_SSL = \"\"\n\n[test : prod]\nconstants.SERV_HOST_NAME_CRON = \"\"\nconstants.ERROR_REPORT_EMAIL = \"help@\"\nconstants.IMPORT_FILES_PATH = \"//data/inbound-test/\"\nconstants.EXPORT_PATH = \"//data/outbound-test/\"\n\n; This section is for MySQL Databases\nresources.multidb.default.adapter = Pdo_Mysql\nresources.multidb.default.host = \nresources.multidb.default.dbname = \nresources.multidb.default.username = \nresources.multidb.default.password = \"\"\n\nresources.multidb.metadata.adapter = Pdo_Mysql\nresources.multidb.metadata.host = \nresources.multidb.metadata.dbname = \nresources.multidb.metadata.username = \nresources.multidb.metadata.password = \"\"\n\nresources.multidb.report.adapter = Pdo_Mysql\nresources.multidb.report.host = \nresources.multidb.report.dbname = \nresources.multidb.report.username = \nresources.multidb.report.password = \"\"\n\nresources.multidb.archive.adapter = Pdo_Mysql\nresources.multidb.archive.dbname = \nresources.multidb.archive.host = \nresources.multidb.archive.username = \nresources.multidb.archive.password = \"\"\n\n; CRYSTAL REPORTS\n; MySQL\ncrystal.jdbc.type = mysql\ncrystal.jdbc.host = \ncrystal.jdbc.username = \ncrystal.jdbc.password = \"\"\ncrystal.jdbc.dbname = \ncrystal.jdbc.port = 3306\n\n; EMAIL\nemail.DISPLAY_NAME = \"PCR-360 Test Admin\"\nemail.EMAIL = \"pcr360-test@\"\nemail.OUTGOING_TRANSPORT_TYPE = \"SENDMAIL\"\n;email.OUTGOING_HOST = \"\"\n;email.OUTGOING_PORT = \"\"\n;email.OUTGOING_SSL = \"\"\n\nINI","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Oracle","type":"text"}]},{"type":"codeBlock","content":[{"text":"cat > << INI\n[default]\n[manatee : default]\n[team360 : default]\n[team360oracle : default]\n[team360mysql : default]\n[servicedesk : default]\n[training : default]\n\n[prod : default]\n// the license key is available from PCR\nlicenseKey = \"\"\n\nconstants.SERV_HOST_NAME_CRON = \"\"\nconstants.ERROR_REPORT_EMAIL = \"help@\"\nconstants.IMPORT_FILES_PATH = \"/data/inbound/\"\nconstants.EXPORT_PATH = \"/data/outbound/\"\nconstants.PDF_CONVERTER_PATH = \"\"\nconstants.RUNTIME_DEBUG_ALLOWED = true\n\n// ORACLE CONFIG\nresources.multidb.default.adapter = Oracle\nresources.multidb.default.host = \nresources.multidb.default.username = \nresources.multidb.default.password = \"\"\nresources.multidb.default.schema = ^}\n;resources.multidb.default.dbname = \"//:/\"\nresources.multidb.default.dbname = \"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))\"\nresources.multidb.report.adapter = Oracle\nresources.multidb.report.host = \nresources.multidb.report.username = \nresources.multidb.report.password = \"\"\nresources.multidb.report.schema = ^}\n;resources.multidb.report.dbname = \"//:/\"\nresources.multidb.report.dbname = \"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))\"\nresources.multidb.metadata.adapter = Oracle\nresources.multidb.metadata.host = \nresources.multidb.metadata.username = \nresources.multidb.metadata.password = \"\"\nresources.multidb.metadata.schema = ^}\n;resources.multidb.metadata.dbname = \"//:/\"\nresources.multidb.metadata.dbname = \"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))\"\nresources.multidb.archive.adapter = Oracle\nresources.multidb.archive.host = \nresources.multidb.archive.username = \nresources.multidb.archive.password = \"\"\nresources.multidb.archive.schema = ^}\n;resources.multidb.archive.dbname = \"//:/\"\nresources.multidb.archive.dbname = \"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))\"\n\n// CRYSTAL REPORTS\n\n// ORACLE\ncrystal.jdbc.type = oracle\ncrystal.jdbc.host = \ncrystal.jdbc.username = \ncrystal.jdbc.password = \"\"\ncrystal.jdbc.schema = ^}\ncrystal.jdbc.port = 1521\ncrystal.jdbc.dsn = DSN\n\n// EMAIL\nemail.DISPLAY_NAME = \"PCR-360 Admin\"\nemail.EMAIL = \"pcr360@\"\nemail.OUTGOING_TRANSPORT_TYPE = \"SENDMAIL\"\n;email.OUTGOING_HOST = \"\"\n;email.OUTGOING_PORT = \"\"\n;email.OUTGOING_SSL = \"\"\n\n[test : prod]\nemail.OUTGOING_TRANSPORT_TYPE = \"FILE\"\n\n// ORACLE CONFIG\nresources.multidb.default.adapter = Oracle\nresources.multidb.default.host = \nresources.multidb.default.username = \nresources.multidb.default.password = \"\"\nresources.multidb.default.schema = ^}\n;resources.multidb.default.dbname = \"//:/\"\nresources.multidb.default.dbname = \"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))\"\nresources.multidb.report.adapter = Oracle\nresources.multidb.report.host = \nresources.multidb.report.username = \nresources.multidb.report.password = \"\"\nresources.multidb.report.schema = ^}\n;resources.multidb.report.dbname = \"//:/\"\nresources.multidb.report.dbname = \"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))\"\nresources.multidb.metadata.adapter = Oracle\nresources.multidb.metadata.host = \nresources.multidb.metadata.username = \nresources.multidb.metadata.password = \"\"\nresources.multidb.metadata.schema = ^}\n;resources.multidb.metadata.dbname = \"//:/\"\nresources.multidb.metadata.dbname = \"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))\"\nresources.multidb.archive.adapter = Oracle\nresources.multidb.archive.host = \nresources.multidb.archive.username = \nresources.multidb.archive.password = \"\"\nresources.multidb.archive.schema = ^}\n;resources.multidb.archive.dbname = \"//:/\"\nresources.multidb.archive.dbname = \"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))\"\n\n// CRYSTAL REPORTS\n\n// ORACLE\ncrystal.jdbc.type = oracle\ncrystal.jdbc.host = \ncrystal.jdbc.username = \ncrystal.jdbc.password = \"\"\ncrystal.jdbc.schema = ^}\ncrystal.jdbc.port = 1521\ncrystal.jdbc.dsn = DSN\nINI","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Install Virtual Host Configurations. Example Configuration:","type":"text"}]},{"type":"codeBlock","content":[{"text":"cat >/etc/httpd/conf.d/pcr360_prod.conf <\n\tRequire all granted\n\n\n## HEADERS FOR MS EDGE ##\n\n\tHeader Set X-UA-Compatible: IE=Edge\n\n\n## LIMIT UPLOAD FILE SIZE TO PROTECT AGAINST DOS ATTACK ##\nLimitRequestBody 10240000\n#bytes, 0-2147483647(2GB)\n\nRewriteEngine On\nRewriteCond %{REQUEST_METHOD} ^(TRACE|TRACK)\nRewriteRule .* - [F]\n\n\n\tServerName pcr360.customeraddress.com\n\tDocumentRoot /var/www/pcr360/prod/public\n\t# rewrite to SSL\n\tRewriteEngine on\n\tRewriteCond %{SERVER_PORT} !^443$\n\tRewriteRule ^(.*) https://%{HTTP_HOST}%{REQUEST_URI}\n\n\n\n\tServerName pcr360.customeraddress.com\n\tDocumentRoot /var/www/pcr360/prod/public\n\n\t# logs\n\tErrorLog logs/ssl_error_log\n\tTransferLog logs/ssl_access_log\n\tLogLevel warn\n\n\t# SSL\n\tSSLEngine on\n\tSSLCertificateFile /etc/pki/tls/certs/pcr360_test.crt\n\tSSLCertificateKeyFile /etc/pki/tls/private/pcr360_prod.key\n\tSSLProtocol -all +TLSv1.2 +TLSv1.3\n SSLCipherSuite HIGH:MEDIUM:!aNULL:+SHA1:+MD5:+HIGH:+MEDIUM\n\tSSLHonorCipherOrder on\n\n\t# environment variables\n\tSetEnv APPLICATION_ENV prod\n\tSetEnv APPLICATION_INI \"/var/www/pcr360/configs/pcr360.ini\"\n\tSetEnv APPLICATION_ENVDEBUG 0\n\tSetEnv APPLICATION_ENVPCR 0\n\n\t# file system\n\t\n Options -Indexes\n DirectoryIndex index.php\n \tAllowOverride None\n \tInclude /var/www/pcr360/prod/public/.htaccess\n \tRequire all granted\n\t\n\n\t\n\t SSLOptions +StdEnvVars\n\t\n\nCONF\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}],"version":1}

Browser not supported