Comments on RoundCube webmail installation on Debian 8 (Jessie)

My certificate doesn't have a hostname. How do I create a certificate without breaking everything in ispconfig?

Subject: C=AU, ST=Some-State, O=Internet Widgits Pty Ltd

 

Please see here: http://www.faqforge.com/linux/how-to-renew-the-ispconfig-3-ssl-certificate/

Okay my certificate is better now and I ran through the steps again but I'm still getting Soap Error: Could not connect to host.

I have everything exactly as explained in your article with the exception of using fpm instead of cgi but I also made sure to modify the php.ini in the fpm folder properly.  

 

Any other ideas or ways I can troubleshoot this?

This tutorial uses mod_php and not cgi PHP. The error " Could not connect to host." means that the SOAP endoint that you configured in the configuration file is not reachable, you either used a wrong IP address or a subdomain that does not exist in DNS.

Thank you for your continued support. Does the certificate have to be signed by an authority? Or am I fine to just continue using the one I generated using your referenced website?

No. You just have to tell PHP that this certificate root is valid. This step is done by editing the php.ini file as described in the tutorial.

It's simple :) - you need to change the way plugins are connecting to SOAP:(ie. /opt/roundcube/plugins/ispconfig3_account/ispconfig3_account.php L:13)        $this->soap = new SoapClient(null, array('location' => $this->rcmail_inst->config->get('soap_url') . 'index.php',                                                 'uri'      => $this->rcmail_inst->config->get('soap_url'),                                                 'trace'    => 1,                                                 'stream_context'=> stream_context_create(array('ssl'=> array('verify_peer'=>false,'verify_peer_name'=>false)))

        ));But you must do this for every single plugin...

Thats only necessary when you use a self-signed SSL certificate and don't import the ispconfig cert as described above. Your approach is an alternative to the setup above but not necessary when you follow this tutorial.

till - well i tried to follow this tutorial and triple checked every single step regarding certificate etc. (And yes i checked cert params, import...). But i wasnt able to get it to work on Debian jessie php 5.6. So let's say, its a workaround. I've seen too many people having trouble with this.

The only way that worked for me, has been editing the plugin. There are several sites reporting this error, but only editing the files to solve. (in my environment)

The following doesn't work, when go to setting after loading the setting tab its blank

 

The files has a plugin setting but with the following command

