Differences between revisions 14 and 22 (spanning 8 versions)
⇤ ← Revision 14 as of 2013-10-31 14:19:03 →
Size: 2216
Editor: ?MathieuParent
Comment:
← Revision 22 as of 2021-02-18 13:39:08 → ⇥
Size: 1981
Editor: ?Beuc
Comment: more MySQL notes
Deletions are marked like this. Additions are marked like this.
Line 6: Line 6:
== Distribution-specific requirements == == Installing ==
Line 8: Line 8:
=== Debian 6.0 "Squeeze" === === Setting up the database ===
Line 10: Line 10:
For Debian squeeze, Horde 3 instructions are at [[Horde/Horde3]].

=== Debian 7.0 "Wheezy" ===

Horde is not in Debian Wheezy, but you can install it from jessie.

Do this (as root):		 For MySQL:
Line 18: Line 12:
cat <<EOF > /etc/apt/sources.list.d/jessie.list
deb http://ftp.fr.debian.org/debian jessie main
EOF
cat <<EOF > /etc/apt/preferences.d/horde.pref
Package: *
Pin: release a=testing
Pin-Priority: 100

Package: php-horde php-horde-*
Pin: release a=testing
Pin-Priority: 500
EOF
apt-get update		 CREATE DATABASE horde;
GRANT ALL PRIVILEGES ON horde.* TO 'horde' IDENTIFIED BY 'secret';
Line 32: Line 15:

... and follow the generic instructions.

=== Debian 8.0 "Jessie" and later ===

No specific instructions: follow the generic instructions.

== Installing ==
Line 44: Line 19:
        apt-get install php-horde-webmail         apt install php-horde-webmail
Line 47: Line 22:
        apt-get install php-horde-groupware         apt install php-horde-groupware
Line 53: Line 28:
Just add php-horde- in front of the application name. Example:
        apt-get install php-horde-gollem		 Just add php-horde- in front of the application name. For example:
        apt install php-horde-gollem
Line 56: Line 31:
=== Installing an admin user ===

For {{{admin:admin}}} credentials, an a MySQL database:

{{{
mysql horde < /usr/share/php/data/horde/scripts/sql/script.initial_horde_user.sql
}}}

For IMP:
{{{
apt install dovecot-imapd
adduser admin
}}}
then edit {{{/etc/horde/imp/backends.php}}} and comment out {{{'secure' => 'tls',}}}.
Line 60: Line 49:
The ''php-horde'' package installs a simple apache config
(''/etc/apache2/conf.d/php-horde.conf''). This is for fast installation but is		 The ''php-horde'' package installs a simple Apache config
(''/etc/apache2/conf-available/php-horde.conf''). This is for fast installation but is
Line 78: Line 67:
 * 3. configure thru the web interface, download the generated file, copy it to  * 3. configure through the web interface, download the generated file, copy it to

Translation(s): none

General Horde installation Howto

Installing

Setting up the database

For MySQL: 

CREATE DATABASE horde;
GRANT ALL PRIVILEGES ON horde.* TO 'horde' IDENTIFIED BY 'secret';

Installing bundles

If you want to install the webmail bundle:

  • apt install php-horde-webmail

If you want to install the groupware bundle:

  • apt install php-horde-groupware

NB: Horde bundles provide the horde-bundle virtual package

Installing individual applications

Just add php-horde- in front of the application name. For example:

  • apt install php-horde-gollem

Installing an admin user

For admin:admin credentials, an a MySQL database: 

mysql horde < /usr/share/php/data/horde/scripts/sql/script.initial_horde_user.sql

For IMP: 

apt install dovecot-imapd
adduser admin

then edit /etc/horde/imp/backends.php and comment out 'secure' => 'tls',.

Configuring Webserver

/!\ The php-horde package installs a simple Apache config (/etc/apache2/conf-available/php-horde.conf). This is for fast installation but is not sufficient for production environment (it does not ensure SSL). You can remove it and add a new site (/etc/apache2/sites-available/horde.conf) and enable it (a2ensite horde).

Configuring Horde

There are several ways to configure Horde:

  • 1. if you have installed a bundle, you can run the included script
    • (webmail-install or groupware-install)
  • 2. for each application, you can bootstrap the config 

        cd /etc/horde/<app>
        cp conf.php.dist conf.php
        chown www-data conf.php
  • .. then use the web interface:
  • 3. configure through the web interface, download the generated file, copy it to

    • /etc/horde/<app> and make it unwritable (chown root + chmod 0755)