Plesk 11.x / Linux :: Searching Large Mailbox In Horde / Roundcube Causes Read Data Timeout
Jun 26, 2014
This is applies to both Horde and roundcube webmail client software;
Using Plesk 11.5.30 with Horde 5.1.5 or roundcube 0.9.5 on CentOS Linux release 6.5 (Final).
We have seen this behavior occur on multiple servers.
Clients experienced slow to no response after executing a search, which eventually results in a failed to communicate with the server-error in the webmail client.
The Apache server log shows script time-out errors when searching larger mailboxes (i.e. larger than 950 MB), this does not happen on smaller mailboxes.
We have seen errors like the following in the Apache server error log with Horde (personal data like IP-address and domain name are x'ed out):
[Thu Jun 19 14:55:06 2014] [warn] [client xx.xxx.xxx.xxx] mod_fcgid: read data timeout in 45 seconds, referer: http://webmail.xxxxxxx.com/imp/dynamic.php?page=mailbox
[Thu Jun 19 14:55:06 2014] [error] [client xx.xxx.xxx.xxx] Premature end of script headers: ajax.php, referer: http://webmail.xxxxxxx.com/imp/dynamic.php?page=mailbox
And with Roundcube:
[Tue Jun 17 13:02:04 2014] [warn] [client xx.xxx.xxx.xxx] mod_fcgid: read data timeout in 45 seconds, referer: https://webmail.xxxxxxxxxxx.com/?_t...d=19445&_mbox=INBOX&_caps=pdf=0,flash=1,tif=0
[Tue Jun 17 13:02:04 2014] [error] [client xx.xxx.xxx.xxx] Premature end of script headers: index.php, referer: https://webmail.xxxxxxxxxxx.com/?_t...d=19445&_mbox=INBOX&_caps=pdf=0,flash=1,tif=0
Steps to reproduce:
- use a large mailbox (950 MB or higher)
- login to the webmail (Horde or roundcube)
- do a search in the search field on the top right
- the time-out error should appear in the server Apache error log (after at least 45 seconds)
This seems like an inefficiency or bug in the search query that searches the user's mailbox. Is there any other way we can prevent this issue and the error messages?
So I was trying to look up something from the horde Databases just to find that the full server backup that can be triggered in "tools & settings" -> "backup manager" does NOT include the horde and roundcube databases, even with "configuration and content" selected.
Sure, there are 7 days worth of daily backups in /var/lib/dumps but it would be nice to have those files included in the "full backup" Or am I missing something here?
Ubuntu 12.04.4 LTS Panel version 11.5.30 Update #45
The data stored in roundcube webmail (like contacts and signatures ), located in the database table "roundcubemail", is not transferred when migrating the whole server, customer or the domain that uses it. Also in the backup server, account, domain this data is not included.
I think it's a real problem if a customer with many mailboxes, who only uses roundcube, needs a backup or wants to migrate to another server. Ok, this data could be exported in rounbcube with a few mouse clicks, but itÂ´s not very comfortable. In my opinion this should be included in the backup and also in the migration process (migration manager).
I've got a server with FastCGI that at random produces 500 internal server errors. In the specific account the errors are as follows in the error_log:
[Wed May 21 12:01:29 2008] [error] [client 188.8.131.52] FastCGI: comm with (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" aborted: (first read) idle timeout (30 sec) [Wed May 21 12:01:29 2008] [error] [client 184.108.40.206] FastCGI: incomplete headers (0 bytes) received from server "/usr/local/apache2/htdocs/user/php-wrapper" As you can see this unfortunately does not tell me anything.
Now viewing the apache error_log I see this
Code: [Wed May 21 12:51:11 2008] [warn] FastCGI: scheduled the restart of the last (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" process: reached dynamicMaxClassProcs (10) [Wed May 21 12:51:11 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (uid 514, gid 515) restarted (pid 20510) [Wed May 21 12:52:00 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20510) termination signaled [Wed May 21 12:52:00 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20510) terminated by calling exit with status '0' [Wed May 21 12:57:02 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20501) termination signaled [Wed May 21 12:57:02 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20501) terminated by calling exit with status '0' [Wed May 21 13:02:03 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20491) termination signaled [Wed May 21 13:02:03 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20491) terminated by calling exit with status '0' All warnings so I'm assuming these don't mean anything.
I installed Roundcube in Plesk 12 through the link: URL....But it doesn't work. I adjusted the mailsettings for a domain to use Roundcube. With the fresh created emailaccount and you click on the webmailicon, it loads the following url but the page does not exists: URL....Aren't there any instructions for using RoundCube with Plesk? After adding Roundcube as an component are there more steps involved to get Roundcube up and running with plesk?
I am trying to configure some type of activesync component with my roundcube install on my plesk 12 box. I downloaded the activesync plugin, enabled it, and get a "your server does not support annotations or meta data" message.
I have also looked into Z Push but wasn't sure the route to go. According to the uservoice forums, plesk states activesync for roundcube is "planned" but it's been planned since 2013.
All of my packages and software is latest versions (via plesk updates) as well.
I have an individual that has moved there "sent box" to the deleted items and yes, has deleted them.
I have not used the restoration feature of plesk so i have a couple of questions before proceeding.
1. Can I restore a specific mail box folder "sent items"
2. If so will it overwrite all the items and only restore whats on the backup, because he has only just noticed and he has about 500 emails from the point he deleted it? or will it merge the items - e.g the 500 he has now + all the others from the back up.
3. If i cant restore a specific folder, does it overwrite all of the current mail from the backup.
i have one Mailbox on my server, which i cannot sending mails. I tested it with Outlook and Horde.
For Example, i see this error at the Maillog:
Jul 14 22:12:13 gaius postfix/cleanup: 2F653402A6: milter-reject: END-OF-MESSAGE from localhost[127.0.0.1]: 5.7.0 The message could not be sent. You are not allowed to use sendmail utility.; from=<email@example.com> to=<firstname.lastname@example.org> proto=ESMTP helo=<gaius.stefanshome.com>
I delete this Mailbox, but after a time, i have the same problem again. On the Plesk Webinterface there is no problem logging with the outgoing spam protection.
I have a script which checks the mailboxes of all clients to notify them when they're reaching capacity.
This does so by checking the psa database for their set limit and matching that to the maildirsize file within the user's Maildir directory.
After upgrading, though, my SQL query no longer works - it was:
Code: SELECT clients.email as owner_email, domains.id, domains.name, Limits.value AS domain_quota, mail.mail_name, mail.mbox_quota from Limits, clients, domains, mail WHERE mail.postbox='true' AND limit_name = 'mbox_quota' AND domains.limits_id = Limits.id AND mail.dom_id = domains.id AND clients.id = domains.cl_id ORDER BY domains.name ASC
However, on closer inspection, all values in the domains table for limit_id are NULL.
Has this changed in 11.5? Is there an alternative way to quickly get all limits for domains?
i then used a MD5 generator to input the hash in the password field of the roundcube user in mysql, with no luck...I even tried to delete roundcube user from mysql, then remove psa-roundcube, then go through the plesk update manager and install roundcube again, did not change nothing, it didn't even create the roundcube user.
Is there anyway i can reinstall roundcube from scratch?PPP 11.5 up to date on ubuntu 12.04
[05-Oct-2013 14:03:54 +0200]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'localhost' (using password: YES)] [Native code: 1045] [Native message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
I installed PLESK12 (or better: I installed the distributed Debian-Image from my hoster) onto my server. Everything works fine as always - except webmail. I did the following:
- in the general webmail properties, I deactivated Horde. roundcube was active and still is (also tried to activate it again) - I also activated roundcube as webmailer in the hosting itsel. - tried to open webmail.mydomain.com --> site not found. I added a mail-adress and tried to use the icon to the webmail --> site not found. - I restarted the server (maybe deactivation Horde did some stuff there...)... no changes.
PLESK 12 (latest update), running on Debian 7.6 ....
I am having a Plesk server and when I scanned it with tools like OpenVas, It detected the following vulnerabilities with CVE acronym. As the corresponding ports and services are being controlled by Plesk, I require to patch it.URL....As you can see this vulnerability has been hit on port 106. I checked the Plesk server and found the port 106 being used by service "poppassd". This was nothing I installed and came along with the Plesk installation. Hence just wanted to make sure whether it has a patch from Parallels. As per my investigation this service is used for changing mailbox passwords and I am currently using Roundcube client. How to patch this vulnerability.
As per the solution in pic, the vulnerability "SMTP antivirus scanner DoS" can be resolved by upgrading or installing anti virus for Plesk mail server. I am ready to buy Dr.Web or Kaspersky from Parallels. But wanted to make sure whether any of the above antivirus can resolve the vulnerability.