HOWTO: Install Roundcube with IIS6 and hMs internal DB
HOWTO: Install Roundcube with IIS6 and hMs internal DB
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
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
Last edited by Slug on 2007-11-14 05:32, edited 7 times in total.
roundcube mysql user
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.
I suspect that roundcube needs on SELECT, UPDATE, INSERT and DELETE privileges on roundcube database.
Re: roundcube mysql user
Because in the roundcube install file it says;dzekas wrote:I think you have granted administrative privileges to roundcube mysql user. Why?
"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.I suspect that roundcube needs on SELECT, UPDATE, INSERT and DELETE privileges on roundcube database.
Thanks
Michael
Missing Hmailserver ... Now running Debian servers
I suspect that screenshot shows
"This dialog allows you to edit user's global privilege(s). Select Tools->...."
Code: Select all
GRANT ALL PRIVILEGES ON *.* TO "roundcube"@"localhost"IDENTIFIED BY "*******" WITH GRANT OPTION
Re: roundcube mysql user
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.dzekas wrote: I suspect that roundcube needs on SELECT, UPDATE, INSERT and DELETE privileges on roundcube database.
So Unless something does not work that I have over looked then the above works fine.
Thanks
Michael
Missing Hmailserver ... Now running Debian servers
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.
$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.
Re: Problem
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.ansu2723 wrote: SERVICE CURRENTLY NOT AVAILABLE!
Error No. 1f4) when i try to access roundcube
Let us know how you go.
Michael
Missing Hmailserver ... Now running Debian servers
-
- New user
- Posts: 4
- Joined: 2006-11-29 21:25
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.
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 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
-
- New user
- Posts: 4
- Joined: 2006-11-29 21:25
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.
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.Slug wrote:Was the install (RC, hMs, MySQL) all local/same machine ??hop wrote: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...
Michael
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
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
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 .....!!!
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?
Anyway, have you activated the MySQL extension in PHP?
-
- New user
- Posts: 4
- Joined: 2006-11-29 21:25
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.
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"sixstring77 wrote:
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
Michael
Missing Hmailserver ... Now running Debian servers
-
- New user
- Posts: 4
- Joined: 2006-11-29 21:25
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.
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
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.....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.
Thanks .... you are great!!!!
This is also in the "How To"ninext wrote:I've followed this tip and finally I got the login page.....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.
Thanks .... you are great!!!!
I think I will need to start this how to with READ WHAT HAS BEEN WRITTEN !!!
Michael
Missing Hmailserver ... Now running Debian servers
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....
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
Code: Select all
// system error reporting: 1 = log; 2 = report (not implemented yet), 4 = show, 8 = trace
$rcmail_config['debug_level'] = 4;
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
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
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]
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 :
Code: Select all
"TCPIP" 3716 "2007-01-04 22:49:29.453" "Created accept socket 1124 on listening socket 1076"
"DEBUG" 3716 "2007-01-04 22:49:29.453" "Socket::Socket(ID: 159)"
"IMAPD" 3716 159 "2007-01-04 22:49:29.453" "192.168.1.1" "SENT: * OK FixMicro!"
"IMAPD" 3716 159 "2007-01-04 22:49:29.468" "192.168.1.1" "RECEIVED: cp01 CAPABILITY"
"IMAPD" 3716 159 "2007-01-04 22:49:29.468" "192.168.1.1" "SENT: * CAPABILITY IMAP4 IMAP4rev1 CHILDREN IDLE QUOTA SORT[nl]cp01 OK CAPABILITY completed"
"IMAPD" 3716 159 "2007-01-04 22:49:29.468" "192.168.1.1" "RECEIVED: a001 LOGIN carlos@fixmicro.com "mypass""
"IMAPD" 3716 159 "2007-01-04 22:49:29.468" "192.168.1.1" "SENT: a001 OK LOGIN completed"
"IMAPD" 3716 159 "2007-01-04 22:49:29.484" "192.168.1.1" "RECEIVED: I LOGOUT"
"IMAPD" 3716 159 "2007-01-04 22:49:29.484" "192.168.1.1" "SENT: * BYE Have a nice day[nl]I OK Logout completed"
"TCPIP" 3716 "2007-01-04 22:49:29.484" "Disconnecting socket 1312 for session 159"
"DEBUG" 3716 "2007-01-04 22:49:29.484" "Socket::~Socket(ID: 159)"
"DEBUG" 3668 "2007-01-04 22:49:32.562" "TimedoutConnectionRemoverTask::DoWork()"
in my browser if i set the the roundcube debug level to 8 i see the following
Code: Select all
* CAPABILITY IMAP4 IMAP4rev1 CHILDREN IDLE QUOTA SORT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #29
Thx
-Carlos[/quote]
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
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:
Code: Select all
"TCPIP" 3716 "2007-01-04 22:49:29.453" "Created accept socket 1124 on listening socket 1076"
"DEBUG" 3716 "2007-01-04 22:49:29.453" "Socket::Socket(ID: 159)"
"IMAPD" 3716 159 "2007-01-04 22:49:29.453" "192.168.1.1" "SENT: * OK FixMicro!"
"IMAPD" 3716 159 "2007-01-04 22:49:29.468" "192.168.1.1" "RECEIVED: cp01 CAPABILITY"
"IMAPD" 3716 159 "2007-01-04 22:49:29.468" "192.168.1.1" "SENT: * CAPABILITY IMAP4 IMAP4rev1 CHILDREN IDLE QUOTA SORT[nl]cp01 OK CAPABILITY completed"
"IMAPD" 3716 159 "2007-01-04 22:49:29.468" "192.168.1.1" "RECEIVED: a001 LOGIN carlos@fixmicro.com "mypass""
"IMAPD" 3716 159 "2007-01-04 22:49:29.468" "192.168.1.1" "SENT: a001 OK LOGIN completed"
"IMAPD" 3716 159 "2007-01-04 22:49:29.484" "192.168.1.1" "RECEIVED: I LOGOUT"
"IMAPD" 3716 159 "2007-01-04 22:49:29.484" "192.168.1.1" "SENT: * BYE Have a nice day[nl]I OK Logout completed"
"TCPIP" 3716 "2007-01-04 22:49:29.484" "Disconnecting socket 1312 for session 159"
"DEBUG" 3716 "2007-01-04 22:49:29.484" "Socket::~Socket(ID: 159)"
"DEBUG" 3668 "2007-01-04 22:49:32.562" "TimedoutConnectionRemoverTask::DoWork()"
in my browser if i set the the roundcube debug level to 8 i see the following
Code: Select all
* CAPABILITY IMAP4 IMAP4rev1 CHILDREN IDLE QUOTA SORT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #29
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.martin wrote:vlskip, I think you should go to http://roundcubeforum.net/forum and ask your question there. This forum is mainly for hMailServer.
Last edited by vlskip on 2007-01-05 21:36, edited 1 time in total.
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:3307/roundcubemail
Now it works like a charm. I hope others will benefit from this info.
mysql://roundcube:mypassword@localhost:3307/roundcubemail
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.
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
"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
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.martin wrote:Iankearns, can you explain exactly how you decrypted the password? I'm guessing that you didn't do it the right way.
Is there a way of generating a new encrypted password for the hMailServer.INI file?
Any help is appreciated
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?
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?