Ok this is my first attempt at a how-to so be nice

Objective
To install and configure Roundcube on hMailServer, using the default MySQL installation that comes with hMailServer. On a dedicated server. Everything is installed on the same machine, etc hMailServer, PHP, Roundcube….

Things you need,

Copy of PHP, you can find it here http://www.php.net
Copy of Roundcube this can be found here http://www.roundcube.net
Copy of SQLyog free edition, this can be downloaded here http://www.webyog.com
Installed and operational copy of hMailServer. (not covered here)
Installed and operational copy of IIS (not covered here)

1)PHP
I looked around a lot when I undertook this for the first time, and whilst there was heaps of installation guides on the internet, I found most were incomplete, a little hard to understand, or lacking in quality information. I even found the install guide on PHP's own website very weak if your intending the run IIS. Which I assume is why you’re here. So the best and easiest tutorial was from this person. http://www.peterguy.com/php/install_IIS6.html Put simply it worked, with the minimum of fuss. Follow it and in no time flat you will have a working installation of PHP.

2)Roundcube
Unpack the copy of Roundcube you just downloaded, inside you will find a file marked “install” open it with your favourite text editor (WordPad etc) This is reasonably well documented for the first timer. Basically you have 4 main things to do, they are;
**Create a new database and a database user
*To do this open up SQLyog Enter in the information required in the fields as below, and press connect.
*Please note you will find the MySql database password in the hMailServer.INI file in the “bin” folder of your hMailServer installation. You will need to use the provided “DecryptBlowfish.vbs” script in the hMailServer\Addons\Utilities folder to decrypt the password for use in SQLyog.



**You now need to follow the directions in the Install File under Database Setup. At the time of writing hMailServer’s internal MySQL is 4.1.18, so you will need to follow the instructions in the MySQL 4.1.x/5.x section.
*Basically you need to Click on “DB” in the menu (top) and enter the name of the database. E.g. roundcubemail. I called mine just roundcube.
**Now you need to “Create database tables” You will find a file called mysql.initial.sql in the SQL folder of your roundcube package. Open the file and copy its contents to the clipboard.
*Now in SQLyog, the section we are interested is called Query, paste the contents of the mysql.initial.sql file into here.
*Now Click on Edit>Execute Query>Execute Current Query. This will setup the tables in your new database.



*To create the new database user Click “Tools>User Manager>Add User” and fill in the fields, make sure the user has the following privileges



