INSTALL document for development versions

[Scott Martin]

---------------------- multipart/mixed attachment
I have worked some more over the weekend on the INSTALL documentation I have
written for the develoment versions of Horde (1.3), Imp (2.3) and Turba. I
want to give this docuement to the horde project for whatever use it may be.
Please look it over and tell me what you think. I am willing to change
anything in it if it will help the project at all. Also, any of you may
alter it in any way you like. I just wanted to do it to help people get
horde installed and working easily.


---------------------- multipart/mixed attachment
Horde/Imp/Turba Quick-Start Guide - 10/2000 by Scott Martin -=0A=
martin@math.ohiou.edu=0A=
=0A=
The Horde project developers have my permission to change, add to or=0A=
subtract from this document in any way they see fit in order to better=0A=
support the Horde project.=0A=
-Scott=0A=
=0A=
I cleaned off my machine and did a fresh install of Redhat Linux 7.0 in=0A=
order to write this document. I also started with a minimal install. This=0A=
document does not cover any installs involving RPM's. I downloaded the=0A=
source on each package and installed from there. This is so those who=0A=
don't have the ability to use RPM's can still benefit from this=0A=
document. I did however include the following programs in my initial=0A=
install. These are required to get PHP, Apache and Horde/Imp configured=0A=
and made: autoconf, automake, bison, cvs, flex, gcc, libtool, make and=0A=
tar. Please make sure you have all of these programs installed on your=0A=
Linux box before you proceed with this document.=0A=
=0A=
In order to take full advantage of everything that Horde and Imp have to=0A=
offer, I have made a list of every package that they could possibly use=0A=
and a URL to obtain the latest release of each package. I suggest you=0A=
grab these packages before you go any further with the install process:=0A=
=0A=
=0A=
Web Servers:=0A=
=0A=
Apache - http://httpd.apache.org/=0A=
=0A=
=0A=
Secure Server: (This is optional. If you don't want secure <https>=0A=
		connections, leave it out.)=0A=
=0A=
mod_ssl - http://www.modssl.org/=0A=
openssl - http://www.openssl.org/  - This is a dependency for mod_ssl,=0A=
	 			     but you may want to use it for ldap also.=0A=
=0A=
=0A=
Scripting Languages:=0A=
=0A=
php4 - http://www.php.net/=0A=
=0A=
=0A=
Php Extensions:=0A=
=0A=
mm - http://www.engelschall.com/sw/mm/ - Shared memory library for both=0A=
					 php and mod_ssl=0A=
imap - http://www.washington.edu/imap/ - Download the file called=0A=
					 c-client.tar.Z=0A=
ldap - http://www.openldap.org/=0A=
mcrypt - http://mcrypt.hellug.gr/index.html - Download the libmcrypt =
file.=0A=
mysql - http://www.mysql.com/ - Download the binaries for your OS. Not=0A=
				the source!=0A=
postgresql - http://postgresql.readysetnet.com/ (Use either this or=0A=
						 MySQL, not both)=0A=
mcal - http://mcal.chek.com/ - Grab both libmcal file and mcaldrivers =
file.=0A=
ftp - (just include --enable-ftp command line on Php configure)=0A=
gettext - http://www.gnu.org/software/gettext/gettext.html=0A=
xml - (Php has Xml libraries included. No need to install anything)=0A=
mssql - Microsoft SQL - commercial package=0A=
odbc - http://www.odbc.org/=0A=
sablotron - http://www.gingerall.com/=0A=
zlib - http://www.info-zip.org/pub/infozip/zlib/=0A=
=0A=
=0A=
External Binaries:=0A=
=0A=
sendmail - http://www.sendmail.org/=0A=
ispell - http://fmg-www.cs.ucla.edu/fmg-members/geoff/ispell.html=0A=
	 Note: No development has been done on ispell since 1995. Try:=0A=
