Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 139 posts ]  Go to page 1, 2, 3  Next

Has this how to worked for you ?
Yes 61%  61%  [ 14 ]
No 39%  39%  [ 9 ]
Total votes : 23
Author Message
 Post subject: HOWTO: Install Roundcube with IIS6 and hMs internal DB
PostPosted: 2006-08-30 17:45 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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.

Top
 Profile  
 
 Post subject:
PostPosted: 2006-08-30 18:24 
Senior user
Senior user

Joined: 2006-08-01 21:24
Posts: 728
Location: Padova, Italy
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 )


Top
 Profile  
 
 Post subject: roundcube mysql user
PostPosted: 2006-08-30 22:13 
Senior user
Senior user
User avatar

Joined: 2005-10-13 21:28
Posts: 2487
Location: Lithuania
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.


Top
 Profile  
 
 Post subject: Re: roundcube mysql user
PostPosted: 2006-08-31 09:25 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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.

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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-08-31 10:58 
Senior user
Senior user
User avatar

Joined: 2005-10-13 21:28
Posts: 2487
Location: Lithuania
I suspect that screenshot shows
Code:
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->...."


Top
 Profile  
 
 Post subject: Re: roundcube mysql user
PostPosted: 2006-08-31 15:35 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-09-01 03:17 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject: Problem
PostPosted: 2006-11-07 21:53 
Normal user

Joined: 2004-07-15 08:53
Posts: 51
Have done everything you wrote but i get

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

?


Top
 Profile  
 
 Post subject:
PostPosted: 2006-11-07 23:10 
Site Admin
User avatar

Joined: 2005-07-29 16:18
Posts: 13792
Location: UK
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.


Top
 Profile  
 
 Post subject: Re: Problem
PostPosted: 2006-11-08 02:53 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-11-29 21:40 
New user
New user

Joined: 2006-11-29 21:25
Posts: 4
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2006-11-30 00:16 
Site Admin
User avatar

Joined: 2005-07-29 16:18
Posts: 13792
Location: UK
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-11-30 00:26 
Normal user

Joined: 2005-11-25 10:47
Posts: 48
Location: UK
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...


Top
 Profile  
 
 Post subject:
PostPosted: 2006-11-30 02:22 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-11-30 18:51 
New user
New user

Joined: 2006-11-29 21:25
Posts: 4
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-01 00:43 
Normal user

Joined: 2005-11-25 10:47
Posts: 48
Location: UK
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-01 13:52 
New user
New user

Joined: 2006-11-28 10:31
Posts: 13
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-01 15:51 
Site Admin
User avatar

Joined: 2005-07-29 16:18
Posts: 13792
Location: UK
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-01 19:22 
New user
New user

Joined: 2006-11-28 10:31
Posts: 13
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 .....!!!


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-01 19:35 
Developer

Joined: 2003-11-21 01:09
Posts: 6403
Location: Sweden
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?


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-01 20:32 
Senior user
Senior user

Joined: 2006-08-01 21:24
Posts: 728
Location: Padova, Italy
ahhhhem
database error on roundcubeforum :p


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-02 07:46 
New user
New user

Joined: 2006-11-29 21:25
Posts: 4
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-02 18:02 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-02 19:50 
New user
New user

Joined: 2006-11-29 21:25
Posts: 4
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-04 15:31 
Senior user
Senior user

Joined: 2006-08-01 21:24
Posts: 728
Location: Padova, Italy
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-04 21:49 
New user
New user

Joined: 2006-11-28 10:31
Posts: 13
Quote:
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!!!!


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-05 03:40 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
ninext wrote:
Quote:
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-07 19:03 
New user
New user

Joined: 2006-11-28 10:31
Posts: 13
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!


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-07 19:09 
Site Admin
User avatar

Joined: 2005-07-29 16:18
Posts: 13792
Location: UK
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:
// 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....


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-07 20:29 
New user
New user

Joined: 2006-11-28 10:31
Posts: 13
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-07 23:51 
Site Admin
User avatar

