Skip to main content

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).

ItemRequirement
Web serverApache, Nginx or IIS with PHP
PHPPHP 8.0 or later
PHP loaderSourceGuardian Loader
DatabaseMySQL 5.7 or later, MariaDB 10.3 or later, Microsoft SQL Server 2016 or later, or PostgreSQL 12 or later
PHP database driverThe driver for your database (see Database Drivers)
BrowserA 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​

ExtensionNeedUsed for
mbstringRequiredUTF-8 text
The driver of your databaseRequiredConnecting to the database, see Database Drivers
curlRecommendedThe automatic update, proxy connections and other web requests
iconvRecommendedCharacter set conversion
zip and xmlRecommendedExcel export
ldapOptionalActive Directory authentication
opensslOptionalEncrypted database connections
fileinfoOptionalFile 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​

DatabaseVersion
MySQL5.7 or later
MariaDB10.3 or later
Microsoft SQL Server2016 or later
PostgreSQL12 or later (14 or later is recommended). The citext extension is required, the installation creates it.

Database Drivers​

DatabasePHP driver
MySQL / MariaDBmysqli
Microsoft SQL Serversqlsrv (Microsoft Drivers for PHP) and the Microsoft ODBC Driver for SQL Server
PostgreSQLpgsql (PHP PostgreSQL extension)
  • MySQL / MariaDB: the mysqli extension is part of most PHP distributions. Enable it in php.ini if 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 TrustServerCertificate on by default. To require a trusted certificate, change $mydbr_defaults['db_connection']['sqlsrv_connect_info'] in user/defaults.php.
  • PostgreSQL: check that pgsql is loaded (php -m | grep pgsql). On Linux it is usually a separate package, for example php-pgsql. The citext extension comes from the contrib package of PostgreSQL (for example postgresql-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.