aspell - http://aspell.sourceforge.net/ - A more intelligent ispell=0A=
pspell - http://pspell.sourceforge.net/ - Required if you install aspell=0A=
wvhtml - http://www.wvware.org/=0A=
png - http://www.libpng.org/pub/png/ - Required for wvHtml=0A=
ImageMagick - http://www.wizards.dupont.com/cristy/ImageMagick.html=0A=
	      Required for wvHtml=0A=
freetype - http://www.freetype.org - Required for wvHtml=0A=
libwmf - http://wvware.sourceforge.net/libwmf.html - Required for wvHtml=0A=
xlhtml - http://www.xlhtml.org/=0A=
tar - (Hopefully this comes with your Linux installation)=0A=
gpg - http://www.gnupg.org/=0A=
rpm - http://www.rpm.org/=0A=
dpkg - http://www.debian.org/Packages/stable/base/dpkg.html=0A=
zipinfo - =0A=
=0A=
=0A=
First off, I am installing all of these programs as user 'root' so as to=0A=
avoid authorization problems. Place all of the archives for the above=0A=
programs in one directory (I used /root).=0A=
=0A=
=0A=
Installing PHP Extensions:=0A=
=0A=
=0A=
Install these in any order you want. I'll do it in alphabetical order.=0A=
=0A=
=0A=
UW Imap C-Client:=0A=
=0A=
=0A=
Untar the file: tar -zxvf c-client.tar.Z=0A=
=0A=
Rename the directory to imap. It's too long!: =0A=
mv imap-2000.RELEASE-CANDIDATE.7 imap=0A=
=0A=
"cd" to the imap directory.=0A=
=0A=
Edit the "Makefile" file and find the proper port name for your operating=0A=
system. For most Linux installations it's "slx".=0A=
=0A=
Type "make" followed by the proper port name: make slx=0A=
=0A=
=0A=
Gettext:=0A=
=0A=
=0A=
Untar the file: tar -zxvf gettext*=0A=
=0A=
"cd" the gettext directory: cd gettext*=0A=
=0A=
Type the following commands:=0A=
./configure=0A=
make=0A=
make check=0A=
make install=0A=
=0A=
=0A=
Libmcal and Mcaldrivers:=0A=
=0A=
=0A=
Make sure you grabbed both the libmcal and mcaldrivers archives from the=0A=
mcal website.=0A=
=0A=
untar both files: tar -zxvf libmcal* =0A=
		  tar -zxvf mcaldrivers*=0A=
=0A=
"cd" to mcal-drivers directory=0A=
=0A=
Move the mstore and icap directories inside of the libmcal directory:=0A=
=0A=
mv * ../libmcal=0A=
=0A=
Remove the mcal-drivers directory (it should be empty now):=0A=
rm -frv mcal-drivers=0A=
=0A=
"cd" to libmcal/mstore directory.=0A=
=0A=
Type "make".=0A=
=0A=
"cd" to libmcal/icap directory: cd ../icap=0A=
=0A=
Type "make".=0A=
=0A=
"cd" back to libmcal directory: cd ..=0A=
=0A=
Change the permissions on the "configure" file. It's screwed up in the=0A=
distribution package:=0A=
=0A=
chmod a+x configure=0A=
=0A=
Type:=0A=
=0A=
./configure --with-mstore --with-icap=0A=
make=0A=
make install=0A=
=0A=
Create the local mstore directory: mkdir /var/calendar=0A=
=0A=
Set the permissions on the new directory: chmod 1777 /var/calendar=0A=
=0A=
=0A=
Libmcrypt:=0A=
=0A=
=0A=
Untar the source: tar -zxvf libmcrypt*=0A=
=0A=
"cd" to the libmcrypt directory: cd libmcrypt*=0A=
=0A=
Type:=0A=
./configure --disable-posix-threads=0A=
make=0A=
make install=0A=
=0A=
=0A=
Libxml: =0A=
=0A=
=0A=
Untar the source: tar -zxvf libxml*=0A=
=0A=
"cd" to libxml directory: cd libxml*=0A=
=0A=
Type:=0A=
./configure=0A=
make=0A=
make install=0A=
=0A=
=0A=
MM (Shared Memory):=0A=
=0A=
=0A=
Untar the source: tar -zxvf mm*=0A=
cd to the mm directory: cd mm*=0A=
=0A=
Type:=0A=
=0A=
./configure	(Don't use --prefix=3D like they suggest in the INSTALL=0A=
make		 file. Let the package install in its default=0A=
make install	 location. This will save problems later when=0A=
		 compiling PHP and Apache.)=0A=
