HOWTO: Install Roundcube with IIS6 and hMs internal DB

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.

Has this how to worked for you ?

Yes
14
61%
No
9
39%
 
Total votes: 23

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

HOWTO: Install Roundcube with IIS6 and hMs internal DB

Postby Slug » 2006-08-30 17:45

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

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.

Image

**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.

Image

*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

Image

**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.

westdam
Senior user
Senior user
Posts: 727
Joined: 2006-08-01 21:24
Location: Padova, Italy
Contact:

Postby westdam » 2006-08-30 18:24

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 )

User avatar
dzekas
Senior user
Senior user
Posts: 2486
Joined: 2005-10-13 21:28
Location: Lithuania

roundcube mysql user

Postby dzekas » 2006-08-30 22:13

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.

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Re: roundcube mysql user

Postby Slug » 2006-08-31 09:25

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


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 suspect that roundcube needs on SELECT, UPDATE, INSERT and DELETE privileges on roundcube database.


I try it and get back to you about this.

Thanks
Michael
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

User avatar
dzekas
Senior user
Senior user
Posts: 2486
Joined: 2005-10-13 21:28
Location: Lithuania

Postby dzekas » 2006-08-31 10:58

I suspect that screenshot shows

Code: Select all

GRANT ALL PRIVILEGES ON *.* TO "roundcube"@"localhost"IDENTIFIED BY "*******" WITH GRANT OPTION


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

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Re: roundcube mysql user

Postby Slug » 2006-08-31 15:35

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


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
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2006-09-01 03:17

westdam wrote:thx for the how-to....

it works!!


Glad it helped ...


Michael
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

ansu2723
Normal user
Normal user
Posts: 51
Joined: 2004-07-15 08:53

Problem

Postby ansu2723 » 2006-11-07 21:53

Have done everything you wrote but i get

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

?

^DooM^
Site Admin
Posts: 13853
Joined: 2005-07-29 16:18
Location: UK

Postby ^DooM^ » 2006-11-07 23:10

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.

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Re: Problem

Postby Slug » 2006-11-08 02:53

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


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
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

sixstring77
New user
New user
Posts: 4
Joined: 2006-11-29 21:25

Postby sixstring77 » 2006-11-29 21:40

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.

^DooM^
Site Admin
Posts: 13853
Joined: 2005-07-29 16:18
Location: UK

Postby ^DooM^ » 2006-11-30 00:16

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

hop
Normal user
Normal user
Posts: 48
Joined: 2005-11-25 10:47
Location: UK

Postby hop » 2006-11-30 00:26

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...

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2006-11-30 02:22

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...


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

Michael
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

sixstring77
New user
New user
Posts: 4
Joined: 2006-11-29 21:25

Postby sixstring77 » 2006-11-30 18:51

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.

hop
Normal user
Normal user
Posts: 48
Joined: 2005-11-25 10:47
Location: UK

Postby hop » 2006-12-01 00:43

Slug wrote:
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...


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

Michael


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

ninext
New user
New user
Posts: 13
Joined: 2006-11-28 10:31

Postby ninext » 2006-12-01 13:52

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

^DooM^
Site Admin
Posts: 13853
Joined: 2005-07-29 16:18
Location: UK

Postby ^DooM^ » 2006-12-01 15:51

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.

ninext
New user
New user
Posts: 13
Joined: 2006-11-28 10:31

Postby ninext » 2006-12-01 19:22

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 .....!!!

User avatar
martin
Developer
Developer
Posts: 6712
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

Postby martin » 2006-12-01 19:35

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?

westdam
Senior user
Senior user
Posts: 727
Joined: 2006-08-01 21:24
Location: Padova, Italy
Contact:

Postby westdam » 2006-12-01 20:32

ahhhhem
database error on roundcubeforum :p

sixstring77
New user
New user
Posts: 4
Joined: 2006-11-29 21:25

Postby sixstring77 » 2006-12-02 07:46

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.

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2006-12-02 18:02

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


Both of these things are in the "How To" :wink:

Michael
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

sixstring77
New user
New user
Posts: 4
Joined: 2006-11-29 21:25

Postby sixstring77 » 2006-12-02 19:50

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.

westdam
Senior user
Senior user
Posts: 727
Joined: 2006-08-01 21:24
Location: Padova, Italy
Contact:

Postby westdam » 2006-12-04 15:31

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

ninext
New user
New user
Posts: 13
Joined: 2006-11-28 10:31

Postby ninext » 2006-12-04 21:49

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.


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

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

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2006-12-05 03:40

ninext wrote:
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.


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

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


This is also in the "How To" :roll:

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

Michael
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

ninext
New user
New user
Posts: 13
Joined: 2006-11-28 10:31

Postby ninext » 2006-12-07 19:03

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!

^DooM^
Site Admin
Posts: 13853
Joined: 2005-07-29 16:18
Location: UK

Postby ^DooM^ » 2006-12-07 19:09

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

Code: Select all

// system error reporting: 1 = log; 2 = report (not implemented yet), 4 = show, 8 = trace
$rcmail_config['debug_level'] = 4;


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

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

