...
- This configuration file matches the file name specified in the Apache Virtual Host .
- A starter file is included in the installation package with a place-holder license key. Please request a license key from PCR to replace the place-holder license in the configuration file.
- The database settings here are specified when setting up and configuring Oracle or MySQL
Other various configurations are available and can be specified in this file. Consult PCR before setting any extra options from the Configuration Guide .
Code Block language java linenumbers true [default] [manatee : default] [team360 : default] [team360ora : default] [team360mssql : default] [servicedesk : default] [training : default] [prod : default] ; the license key is available from PCR licenseKey = "abcdefghijklmnopqrstuvwyxz..." constants.SERV_HOST_NAME_CRON = "pcr360.pcr.com" constants.ERROR_REPORT_EMAIL = "help@pcr.com" constants.IMPORT_FILES_PATH = "/var/www/pcr360/prod/data/inbound/" constants.EXPORT_PATH = "/www/www/pcr360/prod/data/outbound/" constants.RUNTIME_DEBUG_ALLOWED = true ; This section is for MySQL Databases resources.multidb.default.host = localhost resources.multidb.default.dbname = pcr360_prod resources.multidb.default.username = pcr360_usr resources.multidb.default.password = "encrypted_password" resources.multidb.metadata.host = localhost resources.multidb.metadata.dbname = pcr360_prod_metadata resources.multidb.metadata.username = pcr360_usr resources.multidb.metadata.password = "encrypted_password" resources.multidb.report.host = localhost resources.multidb.report.dbname = pcr360_prod resources.multidb.report.username = pcr360_usr resources.multidb.report.password = "encrypted_password" ; All Versions 2019.7+ also require an Archive schema resources.multidb.archive.host = localhost resources.multidb.archive.dbname = pcr360_test_archive resources.multidb.archive.username = pcr360_usr resources.multidb.archive.password = "encrypted_password" ;For mysql ssl with php7, use this ;resources.multidb.default.driver_options.1009 = "/path.to.pem" ;resources.multidb.report.driver_options.1009 = "/path.to.pem" ;resources.multidb.metadata.driver_options.1009 = "/path.to.pem" ; Alternatively this section is for Oracle Databases ;resources.multidb.default.adapter = Oracle ;resources.multidb.default.host = localhost ;resources.multidb.default.username = pcr360_prod ;resources.multidb.default.password = "encrypted_password" ;resources.multidb.default.schema = PCR360_PROD ;resources.multidb.default.dbname = "//localhost:1521/pcr360" ;resources.multidb.report.adapter = Oracle ;resources.multidb.report.host = localhost ;resources.multidb.report.username = pcr360_prod ;resources.multidb.report.password = "encrypted_password" ;resources.multidb.report.schema = PCR360_PROD ;resources.multidb.report.dbname = "//localhost:1521/pcr360" ;resources.multidb.metadata.adapter = Oracle ;resources.multidb.metadata.host = localhost ;resources.multidb.metadata.username = pcr360_prod_metadata ;resources.multidb.metadata.password = "encrypted_password" ;resources.multidb.metadata.schema = PCR360_PROD_METADATA ;resources.multidb.metadata.dbname = "//localhost:1521/pcr360" ; All Versions 2019.7+ also require an Archive schema ;resources.multidb.archive.adapter = Oracle ;resources.multidb.archive.host = localhost ;resources.multidb.archive.username = pcr360_usr ;resources.multidb.archive.schema = PCR360_PROD_ARCHIVE ;resources.multidb.archive.password = "encrypted_password" ;resources.multidb.archive.dbname = "//localhost:1521/pcr360" ; CRYSTAL REPORTS ; MySQL crystal.jdbc.type = mysql crystal.jdbc.host = localhost crystal.jdbc.username = pcr360_usr crystal.jdbc.password = password crystal.jdbc.dbname = pcr360_prod # must be quotes to work properly crystal.jdbc.port = "3306" ; ORACLE ;crystal.jdbc.type = oracle ;crystal.jdbc.host = localhost ;crystal.jdbc.username = usename ;crystal.jdbc.password = password ;crystal.jdbc.schema = SCHEMA # must be quotes to work properly ;crystal.jdbc.port = "1521" ;crystal.jdbc.dsn = DSN [test : prod] resources.multidb.default.dbname = pcr360_test resources.multidb.metadata.dbname = pcr360_test_metadata constants.SERV_HOST_NAME_CRON = "pcr360-test.pcr.com" constants.IMPORT_FILES_PATH = "/var/www/pcr360/prod/data/inbound-test/" constants.EXPORT_PATH = "/var/www/pcr360/prod/data/outbound-test/" email.OUTGOING_TRANSPORT_TYPE = "FILE"
Load System Data
The application requires certain default system level data to operate. Navigate your browser to:
Code Block | ||
---|---|---|
| ||
http://[your pcr-360 url here]/update/db/load-system-data |
.
This will load the required data included a default user account
Username: demo and Password: pcrdemo.
...
Crontab Entries
- Installing the default crontab entries that run background events is relatively simple.
- The jobs need to be running as the root to prevent issues with file permissions.
- su to root
Now, open the cron job edit prompt with the following command:
Code Block language bash crontab -e
- Then, copy and paste the appropriate line from below into the the cron job.
...