Quick Start
The installation wizard is the fastest way to install myDBR. It checks your server, connects to the database, creates the myDBR objects and starts myDBR. Allow about ten minutes.
Before you start, make sure that the server meets the Requirements: PHP 8.0 or later, the PHP loader, the PHP driver of your database and a database that you can connect to.
Steps
- Download the latest myDBR package from myDBR.com.
- Extract the
mydbr.zipfile into the document root of your web server, or into a directory below it. - Make the configuration file writable by the web server (see File Permissions).
- Open the myDBR directory in your browser, for example
https://yourserver.com/mydbr/. A new installation opens the wizard. - Follow the wizard, which has the steps below.
- Log in as
dbawith the passworddbaand change them.
If the PHP loader is missing, myDBR does not start the wizard. It shows instructions for installing the loader on your server. Follow them, restart the web server and open the page again.
The wizard
Welcome
The first page only explains what happens. Click Continue.
Environment check
The wizard checks your server and lists the results. Fix what is marked as failed and click Retry. Continue when all the required checks pass.
| Check | What it looks at |
|---|---|
| PHP version | The PHP version of the web server |
| Database PHP extensions | Which of mysqli, sqlsrv and pgsql are loaded. The wizard lists the databases that you can use. |
| PHP extensions | mbstring is required. curl, iconv, zip and xml are recommended, ldap, openssl and fileinfo are optional. Xdebug is reported as Not supported and stops the wizard. |
| PHP functions | exec and passthru are recommended (PDF export and Graphviz) |
| File permissions | The web server must be able to write mydbr_config.php |
A missing recommended or optional extension does not stop the installation. The feature that needs it is not available until you install it.
| Message | What to do |
|---|---|
mydbr_config.php is not writable | Give the web server write access (the wizard shows the commands) and click Retry. |
| Please turn off Xdebug | Disable the Xdebug extension in php.ini and restart the web server. |
| No database is listed | Install the PHP driver of your database, see Requirements. |
Report database setup
Enter the connection of the reporting database, the database that holds the myDBR objects.
| Field | Meaning |
|---|---|
| Database type | MySQL / MariaDB, Microsoft SQL Server or PostgreSQL. Only the types whose PHP driver is loaded are offered. |
| Host | The host name or IP address of the database server |
| Port | Optional. Leave empty for the default port of the database. |
| Database | The name of the database for the myDBR objects (default mydbr) |
| Schema | PostgreSQL only. The schema for the myDBR objects, see PostgreSQL. Leave it empty to use the default schema. |
| User, Password | The reporting administrator. This account runs myDBR and needs full access to the reporting database and read access to your data. |
| Socket | MySQL and PostgreSQL, optional. A Unix socket instead of a network connection. |
| Use SSL, Key File, Certificate, CA Cert | MySQL and PostgreSQL. Encrypts the connection between the web server and the database, with optional client certificates. |
Click Continue. The wizard tries to connect and shows what is missing. It offers a button for each missing piece:
| Button | When it appears | What it does |
|---|---|---|
| Create User | The user cannot connect (MySQL and PostgreSQL) | Asks for the user name and password of a database administrator and creates the user with the rights it needs |
| Create Database | The database does not exist | Creates the database |
| Create Objects | The database has no myDBR objects | Creates the tables and routines of myDBR |
| Re-Create Objects | The myDBR objects are already there and valid | Creates them again |
The administrator credentials of Create User are used once and are not saved. If you prefer to prepare the database yourself, follow Manual Installation and the page of your database, then run the wizard.
When the objects are ready, click Continue.
Complete
The wizard saves the configuration (SETUP_DONE is set to true in mydbr_config.php) and creates an evaluation license for this server. Click Start to open myDBR and log in with the default administrator:
- User name:
dba - Password:
dba
Change the user name and the password of the default administrator immediately, see After the Installation.
Demo reports
The demo reports show the features of myDBR and are a good way to learn. You can install them, and remove them later, on the Demo / Localization page of the preferences. See Demo / Localization.
Next
- Request a license for the server, see myDBR License.
- Go through After the Installation.
- Install the optional modules for charts and PDF export.