$config['plugins'] = array(    'archive',    'zipdownload',   

$rcmail_config['plugins'] = array("jqueryui", "ispconfig3_account", "ispconfig3_autoreply", "ispconfig3_pass", "ispconfig3_spam", "ispconfig3_fetchmail", "ispconfig3_filter");

Compare your line again with the one of the tutorial, what you posted is not the one from this guide.

Hi Till,

one more great tutorial, thanks!

What about moving $rcmail_config to $config - as is in actual Roundcube installation ($rcmail_config is pre 1 style)?

 

Oh, and I do have problems with this tinyMCE installation here to add comments: my Firefox 42 is not resolving the necessary javascript, so instead of filling the textarea with an editable "virtual" iframe, it just blanks it out :-( I needed to switch to Chrome for a pitty.

Hi Till!

I'm having same problem with certificate, it doesn't have a hostname.

Subject: C=AU, ST=Some-State, O=Internet Widgits Pty Ltd

After trying to send a mail I receive this error:  smtp error (-1) connection to server failed

I have installed twice over this tutorial:

The Perfect Server - Debian 8 Jessie (Apache2, BIND, Dovecot, ISPConfig 3)

Same result.

Thanks!

Enter the hostname while you create the SSL certificate, then the cert has a hostname.

Hi, if there's a tutorial how to install roundcube email for ispconfig3 on centos 6?? thanks

should link to this tutorial at http://www.ispconfig.org/page/en/documentation.html

Thanks for this - worked like a dream!

fololowed the tutorial and i'm able to login. only problem is that if i'm  logged in, settings - account - every submenue shows me a "Soap Error: Bad Request". The yutoreply seems to run forever. due to the error i can't make an entry (for mailfiler for example).

is there something i can check ?

spent some time until i found the hint that solved my problem. i followed the "The Perfect Server - Debian 8 Jessie (Apache2, Bind, Dovecot, ISPConfig 3" before i started this howto.

To get things working i had to add the first two lines written in italic to my .htaccess file:

root@myhost:/usr/local/ispconfig/interface# cat /usr/local/ispconfig/interface/web/.htaccessRequire host <myhostname>Require ip <myIP>AuthType BasicAuthName "Login"AuthUserFile /usr/local/ispconfig/interface/.htpasswdrequire valid-userProbably it would be woth mention that so that others won't have the same issue.

There is no file /usr/local/ispconfig/interface# cat /usr/local/ispconfig/interface/web/.htaccess in ISPConfig by default. If you created one to protect yur ispconfig with a second auth layer, then you have to enable access for the remote api in your manually added .htaccess file off course.

in debian 8 howto will not function on port 465 is an mistake insert in config.inc.php: $config['smtp_server'] = 'localhost';

let var emtpy localhost is defined in: $config['default_host'] = 'localhost'; after install then roundcube send on port 465

 

Hello

it works fine for me too, thanks for this tutorial!

i just have a problemwhen you go to Einstellung (configruation)then to Konto

i go a error "Soap Error: Could not connect to host"

but sending and getting email, addressbook and so works fine

have a nice dayvinc

Make sure the following line in ispconfig3_account/config/config.inc.php

   $rcmail_config['soap_url'] = 'https://server1.example.com:8080/remote/';

has https and not http which is the default.

Hi,

 

thanks again for a brilliant guide, however I have some issues.  I receive a 403 error (Forbidden) whenever I try to access http://my.ip/roundcube or http://my.ip/webmail.  On the apache2 error log I see  AH01630: client denied by server configuration: /var/www/webmail and  AH01630: client denied by server configuration: /var/www/roundcube

How can I resolve this?

Thanks.

Hi,

How to configure roundcubemail for https  only?

For those who have a problem with SOAP ERROR

 

You must add line

openssl.cafile=/etc/ssl/certs/ca-certificates.crt

into the /etc/php5/apache2/php.ini

 

First i have regenerate a SSL certificate for ISPconfig with FQDN hostname of server by run the script update.php in ISPconfig install folder.

Second i apply this tutorial. I use Roundcube in a subdomain with PHP-FPM. This tuto work fine if i add this line in /etc/php5/fpm/php.ini (see below).

No SOAP error or Could not connect message.

Thanks and sorry for my poor english.

openssl.cafile=/etc/ssl/certs/ca-certificates.cr

hii have an server installed with this tutorial : https://www.howtoforge.com/tutorial/perfect-server-debian-8-jessie-apache-bind-dovecot-ispconfig-3/

All worked fine. I followed your tutorial and it works. roundcube works perfact and also the ispconfig plugin works in roundcube

But now i have an problem in ISPCONFIG on the Email Tab. when i click on e-mail the left side menu loads but i see the last Content (for example serverstat). this is only in the email tab. all other worked fine system, sites, client ...

any idea what is gone broken?

Just a guess: You created a alias /mail for roundcube instead of /webmail. The /mail alias that you created redirects the requests of the mail tab in ispconfig to RoundCube now. Change the alias in apache to /webmail and restart apache to fix the issue.

Very important !

Do not forget to set  "$config['des_key']" in your config.inc.php file.

Dear till!

How should i start if i try to make roundcube work on an ispconfig server that i just upgraded from wheezy, and had roundcube before (by your previous guide)?

Hello till!

How should i start if i want to install roundcube on a server that i just upgraded from wheezy to jessie, and it had had a working roundcube before the upgrade per your previous guide (Using RoundCube Webmail With ISPConfig 3 On Debian Wheezy (Apache2))?

 

As this tutorial won't work for every multiserver setup (where the certificate must not be the one from the local server) and I just spent 2 hours finding out what's going on, you might find this useful if- you have a Multiserver Setup- you get a Soap error connecting to the host (using https to connect to the API)- running the webmailer in http is not an option for you- importing the other server's certificate (the one with the main dbispconfig database) and updating using update-ca-certificates failed

the only solution for me was to replace the initialization of the new SoapClient in the 9 ispconfig plugin files (/opt/roundcube/plugins/ispconfig3_*) to:

$this->soap = new SoapClient(null, array('location' => $this->rcmail_inst->config->get('soap_url') . 'index.php', 'uri'=> $this->rcmail_inst->config->get('soap_url'),'stream_context' => stream_context_create(array('ssl'=> array('verify_peer'=>false,'verify_peer_name'=>false)))));

FWIW, jessie-backports does have a roundcube package if anyone prefers that.

Good to know. I was not aware of that :)

hello i have question about multi-card ss certyficat in roundcube . If i don't implement my premum ssl and using with isp ssl certyfication plugins in roundcube work fine. But when i change with my plugins send ERROR: no connection to server. i know this is problem with sopa url in config.inc.php . My certyficat CN = .*mydomain.com but in ispconfig CN=mailserver.maindomain.com and in soap url is ok if he see that  CN = mailserver.maindomain.com $rcmail_config['soap_url'] = 'https://mailserver.maindomain.com:8080/remote/'; Roundcube plugins work fine !!! but self ssl is bad idea i have premium multi domain ssl . And now my question is what i can add here if my CN = .*maindomain.com $rcmail_config['soap_url'] = 'https://what need here :8080/remote/'; 

  i know this is problem with sopa url in config.inc.php . My certyficat CN = .*mydomain.com but in ispconfig CN=mailserver.maindomain.com and in soap url is ok if he see that  CN = mailserver.maindomain.com $rcmail_config['soap_url'] = 'https://mailserver.maindomain.com:8080/remote/'; Roundcube plugins work fine !!! but self ssl is bad idea i have premium multi domain ssl . And now my question is what i can add here if my CN = .*maindomain.com $rcmail_config['soap_url'] = 'https://what need here :8080/remote/'; 

Hi. I have a question regarding password plugin for roundcube. If both email and web server resides on the same machine the plugin setup is quite clear:

$config['password_db_dsn'] = 'mysql://userdb:password@localhost/dbispconfig';

and 

$config['password_query'] = 'UPDATE mail_user SET password = %c WHERE email = %u LIMIT 1';

In my case roundcube resides on a separate server than email server, in a multiserver ISPConfig setup.

So there are two mysql databases that must by updated in the same time.

Can anyone help with this? How to change the config.inc.php and sql.php (from drivers sub-folder) in order to accomplish this task?

Thank you!

Use the ispconfig roundcube plugin (which uses the correct way to connect to ISPConfig with the remote api) and not a plugin that messes with MySQl directly.

Hey :)