ninext
New user
New user
Posts: 13
Joined: 2006-11-28 10:31

Postby ninext » 2006-12-07 20:29

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

^DooM^
Site Admin
Posts: 13853
Joined: 2005-07-29 16:18
Location: UK

Postby ^DooM^ » 2006-12-07 23:51

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

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2006-12-08 04:54

^DooM^ wrote:You should really be asking for help on the RC forums anyway....


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 :shock:

BTW Jon, you really need to install SVN 400 :D

Michael
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

^DooM^
Site Admin
Posts: 13853
Joined: 2005-07-29 16:18
Location: UK

Postby ^DooM^ » 2006-12-08 12:26

Slug wrote:BTW Jon, you really need to install SVN 400 :D
Michael


I will I will :) just haven't gotten around to it yet ;)
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

digigil
New user
New user
Posts: 1
Joined: 2006-12-15 07:17
Location: Australia

Postby digigil » 2006-12-15 07:22

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

malco
New user
New user
Posts: 7
Joined: 2006-03-19 19:39

Postby malco » 2006-12-17 12:52

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

raymond
Normal user
Normal user
Posts: 135
Joined: 2006-11-30 07:13
Location: Australia

Postby raymond » 2006-12-22 07:35

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. -_-"

vlskip
New user
New user
Posts: 9
Joined: 2006-03-08 20:53

Postby vlskip » 2007-01-05 05:52

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 :

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

Can anyone help me out ???


Thx
-Carlos[/quote]

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2007-01-05 06:35

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
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

vlskip
New user
New user
Posts: 9
Joined: 2006-03-08 20:53

Postby vlskip » 2007-01-05 06:48

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.

westdam
Senior user
Senior user
Posts: 727
Joined: 2006-08-01 21:24
Location: Padova, Italy
Contact:

Postby westdam » 2007-01-05 15:51

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.

vlskip
New user
New user
Posts: 9
Joined: 2006-03-08 20:53

Postby vlskip » 2007-01-05 17:58

What version of MYSQL are you runing ???

vlskip
New user
New user
Posts: 9
Joined: 2006-03-08 20:53

Postby vlskip » 2007-01-05 18:45

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:

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

User avatar
martin
Developer
Developer
Posts: 6712
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

Postby martin » 2007-01-05 18:59

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

vlskip
New user
New user
Posts: 9
Joined: 2006-03-08 20:53

Postby vlskip » 2007-01-05 21:29

martin wrote: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.
Last edited by vlskip on 2007-01-05 21:36, edited 1 time in total.

User avatar
martin
Developer
Developer
Posts: 6712
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

Postby martin » 2007-01-05 21:30

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

vlskip
New user
New user
Posts: 9
Joined: 2006-03-08 20:53

Postby vlskip » 2007-01-05 21:38

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


Thx!

Thats all i needed :)

pimpi
New user
New user
Posts: 5
Joined: 2007-01-17 03:09

Postby pimpi » 2007-01-17 13:51

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 !

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2007-01-17 16:14

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

Michael
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

Pieter
Normal user
Normal user
Posts: 55
Joined: 2005-07-27 19:20

Postby Pieter » 2007-02-08 20:56

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.

User avatar
BOOZy
Normal user
Normal user
Posts: 76
Joined: 2006-05-25 01:25
Location: .nl
Contact:

Postby BOOZy » 2007-02-08 22:44

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.

iankearns
New user
New user
Posts: 12
Joined: 2007-02-27 13:13

Postby iankearns » 2007-02-27 16:40

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

User avatar
martin
Developer
Developer
Posts: 6712
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

Postby martin » 2007-02-27 20:37

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

iankearns
New user
New user
Posts: 12
Joined: 2007-02-27 13:13

Postby iankearns » 2007-02-27 23:00

martin wrote: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 :)

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2007-02-28 14:15

Are you using port 3307 ???

Michael
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

iankearns
New user
New user
Posts: 12
Joined: 2007-02-27 13:13

Postby iankearns » 2007-02-28 14:22

Hi Slug

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

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2007-02-28 15:04

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
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

iankearns
New user
New user
Posts: 12
Joined: 2007-02-27 13:13

Postby iankearns » 2007-02-28 15:37

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?

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2007-02-28 15:43

iankearns wrote: "No query(s) were executed. Please enter a query in the SQL window or place the cursor inside a query."


Try high lighting them, then execute them.

Michael
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2

iankearns
New user
New user
Posts: 12
Joined: 2007-02-27 13:13

Postby iankearns » 2007-02-28 16:02

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

User avatar
Slug
Moderator
Moderator
Posts: 1368
Joined: 2005-03-13 05:42
Location: Sydney Australia
Contact:

Postby Slug » 2007-02-28 16:09

iankearns wrote:SERVICE CURRENTLY NOT AVAILABLE!
Error No. 1f4)


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

Michael

I'm off to bed .... good luck.
hMailServer 5.4 B1944 external MySQL 5.5
Win 2003 SP2 | IIS 6 | ClamAV 0.97.3 | PHP 5.3.17 | Roundcube Webmail 0.8.2


Return to “General discussions”



Who is online

Users browsing this forum: No registered users and 4 guests

cron