Document toolboxDocument toolbox

Install the Database

SELINUX

If the database is on another server, the remote connection must be enabled in SELINUX

setsebool -P httpd_can_network_connect_db 1

Percona (MySQL)

  1. Disable the MySQL Module

    # Rhel 8+ yum -y module disable mysql



  2. Install the Percona repo

    yum -y install https://repo.percona.com/yum/percona-release-latest.noarch.rpm yum -y update percona-release



  3. Install Percona



  4. Enable and Start the Percona service



  5. Secure the installation



  6. Update the database config



  7. Create the Databases and Users.
    NOTE: This is just an example of how to create the SQL. Previous installations used a pcr360_usr to access both databases. For all new installations, we want to have separate users for the prod and test databases. The placeholder information needs to filled in and the query it needs to run for the Test and Production Database, i.e pcr360_prod & pcr360_test. 

    For MySQL the database must be configured with the UTF8 character set. For MySQL 8 utf8mb4 and utf8mb4_unicode_ci are supported as well. Currently, other character sets and collations are not supported.



Oracle

  1. Install the Oracle Instant Client

    We highly recommend installing Oracle on a dedicated database server. To communicate with Oracle on that server completing this installation will require the username, password, hostname, port (e.g. 1521) and SID.

    Download and install the Oracle Instant Client on the PCR-360 application server. This is required before installing the PHP oracle driver (oci8).



  2. Required to compile OCI8 PHP module:



  3. Required to use the sqlplus interface:



  4. Download each and install each using rpm:



  5. Set the library location