Manual Installation

This page describes the installation step by step, without relying on the wizard to prepare the database. You can also use it to understand what the wizard does. The wizard can do the same work for you, see Quick Start.

Check the Requirements first. The steps are:

1. Download and extract the application
2. Set the file permissions
3. Prepare the database
4. Start myDBR and finish the setup

Download and extract

Download the myDBR package from the myDBR website. Extract the ZIP file into the document root of your web server (or a directory below it), so that the mydbr directory contains index.php, install/ and user/.

File permissions

The web server needs to read all the files, and to write the configuration file mydbr_config.php while the wizard saves the connection. Keep the file unreadable by other users of the server, because it holds the database password.

Adjust the commands to your document root and web server user (for example www-data on Debian and Ubuntu, apache on Red Hat, _www on macOS):

$ sudo mv mydbr /var/www/html
$ cd /var/www/html/mydbr
$ sudo chown -R apache:apache .
$ sudo chmod -R go-r .
$ sudo chmod -R u+w .

Open the myDBR URL. If the files are in place and the PHP loader is installed, the setup screen opens.

Prepare the database

myDBR keeps its reports and settings in a reporting database. Using a separate database (default name mydbr) is the cleanest choice. You can also install the objects into your data database. They are prefixed with mydbr (tables mydbr_, internal routines sp_MyDBR_, reports sp_DBR), so they do not collide with your own objects.

The database account that myDBR uses needs:

1. Full access to the reporting database.
2. Read access to the databases that hold the data you report on.

Prepare the database for your system. Each page gives the commands for creating the user and the database and for running the creation script. The scripts are in install/db_creation.

Database	Page	Creation script
MySQL, MariaDB	MySQL and MariaDB	mydbr_create_mysql.sql
Microsoft SQL Server	Microsoft SQL Server	mydbr_create_mssql.sql
PostgreSQL	PostgreSQL	mydbr_create_pgsql.sql

When the objects exist, the wizard recognizes them and only checks them (Re-Create Objects is offered if you want to create them again).

Start myDBR and finish the setup

Open the myDBR URL in your browser and follow the wizard (see Quick Start). When you enter the connection of the reporting database, the wizard finds the objects and continues. The result is a mydbr_config.php like this:

define( "DB_VENDOR", 'mysql' );          // mysql, sqlsrv or pgsql
define( "DB_HOST", 'localhost' );
define( "DB_PORT", 3306 );
define( "DB_NAME", 'mydbr' );
define( "DB_USER", 'mydbr' );
define( "DB_PASSWORD", '********' );
define( "SETUP_DONE", true );

You can write the file by hand and set SETUP_DONE to true instead of using the wizard. The settings of SSL, a socket and a PostgreSQL schema (DB_SCHEMA) are described in the page of the database.

tip

To run the wizard again, set SETUP_DONE to false in mydbr_config.php. myDBR then shows the installation screen instead of the login page. myDBR also tells you to do this when it cannot find its objects in the database.

After the setup you can log in with the default administrator dba and the password dba. Continue with After the Installation.