Thanks for your tutorial.

I have a little problem. When i go to my website https://192.168.x.xxx/webmail

I have a little error:

DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database!Please contact your server-administrator.   And i can't finde the mistake  Can you help me?   Thank you!

Hallo Till,

sehr ausführliches und gutes Tutorial. Ich möchte aber kurz fragen, ob das ganze auch für ISPConfig 3.1 funktioniert?

As far as I know, the author of the roundcube ISPConfig plugin did not adjust it for ISPConfig 3.1 yet. But you might find more up to date information on the Github page of the roundcube plugin.

Hi thx for your tutorial it's realy helpfull, i was lost a littel bit on installing roundcube, i got an error "Could not connect to localhost:143: Connexion refused" i think i follow all steps on your tutorial but it dont work, i would like to remove roundcube anr reinstall it but i got the msg no could not find the roundcube package!!

how can i inunstall it completly thank you

Hi Till,

 

Thanks for this information is really usefull. However i have adoubt after roundcube is install, what user and password do you use for the first time? or where do you created it? I'm getting an error: "Connection to storage server failed".

 

I'm not quite sure what could this be?

 

Thanks indeed.

 

Regards

Roundcube does not has it's own username or password. Roundcube is an email client, so the username and password are the login credentials of the email account that you want to login. You get a connect error, so either MySQL or the IMAP server are not reachable.

Thx for tutorial.I made it and arrived at the end i m in the same situation than julio barreto.I have no account to connect in roundcube.I made an other tutorial where account were created in mysql database postfix.In your tutorial there is nothing about postfix or those account.

You seem to haven't read the prerequisites, which describe that you must have an email server. to use the email client RoundCube. Roundcube is just an IMAP email client like Thunderbird or Outlook, not more and not less. Setting up an email server is not in the scope of a RoundCube installation tutoral as you can use Roundcube with any mail server at any internet provider that provides an IMAP login. This tutorial is made e.g. for ISPConfig servers (perfect server setup as mentioned in the prerequisites), the account creation of IMAP accounts is done in ISPConfig then. All you have to do is to login to ISPConfig on your server, go to the mail tab, enter the email address and password of the account that you want to create. ISPConfig then adds this mailbox to your system and you use this email address and password to login to roundcube.

ahah.Thank you for your answer Till, you helped me good and made me laugh.I m not Linux user. So all that not so easy for me and English, not my native language. I have my own server since some months, i already installed Roundcube 2 times and it worked...with a different method. Without ispconfig, only postfix, and courier. I thought i could mix my old installation with your installation without making your prerequisite but all that is complicated and sensible and it didn't work. My knowledge in Linux is little and not enough to fix all problems. Could take me years and i have other things more interesting to do. So I reinstalled all my server, using your "perfect server" setup. And I can connect in Roundcube now.In my last installation of Roundcube i spent weeks to have a 10/10 in "mail-tester",at start it was 0.I finally had SPF, DKIM and DMARC validation. Actually with your installation I m at start at 7.9/10 in mail-tester it is good but email still finishes in spam box if I send to msn, hotmail, live. What is the correct setting with your installation to fix that problem?Probably you know a tutorial which work fine with your installation.

Please make a post in the forum with your mal tester result so that the community can help you with fine-tuning your mail domain settngs.

I not need forum for dkim and spf, i m already again at 10/10 in mail-tester.Problem is my messages still always finish in spam box of Microsoft outlook. You made a tutorial about installation of RoundCube and i m 100% sure you know till what is the setting to do in server to not make Microsoft consider your emails like spam. When i check mail source in outlook, i have dkim pass, spf pass, dmarc pass but email is considered like spam.Thanks.

