HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

I made this guide to help with the installation of Horde Groupware Webmail Edition. I found it was quite difficult when setting this up at first as I was trying to install the full version of Horde and did not need it. This is not the full version of Horde but the Webmail edition which is all I needed for my clients that have used Horde in the past. EX. Ones moving from cAnal.

Note: I am not an expert by any means. This is only what has worked for me. The information listed below is to be used at your own risk. If you have any questions about this post or helpful insight that is not listed please post.

Prerequisite:
First prerequisite to this guide of course is to have ISPConfig up and running. The second part is to have followed the directions listed at the below link on setting up your server to have multiple webmail clients. You can find the directions here: "Webmail Alias not working"

Once you have configured your server to have multiple webmail clients we can get started with setting up Horde.

Step 1: Create a User and Database for your new Horde install
Note: You can use an existing account on your server to add a database and user. I will not cover this as it should be basic knowledge.
Note 2: If you have a primary website this would be the place to create one.

Step 2: Create folder where Horde installs to
From root type:

Code:

# mkdir /usr/share/horde

Step 3: If you have not already done so using "Webmail Alias not working" create a symlink to that folder

Code:

# ln -s /usr/share/horde/ /var/www/webmail/horde

Step 4: Download and extract Horde Groupware Webmail Edition (I'm sure there are better ways to do this but I do not profess to be an expert)

Code:

# cd /usr/share/horde

# wget ftp://ftp.horde.org/pub/horde-webmail/horde-webmail-latest.tar.gz

# tar -zxvpf horde-webmail-latest.tar.gz

# cp -r horde-webmail-1.2.9/* /var/www/webmail/horde

Step 5: Remove unneeded files we just downloaded and moved

Code:

# rm -rf horde-webmail-1.2.9/ horde-webmail-latest.tar.gz

Step 6: Run the install script

Code:

# ./scripts/setup.php

Step 6a: Install options
Here I typed /webmail/horde because that is where I am calling it from in a browser but as you will see later the script ignores this.

Code:

What is the web root path on your web server for this installation, i.e. the 

path of the address you use to access Horde Groupware Webmail Edition in your 

browser? [/horde] /webmail/horde

Step 6b: Install tables
Here I choose 1 to Configure database settings

Code:

Horde Groupware Webmail Edition Configuration Menu

    (0) Exit

    (1) Configure database settings

    (2) Create database or tables

    (3) Configure administrator settings

    (4) Update PEAR for a new or changed location

    (5) Update from an older Horde Groupware Webmail Edition version



Type your choice: 1

Step 6c: What Database to use
Here I have chosen mysql
Note: If you have followed the perfect setup guides then you more than likely would have chosen MySQL for your databases

Code:

What database backend should we use? [false]

    (false) [None]

    (dbase) dBase

    (ibase) Firebird/InterBase

    (fbsql) Frontbase

    (ifx) Informix

    (msql) mSQL

    (mssql) MS SQL Server

    (mysql) MySQL

    (mysqli) MySQL (mysqli)

    (oci8) Oracle

    (odbc) ODBC

    (pgsql) PostgreSQL

    (sqlite) SQLite

    (sybase) Sybase



Type your choice: mysql

Step 6d: Persistent connections
Here I choose no 0

Code:

Request persistent connections? [0]

    (1) Yes

    (0) No



Type your choice: 0

Step 6e: Config your database user
Fill in your_dbuser with your real database username

Code:

Username to connect to the database as* [] your_dbuser

Step 6f: Config your database password
Fill in your_dbpass with your real database password

Code:

Password to connect with [] your_dbpass

Step 6g: Connection
Here I choose tcp because most applications just want to know a host

Code:

How should we connect to the database? [unix]

    (unix) UNIX Sockets

    (tcp) TCP/IP



Type your choice: tcp

Step 6h: Host or Server
Put in localhost

Code:

Database server/host* [] localhost

Step 6i: Port for MySQL
Here just press enter for the default port of 3306

Code:

Port the DB is running on, if non-standard [3306]

Step 6j: What database to use
Fill in your_db with your real database name you created

Code:

Database name to use* [] your_db

Step 6k: Pick charset
Just use the defaults unless you need something different. Press enter

Code:

Internally used charset* [utf-8]

Step 6l: Use SSL or not
I choose 0 for no to keep things easy

Code:

Use SSL to connect to the server? [0]

    (1) Yes

    (0) No



Type your choice: 0

Step 6m: Certification Authority to use for SSL connections
Just press enter

Code:

Certification Authority to use for SSL connections []

Step 6n: Split reads
I choose false for this

Code:

Split reads to a different server? [false]

    (false) Disabled

    (true) Enabled



Type your choice: false

After that you should get this message:
Here I choose option 2 to now write our tables to our database

Code:

Writing main configuration file

Done configuring database settings.





Horde Groupware Webmail Edition Configuration Menu

    (0) Exit

    (1) Configure database settings

    (2) Create database or tables

    (3) Configure administrator settings

    (4) Update PEAR for a new or changed location

    (5) Update from an older Horde Groupware Webmail Edition version



Type your choice: 2

Step 7: Write tables to database
Here I choose n for no to create a database

Code:

Should we create the database for you? If yes, you need to provide a database

user that has permissions to create new databases on your system. If no, we

will only create the database tables for you. [y]

    (y) Yes

    (n) No



Type your choice: n

Step 7a: Provide database user again
Here you will want to type in your_dbuser from step 6e

Code:

Database superuser for creating the tables if necessary for your database system: your_dbuser

Step 7b: Provide the database user password again
Here you will want to type in your_dbpass from step 6f

Code:

Specify a password for the database user: your_dbpass

Step 8: After the above it should successfully write the tables
You should receive messages like this

Code:

Loading database module...

Creating database...

[   OK   ] Successfully created the global tables.

[   OK   ] Successfully created the tables for Mail (imp).

[   OK   ] Successfully created the tables for Filters (ingo).

[   OK   ] Successfully created the tables for Address Book (turba).

[   OK   ] Successfully created the tables for Calendar (kronolith).

[   OK   ] Successfully created the tables for Tasks (nag).

[   OK   ] Successfully created the tables for Notes (mnemo).

Step 9: You will be asked one last question for the tables
Here I choose n for no to keep things easy

Code:

Should we build the database with METAR weather stations now? This is necessary if you want to display METAR weather information. Building the database requires a network connection. [y]

    (y) Yes

    (n) No



Type your choice: n

Then you will receive a message of completion:

Code:

Done creating tables.

Step 10: Finish the install
Choose 0 to exit

Code:

Horde Groupware Webmail Edition Configuration Menu

    (0) Exit

    (1) Configure database settings

    (2) Create database or tables

    (3) Configure administrator settings

    (4) Update PEAR for a new or changed location

    (5) Update from an older Horde Groupware Webmail Edition version



Type your choice: 0

Thank you for using Horde Groupware Webmail Edition!

Now if everything went as it should you should be able to navigate to http://your.tld/webmail/horde

There you should be prompted with a login page for Horde.

Note: If you visit http://your.tld/webmail/horde and it redirects you to http://your.tld/login.php and will not load,
you will have to edit the /usr/share/horde/config/registry.php file.

To do this:

Code:

# nano /usr/share/horde/config/registry.php

Search for this line:

Code:

'webroot' => _detect_webroot(),

And change it to this:

Code:

'webroot' => '/webmail/horde',

Once you have saved the changes try your site again http://your.tld/webmail/horde. It should now load correctly.

With that, I hope this has helped. If you have any questions I would be happy to try and assist. Or if I have missed anything please let me know.

Thanks for the read,
Casey