=0A=
=0A=
MySQL:=0A=
=0A=
=0A=
Untar the source: tar -zxvf mysql*=0A=
=0A=
Rename the newly created directory "mysql":=0A=
=0A=
mv mysql-3.23.25-beta-pc-linux-gnu-i686 mysql=0A=
=0A=
Move the "mysql" directory to /usr/local : mv mysql /usr/local=0A=
=0A=
Type the following commands:=0A=
groupadd mysql=0A=
useradd -g mysql mysql=0A=
cd /usr/local/mysql=0A=
scripts/mysql_install_db=0A=
chown -R mysql /usr/local/mysql=0A=
chgrp -R mysql /usr/local/mysql=0A=
bin/safe_mysqld --user=3Dmysql &=0A=
=0A=
The following lines are for RedHat Linux to provide automatic startup at=0A=
boot time for MySQL. Your operating system may differ:=0A=
=0A=
cp support-files/mysql.server /etc/rc.d/init.d/mysqld =0A=
chmod a+x /etc/rc.d/init.d/mysqld=0A=
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc2.d/S90mysqld=0A=
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc3.d/S90mysqld=0A=
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc4.d/S90mysqld=0A=
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc5.d/S90mysqld=0A=
=0A=
=0A=
Openldap:=0A=
=0A=
=0A=
Untar the source: tar -zxvf openldap*=0A=
=0A=
If you want the source to compile with the default "./configure" you will=0A=
need a ldbm backend. I suggest Berkeley DB, available at=0A=
http://www.sleepycat.com/.=0A=
=0A=
Untar the DB source: tar -zxvf db*=0A=
=0A=
"cd" to the DB directory: cd db*=0A=
=0A=
"cd" to the build_unix directory: cd build_unix=0A=
=0A=
Type the following:=0A=
../dist/configure=0A=
make=0A=
make install=0A=
=0A=
Note: If you want your LDAP to have SSL support, you need to go to the=0A=
section labeled "OpenSSL:" and install OpenSSL before you go any=0A=
further.=0A=
=0A=
Now "cd" back to the openldap directory: cd /root/openldap*=0A=
=0A=
If you installed Berkeley DB and OpenSSL your next commands will be:=0A=
=0A=
CPPFLAGS=3D"-I/usr/local/BerkeleyDB.3.1/include =
-I/usr/local/ssl/include" \=0A=
LDFLAGS=3D"-L/usr/local/BerkeleyDB.3.1/lib -L/usr/local/ssl/lib" \=0A=
./configure=0A=
make depend=0A=
make=0A=
make install=0A=
=0A=
=0A=
OpenSSL:=0A=
=0A=
=0A=
Untar the source: tar -zxvf openssl*=0A=
"cd" to the openssl directory: cd openssl*=0A=
=0A=
Type the following:=0A=
./config=0A=
make=0A=
make test=0A=
make install=0A=
=0A=
=0A=
Sablot:=0A=
=0A=
=0A=
Untar the source: tar -zxvf Sablot*=0A=
"cd" to the Sablotron directory: cd Sablot*=0A=
=0A=
Type the following commands: (Read the INSTALL document, so you'll know=0A=
			      why you are typing these commands.)=0A=
