ociphpbb

Use Oracle Database with phpBB

phpBB allows the use of OracleDB as the main database. If you ever wanted to use a more scalable and professional database for your JBoss installation, follow the steps below.

Note: By following these steps you will lose all the data you have in your phpBB installation |

Step 1: Enable PHP OCI module

If you haven’t enabled the Oracle Connector (oci_connect) extension in PHP, please follow the Oracle Connector PHP module instructions.

Step 2: Enable the phpBB installation wizard

  • Copy the installer wizard installation files to phpBB htdocs folder:

    $ cp -r /opt/bitnami/apps/phpbb/backup/installer /opt/bitnami/apps/phpbb/htdocs
    
  • Clear phpBB configuration file:

    $ cat /dev/null > /opt/bitnami/apps/phpbb/htdocs/config.php
    
  • Grant write permissions to this configuration file:

    $ chmod g+w /opt/bitnami/apps/phpbb/htdocs/config.php
    
  • Remove phpBB cache:

    $ rm -rf /opt/bitnami/apps/phpbb/htdocs/cache/*
    

Step 3: Run the installation wizard

  • Using a web browser, enter http://YOUR-DOMAIN/install.

  • Click on the “Install” button.

  • Follow the steps described in the wizard. Make sure that, under the “Database Settings” step, you select Oracle as your Database connector.

  • If the error message ORA-00001: unique constraint violated appars, execute the following commands and repeat all the previous steps in this section:

    $ cp /opt/bitnami/phpbb/install/schemas/schema_data.sql.bak /opt/bitnami/phpbb/install/schemas/schema_data.sql.bak
    $ sed -i '/rand_seed_last_update/d' /opt/bitnami/phpbb/install/schemas/schema_data.sql
    
  • Once the installation is finished, execute the following commands:

    $ rm -rf  /opt/bitnami/apps/phpbb/htdocs/installer
    $ rm -rf /opt/bitnami/apps/phpbb/htdocs/cache/*
    $ chmod g-w /opt/bitnami/apps/phpbb/htdocs/config.php
    

Step 4: Test the connection

If everything was configured correctly, you should be able to log in to phpBB.

Step 5 (Optional): Disable MySQL

To permanently disable MySQL in the stack, so that it is never started and does not waste any resource, execute the commands below:

    $ sudo /opt/bitnami/ctlscript.sh stop mysql
    $ sudo sed -i '1i exit 0' /opt/bitnami/mysql/scripts/ctl.sh
Last modification October 1, 2018