| | |
|---|
| | | - memory_limit (increase as suitable to support large attachments) |
|---|
| | | - file_uploads enabled (for attachment upload features) |
|---|
| | | - session.auto_start disabled |
|---|
| | | - magic_quotes_gpc disabled |
|---|
| | | - magic_quotes_sybase disabled |
|---|
| | | - zend.ze1_compatibility_mode disabled |
|---|
| | | * PHP compiled with OpenSSL to connect to IMAPS and to use the spell checker |
|---|
| | | * A MySQL or PostgreSQL database engine or the SQLite extension for PHP |
|---|
| | |
|---|
| | | DATABASE SETUP |
|---|
| | | ============== |
|---|
| | | |
|---|
| | | * MySQL 4.0.x |
|---|
| | | ------------- |
|---|
| | | * 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; |
|---|
| | | > CREATE DATABASE roundcubemail /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; |
|---|
| | | > GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost |
|---|
| | | IDENTIFIED BY 'password'; |
|---|
| | | > quit |
|---|
| | | |
|---|
| | | # mysql roundcubemail < SQL/mysql.initial.sql |
|---|
| | | |
|---|
| | | |
|---|
| | | * MySQL 4.1.x/5.x |
|---|
| | | ----------------- |
|---|
| | | For MySQL version 4.1 and up, it's recommended to create the database for |
|---|
| | | RoundCube with utf-8 charset. Here's an example of the init procedure: |
|---|
| | | |
|---|
| | | # mysql |
|---|
| | | > CREATE DATABASE roundcubemail DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; |
|---|
| | | > GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost |
|---|
| | | IDENTIFIED BY 'password'; |
|---|
| | | > quit |
|---|
| | | |
|---|
| | | # mysql roundcubemail < SQL/mysql5.initial.sql |
|---|
| | | |
|---|
| | | Note: 'password' is the master password for the roundcube user. It is strongly |
|---|
| | | Note 1: 'password' is the master password for the roundcube user. It is strongly |
|---|
| | | recommended you replace this with a more secure password. Please keep in |
|---|
| | | mind: You need to specify this password later in 'config/db.inc.php'. |
|---|
| | | |
|---|
| | | Note 2: For MySQL version 4.1 and up, it's recommended to create the database for |
|---|
| | | RoundCube with utf-8 charset. |
|---|
| | | |
|---|
| | | |
|---|
| | | * SQLite |
|---|
| | |
|---|
| | | which ever is the database superuser): |
|---|
| | | |
|---|
| | | $ createuser roundcube |
|---|
| | | $ createdb -O roundcube roundcubemail |
|---|
| | | $ createdb -O roundcube -E UNICODE roundcubemail |
|---|
| | | $ psql roundcubemail |
|---|
| | | |
|---|
| | | roundcubemail =# ALTER USER roundcube WITH PASSWORD 'the_new_password'; |
|---|