cp bin/* /usr/bin=0A=
cp include/* /usr/include=0A=
cp lib/* /usr/lib=0A=
ldconfig=0A=
=0A=
=0A=
Zlib:=0A=
=0A=
=0A=
Note: My Redhat Linux initial setup already had zlib installed. However,=0A=
if you are using Redhat, you need to install the zlib-devel rpm also in=0A=
order for the zlib extension to build with PHP.=0A=
=0A=
Untar the zlib source source: tar -zxvf zlib*=0A=
"cd" to the zlib directory: cd zlib=0A=
=0A=
Type the following:=0A=
./configure=0A=
make=0A=
make install=0A=
=0A=
=0A=
Apache and PHP:=0A=
=0A=
=0A=
Untar Apache source: tar -zxvf apache*=0A=
=0A=
Rename the apache source directory to "apache": mv apache_1.3.14 apache=0A=
=0A=
"cd" to the apache directory: cd apache*=0A=
=0A=
Type "./configure" - This will setup enough of a preliminary=0A=
configuration to allow you to 	build PHP. We will come back and=0A=
reconfigure apache again later.=0A=
=0A=
"cd" back to the directory holding the archives: cd ..=0A=
=0A=
Login to the PHP CVS repository. Use phpfi as the password. Type this=0A=
command:=0A=
=0A=
cvs -d :pserver:cvsread@cvs.php.net:/repository login=0A=
=0A=
Obtain the PHP 4.0 CVS tree. Type these commands:=0A=
cvs -d :pserver:cvsread@cvs.php.net:/repository co php4=0A=
cd php4=0A=
=0A=
Login to the Zend CVS repository. Use zend as the password. Type this=0A=
command:=0A=
=0A=
cvs -d :pserver:cvsread@cvs.zend.com:/repository login=0A=
=0A=
Obtain the Zend and TSRM (Thread Safe Resource Manager) CVS tree. Type=0A=
this command:=0A=
=0A=
cvs -d :pserver:cvsread@cvs.zend.com:/repository co Zend TSRM=0A=
=0A=
Configure php. The following command will give you the proper support for=0A=
all of the programs we installed above, but I suggest you type=0A=
"./configure --help" and look over all of the options you can use:=0A=
=0A=
./configure --with-zlib --with-mm --with-sablot \=0A=
--with-mysql=3D/usr/local/mysql --with-mcal=3D../libmcal --with-ldap \=0A=
--with-imap=3D../im4ap --with-gettext --enable-ftp \=0A=
--with-db3=3D/usr/local/BerkeleyDB.3.1 --with-apache=3D../apache \=0A=
--with-mcrypt=0A=
=0A=
Now type:=0A=
make =0A=
make install=0A=
=0A=
If you are not installing mod_ssl, skip this next section:=0A=
=0A=
"cd" back to the directory the archives are stored in: cd ..=0A=
=0A=
Untar the mod_ssl source: tar -zxvf mod_ssl*=0A=
=0A=
"cd" to the mod_ssl directory: cd mod_ssl*=0A=
=0A=
Type:=0A=
./configure --with-apache=3D../apache=0A=
=0A=
If you are NOT installing mod_ssl, start again here:=0A=
=0A=
cd ../apache=0A=
EAPI_MM=3D/usr/local ./configure \=0A=
--activate-module=3Dsrc/modules/php4/libphp4.a \=0A=
=0A=
--enable-module=3Dssl (Leave this line out if you are NOT installing =
mod_ssl.)=0A=
=0A=
make=0A=
=0A=
make certificate TYPE=3Dcustom  (Leave this line out if you are NOT=0A=
			       installing mod_ssl)=0A=
make install=0A=
/usr/local/apache/bin/apachectl start=0A=
cp /usr/local/apache/bin/apachectl /init.d/httpd=0A=
cd /etc/rc.d=0A=
ln -s ../init.d/httpd rc2.d/S99httpd=0A=
ln -s ../init.d/httpd rc3.d/S99httpd=0A=
ln -s ../init.d/httpd rc4.d/S99httpd=0A=
ln -s ../init.d/httpd rc5.d/S99httpd=0A=
=0A=
=0A=
Horde and Imp:=0A=
=0A=
=0A=
Well, if you made it this far, your web server is up and running and so =
is=0A=
PHP. We need to grab the Horde and Imp packages from CVS. Let's get=0A=
started:=0A=
=0A=
First, "cd" to the apache web root. This is where we'll put the Horde and=0A=
Imp directories.=0A=
=0A=
Type:=0A=
=0A=
cd /usr/local/apache/htdocs=0A=
cvs -d :pserver:cvsread@cvs.horde.org:/cvs/horde login=0A=
=0A=
You will be asked for a password. Type: horde=0A=
then type:=0A=
=0A=
cvs -z3 -d :pserver:cvsread@cvs.horde.org:/cvs/horde co horde=0A=
cd horde=0A=
cvs -z3 -d :pserver:cvsread@cvs.horde.org:/cvs/horde co imp=0A=
cvs -z3 -d :pserver:cvsread@cvs.horde.org:/cvs/horde co turba=0A=
ln -s /usr/local/apache/htdocs/horde /horde=0A=
ln -s /usr/local/apache/htdocs/horde/imp /imp=0A=
ln -s /usr/local/apache/htdocs/horde/turba /turba=0A=
=0A=
Now, we have the Horde, Imp and Turba source. Let's put our default=0A=
configuration files into place. Type:=0A=
=0A=
cd /horde/config=0A=
rename php.dist php *=0A=
cd /imp/config=0A=
rename php.dist php *=0A=
cd /turba/config=0A=
rename php.dist php *=0A=
=0A=
Before we test horde, you need to edit httpd.conf in=0A=
/usr/local/apache/conf and uncomment the 4 'AddType' lines related to=0A=
PHP3 and PHP4. Also find the line that says "DirectoryIndex=0A=
index.html" and change it to say:=0A=
=0A=
DirectoryIndex index.html index.php index.php3=0A=
=0A=
Save the file and exit your editor.=0A=
=0A=
You need to copy the file "php.ini-dist" which is in the directory where=0A=
you are storing the Php CVS to "php.ini" in /usr/local/lib. For me, the=0A=
command was:=0A=
=0A=
cp /root/php4/php.ini-dist /usr/local/lib/php.ini=0A=
=0A=
Next, edit the php.ini file and change the line:=0A=
=0A=
magic_quotes_gpc        =3D       On=0A=
=0A=
To:=0A=
=0A=
magic_quotes_gpc        =3D       Off=0A=
=0A=
Also, change the following line from:=0A=
=0A=
include_path =3D  ; UNIX: "/path1:/path2"  Windows: "\path1;\path2"=0A=
=0A=
To:=0A=
=0A=
include_path =3D "/usr/local/lib/php"=0A=
=0A=
Save the file and exit you editor, then type:=0A=
=0A=
/etc/rc.d/init.d/httpd restart=0A=
=0A=
This will restart the web server with the above changes and now you are=0A=
ready to test horde. Go to your web browser and point it to: =0A=
=0A=
http://yourdomainname/horde/test.php=0A=
=0A=
=0A=
External Binaries:=0A=
=0A=
NOTE: You do not have to install the following items for Horde, Imp and=0A=
Turba to work. They are optional. These are the programs that Imp can use=0A=
to show attachments to your emails such as Microsoft Word, Microsoft=0A=
Excel, and PKZipped archives.=0A=
=0A=
=0A=
DPKG:=0A=
=0A=
Extremely simple to install! Download the binary package for your type of=0A=
system from ftp://ftp.debian.org/debian/project/dpkg/. For Redhat, I=0A=
downloaded dpkg-1.6.15_i386.nondebbin.tar.gz.=0A=
=0A=
Now, just switch to your root directory: cd /=0A=
and untar the archive: tar -zxvf /(archive_directory)/dpkg*.gz=0A=
=0A=
That's it. It's installed!=0A=
=0A=
=0A=
GnuPG:=0A=
=0A=
=0A=
Untar the source: tar -zxvf gnupg*=0A=
=0A=
"cd" to the source directory: cd gnupg*=0A=
=0A=
Type:=0A=
=0A=
./configure=0A=
make=0A=
make check=0A=
make install=0A=
gpg --gen-key=0A=
=0A=
=0A=
Aspell:=0A=
=0A=
=0A=
Install the required pspell library first.=0A=
=0A=
Untar the source: tar -zxvf pspell*=0A=
=0A=
"cd" to the source directory: cd pspell*=0A=
=0A=
To install the library simply type=0A=
=0A=
    ./configure=0A=
    make=0A=
    make install=0A=
=0A=
Then install at least one pspell module. You can find more information=0A=
about available modules from the Pspell home page.=0A=
=0A=
After all the pspell modules are installed=0A=
=0A=
    cd modules=0A=
    ./add-modules=0A=
    cd ..=0A=
    make=0A=
    make install=0A=
=0A=
Which will link in the pspell modules.=0A=
=0A=
Now, to install aspell, "cd" back to the aspell source directory:=0A=
cd ..\aspell*=0A=
=0A=
Type:=0A=
=0A=
./configure=0A=
make=0A=
make install=0A=
=0A=
=0A=
ISPELL:=0A=
=0A=
=0A=
This package is extremely old and I honestly cannot figure out how to=0A=
build it under Linux. I will update this section when I do.=0A=
=0A=
=0A=
XlHtml:=0A=
=0A=
=0A=
Untar the source: tar -zxvf xlHtml*=0A=
=0A=
"cd" to the source directory: cd xlHtml*=0A=
=0A=
Type:=0A=
=0A=
./configure=0A=
make=0A=
make check=0A=
make install=0A=
=0A=
=0A=
WvHtml:=0A=
=0A=
=0A=
You have to install the prerequisites for wvHtml first. We'll start for=0A=
freetype:=0A=
=0A=
NOTE: Do NOT install the version 2 Beta of freetype. They have changed=0A=
libttf to libfreetype which will cause libwmf to not find freetype.=0A=
=0A=
Untar the truetype source: tar -zxvf freetype*=0A=
=0A=
"cd" to the source directory: cd freetype*=0A=
=0A=
Type :=0A=
=0A=
./configure=0A=
make=0A=
make install=0A=
=0A=
Now let's install libwmf.=0A=
=0A=
Note: In my initial installation of RedHat, I already had Xpm installed,=0A=
which is required for libwmf. However, libwmf also requires the Xpm =
header=0A=
files, which are in the rpm package XFree86-devel. I had to install this=0A=
package from the RedHat CD-Rom. If you do not have this luxury, you will=0A=
have to install the XPM package from: ftp://ftp.x.org/contrib/libraries=0A=
=0A=
"cd" back to the directory where the archives are stored: cd ..=0A=
=0A=
Untar the souce: tar -zxvf libwmf*=0A=
=0A=
"cd" to the libwmf directory: =0A=
=0A=
Type:=0A=
=0A=
./configure --with-ttf=3D/usr/local=0A=
make=0A=
make install=0A=
=0A=
Next, we install libpng:=0A=
=0A=
"cd" back to the directory where the archives are stored: cd ..=0A=
=0A=
Untar the source: tar -zxvf libpng*=0A=
=0A=
"cd" to the source directory: cd libpng*=0A=
=0A=
You are probably going to have to read the installation instructions from=0A=
the distribution here, because you have to copy the proper "Makefile" =
from=0A=
the "scripts" directory to be able to install. I used "makefile.gcmmx".=0A=
Here are the commands I used to install:=0A=
=0A=
cp scripts/makefile.gcmmx Makefile=0A=
make test=0A=
make install=0A=
=0A=
Onward to ImageMagick install:=0A=
=0A=
"cd" back to the directory where the archives are stored: cd ..=0A=
=0A=
Untar the source: tar -zxvf Image*=0A=
=0A=
"cd" to the source directory: cd Image*=0A=
=0A=
Type:=0A=
=0A=
./configure --with-xpm=3D/usr/X11R6 --with-ttf=3D/usr/local \=0A=
--with-Magick=3D/usr/local=0A=
make=0A=
make install=0A=
=0A=
=0A=
Adding External Binaries To Imp Configuration File:=0A=
=0A=
=0A=
cd /imp/config=0A=
pico conf.php=0A=
=0A=
/* External Utilities */=0A=
$conf['utils'] =3D array();=0A=
$conf['utils']['sendmail'] =3D '/usr/sbin/sendmail';=0A=
$conf['utils']['ispell'] =3D '/usr/local/bin/aspell';=0A=
$conf['utils']['wordviewer'] =3D '/usr/local/bin/wvHtml';=0A=
$conf['utils']['excelviewer'] =3D '/usr/local/bin/xlHtml';=0A=
$conf['utils']['tar'] =3D '/bin/tar';=0A=
$conf['utils']['gpg'] =3D '/usr/bin/gpg';=0A=
$conf['utils']['rpm'] =3D '/bin/rpm';=0A=
$conf['utils']['dpkg'] =3D '/usr/bin/dpkg';=0A=
=0A=
=0A=
Setting Up The Horde Database Under MySQL:=0A=
=0A=
For preferences:=0A=
=0A=
 create table user_webmail_prefs (=0A=
     uid             char(32) not null,=0A=
     pref_name       char(32) not null,=0A=
     pref_value      text null,=0A=
     primary key (uid, pref_name)=0A=
 );=0A=
