[cvs] Would help to attach file, wouldn't it???
Scott Martin
martin@math.ohiou.edu
Wed, 1 Nov 2000 15:58:58 -0500
---------------------- multipart/mixed attachment
I guess I have to name it INSTALL.patch.txt so that Outlook Express will
encode it in a form that Qmail will except. Here goes another try.
----- Original Message -----
From: "Scott Martin" <martin@math.ohiou.edu>
To: <cvs@lists.horde.org>
Sent: Wednesday, November 01, 2000 3:52 PM
Subject: [cvs] Would help to attach file, wouldn't it???
>
>
---------------------- multipart/mixed attachment
Index: INSTALL=0A=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A=
RCS file: /cvs/horde/horde/docs/INSTALL,v=0A=
retrieving revision 1.12=0A=
diff -u -r1.12 INSTALL=0A=
--- INSTALL 2000/11/01 12:50:58 1.12=0A=
+++ INSTALL 2000/11/01 20:30:45=0A=
@@ -35,22 +35,21 @@=0A=
The following are notes from Scott Martin <martin@math.ohiou.edu> on=0A=
how he successfully installed Horde/IMP.=0A=
=0A=
-I cleaned off my machine and did a fresh install of Red Hat 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.=0A=
+I cleaned off my machine twice and did fresh installs of Redhat Linux=0A=
+7.0, php, horde, imp, turba, etc. in order to write this document. I =
also=0A=
+started with a minimal install. This document does not cover any =
installs=0A=
+involving RPM's. I downloaded the source on each package and installed=0A=
+from there. This is so those who don't have the ability to use RPM's can=0A=
+still benefit from this document.=0A=
=0A=
-=0A=
---------------------=0A=
Prerequisite Packages=0A=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A=
=0A=
-The following 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=
+The following are required to get PHP, Apache and the PHP extensions =0A=
+configured and made: autoconf, automake, bison, cvs, flex, gcc, libtool,=0A=
+make and tar. Please make sure you have all of these programs installed=0A=
+on your 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=
@@ -74,7 +73,8 @@=0A=
Scripting Languages=0A=
-------------------=0A=
=0A=
-php4 - http://www.php.net/=0A=
+php4 - http://www.php.net/ - Don't download a package. You'll have to=0A=
+ obtain the latest source code using CVS. Instructions below.=0A=
=0A=
=0A=
PHP Extensions=0A=
@@ -85,18 +85,14 @@=0A=
IMAP - http://www.washington.edu/imap/ - Download the file called=0A=
c-client.tar.Z=0A=
LDAP - http://www.openldap.org/=0A=
+Berkeley DB - http://www.sleepycat.com/ - Required for LDBM in LDAP.=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=
@@ -135,13 +131,25 @@=0A=
=0A=
UW-IMAP c-client=0A=
----------------=0A=
+=0A=
+NOTE: You are not forced to use the UW-Imap source as your IMAP client =
for=0A=
+Imp. There are other programs available such as Cyrus IMAP that are=0A=
+reported to work just as well. I chose UW-IMAP because it is the most=0A=
+commonly used IMAP client. If you install another client and get it=0A=
+successfully working, please submit the install instuctions for =
inclusion=0A=
+into this document.=0A=
+=0A=
+"cd" to the directory containing your source files (I used /root):=0A=
+=0A=
+cd /root=0A=
=0A=
-Untar the file: tar -zxvf c-client.tar.Z=0A=
+Untar the source file: tar -zxvf c-client.tar.Z=0A=
=0A=
-Rename the directory to imap. It's too long!:=0A=
+Rename the directory to imap. The name is too long! Type:=0A=
+=0A=
mv imap-2000.RELEASE-CANDIDATE.7 imap=0A=
=0A=
-"cd" to the imap directory.=0A=
+"cd" to the imap directory: cd imap=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=
@@ -151,12 +159,15 @@=0A=
=0A=
gettext=0A=
-------=0A=
+=0A=
+"cd" to the directory containing your source files: cd ..=0A=
=0A=
-Untar the file: tar -zxvf gettext*=0A=
+Untar the source file: tar -zxvf gettext*=0A=
=0A=
-"cd" the gettext directory: cd gettext*=0A=
+"cd" the source directory: cd gettext*=0A=
=0A=
Type the following commands:=0A=
+=0A=
./configure=0A=
make=0A=
make check=0A=
@@ -169,25 +180,33 @@=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=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
+Untar both files: tar -zxvf libmcal*=0A=
tar -zxvf mcaldrivers*=0A=
=0A=
-"cd" to mcal-drivers directory=0A=
+"cd" to mcal-drivers directory: cd mcal-drivers=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=
+=0A=
+cd ..=0A=
rm -frv mcal-drivers=0A=
=0A=
"cd" to libmcal/mstore directory.=0A=
+=0A=
+Type:=0A=
=0A=
-Type "make".=0A=
+make=0A=
=0A=
"cd" to libmcal/icap directory: cd ../icap=0A=
+=0A=
+Type:=0A=
=0A=
-Type "make".=0A=
+make=0A=
=0A=
"cd" back to libmcal directory: cd ..=0A=
=0A=
@@ -201,20 +220,27 @@=0A=
./configure --with-mstore --with-icap=0A=
make=0A=
make install=0A=
+=0A=
+Create the local mstore directory:=0A=
+=0A=
+mkdir /var/calendar=0A=
=0A=
-Create the local mstore directory: mkdir /var/calendar=0A=
+Set the permissions on the new directory:=0A=
=0A=
-Set the permissions on the new directory: chmod 1777 /var/calendar=0A=
+chmod 1777 /var/calendar=0A=
=0A=
=0A=
libmcrypt=0A=
---------=0A=
=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
Untar the source: tar -zxvf libmcrypt*=0A=
=0A=
"cd" to the libmcrypt directory: cd libmcrypt*=0A=
=0A=
Type:=0A=
+=0A=
./configure --disable-posix-threads=0A=
make=0A=
make install=0A=
@@ -223,11 +249,14 @@=0A=
libxml=0A=
------=0A=
=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
Untar the source: tar -zxvf libxml*=0A=
=0A=
"cd" to libxml directory: cd libxml*=0A=
=0A=
Type:=0A=
+=0A=
./configure=0A=
make=0A=
make install=0A=
@@ -236,7 +265,10 @@=0A=
mm (shared memory)=0A=
------------------=0A=
=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
Untar the source: tar -zxvf mm*=0A=
+=0A=
cd to the mm directory: cd mm*=0A=
=0A=
Type:=0A=
@@ -251,9 +283,20 @@=0A=
MySQL=0A=
-----=0A=
=0A=
+NOTE: You are not required to use MySQL as your Horde/Imp database. PHP=0A=
+also supports other databases such as PostgreSQL and Microsoft SQL. I=0A=
+chose to use MySQL because it was the original database used by the =
Horde=0A=
+project developers. If you successfully get another database working =
with=0A=
+Horde/Imp, please submit the installation instructions for inclusion =
into=0A=
+this document.=0A=
+=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
Untar the source: tar -zxvf mysql*=0A=
=0A=
-Rename the newly created directory "mysql":=0A=
+Rename the newly created directory to "mysql": (Please note, that I used=0A=
+ MySQL 3.23.25-beta during this install. The actual name of the=0A=
+ directory you will rename may differ.)=0A=
=0A=
mv mysql-3.23.25-beta-pc-linux-gnu-i686 mysql=0A=
=0A=
@@ -268,6 +311,20 @@=0A=
chgrp -R mysql /usr/local/mysql=0A=
bin/safe_mysqld --user=3Dmysql &=0A=
=0A=
+Edit the file /etc/profile and add the mysql/bin path to it. Type:=0A=
+=0A=
+pico /etc/profile (or type: vi /etc/profile if you don't have pico)=0A=
+=0A=
+Here is what my "path" line in the file looked like before editing:=0A=
+=0A=
+PATH=3D"$PATH:/usr/X11R6/bin"=0A=
+=0A=
+and after:=0A=
+=0A=
+PATH=3D"$PATH:/usr/X11R6/bin:/usr/local/mysql/bin"=0A=
+=0A=
+Save the file and exit the editor.=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=
@@ -282,12 +339,20 @@=0A=
OpenLDAP=0A=
--------=0A=
=0A=
+"cd" to the directory containing your source files: cd ..=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=
+In order to get the source to compile with the default "./configure", we=0A=
+have to install the LDBM backend first.=0A=
=0A=
+NOTE: You are not required to use Berkeley DB for your LDBM backend. =
There=0A=
+are other programs which will work. I chose Berkeley DB because it is =
the=0A=
+most commonly used LDBM backend. See the OpenLDAP installation=0A=
+instructions for information on other backends that you can use.=0A=
+=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
Untar the DB source: tar -zxvf db*=0A=
=0A=
"cd" to the DB directory: cd db*=0A=
@@ -295,6 +360,7 @@=0A=
"cd" to the build_unix directory: cd build_unix=0A=
=0A=
Type the following:=0A=
+=0A=
../dist/configure=0A=
make=0A=
make install=0A=
@@ -318,41 +384,36 @@=0A=
OpenSSL=0A=
-------=0A=
=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
Untar the source: tar -zxvf openssl*=0A=
+=0A=
"cd" to the openssl directory: cd openssl*=0A=
=0A=
Type the following:=0A=
+=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 Red Hat Linux initial setup already had zlib installed. =
However,=0A=
if you are using Red Hat, you need to install the zlib-devel rpm also in=0A=
-order for the zlib extension to build with PHP.=0A=
+order for the zlib extension to build with PHP. I went ahead and=0A=
+uninstalled the RPM's so I could build from source.=0A=
+=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
+Untar the zlib source: tar -zxvf zlib*=0A=
=0A=
-Untar the zlib source source: tar -zxvf zlib*=0A=
"cd" to the zlib directory: cd zlib=0A=
=0A=
Type the following:=0A=
+=0A=
./configure=0A=
make=0A=
make install=0A=
@@ -361,16 +422,23 @@=0A=
Apache and PHP=0A=
--------------=0A=
=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
Untar Apache source: tar -zxvf apache*=0A=
+=0A=
+Rename the apache source directory to "apache":=0A=
=0A=
-Rename the apache source directory to "apache": mv apache_1.3.14 apache=0A=
+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=
+Type:=0A=
+=0A=
+./configure=0A=
=0A=
+This will setup enough of a preliminary configuration to allow you to=0A=
+build PHP. We will come back and 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=
@@ -379,6 +447,7 @@=0A=
cvs -d :pserver:cvsread@cvs.php.net:/repository login=0A=
=0A=
Obtain the PHP 4.0 CVS tree. Type these commands:=0A=
+=0A=
cvs -d :pserver:cvsread@cvs.php.net:/repository co php4=0A=
cd php4=0A=
=0A=
@@ -396,17 +465,17 @@=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=
+./configure --with-zlib --with-mm --with-mysql=3D/usr/local/mysql \=0A=
+--with-mcal=3D../libmcal --with-ldap --with-imap=3D../imap \=0A=
+--with-gettext --enable-ftp --with-db3=3D/usr/local/BerkeleyDB.3.1 \=0A=
+--with-apache=3D../apache --with-mcrypt=0A=
=0A=
Now type:=0A=
+=0A=
make=0A=
make install=0A=
=0A=
-If you are not installing mod_ssl, skip this next section:=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=
@@ -415,22 +484,22 @@=0A=
"cd" to the mod_ssl directory: cd mod_ssl*=0A=
=0A=
Type:=0A=
+=0A=
./configure --with-apache=3D../apache=0A=
=0A=
If you are NOT installing mod_ssl, start again here:=0A=
=0A=
cd ../apache=0A=
+=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=
+/usr/local/apache/bin/apachectl start (or startssl for mod_ssl)=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=
@@ -470,17 +539,29 @@=0A=
configuration files into place. Type:=0A=
=0A=
cd /horde/config=0A=
-rename php.dist php *=0A=
+cp horde.php.dist horde.php=0A=
+cp mime.php.dist mime.php=0A=
+cp registry.php.dist registry.php=0A=
+cp html.php.dist html.php=0A=
+cp modules.php.dist modules.php=0A=
cd /imp/config=0A=
-rename php.dist php *=0A=
+cp conf.php.dist conf.php=0A=
+cp prefs.php.dist prefs.php=0A=
+cp html.php.dist html.php=0A=
+cp servers.php.dist servers.php=0A=
cd /turba/config=0A=
-rename php.dist php *=0A=
+cp conf.php.dist conf.php=0A=
+cp html.php.dist html.php=0A=
+cp sources.php.dist sources.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=
+PHP3 and PHP4. Also find the line that says:=0A=
=0A=
+DirectoryIndex index.html=0A=
+=0A=
+and change it to say:=0A=
+=0A=
DirectoryIndex index.html index.php index.php3=0A=
=0A=
Save the file and exit your editor.=0A=
@@ -498,8 +579,11 @@=0A=
To:=0A=
=0A=
magic_quotes_gpc =3D Off=0A=
+=0A=
=0A=
-Also, change the following line from:=0A=
+ln -s /usr/local/apache/htdocs/horde /horde=0A=
+Also, change the following line=0A=
+from:=0A=
=0A=
include_path =3D ; UNIX: "/path1:/path2" Windows: "\path1;\path2"=0A=
=0A=
@@ -507,7 +591,7 @@=0A=
=0A=
include_path =3D "/usr/local/lib/php"=0A=
=0A=
-Save the file and exit you editor, then type:=0A=
+Save the file and exit your editor, then type:=0A=
=0A=
/etc/rc.d/init.d/httpd restart=0A=
=0A=
@@ -516,6 +600,10 @@=0A=
=0A=
http://example.com/horde/test.php=0A=
=0A=
+Hopefully, your php setup passed all the required tests in test.php and=0A=
+you are ready to move on to configuring Horde, Imp and Turba so you can=0A=
+use them.=0A=
+=0A=
=0A=
-----------------=0A=
External Binaries=0A=
@@ -523,8 +611,8 @@=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=
+to show attachments to your emails such as Microsoft Word documents,=0A=
+Microsoft Excel documents, RPM packages, etc.=0A=
=0A=
=0A=
DPKG=0A=
@@ -535,7 +623,8 @@=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=
+Untar the archive: tar -zxvf /(archive_directory)/dpkg*.gz=0A=
=0A=
That's it. It's installed!=0A=
=0A=
@@ -543,6 +632,10 @@=0A=
GnuPG=0A=
-----=0A=
=0A=
+"cd" to the directory containing your source files (I used /root):=0A=
+=0A=
+cd /root=0A=
+=0A=
Untar the source: tar -zxvf gnupg*=0A=
=0A=
"cd" to the source directory: cd gnupg*=0A=
@@ -559,32 +652,35 @@=0A=
aspell=0A=
------=0A=
=0A=
-Install the required pspell library first.=0A=
+"cd" to the directory containing your source files: cd ..=0A=
=0A=
+We have to 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=
+./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=
+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=
+=0A=
cd ..\aspell*=0A=
=0A=
Type:=0A=
@@ -598,12 +694,15 @@=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=
+build it under Linux. I will update this section when I do. If you can=0A=
+build it, please submit the installation instructions to me.=0A=
=0A=
=0A=
xlHtml=0A=
------=0A=
=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
Untar the source: tar -zxvf xlHtml*=0A=
=0A=
"cd" to the source directory: cd xlHtml*=0A=
@@ -619,7 +718,9 @@=0A=
wvHtml=0A=
-------=0A=
=0A=
-You have to install the prerequisites for wvHtml first. We'll start for=0A=
+"cd" to the directory containing your source files: cd ..=0A=
+=0A=
+You have to install the prerequisites for wvHtml first. We'll start with=0A=
freetype:=0A=
=0A=
NOTE: Do NOT install the version 2 Beta of freetype. They have changed=0A=
@@ -674,6 +775,10 @@=0A=
=0A=
Onward to ImageMagick install:=0A=
=0A=
+NOTE: I had problems getting the pre-compile binary packages to work=0A=
+correctly, so I downloaded the source and built it. The following=0A=
+instructions assume you are building from source:=0A=
+=0A=
"cd" back to the directory where the archives are stored: cd ..=0A=
=0A=
Untar the source: tar -zxvf Image*=0A=
@@ -689,16 +794,22 @@=0A=
=0A=
=0A=
--------------------------------------------------=0A=
-Adding External Binaries To IMP Configuration File=0A=
-=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=0A=
+Adding External Binaries To The IMP Configuration File=0A=
+=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=0A=
+=0A=
+Edit the conf.php file and add the paths to all of the external binaries=0A=
+that we installed above:=0A=
=0A=
cd /imp/config=0A=
-pico conf.php=0A=
+pico conf.php (or use vi if you don't have the pine package installed)=0A=
=0A=
+Here is what the External Utilities section of Imp's conf.php looked =
like=0A=
+after I made the changes:=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']['spellchecker'] =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=
@@ -710,20 +821,60 @@=0A=
-----------------------------------------=0A=
Setting Up The Horde Database Under MySQL=0A=
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A=
+=0A=
+First of all, it is very important that you change the MySQL password =
for=0A=
+the user 'root'. If you haven't done so already, log in as user 'root' =
and=0A=
+type:=0A=
+=0A=
+mysqladmin -p password (put your new password here)=0A=
+=0A=
+Login to MySQL by typing:=0A=
+=0A=
+mysql -p=0A=
+=0A=
+Enter the password for root.=0A=
+=0A=
+Now, create the database name "horde" and set up the two tables called=0A=
+"user_webmail_prefs" and "connections". You can name these fields =
anything=0A=
+you like as long as you use the same names when you alter the conf.php=0A=
+file in the /imp/config directory (see instructions below). Type:=0A=
=0A=
-For preferences:=0A=
+create table user_webmail_prefs (uid char(32) not null, pref_name =
char(32)=0A=
+not null, pref_value text null, primary key (uid, pref_name));=0A=
+create table connections (addr varchar(8) not null, conn_id varchar(32)=0A=
+not null, conn_ts int(14) not null, primary key (addr, conn_id));=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=
+Next, create the user for the horde database. You can call this user any=0A=
+name and give this user any password you want, just make sure that you=0A=
+use the same name and password when you alter conf.php in /imp/config.=0A=
+For this example, I will call the user "hordemgr" and make the password=0A=
+"hordepass". Type:=0A=
=0A=
-and in imp/config/conf.php=0A=
+REPLACE INTO user ( host, user, password )=0A=
+VALUES ('localhost', 'hordemgr', password('hordepass'));=0A=
+REPLACE INTO db ( host, db, user, select_priv, insert_priv, update_priv,=0A=
+delete_priv, create_priv, drop_priv )=0A=
+VALUES ('localhost', 'horde', 'hordemgr', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');=0A=
=0A=
+Exit MySQL by typing:=0A=
+=0A=
+quit=0A=
+=0A=
+Now that MySQL is setup with the Horde database and the database user, =
we=0A=
+can configure Imp to use MySQL. Edit conf.php in the /imp/config =
directory=0A=
+with either the pico or vi editor and make the following changes:=0A=
+=0A=
+Change:=0A=
+=0A=
/* Preference System Settings */=0A=
$conf['prefs'] =3D array();=0A=
+$conf['prefs']['driver'] =3D 'none';=0A=
+$conf['prefs']['params'] =3D array();=0A=
+=0A=
+To:=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=
@@ -733,16 +884,14 @@=0A=
$conf['prefs']['params']['database'] =3D 'horde';=0A=
$conf['prefs']['params']['table'] =3D 'user_webmail_prefs';=0A=
=0A=
-And for connection tracking:=0A=
+Change:=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=
+/* Connection Tracking */=0A=
+$conf['connections']['track'] =3D false;=0A=
+$conf['connections']['driver'] =3D 'sql';=0A=
+$conf['connections']['params'] =3D array();=0A=
=0A=
-and in imp/config/conf.php=0A=
+To:=0A=
=0A=
/* Connection Tracking */=0A=
$conf['connections']['track'] =3D true;=0A=
@@ -754,20 +903,6 @@=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=
=0A=
=0A=
-----------------------=0A=
---------------------- multipart/mixed attachment--