SQL Database

The Horde 6 Base application can be run without an SQL Database.
Most Horde 6 applications and features cannot be run without an SQL Database.

MariaDB?

Horde 6 has been tested with MariaDB? 10.8 and MariaDB? 10.9 - any MariaDB? of the 10.x series should work.

* ensure mariadb uses "innodb" as its default engine
* ensure the PHP server can reach the database hostname and port
* use utf8mb4 as default charset.
* create a database schema. This documentation assumes the db name is "horde"

mysql> CREATE DATABASE horde;

* create a mariadb user with all default privileges on horde.*

mysql> create user 'hordeuser'@'%' IDENTIFIED by 'hordepw';
mysql> GRANT ALL on horde.* to 'hordeuser'@'%';

Do not use the default password shown here. If you run the DB on the same host as horde, use @'localhost' instead of @'%'. If you want to restrict access to a specific IP address or network, consult the database manual.

MySQL?

Horde 6 has been tested with MySQL? 8 and MySQL? 5.7 versions.
Use the "mysql" settings described under MariaDB?.

Percona Server

Horde 6 has not been tested with Percona Server - any Percona 8 release should work.
Use the "mysql" settings described under MariaDB?.

SQLite

TBD - untested for H6 except some libraries

Postgresql

TBD - Needs confirmation for H6

#Create the database

sudo -u postgres psql horde
postgres=# CREATE USER horde;
postgres=# ALTER USER horde with password 'your password';

#starting with postgres 15+
$ sudo -u postgres psql
postgres=# \c horde 
postgres=# GRANT CREATE ON SCHEMA public TO horde;

Oracle

TBD - untested for H6