From cead5c727147faac362e742aa7bcecf07f68cd99 Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Thu, 18 May 2006 17:24:42 -0400
Subject: [PATCH] Updated CHANGELOG

---
 INSTALL |   57 ++++++++++++++++++++++++++++++++++++++++++---------------
 1 files changed, 42 insertions(+), 15 deletions(-)

diff --git a/INSTALL b/INSTALL
index cca4fa1..dd52fa5 100644
--- a/INSTALL
+++ b/INSTALL
@@ -1,4 +1,18 @@
 
+REQUIREMENTS
+============
+
+* The Apache Webserver
+* .htaccess support allowing overrides for DirectoryIndex
+* PHP Version 4.3.1 or greater
+* PCRE (perl compatible regular expression) installed with PHP
+* php.ini options:
+   - error_reporting E_ALL & ~E_NOTICE (or lower)
+   - file_uploads on (for attachment upload features)
+* A MySQL or PostgreSQL database engine or the SQLite extension for PHP
+* A database with permission to create tables
+
+
 INSTALLATION
 ============
 
@@ -25,11 +39,16 @@
 roundcube user. Here is an example of that procedure:
 
 # mysql
-> create database 'roundcubemail';
+> CREATE DATABASE 'roundcubemail';
 > GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost
         IDENTIFIED BY 'password';
 > quit
 # mysql roundcubemail < SQL/mysql.initial.sql
+
+For MySQL version 4.1 and up, it's recommended to create the database for
+RoundCube with the following command:
+> CREATE DATABASE 'roundcubemail' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
+
 
 * SQLite
 --------
@@ -44,23 +63,23 @@
 webserver can write to the file.
 
 
-UPGRADING
-=========
-If you already have a previous version of RoundCube installed,
-please refer to the instructions in UPGRADING guide.
+* PostgreSQL
+------------
+To use RoundCube with PostgreSQL support you have to follow the next
+simple steps, which have to be done with the postgres system user (or
+which ever is the database superuser):
 
+$ createuser roundcubemail
+$ createdb -O roundcubemail roundcubemail
+$ psql roundcubemail
 
-REQUIREMENTS
-============
+roundcubemail =# ALTER USER roundcube WITH PASSWORD 'the_new_password';
+roundcubemail =# \c - roundcubemail
+roundcubemail => \i SQL/postgres.initial.sql
 
-* The Apache Webserver
-* .htaccess support allowing overrides for DirectoryIndex
-* PHP Version 4.3.1 or greater
-* php.ini options:
-   - error_reporting E_ALL & ~E_NOTICE (or lower)
-   - file_uploads on (for attachment upload features)
-* A MySQL or PostgreSQL database engine or the SQLite extension for PHP
-* A database with permission to create tables
+All this has been tested with PostgreSQL 8.0.x and 7.4.x. Older
+versions don't have a -O option for the createdb, so if you are
+using that version you'll have to change ownership of the DB later.
 
 
 CONFIGURATION
@@ -68,3 +87,11 @@
 
 Change the files in config/* according your to environment and your needs.
 Details about the config paramaters can be found in the config files.
+
+
+UPGRADING
+=========
+If you already have a previous version of RoundCube installed,
+please refer to the instructions in UPGRADING guide.
+
+

--
Gitblit v1.9.1