**Rename the files config/*.inc.php.dist to config/*.inc.php, (remove the .dist extension from them) Now modify the files in config/* to suit your local environment
*Open up the db.inc.php file, here the only thing you need to modify is this line of code $rcmail_config['db_dsnw'] = 'mysql://roundcube:yourdatbasepassword@localhost/roundcube'; Close and save.
*Now open main.inc.php and edit this according to your preferences, it is well documented so I don’t need to comment about this except a the time of writing there is a cache issue yet to be resolved in 0.1Beta2, so it is recommended to turn the cache off $rcmail_config['enable_caching'] = FALSE;
*One strange thing I found was when specifying a temp folder for Roundcube you have to type in the full path e.g. $rcmail_config['temp_dir'] = 'C:\mywebsite\mail\temp'; as for what ever reason \temp does not work, strange as all the other specified (logs etc) directories work without specifying the full path ?? One of life’s mysteries. Close and save when done.
**Ok all that is left is to upload Roundcube to your server (if you’re doing this remote) Or if you’re at the console then move it to a folder on your webserver. I used C:\mywebsite\mail. Just make sure that the internet guest account has privileges, it should have inherited these from your websites parent folder.

Please let me know if I have missed something, or something I said does not make sense and I will make the corrections to this page.

EDIT: The non default port that the internal MySQL uses is catching a few people out. So please make sure that you change the Port number in php.ini (mysql.default_port = 3307).

2nd Edit: Another user has reported that they needed to use slashes "/" not backslashes "\" in the temp folder path So if you having blank screen issues try this. He also reported that is you set the debug to $rcmail_config['debug_level'] = 8; Then it will output the error message to the screen.

3rd Edit: Another user has reported, In the latest version of SQLyog only the FIRST statement will be executed if the guide is followed (execute current). Ie. you get a db with 1 table, it will stop execution after the first ";". You have to select each statement one at a time and F5/execute. (F9 refreshes which also might be worth mentioning)



Enjoy.
Michael

michel, i havent told you that u're great yet?????

thx for the how-to....


it works!!

( previous mine post were deleted 'couse i've solved the problem.. the tar.gz was corrupted so mine roundcube script was broken )

I think you have granted administrative privileges to roundcube mysql user. Why?

I suspect that roundcube needs on SELECT, UPDATE, INSERT and DELETE privileges on roundcube database.

Because in the roundcube install file it says;

"GRANT ALL PRIVILEGES ON roundcubemail"

So I did,

I will try your suggestion and if it works I will reduce the user privileges for RC.



I try it and get back to you about this.

Thanks
Michael

I suspect that screenshot shows


"This dialog allows you to edit user's global privilege(s). Select Tools->...."

Ok I have changed the user privileges, as per your suggestion and so far it seems to work. I have tried all the usual things, send, receive, add folders, deleted folders, add attachments etc.

So Unless something does not work that I have over looked then the above works fine.

Thanks
Michael

Glad it helped ...


Michael

Have done everything you wrote but i get

SERVICE CURRENTLY NOT AVAILABLE!
Error No. 1f4) when i try to access roundcube

?

If your mysql DB is located on a different machine you will need to change this:

$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';

to this:
$rcmail_config['db_dsnw'] = 'mysql://myusername:mypassword@yourmysqlhostname.domain.com/mydatabasename'

I hope this helps.

That error is a database error, If after you have tried what doom mentioned (if the DB is on another machine) You need to double check your passwords etc. I had this same error come up when I first tried setting RC up and after I checked 4 times I found my typo.

Let us know how you go.
Michael

Hi, I have been learning a ton from the forums. In less than a week I have a webserver (Apache, PHP, ActivePerl) and hmail setup with SM as my webmail. I had heard about RC and really like the way it looks but I'm extremely new to all of this. I have been using tutorials and how-to's to get everything working. Your guide looks excellent!

I am running Apache on Windows XP Pro along with hmail. I was wondering if the installation process you used for RC will be the same (or close to it) for my setup? I was also wondering why you had to install SQLyog if hmail already has MySQL built in? Thanks for your guidance.

SQLyog is an application used to easily manage a mysql database in much the same way you can with phpmyadmin.

I would recommend installing either of the 2 apps i mentioned above to manage your mysql database. Unlike Squirrel Mail, Roundcube uses a mysql database to save its options and config variables. This is why you need to access mysql and setup permissions and add the table data needed to run RC.

HTH

I tried hard to get it to work, but couldn't get beyond the "Error No. 1f4)" message. Pretty sure it wasn't a typo.

Gave up a long time ago. I'll try again sometime...

Was the install (RC, hMs, MySQL) all local/same machine ??

Michael

I'm getting the same SERVICE CURRENTLY NOT AVAILABLE!
Error No. 1f4

I believe I followed the tutorial correctly but I'm guessing I misunderstood something.


In the db.inc.php file for the line

$rcmail_config['db_dsnw'] = 'mysql://roundcube:password@localhost/roundcubemail';

What password am I to enter in that line. The password I got when I decrypted the password from hmail/bin/hmailserver.ini or do I make a password for user "roundcube" in the SQLyog.

I think I am to enter the password I created for the user "roundcube".

I am able to log on to SQLyog using "roundcube" and the password I created. I put those parameters into the $rcmail_config line but I still get an error. I also tried putting the user "root" and the password decrypted from the hmailserver.ini file in but I still get the error. I checked the error logs and I have only 1 error multiple times (from hitting refresh I'm guessing):

[30-Nov-2006 11:41:15 -0600] DB Error: DB Error: extension not found in C:\webroot\domain\www\roundcube\program\include\rcube_db.inc on line 105

I am running Windows XP Pro, Apache 2.0.59, PHP 5.2, Hmailserver 4.3 (latest stable) with built in MySQL, Perl 5.8.8 (all local install)

I have shutoff all firewalls in case the MySQL port was being blocked or something (I'm not even sure if that's possible but I thought I'd try) still no go.

Thanks for any help.

Yes, but don't worry about it. Not important, not enough time at the moment.

I've installed RC on the following configuration: Hmailserver 4.3 B248, win2003, IIS6 and MySql (the one installed with hMailserver) ..

When I try to the browse login page I hae this message:

SERVICE CURRENTLY NOT AVAILABLE!
Error No. 1f4)

and in RC log I have the following repeated message:

[29-Nov-2006 19:35:37 +0100] DB Error: DB Error: extension not found in C:\Webs\Roundcubemail\program\include\rcube_db.inc on line 105

I've followed the instruction supplied by RC Install and by this forum ...... what can I check?? ... or what can I do to solve this problem???

Thanks

The problem might be that the user and the password of that user that you
have defined in db.inc.php in the config folder are either wrong or you have
forgotten to give that user the permissions to the rouncube database.

I've checked user the username and password of that user that I
have defined in db.inc.php in the config folder ...... are the same

So I've checked the user permissions on rouncube database ....and they are the same you specified in this topic!

P.S. I've also granted full permissions .... but I get the same error!

Please help me .....!!!

I don't want to spoil the fun, but if you want real RoundCube support, you should go to the RoundCube page. This forum is mainly for hMailServer. http://roundcubeforum.net/

Anyway, have you activated the MySQL extension in PHP?

ahhhhem
database error on roundcubeforum :p

I'll post what worked for me since the roundcube forums are down with of all things - a database error.

First thing I did was uncomment the line

extension=php_mysql.dll

in the php.ini file. (Thanks for the advice martin)

Next I made the line

mysql.default_port =

read

mysql.default_port = 3307

I was still having the same error and found in my apache error logs that the php_mysql.dll could not be found. I needed to add c:\php to the path. To do this I went to Control Panel / System / Advanced / Environment Variables. I have also read you could copy the php_mysql.dll file to your c:\windows\system32 folder instead of adding to path.

I restarted the computer and it works now. Thanks for the help. Hopefully the Roundcube forums start working again so I can ask questions about tweaking roundcube.

BTW when you uncomment extension=php_mysql.dll in the php.ini you might as well uncomment extension=php_openssl.dll and extension=php_sockets.dll so that the check spelling function works in roundcube. Quite a nice looking program. Hopefully a plugin for changing passwords will become available someday.

Both of these things are in the "How To"

Michael

My bad! I skipped the PHP guide you mentioned thinking I had it setup right. Good guide.

This is an hmail question. I am trying to get the password change option to work in RC. I am using a prepatched version that has password option. I am setting up the db.inc.php file to change the email password in the hmail mysql.

I have these lines added to the db.inc.php

$rcmail_config['db_imap_dsn'] = 'mysql://roundcube:password@localhost/hmailserver';
$rcmail_config['db_imap_users_table'] = 'hm_accounts';
$rcmail_config['db_imap_user_field'] = 'accountaddress';
$rcmail_config['db_imap_passwd_field'] = 'accountpassword';
$rcmail_config['db_imap_passwd_type'] = 'ENCRYPT'; // ''-- for Plaintext, 'ENCRYPT', 'PASSWORD'

I guessed at what mysql fields that needed to be changed.

This is the hmailserver question = where in built in hmail mysql table are the users_table user_field passwd_field.

Right now when I change the password it says it completes but the password I entered does not work and the previous password doesn't work either. I have to go into hmail admin and reenter a password and it works again. Because it at least wipes the password out I think I'm close at getting it to work.

Please be kind if I am way off on what I'm asking...I have very little knowledge of mysql, php, etc... and am trying to learn...not trying to be a pest.

hi Michael
well the howto works fine for me.. unfortunately roundcube doesnt work as well i want with italian language and italian pop3/imap client... i've got a lot of IMAP folder called "sent items" or "posta inviata" ( the same just translated.. ) . it's not easy to manage.if all my customer speak english i just could use it in eng with no problem.. but i'm not so lucky.. hehehe

I've followed this tip and finally I got the login page.....

Thanks .... you are great!!!!

This is also in the "How To"

I think I will need to start this how to with READ WHAT HAS BEEN WRITTEN !!!

Michael

I need hel one more time!!!!!!!!!!

When I try to send a message I get the message that the mail wasn't sent ! .... what happens ??

I think it depends to my wrong setting in "main.inc.php" of roundcube!

Could anyone post am example of working configuration of this file???

Many thanks!

Check the error log in \roundcube\logs\ it should tell you the problem.

If you have no error log make sure the folder is writable by your webserver.

If that still doesn't work change the debug value in main.inc.php to 4



Just saying message wasn't sent really doesn't help.

You should really be asking for help on the RC forums anyway....

Now I get this message after my login:

Warning: include_once(C:\Webs\Roundcubemail/program/localization/it/labels.inc) [function.include-once]: failed to open stream: Permission denied in C:\Webs\Roundcubemail\program\include\rcube_shared.inc on line 1104

Warning: include_once() [function.include]: Failed opening 'C:\Webs\Roundcubemail/program/localization/it/labels.inc' for inclusion (include_path='C:\Webs\Roundcubemail/;C:\Webs\Roundcubemail/program;C:\Webs\Roundcubemail/program/lib;.;C:\php5\pear') in C:\Webs\Roundcubemail\program\include\rcube_shared.inc on line 1104

Warning: include_once(C:\Webs\Roundcubemail/program/localization/it/messages.inc) [function.include-once]: failed to open stream: Permission denied in C:\Webs\Roundcubemail\program\include\rcube_shared.inc on line 1105

Warning: include_once() [function.include]: Failed opening 'C:\Webs\Roundcubemail/program/localization/it/messages.inc' for inclusion (include_path='C:\Webs\Roundcubemail/;C:\Webs\Roundcubemail/program;C:\Webs\Roundcubemail/program/lib;.;C:\php5\pear') in C:\Webs\Roundcubemail\program\include\rcube_shared.inc on line 1105

Then check what the error messages are telling you. the first 3 are permissions issues. and the last one it can't find.

The sad part about this is the RC forums suck. Its a pity you get more sence on the hMs forums then the RC forums

BTW Jon, you really need to install SVN 400

Michael

I will I will just haven't gotten around to it yet

Thanks for the "How To", it worked for me.

Thanks! Worked a charm for me too, just got to sort the whole crashing IIS 6 x64 thing that roundcube keeps doing now!


XP Pro x64 | IIS 6 | AVG 7.5 Pro | PHP 5.20 x64 | Roundcube

Good guide. This also worked for me after resolving a few stupid headaches with running IIS 5.1 (win xp pro). It involved me editing the roundcube source code. -_-"

ok!

First of all great how to.

I'm running Hmail server 4.3 b248
With external DB under mysql 5.0
Roundcube with DB also under mysql 5.0
Windows server 2003
PHP Version 5.2.0

I almost got it working but now when i try to login from webmail (roundcube) i get the follwing in my hmailserver log :



in my browser if i set the the roundcube debug level to 8 i see the following


Can anyone help me out ???


Thx
-Carlos[/quote]

I haven't installed this with a external DB so I'm not real good at this, but when you go to the RC login page what do you see ??

Michael

If i try to login only with my name ex : carlos i get the normal error saying i must login with the complete email adress in the roundcube log.

if i lgon with me email i get the messages in my previous post.

But the login page looks normal.

try with the full email address instead only username.

just to say: i've installed roundcube on a separate DB ( external ) and it works like a charm.

What version of MYSQL are you runing ???

I already tried with and without the complete email.

Login with : carlos
results in the error saying i must login with the complete email adress in the roundcube log


login with: carlos@myemail.com

results in the following entries in the hmail log:



in my browser if i set the the roundcube debug level to 8 i see the following

vlskip, I think you should go to http://roundcubeforum.net/forum and ask your question there. This forum is mainly for hMailServer.

I know, i was just wondering if someone would see anything abnormal in the hmail server log i posted.

No, the log just shows your client logging on succesfully, and then logging out immediately again.

Thx!

Thats all i needed

hi i got a problem installing roundcube with hMailServer. When i open the index.php page in my browser i got plain page ! nothing on it !

The blank page issue has been discussed on the roundcube website.

Michael

I had problems getting roundcube mail to work using the howto described in this post. I kept getting the error message regardin roundcube being unable to connect to the database. I had changed the setting in php as advised but nothing seemed to work until I added the port-number to the connection-string like this:
mysql://roundcube:mypassword@localhost: ... ndcubemail

Now it works like a charm. I hope others will benefit from this info.

I have a similar setup, with two instances of MySQL on the machine. One is the build-in hMail database, and one is for 'everything else', which in this case is also RoundCube.
I used PHPmyAdmin to create the database, and a user, and created the tables with the CLI commands from the readme.
The whole installation took less than an hour.
It took more time to customize the theme, and replace the standard logos with the company logo, etc.

Having problems when trying to establish connection through to MySQL database.

"To do this open up SQLyog Enter in the information required in the fields as below, and press connect" - have done this many time but still keep getting authentication problems. Error No.1045 Access Denied.

Have decrypted password and entered it exactly as shown - no joy

Iankearns, can you explain exactly how you decrypted the password? I'm guessing that you didn't do it the right way.

Hi Martin, I open the vbs script for decrypting the password and it asked me for a password, I presume this is the administration password you input when installing hMailserver. It then asks for the encrypted password so I copied the entry from the file hMailServer.INI and pasted it in. I then get a comment window with a password which I then put into SQLyog which spits me back out saying connection refused or denied.

Is there a way of generating a new encrypted password for the hMailServer.INI file?

Any help is appreciated

Are you using port 3307 ???

Michael

Hi Slug

Yes I am. I have included a screenshot http://iankearns.dialnet.com/images/mysql_error.JPG

Ok, after a couple of PM's between myself and iankearns we are all up and running. The problem was lower case "L" looks like this "|" (the key above the enter). So just something to look out for.

Michael

Hi all (again)

As I struggle through this set up, I get to the point in creating the MySQL tables and the guide says to copy the contents of the file mysql.initial.sql into the query field and then execute the query.

When I do this I get the return message "No query(s) were executed. Please enter a query in the SQL window or place the cursor inside a query." - Do you have to enter each seperate query from the file one at a time?

Try high lighting them, then execute them.

Michael

Thanks for your help. Never having used MySQL then this is becoming a bit of a pain but I am committed to getting this to work. I am now getting the familiar error as reported by others of
SERVICE CURRENTLY NOT AVAILABLE!
Error No. 1f4)
but I will battle on through what others have been advised

Your not connecting to the database, recheck the database.inc.php file ...

Michael

I'm off to bed .... good luck.