=0A=
and in imp/config/conf.php=0A=
=0A=
/* Preference System Settings */=0A=
$conf['prefs'] =3D array();=0A=
$conf['prefs']['driver'] =3D 'sql';=0A=
$conf['prefs']['params'] =3D array();=0A=
$conf['prefs']['params']['phptype'] =3D 'mysql';=0A=
$conf['prefs']['params']['hostspec'] =3D 'localhost';=0A=
$conf['prefs']['params']['username'] =3D 'user';=0A=
$conf['prefs']['params']['password'] =3D 'pass';=0A=
$conf['prefs']['params']['database'] =3D 'horde';=0A=
$conf['prefs']['params']['table'] =3D 'user_webmail_prefs';=0A=
=0A=
And for connection tracking:=0A=
=0A=
 create table connections (=0A=
     addr        varchar(8)  not null,=0A=
     conn_id     varchar(32) not null,=0A=
     conn_ts     int(14)     not null,=0A=
     primary key (addr, conn_id)=0A=
 );=0A=
=0A=
and in imp/config/conf.php=0A=
=0A=
/* Connection Tracking */=0A=
$conf['connections']['track'] =3D true;=0A=
$conf['connections']['driver'] =3D 'sql';=0A=
$conf['connections']['params'] =3D array();=0A=
$conf['connections']['params']['phptype'] =3D 'mysql';=0A=
$conf['connections']['params']['hostspec'] =3D 'localhost';=0A=
$conf['connections']['params']['username'] =3D 'user';=0A=
$conf['connections']['params']['password'] =3D 'pass';=0A=
$conf['connections']['params']['database'] =3D 'horde';=0A=
$conf['connections']['params']['table'] =3D 'connections';=0A=
=0A=
=0A=
Welcome to the MySQL monitor.  Commands end with ; or \g.=0A=
Your MySQL connection id is 27 to server version: 3.23.25-beta=0A=
=0A=
Type 'help;' or '\h' for help. Type '\c' to clear the buffer=0A=
=0A=
mysql> GRANT ALL PRIVILEGES ON *.* TO hordemgr@localhost=0A=
    -> IDENTIFIED BY 'hordemgr' WITH GRANT OPTION;=0A=
Query OK, 0 rows affected (0.00 sec)=0A=
=0A=
mysql> GRANT ALL PRIVILEGES ON *.* TO hordemgr@"%"=0A=
    -> IDENTIFIED BY 'hordemgr' WITH GRANT OPTION;=0A=
Query OK, 0 rows affected (0.00 sec)=0A=

---------------------- multipart/mixed attachment--