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?

View 4 Replies


ADVERTISEMENT

Plesk 11.x / Linux :: No Mailbox Created

May 24, 2014

$request = <<<EOF
<packet version="1.6.5.0">
<mail>
<create>
<filter>
<site-id>34</site-id>
<mailname>
<name>$username</name>
<mailbox>
<enabled>true</enabled>
<quota>1024000</quota>
</mailbox>

[code]....

I write this code for creating mail box, but I get "No mailbox" message in plesk panel. I need to create mailbox.

View 2 Replies View Related

Plesk 12.x / Linux :: New Email Address With NO Mailbox

Jun 20, 2014

Since upgrading to 12.0.18 Update #5 i have picked up a strange problem when creating a new email account.

When I try setup and new email account on any domain, I get teh following error message.

Code:

Error: mailmng-outgoing failed: ERROR:outgoing:mails.domain_id may not be NULL

If i click OK, I get the following error message

The specified email address is already in use.

I have to click cancel to return to the email address list, which shows the new email address with NO mailbox.

I then have to open the email address and check the Mailbox option to activate it.

Now the email account is configured correctly.

View 5 Replies View Related

Plesk 11.x / Linux :: Email Mailbox Restoration

Oct 28, 2014

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.

View 1 Replies View Related

Plesk 12.x / Linux :: Spam Sent From Limited Mailbox?

Apr 3, 2015

Today in a plesk 12 with mail control (20 mails per hour per mailbox) a spammer stole a password of a mailbox and send nearly 1000 mails in two hours.

How can it is possible? Also in the stats I see 0 mails sent. In the logs (var/log/mail.log) I see the spam wast sent from a mailbox...

View 8 Replies View Related

Plesk 12.x / Linux :: One Mailbox Cannot Send Mails?

Jul 14, 2014

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.

View 2 Replies View Related

Plesk 12.x / Linux :: Mailbox Quota In Web App Edition

Oct 20, 2014

how to adjust the mailbox sizes.

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

View 10 Replies View Related

Plesk 12.x / Linux :: Mailbox Usage Display?

Jul 1, 2015

On the page /smb/email-addresses/list (for each domain) there is a list of email addresses with a usage bar graph on each line.

Last week, all mail was deleted from some of the accounts, but the bar grpah has not updated.

One of the mailboxes shows 495mb, but du on the qmail directory shows it has only 9.

How can I get the Usage column to report correct data?

View 1 Replies View Related

Plesk 12.x / Linux :: Set All Mailbox Quotas Under A Domain?

Feb 11, 2015

Plesk 12.x
CentOS 6.6, 64-bit

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.

View 3 Replies View Related

Plesk 12.x / Linux :: Reset Outgoing Mail Limits Report

Jul 27, 2014

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.

View 1 Replies View Related

Plesk 12.x / Linux :: Resource Limits Exceeded By Reseller Account

Dec 15, 2014

Reseller account receives the email:

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

View 9 Replies View Related

Plesk 11.x / Linux :: Add Mailbox - Invalid Parameter Number

Jul 25, 2014

After upgrading from 9.5 to 11.5.30 update #47 (CentOS 5.8 (Final) 32bit) i'm getting error when trying to add an email box:

Internal error: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound MessageSQLSTATE[HY093]: Invalid parameter number: no parameters were bound
File Pdo.php
Line234
TypeZend_Db_Statement_Exception

mysql request "select objectId from Configurations where status='error';" gives nothing.

View 1 Replies View Related

Plesk 11.x / Linux :: 4.4.2 Mailbox Full But Quota Is Not Exceeded

Sep 18, 2014

we have a Problem with one of our customers there hosted by Plesk 11.5.30 Update #47.

If a mail was sent to the mail address from our customer, postfix log the following entry:

Code:

/usr/lib/plesk-9.0/psa-pc-remote[28391]: handlers_stderr: DATA Mailbox full#015#012DEFER
/usr/lib/plesk-9.0/psa-pc-remote[28391]: DEFER during call 'check-quota' handler
/usr/lib/plesk-9.0/psa-pc-remote[28391]: Message aborted

The mail Sender will receive a Information with the error message 4.2.2 Mailbox full

But the quota is not exceeded. The quota is 3GB and the assignment is perhaps 20 percent.

We have configured, that we became a mail if the quota from our customer is oversized. But we also become no mail that the quota is oversized.

View 2 Replies View Related

Plesk 11.x / Linux :: Service Is Used For Changing Mailbox Passwords

Feb 20, 2015

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.

