Requirements
This page lists what the server needs before you install myDBR. The installation wizard checks the same things and shows what is missing (see Quick Start).
| Item | Requirement |
|---|---|
| Web server | Apache, Nginx or IIS with PHP |
| PHP | PHP 8.0 or later |
| PHP loader | SourceGuardian Loader |
| Database | MySQL 5.7 or later, MariaDB 10.3 or later, Microsoft SQL Server 2016 or later, or PostgreSQL 12 or later |
| PHP database driver | The driver for your database (see Database Drivers) |
| Browser | A current browser. Users need no software on their computers. |
PHP
myDBR needs PHP 8.0 or later. Use a current, supported release of PHP for performance and security (see php.net).
PHP extensions
| Extension | Need | Used for |
|---|---|---|
mbstring | Required | UTF-8 text |
| The driver of your database | Required | Connecting to the database, see Database Drivers |
curl | Recommended | The automatic update, proxy connections and other web requests |
iconv | Recommended | Character set conversion |
zip and xml | Recommended | Excel export |
ldap | Optional | Active Directory authentication |
openssl | Optional | Encrypted database connections |
fileinfo | Optional | File downloads |
Check the loaded extensions with php -m.
PHP functions
The functions exec and passthru are recommended. myDBR needs them to run wkhtmltopdf for PDF export and Graphviz for hierarchy charts. If your php.ini lists them in disable_functions, those features do not work.
Xdebug
The xdebug extension must be disabled. SourceGuardian does not run protected scripts when Xdebug is loaded, and the installation wizard stops with the message that Xdebug is not supported.
PHP Loader Requirements
myDBR is distributed as a compiled PHP application and needs the SourceGuardian loader to run. If the loader is missing, myDBR shows the installation instructions for your server when you open it in the browser.
Download the loader for your platform and PHP version from the SourceGuardian download page. The Loader Assistant gives step-by-step instructions. After you change the PHP version, install the loader of the new version too.
Supported Database Versions
| Database | Version |
|---|---|
| MySQL | 5.7 or later |
| MariaDB | 10.3 or later |
| Microsoft SQL Server | 2016 or later |
| PostgreSQL | 12 or later (14 or later is recommended). The citext extension is required, the installation creates it. |
Database Drivers
| Database | PHP driver |
|---|---|
| MySQL / MariaDB | mysqli |
| Microsoft SQL Server | sqlsrv (Microsoft Drivers for PHP) and the Microsoft ODBC Driver for SQL Server |
| PostgreSQL | pgsql (PHP PostgreSQL extension) |
- MySQL / MariaDB: the
mysqliextension is part of most PHP distributions. Enable it inphp.iniif it is not loaded. - Microsoft SQL Server: install the Microsoft Drivers for PHP and follow the installation guide of the project. The drivers need the Microsoft ODBC Driver for SQL Server on the same computer. myDBR connects with
TrustServerCertificateon by default. To require a trusted certificate, change$mydbr_defaults['db_connection']['sqlsrv_connect_info']inuser/defaults.php. - PostgreSQL: check that
pgsqlis loaded (php -m | grep pgsql). On Linux it is usually a separate package, for examplephp-pgsql. Thecitextextension comes from the contrib package of PostgreSQL (for examplepostgresql-contrib) on some systems.
Files and Permissions
During the installation the web server must be able to write the configuration file mydbr_config.php in the myDBR directory, because the wizard saves the database connection there. See Manual Installation for the commands.