Wednesday, March 13, 2013


I lost a lot of time trying make this work with IIS, PHP, Mysql on windows boxes and hit my head against the wall more than once for nothing :( :( :( :( :( . I don't want you to go through the same torture, so here is the easy how to.

Prerequisits
1. Xampp USB lite, executable version downloadable http://www.apachefriends.org/en/xampp-windows.html
2. RoundCube webmail downloadable at http://roundcube.net/
3. 7zip, if you don't have it already downloadable at http://www.7-zip.org/

Installation
1. Install Xampp USB lite using the default settings. This will install PHP5, Apache web server and Mysql database version in C:\xampp
2. Browse to C:\xampp and create a shortcut for xampp-control.exe on your desktop
3. Launch xampp-control, click on service on top and check to run xampp control panel as a service, as well under start these modules choose both mysql and apache. Leave the rest of the fields as default, click ok. It will prompt you to install xampp as service, accept and check in your services applet, that the service xampp is set to automatic.
4. Launch your internet browser and enter localhost as address. This will take you to the xampp welcome page, choose your language.
5. Click the security link on the left, then click the link in the middle of the page that reads http://localhost/security/xamppsecurity.php
6. Here you must enter a new password for the root user then retype the new password. Leave the old password blank.
7. Using the xampp-control, restart mysql service.
8. Now navigate to http://localhost/phpmyadmin, enter root as username and the password that you just created.
9. Click on databases, create new database called roundcubemail. Then on the left, from the available databases, click the one you just created, click on privileges tab then click add a new user.
10. In the username field enter roundcube, host field enter localhost, choose a password for the user account and retype. 
11. Under database for user, choose grant all privileges on database roundcubemail then click go on the bottom.
12. Click the home icon on the left top corner, choose the roundcubemail database, privileges tab and make sure that the user we just created is there.
13. Using 7zip, unzip the rouncube package, simply rename the folder as roundcube and copy it to C:\xampp\htdocs folder
14. Browse to C:\xampp\htdocs\roundcube\config folder, copy and rename db.inc.php.dist and main.inc.php.dist to db.inc.php and main.inc.php respectively within the same folder.
15. Open main.inc.php in notepad and make modifications as below
• $rcmail_config['default_host'] = 'localhost';
• $rcmail_config['smtp_server'] = 'localhost';
• $rcmail_config['smtp_user'] = '%u';
• $rcmail_config['smtp_pass'] = '%p';
• $rcmail_config['enable_installer'] = true;
Save the file.
16. Open db.inc.php in notepad and make modifications as below
$rcmail_config['db_dsnw'] = 'mysql://roundcube:password@localhost/roundcubemail'; 
This is the username and password of the database user that we created at step 9. Save the file.
17. Launch your internet browser and navigate to http://localhost/roundcube/installer
18. Make sure that there is nothing highlighted in Red and click next on the bottom of the page.
19. Make sure there is noting highlighted in red on the last page and run SMTP and IMAP connection tests. Remember you must use a valid user on the hmail server to run the test. Use username@domainname.xxx format for user credentials
These two steps will create the tables in your databse. Once done, delete the installer folder from the roundcube directory as well modify thercmail_config['enable_installer'] variable in main.inc.php file to show false and save the file
20. Now navigate to C:\xampp\apache\conf directoy and open httpd.conf file in notepad.
21. Modify the DocumentRoot variable to point to "/xampp/htdocs/roundcube". This step is very important to secure the files and folders within xampp/htdocs directory.
22. At this point, launch the xampp-control and restart the apache service
23. Now navigate to C:\xampp\PHP folder and open the php.ini file in notepad. Make sure that file_uploads variable is on, as well the upload_max_filesize variable set to 20 MB (or whatever you want, as this will effect the size of email attachments). Save the file.
24. Launch your internet browser and navigate to http://localhost and voila..


Credits: http://www.hmailserver.com/forum/viewtopic.php?f=12&t=21540

3 comments:

  1. RoundcubeSkins.Com COLORFUL skins for Roundcube Webmail Client !!! Roundcube our skins are compatible for 0.8.x, 0.9.x and Soon we will be coming up with all our roundcubeskins compatible with 1.0 beta release of roundcube webmail. So keep visiting our site for updates!!

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. Check DB config
      DSN (write): NOT OK (SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES))

      Make sure that the configured database exists and that the user has write privileges
      DSN: mysql://roundcube:xxxxxxxxxx@localhost/roundcubemail


      roundcubemail-1.6.2-complete.tar.gz - for not install error problem.
      Please I need Your help.

      Delete