cat /usr/local/psa/version
11.0.9 CentOS 6 110120608.16

View 1 Replies View Related

Plesk 12.x / Linux :: Customer Email Hacked / Exceeded Limits Warning

Dec 13, 2014

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

View 2 Replies View Related

Plesk 11.x / Linux :: How To Auto-empty Specific Mailbox Daily

Dec 4, 2013

Is there any way to auto-delete all the messages in a specific mailbox on a specify domain on a daily basis? Using Postfix.

View 4 Replies View Related

Plesk 11.x / Linux :: Mailbox Disabled - Email Accepted And Not Bouncing

Jul 4, 2014

I have Plesk 11.5.30 Update #47, Centos OS 6.5 x64, MTA Qmail 1.03

Today I encountered a estrange thing, a disabled mailbox was accepting mail but not bouncing it.

In the panel the "user@tld.com" mailbox is disabled, if a email is sent to that address Qmail accepts it:

Jul 4 17:51:35 mx3 qmail-queue-handlers[27432]: Handlers Filter before-queue for qmail started ...
Jul 4 17:51:36 mx3 qmail-queue-handlers[27432]: from=root@mx3
Jul 4 17:51:36 mx3 qmail-queue-handlers[27432]: to=user@tld.com
Jul 4 17:51:36 mx3 qmail-queue-handlers[27432]: handlers_stderr: SKIP

[Code] ....

No mail is bounced, nothing, the message is not in the mailbox.

Tested in several accounts the result is the same, even in a new created account.

View 2 Replies View Related

Plesk 11.x / Linux :: Convert Mailbox To Lowercase - Failed Error

Oct 29, 2014

When running the repair function to convert mailboxes to lowercase, I immediately receive the following error:

/usr/local/psa/bin/repair --convert-mailboxes-to-lowercase
2014-10-30T00:11:09+01:00 ERR (3) [util_exec]: proc_close() failed

What does this "[util_exec]: proc_close() failed" means and how can I fix this error?

View 2 Replies View Related

Plesk 11.x / Linux :: Cannot Authenticate Via SMTP For Mail-users With Mailbox Off And Forwarding On

Apr 9, 2013

I have mail-addresses with mailbox turned OFF and Forwarding switched ON.

The user can receive emails but can't use SMTP to send email. I expect that users without mailboxes can send messages, like in Plesk 9.5.

Error: No such user 'info@example.com' in mail authorization database

CentOS 6.4 + Plesk 11.0.9 Update #45

View 9 Replies View Related

Plesk 11.x / Linux :: New Mailbox Variable From (Mail Account Updated) Event

Jan 15, 2015

PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
Parallels Plesk, 11.5, .30_build115130819.13, Debian 7.0, Intel 64bit

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

View 2 Replies View Related

Plesk 11.x / Linux :: Shutdown Completely Spamassassin Service And Mailbox Statistic?

Sep 30, 2014

I'm suffer 2 major problem as below :

1.
how to turn off spamassassin completely ?

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

View 14 Replies View Related

Plesk 12.x / Linux :: Loose Mailbox Size Policy Doesn't Work After Upgrading?

Jul 24, 2014

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

View 1 Replies View Related

Plesk 12.x / Linux :: SpamAssassin Setup Default Value From Server Level To Specific Mailbox

Jun 17, 2014

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"

How i can do it ?

View 6 Replies View Related

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?

View 4 Replies View Related

Plesk 12.x / Linux :: Unknown Database Atmail When Selecting Database

Nov 20, 2014

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.

View 5 Replies View Related

Plesk 12.x / Linux :: Outgoing Mail Limits Not Limiting Mail

Mar 3, 2015

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.

View 8 Replies View Related

Plesk 11.x / Linux :: Anti-virus And Anti-spam Enabled By Default On Mailbox Creation?

May 27, 2013

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.

View 13 Replies View Related

VPS HARD Limits? (hardware Limits, Such As CPU/memory)

Apr 11, 2009

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?

View 2 Replies View Related

Plesk 12.x / Linux :: Possible To Reconstruct Psa Database

Aug 9, 2014

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?

View 2 Replies View Related

Plesk 12.x / Linux :: Copy Database To Other Domain

Jul 7, 2015

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

View 5 Replies View Related

Plesk 11.x / Linux :: Assign Database To Domain

Jul 20, 2014

I've created a database through SSH and give it a user so no problem.

But when i came back in Plesk Panel i don't see this database connected to the domain i want.

So how can i do to "indicate" my server this database must be going with this domain ?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved