(→Database Setup) |
|||
| Line 36: | Line 36: | ||
| − | + | * Creating the RoundCube Database<br> | |
| − | + | ||
mysql -u root -p | mysql -u root -p | ||
''(When prompted for a password enter the root password)'' | ''(When prompted for a password enter the root password)'' | ||
| Line 44: | Line 43: | ||
| − | + | * Create RoundCube User and Grant Privileges<br> | |
mysql> GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost IDENTIFIED BY 'Your-Password-Here';<br> | mysql> GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost IDENTIFIED BY 'Your-Password-Here';<br> | ||
''(where 'Your-Password-Here' is the password you want for the roundcube user)'' | ''(where 'Your-Password-Here' is the password you want for the roundcube user)'' | ||
| − | + | ||
| + | * Exit MySQL<br> | ||
mysql> quit | mysql> quit | ||
| − | + | ||
| + | * Import RoundCube Database Tables<br> | ||
mysql -u root -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql<br> | mysql -u root -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql<br> | ||
''(When prompted for a password enter the root password)'' | ''(When prompted for a password enter the root password)'' | ||
| + | == Initial Configuration == | ||
| + | * Copy the sample configuration file | ||
| + | cd config/ | ||
| + | cp db.inc.php.dist db.inc.php | ||
| + | cp main.inc.php.dist main.inc.php | ||
| + | |||
| + | |||
| + | * Configure Database | ||
| + | vi db.inc.php | ||
| + | ''change this line: $rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail'; to'' | ||
| + | $rcmail_config['db_dsnw'] = 'mysql://roundcube:'''Your-Password-Here'''@localhost/'''roundcube''''; | ||
| + | '''Note: I created the database as 'roundcube' but the sample database config calls it 'roundcubemail' change it where necessary'' | ||
Revision as of 06:57, 29 July 2006
NOTE: This HowTo assumes you are using a RedHat or Fedora based distro, but most of this info can be applied to any Unix based Operating System.
Contents
Download
- Download the latest version of Roundcube
wget http://easynews.dl.sourceforge.net/sourceforge/roundcubemail/roundcubemail-0.1beta.tar.gz
If the Above link is broken or out of date, get the latest version Here
UnTar
tar -xvzf roundcubemail-0.1beta.tar.gz
Move
mv roundcubemail-0.1beta /var/www/roundcube
Read the Documentation
cd /var/www/roundcube less README (press q to quit)
less INSTALL (press q to quit)
Change Ownership & Premissions
chown -R root.root roundcube/ cd roundbube/ chmod 755 log/ temp/
Database Setup
(This Assumes you already have MySQL installed)
- Creating the RoundCube Database
mysql -u root -p (When prompted for a password enter the root password)
mysql> CREATE DATABASE `roundcube` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- Create RoundCube User and Grant Privileges
mysql> GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost IDENTIFIED BY 'Your-Password-Here';
(where 'Your-Password-Here' is the password you want for the roundcube user)
- Exit MySQL
mysql> quit
- Import RoundCube Database Tables
mysql -u root -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql
(When prompted for a password enter the root password)
Initial Configuration
- Copy the sample configuration file
cd config/ cp db.inc.php.dist db.inc.php cp main.inc.php.dist main.inc.php
- Configure Database
vi db.inc.php
change this line: $rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail'; to
$rcmail_config['db_dsnw'] = 'mysql://roundcube:Your-Password-Here@localhost/roundcube'; 'Note: I created the database as 'roundcube' but the sample database config calls it 'roundcubemail' change it where necessary