Differences between revisions 5 and 22 (spanning 17 versions)
Revision 5 as of 2013-01-03 17:53:56
Size: 1541
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 1: Line 1:
#language en
~-[[DebianWiki/EditorGuide#translation|Translation(s)]]: none-~
----
Line 3: Line 6:
== Debian <= 6 (squeeze) ==
For Debian squeeze and above, Horde 3 instructions are at [[Horde/Horde3]].
== Installing ==
Line 6: Line 8:
== Debian 7 (wheezy) == === Setting up the database ===
Line 8: Line 10:
Horde is not in Debian Wheezy, but you can install it from unstable.

This can be done with:
For MySQL:
Line 12: Line 12:
cat <<EOF > /etc/apt/sources.list.d/unstable.list
deb http://ftp.fr.debian.org/debian unstable main
EOF
cat <<EOF > /etc/apt/preferences.d/horde.pref
Package: *
Pin: release a=unstable
Pin-Priority: 100

Package: php-horde php-horde-*
Pin: release a=unstable
Pin-Priority: 500
EOF
apt-get update
CREATE DATABASE horde;
GRANT ALL PRIVILEGES ON horde.* TO 'horde' IDENTIFIED BY 'secret';
Line 27: Line 16:
... and following the instructions for sid. === Installing bundles ===
Line 29: Line 18:
== Debian unstable (sid) == If you want to install the webmail bundle:
        apt install php-horde-webmail
Line 31: Line 21:
=== Installing bundles ===
If you want to install the webmail bundle:
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:
Line 34: Line 36:
aptitude install php-horde-webmail mysql horde < /usr/share/php/data/horde/scripts/sql/script.initial_horde_user.sql
Line 37: Line 39:
Then : For IMP:
Line 39: Line 41:
webmail-install apt install dovecot-imapd
adduser admin
Line 41: Line 44:
then edit {{{/etc/horde/imp/backends.php}}} and comment out {{{'secure' => 'tls',}}}.
Line 42: Line 46:
If you want to install the groupware bundle: == 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
Line 44: Line 62:
aptitude install php-horde-groupware         cd /etc/horde/<app>
        cp conf.php.dist conf.php
        chown www-data conf.php
Line 46: Line 66:

Then :
{{{
groupware-install
}}}

NB: Horde bundles provides the ''horde-bundle'' virtual package

=== Installing individual applications ===
Just add php-horde- in front of the application name. Example
{{{
aptitude install php-horde-gollem
}}}

=== Configuring Webserver ===

/!\ The ''php-horde'' package installs a simple apache config (''/etc/apache2/conf.d/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'').
   ... 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)

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)