== Introduction == So you've read up on what !RoundCube is, and what it can do. But of course, you can't really know if you like it or not, unless you install it and use it for yourself for a week or two. This document will help guide you through a standard installation of Roundcube. We recommend you read this guide to familiarize yourself with how to install Roundcube, but for those who just want to get up and going, there is a shell script at the bottom to automate the installation and have you running almost instantly. === Other tutorials === There's a nice [http://www.hmailserver.com/forum/viewtopic.php?t=5591 how-to] about the installation of !RoundCube on a Windows box with IIS6 and hMailServer. '''NOTE:''' Make sure you set temp_dir in main.inc.php to an absolute path as otherwise users may run into issues with attaching files to emails. A Debian-specific step-by-step [http://blogs.ungrund.org/xio/2008/08/13/roundcube-on-debian-testing/ how-to] in Russian language also exists. It's a little bit outdated and not perfectly correct, but still can be useful. == Installation == === Get !RoundCube! === To get started, you need to download !RoundCube. The easiest way to get it is to visit [http://www.roundcube.net] and click on "Downloads". Download the archive file containing !RoundCube (name should end in {{{.tar.gz}}}) and extract its contents (on Windows, with !WinZip or 7-Zip, on Mac/Unix with `tar xfz roundcubemail-xx.tar.gz` or `gunzip -c roundcube-xx.tar.gz | tar xf -`) in the current directory. Verify that after extracting all of the files, you have a directory structure like in [wiki:Dev_Docs]. === Get it ready === Now that we've got our files, we can upload the whole directory to the web server (using your favorite scp or FTP program) in case you're not already working there. !RoundCube needs to save some temp files and it also writes logs. Therefore make sure that the following directories (and the files within) are writable by the web server user: * `temp` * `logs` === Database Configuration === Next thing we need to do is decide what database backend we'll use. The most common is MySQL but others are PostgreSQL and SQLite. So once you decide, create a database with any name you want and grant privileges to a separate database user. It's recommended not to use an existing user or root. With MySQL you can set up the database by issuing the following commands: {{{ CREATE DATABASE roundcubemail; GRANT ALL PRIVILEGES ON roundcubemail.* TO username@localhost IDENTIFIED BY 'password'; }}} (of course you have to replace the database, username and password accordingly) See the INSTALL file for information about setting up PostgreSQL or SQLite If you are using MySQL, be sure to flush the users privileges when you add a new user or you will get a database connection error: {{{ FLUSH PRIVILEGES; }}} Note that preconfigured database tables are included in the SQL folder. Import or restore your version or you may get a 500 Error. === Configuring !RoundCube === After uploading the files point your browser to http://url-to-roundcube/installer/ to start the install wizard. The first page shows some requirements, and when you click "START INSTALLATION", the installer checks if everything is there. In case you see some red '''NOT OK''' messages, you need to install or enable something. Follow the links or find out more by searching your web site for your server's operating system or http://www.php.net. Once your web server is ready to run !RoundCube you can start creating the config files on the next step. Click "NEXT" to get there. Get through the form and change the settings according to your needs. Don't forget to enter the database credentials within the "Database Setup" section. All the config parameter are described with a few words. If you don't know that a setting means, find out more on the [wiki:Howto_Config] page or just trust the defaults. When finished the configuration hit the "CREATE CONFIG" button at the bottom of the page. You now get two text boxes on top of your browser window. Copy the contents and put them into two files within the {{{config}}} directory of your !RoundCube installation. Name them {{{main.inc.php}}} and {{{db.inc.php}}} as stated above the text boxes. ''Warning:'' Pasting directly into an editor such as nano may not work due to word-wrapping. Please use vi or download the files directly instead. Finally click "CONTINUE" and get to the last step of the install process. Now your configuration is being verified tested against your webserver. Click the "Initialize database" button in you're requested to in order to create the necessary tables in your database. If there are no red '''NOT OK''' messages, you can also try to send a mail in order to test the SMTP settings. Last but not least you have to remove the whole installer directory from the webserver. If this remains active it can expose the configuration including passwords. === Protect your installation === Access through your webserver to at least the following directories should be denied: * `/config` * `/temp` * `/logs` Roundcube use .htaccess files to protect this directories, be sure to allow override of the `Limit` directives to get them taken into account. == Conclusion == This is a very basic setup to get you up and running with Roundcube in less than twenty minutes. There are plenty of other options, and a lot more options to investigate. See [wiki:Howto_Config] or browse the [http://www.roundcubeforum.net forums] for other tricks and modifications, as well as support if you just can't get it working. Have fun with your new Roundcube installation!! == Troubleshooting == '''500 Internal Server Error''':: This is a very common problem. The likely cause is !AllowOverride Apache directive is in effect. Try to comment all the lines in .htaccess in the document root and then uncomment one line at a time to find which directives in .htaccess cause the error. If these directives protect some critical files from downloading, ask your hoster or administrator to give you more !AllowOverride rights or include the problem directives from .htaccess file into administrator maintained configuration file. '''Using MySQL - Database Error | Failed Connection''' Make sure your database connection string is correct. If you are using MySQL 4.1 or above, your client libraries may not support the new password encryption protocol: http://dev.mysql.com/doc/refman/5.0/en/old-client.html '''Other Issues''' If you're still having trouble after following the steps above, check out the [http://roundcube.net/support support page] where you'll find information about our forum or the mailing list. We also answered some [wiki:FAQ Frequently Asked Questions] concerning !RoundCube. == Shell Script == This shell script is written for CentOS/RHEL and assumes Apache is installed in a default way, with your MySQL, SMTP and IMAP servers running on the localhost. You will also need to install wget (yum install -y wget) if you haven't already. Once the script is finished, you can access roundcube by http://{your_web_server}/roundcube or http://{your_web_server}/webmail. {{{ #!/bin/sh clear if [ -z "${mysql_roundcube_password}" ]; then tmp=$(> .passwords fi if [ -z "${mysql_root_password}" ]; then read -p "MySQL root password []:" mysql_root_password fi wget -P /var/www/html http://sourceforge.net/projects/roundcubemail/files/roundcubemail/0.8.5/roundcubemail-0.8.5.tar.gz/download# tar -C /var/www/html -zxvf /var/www/html/roundcubemail-*.tar.gz rm -f /var/www/html/roundcubemail-*.tar.gz mv /var/www/html/roundcubemail-* /var/www/html/roundcube chown root:root -R /var/www/html/roundcube chmod 777 -R /var/www/html/roundcube/temp/ chmod 777 -R /var/www/html/roundcube/logs/ cat <<'EOF' > /etc/httpd/conf.d/20-roundcube.conf Alias /webmail /var/www/html/roundcube Options -Indexes AllowOverride All Order Deny,Allow Deny from All Order Deny,Allow Deny from All Order Deny,Allow Deny from All EOF sed -e "s|mypassword|${mysql_roundcube_password}|" <<'EOF' | mysql -u root -p"${mysql_root_password}" USE mysql; CREATE USER 'roundcube'@'localhost' IDENTIFIED BY 'mypassword'; GRANT USAGE ON * . * TO 'roundcube'@'localhost' IDENTIFIED BY 'mypassword'; CREATE DATABASE IF NOT EXISTS `roundcube`; GRANT ALL PRIVILEGES ON `roundcube` . * TO 'roundcube'@'localhost'; FLUSH PRIVILEGES; EOF mysql -u root -p"${mysql_root_password}" 'roundcube' < /var/www/html/roundcube/SQL/mysql.initial.sql cp /var/www/html/roundcube/config/main.inc.php.dist /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['default_host'\] =\).*$|\1 \'localhost\';|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['smtp_server'\] =\).*$|\1 \'localhost\';|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['smtp_user'\] =\).*$|\1 \'%u\';|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['smtp_pass'\] =\).*$|\1 \'%p\';|" /var/www/html/roundcube/config/main.inc.php #sed -i "s|^\(\$rcmail_config\['support_url'\] =\).*$|\1 \'mailto:${E}\';|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['quota_zero_as_unlimited'\] =\).*$|\1 true;|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['preview_pane'\] =\).*$|\1 true;|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['read_when_deleted'\] =\).*$|\1 false;|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['check_all_folders'\] =\).*$|\1 true;|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['display_next'\] =\).*$|\1 true;|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['top_posting'\] =\).*$|\1 true;|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['sig_above'\] =\).*$|\1 true;|" /var/www/html/roundcube/config/main.inc.php sed -i "s|^\(\$rcmail_config\['login_lc'\] =\).*$|\1 2;|" /var/www/html/roundcube/config/main.inc.php cp /var/www/html/roundcube/config/db.inc.php.dist /var/www/html/roundcube/config/db.inc.php sed -i "s|^\(\$rcmail_config\['db_dsnw'\] =\).*$|\1 \'mysqli://roundcube:${mysql_roundcube_password}@localhost/roundcube\';|" /var/www/html/roundcube/config/db.inc.php rm -rf /var/www/html/roundcube/installer service httpd reload }}}