Horde Groupware Webmail Edition

From MattWiki

This document was written for a Fedora core 5 system running Horde webmail 1.0.1

Horde Groupware Webmail Edition Prerequisites

yum -y install httpd mod_ssl.i386 php php-ldap php-gd php-pear-DB.noarch php-pear-Net-Socket \
php-pear-Auth-SASL php-pear-Net-SMTP php-pear-Mail php-imap php-pear-Net-Sieve php-pear-Net-URL \
php-pear-HTTP-Request php-pear-Date php-pecl-Fileinfo php-mcrypt php-pear-DB-QueryTool.noarch \
php-dba.i386 php-dbase.i386 php-xml.i386 php-pear-MDB2-Driver-mysql.noarch php-mysql openldap-servers.i386

Setup Mysql for Horde Groupware Webmail Edition

First we need to add the horde user to the database server. So I ran:

mysql -u root
GRANT ALL ON horde.* TO 'horde'@'localhost' IDENTIFIED BY 'hordepass';
exit

Then output from the grant command should be something like:

Query OK, 0 rows affected (0.00 sec)

Download Horde Groupware Webmail Edition

As ROOT run:

cd /var/www/html
wget ftp://ftp.horde.org/pub/horde-webmail/horde-webmail-latest.tar.gz
tar -xf horde-webmail-latest.tar.gz
rm -rf horde-webmail-latest.tar.gz
mv horde-webmail-1.0.1 horde
chown -R apache:apache horde
chmod -R o-rwx horde
cd horde

Installing Horde Groupware Webmail Edition 1.0.1

From the horde install dirctory run:

php scripts/setup.php

Then I answer the questions as following.

What is the root path on your web server for this installation? [/horde]    <Enter>

Configuration Menu
   (0) Exit
   (1) Configure database settings
   (2) Create database or tables
   (3) Configure administrator settings

Type your choice:  1

What database backend should we use?    mysql
Request persistent connections?    1
Database server/host*    127.0.0.1
Username to connect to the database as*    horde
Password to connect with    hordepass
How should we connect to the database?    unix
Location of UNIX socket    /var/lib/mysql/mysql.sock
Database name to use*    horde
Internally used charset* [iso-8859-1]     <Enter>

Now You should be bumped back to the 'Configuration Menu' from above. If you do not you must have misted a step or you my already have horde database info on your system. From this same menu move on to step 2

Configuration Menu
   (0) Exit
   (1) Configure database settings
   (2) Create database or tables
   (3) Configure administrator settings

Type your choice: 2
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: y

Database user for creating the database if necessary for your database system: <Enter>
Specify a password for the database user: <Enter>

You should now see a screen like this

[   OK   ] Successfully created the database.
[   OK   ] Successfully created the tables for Address Book (turba).
[   OK   ] Successfully created the tables for Calendar (kronolith).
[   OK   ] Successfully created the tables for Notes (mnemo).
[   OK   ] Successfully created the tables for Tasks (nag).

And your back to the 'Configuration Menu'. Now setup the Admin user.

Configuration Menu
   (0) Exit
   (1) Configure database settings
   (2) Create database or tables
   (3) Configure administrator settings
Type your choice: 3
Specify a mail user who should have administrator permissions (optional): me

Horde is setup to a point you now can login to your new webmail interface.

Setting up Apache

echo "AddType application/x-httpd-php .php" >> /etc/httpd/conf/httpd.conf
echo "AddType application/x-httpd-php .phps" >> /etc/httpd/conf/httpd.conf
echo "DirectoryIndex index.php" >> /etc/httpd/conf/httpd.conf
/sbin/service httpd restart

Configuring Horde Groupware Webmail Edition

IMP: How to Remove the Outgoing Message Trailer

To remove the trailer on IMP

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

just clear out the trailer.txt file as root via echo

echo "" > /var/www/html/horde/imp/config/trailer.txt

IMP: Display HTML messages inline

To display HTML messages inline aposed to via a link you will need to edit imp/config/mime_drivers.php and change the value to true.

$mime_drivers['imp']['html']['inline'] = true;