Plesk 11.x / Linux :: How To Get Mailbox Limits From Database
May 21, 2014
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 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:
Code:
Jul 14 22:12:13 gaius postfix/cleanup[12194]: 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=<user@server1.local> to=<user2@server.local> 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 imported ~15 email account during a cPanel migration/transfer done with the manager. mails are there but mailboxes, that had an unlimited quota, are now set to 350MB.
i tried a bunch of stuff, from searching the whole webinterface, changing db entries up to postfix main.cf.
i'm just restoring yesterdays backup. i already lost hours, and now am loosing nerves ..
where can I find this setting, or how can i set it in the DB (chancing max_box and mbox_size did not work, changes in the mail table were reflected on the UI, but not for postifx ..) ?
Is there a way to set the mailbox quotas for all of the mailboxes on a domain, at once? When I set the default, it doesn't change the quotas for existing mailboxes.
How do you reset the outgoing mail limits report?I have been doing some testing and I don't want the report to show that some of my domains are over their limits.
-----Original Message----- From: Provider Co. [mailto:<email>] Sent: <date> To: <customer name> Subject: Notification: Resource limits exceeded by reseller account.
The <account name> account is approaching or already exceeded the limits:However, no exceeded or close to exceeded resources were found.This is in the KB, but no date is on it. Has this been fixed?URL...
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.
For some reason one of my customers email accounts seems to have been hacked. My admin account continues to say that the customer has reach over the 30 emails per hour limit. This is the email error:
following customers' domains, mailboxes and subscriptions are reached their limits for outgoing emails for the period:>From Dec/13/2014 05:47. To Dec/ 13/ 2014 06:47
Subscriptions customerdomain.com, the limit is 100 messages per hour 336 attempt(s) to exceed limits from Dec/13/2014 04:31 to Dec/13/2014 05:47
So far it has sent over 5,000 attempted in the past few hours. The customer used gmail to send from domain before, so I've changed their gmail email password. I've also changed the main email password, and the plesk username and password login for the customer. It still continues
PROBLEM DESCRIPTION When triggering the events 'Mail account created' or 'Mail account modified' the returned variable NEW_MAILBOX will always state TRUE regardless of the mailbox option being ticked or not ticked on the 'New mail account' option located on the 'Mail' tab of a subscription.
STEPS TO REPRODUCE 1: Log in to plesk. 2. Select 'Tools & Settings' 3: Select 'Event Manager' 4: Select 'Add New Event Handler' 5: Select Event 'Mail account updated' 6: Enter in '/usr/bin/php /root/scripts/dbmail/mail_mod.php' to the Command box.
[Code] ....
ACTUAL RESULT
[NEW_MAILBOX] => true
EXPECTED RESULT
[NEW_MAILBOX] => false
ANY ADDITIONAL INFORMATION
I submitted this with parallels support and they stated that the variable NEW_MAILBOX will always return as TRUE regardless of if the mailbox option is ticked or not. They also stated the NEW_MAILBOX variable will be true regardless of any action taken on the panel with mail accounts. The actual documentation on this variable is very sparse
Component name/description Old component value New component value Mailbox old_mailbox new_mailbox
We previously had some code that would trigger on this variable and would create a mail account on our mail server with or without a mailbox.
if (!strcmp(getenv('NEW_MAILBOX'),"true") && !strcmp(getenv('OLD_MAILBOX'),"false")){ //Create a mailbox on the external mail service } if (!strcmp(getenv('NEW_MAILBOX'),"false") && !strcmp(getenv('OLD_MAILBOX'),"true")){ //Create a mail forwarder on the external mail service }
At some point this variable has stopped working with newer versions of plesk. Having a variable that is always true regardless of what is done when creating a mail account seems pointless and requesting a new feature that was already there in older versions doesnt seem like something that should be requested on a new feature request.
QUESTION: Is there anyway to get this functionality restored other than requesting it gets re added via [URL] ....
I've already stop the spamassassin service on Services Management but it's only valid one day. The next day, spam assassin service automatically start
2. my customer mailbox statistic wrong. Even if their mailbox not full but when they send email. The quota said that their mailbox full. So they can't send/receive email.
Our action : Manually, use command /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/DailyMaintainance/script.php -f execute-statistics
Today I upgraded to Plesk 12 and during the day I got several customers that had problems with their mailbox size. According to Plesk they were exceeding the size, but they've been doing that for years. The setting that these limits don't have any real meaning is ignored after the upgrade...
When I create Mailbox for customer, spamassassin have status (default):
HTML: Status false The score that a message must receive to qualify as spam What to do with spam mail move Add the following text to the true beginning of subject of each message recognized as spam Modify spam mail subject text ***SPAM***
Black list ================================ Server-wide black list:
User's black list:
White list ================================ Server-wide white list:
User's white list:
But i want it:
HTML:
Status false The score that a message must 7 receive to qualify as spam What to do with spam mail text Add the following text to the true beginning of subject of each message recognized as spam Modify spam mail subject text ***SPAM***
Black list ================================ Server-wide black list:
User's black list:
White list ================================ Server-wide white list:
User's white list:
Not Move, it only text at "What to do with spam mail text"
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?
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm ...done. done -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started. ===> Cumulative upgrade of APS controller database has been completed. ===> Cumulative Plesk database upgrade (revertable stage) has been started. ===> Preparing Plesk database upgrade (revertable stage). ===> Cumulative upgrade of Plesk database (revertable stage) has been completed. Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.
I upgraded from 11 to 12 (centOS) and set outgoing mail limits for mailboxes, domains and subscriptions, as per the documentation at URL....However, it doesn't appear the limits are limiting outgoing mail. As I can still send far more mail than the current limit using a PHP script.
#### maillog (partial & timestamp + servername removed for brevity) #### py_limit_out[16427]: ERROR 'NoneType' object has no attribute 'lower' plesk sendmail[16426]: Error during 'limit-out' handler plesk sendmail[16426]: handlers_stderr: SKIP plesk sendmail[16426]: SKIP during call 'check-quota' handler
[code]....
how to configure outgoing mail limits? I've also read through the sendmail documentation but couldn't find anything.
It is possible to have anti-virus and anti-spam enabled by default when we go to "CREATE E-MAIL ADRESS" -> "SPAM FILTER" / "ANTI-VIRUS" is always disabled.
I have been playing around with different virtualization platforms:
- OpenVZ (newer kernels do not support hard-cpu limits for whatever reason)
- Xen Server
- Windows Hyper-V
- Linux KVM
However, none of them seem to be able to stablish HARD limits on resources for a virtual machine. Or am I missing something?
HyperVM supposedly has hard-limits because they use OpenVZ older kernels, right? -- I have not tried Parallels Containers do they have hard-limits enforced?
After upgrade 11.5 to 12, my panel works fine but nos subscription in the panel.Websites are working well...Is it possible to reconstruct the psa database (no backup :-( ) ?Some backups of psa database are done before the upgrade?
Just updated to V12 and noticed you can't copy a database from one domain to another as easy as before. So doing any testing is much harder. Is this correct or am I missing something...