It might be that your IP address has a bad reputation. You might try to whitelist it a Microsoft here: https://support.microsoft.com/en-us/getsupport?oaspworkflow=start_1.0.0.0&wfname=capsub&productkey=edfsmsbl3&locale=en-us&ccsid=636130889221261125

Hi, thanks again for this great job, i followed your tutrial and finaly i was able to connect to my mail box but i still have some problems hope you or some one here will help me resolve them.

when i click on the mail icon from ispconfig i got a not found erro due to the lik https://myserver:8080/mail/webmail  i have to remove the mail but i dont see where i can do it.

and when i get to my mail box i got this erro: SMTP Error (-1): Connection to server failed.

impossibe to send or recieve emails.

i dont know if you already talk about that but i have treid many solution from the tutorial and the comments without any result.

The link behind the icon is freely configurable, you can find the settings under System > Interface config in ISPConfig. Regarding your postfix errr, please use the forum to ask for help.

Thanks it was easy and straight forward not using ispconfig but webin otherwise i would be glad to try it out with Webmin which i have tried use but could not make it work.

Hello everybody, i need help. I use this tutorial and the "perfect server for debian 8". and my server is working but my roundcube have one problem. When i send an email from outside (gmail, outlook,etc..) to my roundcube cannot receive mail. But i can use internal service(the server) and can send to outside (gmail,outlook). I really need help. THanks.

Would you recommend to use the ISPConfig RoundCube plugin on a ISPC3/Apache/Ubuntu 16.04 Perfect Server setup?

Or is it discouraged?

I don't see any problems in using it with ISPConfig on Ubuntu.

Open the /etc/php5/cgi/php.ini file

nano /etc/php5/apache2/php.ini

Scroll down until you see the [openssl] section of the file and there you add the following line:

openssl.cafile=/etc/ssl/certs/ca-certificates.crt

 

Which one is correct? I added it to both and this is the only instruction that's unclear to me. When I login to RoundCube v1.2.3, there's still no Settings > Account. I have successfully done this for several other servers without issue and have tripple-checked everything but confused.

When i tried login in roundcube i am getting this error which is mention below.

Connection to IMAP server failed.

Please provide me the solution.

Its a great tutorial. I am using mail server configured through the help of this tutorial for last 3 years. Now the HDD having Vmail folder is 80 Percent full. I want to delete some specific emails directly on the server across all the mailboxes to create some space on HDD. For example all mails containig phrase 'Happy Birthday'. Also want to clear Trash and Junk folder directly on the server. I am not very proficient in Linux. Kindly help, Thanks in advance.

Hi how i can add password change plugin to IspConfig 3.1 Debain 9?

We have move from IspConfig 3 and i like to enable this feature for users in RoundCube Webmail 1.2.3. 

Thanks

There is nothing to be installed in ISPConfig. Just install the RoundCube addon and connect it to ISPConfig with the remote API (User/Password).

Hi Till,Ich habe die Anleitung strikt befolgt und es funktioniert soweit auch alles.Allerdings wenn ich in den Einstellungen zu Konto wechsle, bekomme ich eine Fehlermeldung "Soap Error: Internal Server Error".Also habe ich nachgesehen, was in meinem error.log steht.mod_fcgid: stderr: PHP Fatal error:  Uncaught Error: Class 'SoapServer' not found in /usr/local/ispconfig/interface/web/remote/index.php:16mod_fcgid: stderr: Stack trace:mod_fcgid: stderr: #0 {main}mod_fcgid: stderr:   thrown in /usr/local/ispconfig/interface/web/remote/index.php on line 16In Zeile 16 der index.php habe ich das gefunden:$server = new SoapServer(null, array('uri' => $_SERVER['REQUEST_URI']));I don't know what to do now.If you or anyone else could help me, that would be great.

 

Thanks

Steffen

Sorry for the bad formatting in my previous comment.

 

I just thought about it again and just tried the following:

 

wget https://server.domain.tld:8080/remote/

 

I got the 500 Internal Server error.

 

This is how I identified the problem.

 

I made a mistake with the hostname. My hostname pointed to 127.0.1.1 and not to 127.0.0.1

 

After the change everything works fine for me.

Hi Till, I start testing this (or almost) setup on multiserver, about 1 year ago. It looks stable and roundcube works fine, but trying to use https://my.domain leads to roundcube login page instead of secure my.domain webpage ! I'm trying for 2 days to imagine why happnes, but not found the cause :(

I guess is useless to mention if I comment out those 2 classic aliases, will stop working my.domain/roundcube, but https://my.domain will still go to roundcube login page.

Where could be the statement wich is doing that redirection ? I guess it's a default because I don't remember to configure anything related to https.

Hello, how to create user login of roundcube?.

RoundCube is an IMAP email client, you use your mailbox login to login to RoundCube.