==============
 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