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