Install Database PostgreSQL

ViMbAdmin requires a backend database. We use the Doctrine2 DBAL and ORM so, in theory, any of the databases that Doctrine2 DBAL supports should work fine. We tend to use MySQL / MariaDB exclusively for testing and production so these should be considered as fully supported and recommended.

Installing with PostgreSQL

We have tested a basic install with some features on PostgreSQL and it has worked without issue. That said, you may find somethings do not work - if so, please open an issue with full details.

We referenced Ubuntu's documentation for a primer on PostgreSQL for this.

Ensure you have installed the PHP PostgreSQL module:

sudo apt-get install php5-pgsql

Then, create your user and database:

sudo -u postgres createuser -D -A -P vimbadmin
sudo -u postgres createdb -O vimbadmin vimbadmin
sudo service postgresql reload

Then set your ViMbAdmin application.ini configuration as appropriate:

resources.doctrine2.connection.options.driver   = 'pdo_pgsql'
resources.doctrine2.connection.options.dbname   = 'vimbadmin'
resources.doctrine2.connection.options.user     = 'vimbadmin'
resources.doctrine2.connection.options.password = 'xxx'
resources.doctrine2.connection.options.host     = 'localhost'

You should now be able to continue the standard installation procedure.