summaryrefslogtreecommitdiff
blob: 93cbcbcfc95f65c4eec53d10d45ba5137638bbee (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
0. DATABASE SETUP

* MySQL
-------
Setting up the mysql database can be done by creating an empty database,
importing the table layout and granting the proper permissions to the
roundcube user. Here is an example of that procedure:

# mysql
> create database 'roundcubemail';
> GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost
        IDENTIFIED BY 'password';
> quit
# mysql roundcubemail < ${MY_INSTALLDIR}/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 `roundcube` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


* SQLite
--------
Here is an example how you can setup the sqlite.db for roundcube:

# sqlite -init SQL/sqlite.initial.sql sqlite.db

Make sure your configuration points to the sqlite.db file and that the
webserver can write to the file.


* 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

roundcubemail =# ALTER USER roundcube WITH PASSWORD 'the_new_password';
roundcubemail =# \c - roundcubemail
roundcubemail => \i ${MY_INSTALLDIR}/SQL/postgres.initial.sql


1. CONFIGURATION
  Modify the files in ${MY_INSTALLDIR}/config/* to suit your local environment

2. PHP CONFIGURATION

  - error_reporting E_ALL & ~E_NOTICE (or lower)
  - file_uploads on (for attachment upload features)
  - memory_limit  (increase as suitable to support large attachments)