Joined: 2005-07-29 16:18
Posts: 13792
Location: UK
Then check what the error messages are telling you. the first 3 are permissions issues. and the last one it can't find.


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-08 04:54 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
^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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-08 12:26 
Site Admin
User avatar

Joined: 2005-07-29 16:18
Posts: 13792
Location: UK
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! ヅ


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-15 07:22 
New user
New user

Joined: 2006-12-15 07:17
Posts: 1
Location: Australia
Thanks for the "How To", it worked for me.


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-17 12:52 
New user
New user

Joined: 2006-03-19 19:39
Posts: 7
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


Top
 Profile  
 
 Post subject:
PostPosted: 2006-12-22 07:35 
Normal user

Joined: 2006-11-30 07:13
Posts: 135
Location: Australia
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. -_-"


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 05:52 
New user
New user

Joined: 2006-03-08 20:53
Posts: 9
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:
"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:
* CAPABILITY IMAP4 IMAP4rev1 CHILDREN IDLE QUOTA SORT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #29

Can anyone help me out ???


Thx
-Carlos[/quote]


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 06:35 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 06:48 
New user
New user

Joined: 2006-03-08 20:53
Posts: 9
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 15:51 
Senior user
Senior user

Joined: 2006-08-01 21:24
Posts: 728
Location: Padova, Italy
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 17:58 
New user
New user

Joined: 2006-03-08 20:53
Posts: 9
What version of MYSQL are you runing ???


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 18:45 
New user
New user

Joined: 2006-03-08 20:53
Posts: 9
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:
"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:
* CAPABILITY IMAP4 IMAP4rev1 CHILDREN IDLE QUOTA SORT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #29


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 18:59 
Developer

Joined: 2003-11-21 01:09
Posts: 6403
Location: Sweden
vlskip, I think you should go to http://roundcubeforum.net/forum and ask your question there. This forum is mainly for hMailServer.


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 21:29 
New user
New user

Joined: 2006-03-08 20:53
Posts: 9
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.

Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 21:30 
Developer

Joined: 2003-11-21 01:09
Posts: 6403
Location: Sweden
No, the log just shows your client logging on succesfully, and then logging out immediately again.


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-05 21:38 
New user
New user

Joined: 2006-03-08 20:53
Posts: 9
martin wrote:
No, the log just shows your client logging on succesfully, and then logging out immediately again.


Thx!

Thats all i needed :)


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-17 13:51 
New user
New user

Joined: 2007-01-17 03:09
Posts: 5
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 !


Top
 Profile  
 
 Post subject:
PostPosted: 2007-01-17 16:14 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-08 20:56 
Normal user

Joined: 2005-07-27 19:20
Posts: 55
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-08 22:44 
Normal user
User avatar

Joined: 2006-05-25 01:25
Posts: 77
Location: .nl
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-27 16:40 
New user
New user

Joined: 2007-02-27 13:13
Posts: 12
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


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-27 20:37 
Developer

Joined: 2003-11-21 01:09
Posts: 6403
Location: Sweden
Iankearns, can you explain exactly how you decrypted the password? I'm guessing that you didn't do it the right way.


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-27 23:00 
New user
New user

Joined: 2007-02-27 13:13
Posts: 12
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 :)


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-28 14:15 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-28 14:22 
New user
New user

Joined: 2007-02-27 13:13
Posts: 12
Hi Slug

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


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-28 15:04 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-28 15:37 
New user
New user

Joined: 2007-02-27 13:13
Posts: 12
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?


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-28 15:43 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-28 16:02 
New user
New user

Joined: 2007-02-27 13:13
Posts: 12
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


Top
 Profile  
 
 Post subject:
PostPosted: 2007-02-28 16:09 
Moderator
User avatar

Joined: 2005-03-13 05:42
Posts: 1369
Location: Sydney Australia
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 139 posts ]  Go to page 1, 2, 3  Next


Who is online

Users browsing this forum: No registered users and 5 guests



Search for:
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group