6.0.0-git
2024-12-02

Diff for Doc/Dev/H6/Installation/SQL between and 1

+ 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" 
<code>mysql> CREATE DATABASE horde;
</code>
 * create a mariadb user with all default privileges on horde.*  
<code>
mysql> create user 'hordeuser'@'%' IDENTIFIED by 'hordepw';
mysql> GRANT ALL on horde.* to 'hordeuser'@'%';
</code>

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 - untested for H6

++ Oracle

TBD - untested for H6