1541
Comment:
|
← Revision 22 as of 2021-02-18 13:39:08 ⇥
1981
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)