Plesk 11.x / Linux :: Clear SpamAssassin Database?
Sep 19, 2014The SpamAssassin bayes database has become ineffective on one of our servers and we want to wipe it and start fresh - how to do this on Plesk 11.5.30?
View 1 RepliesThe SpamAssassin bayes database has become ineffective on one of our servers and we want to wipe it and start fresh - how to do this on Plesk 11.5.30?
View 1 Repliesi'm using plesk 11.5..i've deleted a huge file of 15Go and i've still a message about free space on ther server...MySQL query failed: Got error 28 from storage engineClick to expand...
View 2 Replies View RelatedWebmail using, in the "Inbox" I chose all the mail and accidentally pressed the "clear folder" letters deleted or i am can be restored? I need to return the letter....
View 3 Replies View RelatedVersion 12.0.18. Using QMail.
If I attempt to remove even a small message from the mail queue, using the panel interface, the screen grays slightly but nothing happens. If I refresh the screen after several minutes, I'll sometimes get the following message:
"This operation is taking too long. Check the results in a few minutes."
Switching to Postfix eliminated the problem. But with Postfix, all of my Mailman lists (scores of them) broke, so I had to switch back -- and the problem reappeared.
I'm just moved from VPS OVH to KIMSUFI DEDI and got question about DNS records because isn't clear at all for me...
Domain: xxx
New DNS should be:
ns.kimsufi.com
ns3006711.ip-151-80-42.eu
My DNS records looks like that: E-mail didn't work properly as well...
I have a problem with Parallels Plesk 12 Web Host Edition. In the dashboard, Plesk tells me that Spamassassin service is not running and not installed.
How to setting up it ? Is there a component, a service to buy, or do i have to configure it through SSH ?
We are using Plesk 11.5 with postfix MTA. Spamassassin is working fine for incoming mails and leaves outbound mails unchecked - as it should.
Now there is one of my domains whose mails are relayed to another server (using postfix transport tab; mail support for this domain is disabled in plesk). For the moment, these mails arrive without beeing checked and marked by spamassassin. How could I change this? I have tried to register an additional mail-handler like
Code:
/usr/local/psa/admin/sbin/mail_handlers_control --add --priority=10 --executable=/usr/local/psa/handlers/hooks/spam --name=spam --enabled --queue=before-remote --mailname=relaydomain.de --type=recipient-domain --dont-preserve-on-restore --context=text
but this didn't have any effect so far.
If there is a direct way to enable spam-control for relay domains, Otherwise I could still access spamassassin via postfix' config-files, but how to use two different implementation of spamassassin at the same time.
What steps can we take to improve SpamAssassin performance? I know this was talked about in older Plesk versions, but we may be able to do more now. What configurations can I do to stop more spam?
View 1 Replies View RelatedIt seems that SA is not using bayes on the incoming messages. How to get bayes to work?
I have trained with plenty of ham and spam. Where are the db files for global bayes located?
I am running Plesk 11.5.30 Update #44, Postfix 2.8.14 and Spamassassin 3.3.1 on a Red Hat Enterprise Linux Server 6.5 server. I am looking to update the rules within Spamassassin. I have had a bit of a look and see that a crontab has been created but its a bash script with a comment saying it has been disabled by psa-spamassassin package (/etc/cron.d/sa-update).
Code:
#!/bin/sh
# This task was disabled by psa-spamassassin package
exit 0
Is there a reason why it has been disabled by Plesk? If I update the rules, will it break something?
I have recently added into Postfix RBLs to reduce the amount of SPAM my customers is getting and this is my next step in a list of things that I would like to change.
I noticed that my spamassassin wasn't running on my server. so I restarted the service from the plesk panel but got the following message:
Error: Unable to make action: Unable to manage service by spammng: spamassassin: unrecognized service
ERROR:spammng:Unable to start SpamAssassin service
('--start', 'spamassassin')
So I SSH'ed into my machine and saw that spamassassin wasn't running.
The I reinstalled spamassassin from the "add and remove product components", but that didn't change anything. Still the same error.
Installing Plesk Panel with Spamassassin on Ubuntu 14.04 LTS gives a significant error:
Restarting SpamAssassin Mail Filter Daemon: No /usr/bin/perl found running; none killed.
server socket setup failed, retry 1: spamd: could not create IO::Socket::INET6 socket on [::1]:783: Cannot assign requested address
server socket setup failed, retry 2: spamd: could not create IO::Socket::INET6 socket on [127.0.0.1]:783: Address already in use
server socket setup failed, retry 9: spamd: could not create IO::Socket::INET6 socket on [127.0.0.1]:783: Address already in use
spamd: could not create IO::Socket::INET6 socket on [127.0.0.1]:783: Address already in use
invoke-rc.d: initscript spamassassin, action "restart" failed.
dpkg: error processing package sa-compile (--configure):
even though spamassassin (i.e. spamd) is not running. The usual suspects for the before mentioned error, being
a) differences in the name of the PIDFILE variable in /etc/default/spamassassin and /etc/init.d/spamassassin
b) directory and/or file location are not readable/writable
are not causing this specific installation bug. The work-arounds:
1 - not installing spamassassin (not an option)
2 - installing spamassassin and (afterwards)
change /etc/default/spamassassin, add the option "-4" to the line OPTIONS, resulting in the line: OPTIONS="--nouser-config -4 --username=popuser --daemonize --helper-home-dir=/var/qmail --virtual-config-dir=/var/qmail/mailnames/%d/%l/.spamassassin --create-prefs --max-children=5"
run plesk-installer or autoinstaller again ..Work-around 2 works fine, after reinstallation the /etc/default/spamassassin is as it should be (note that the added "-4" is not present anymore).
The before mentioned work-around suggests some error in the installation process, very likely to be an issue with the chronological order of installation of the various components. In theory, it can be excluded that this bug/issue is caused by psa-spamassassin and/or spamassassin (version 3.3.x) packages, even though some current spamassassin bugs are known: URL....I sincerely hope that Parallels Team can investigate and patch both of the bugs/issues.
I just migrated a bunch of domains from plesk 11.5. Everything appears to be working well however when examining the maillog, I am seeing some strange errors... In this example, the message was delivered and had the spamassassin stuff in the header.
spamd: handle_user unable to find user: 'jason@xxxxxxp.com'
I have one specific domain being to another SMTP server via Postfix transport_maps.
This works great, apart from Spam check not working anymore, Spamassassin is not being called for the domain.
Is there any configuration to have Spamassassin check email before it is routed via transport_maps?
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.
When I set up spamassassin to store spam in the spam folder of my mailbox, it doesn't add any X-Sapm headers nor tags the subject. All I found so far was an old thread where a plesk employee stated that it will be fixed in 'a' future version.
I am on 11.5.30 Update #47.
The Plesk panel indicates that the Spam folder can be retrieved using an email client. We are using Outlook 2013 and can not figure out a way to make this happen. We can see the Spam folder using Webmail, but the contents never shows up in Outlook...
View 1 Replies View RelatedI'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
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 ?
Hi,
can you please tell me how i can clear the firewall in my linux box?
It's CentOS but i'm not sure what type of firewall is installed on my box.
Hpe to get response soon,
toby
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 RelatedJust 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 RelatedI'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 ?
We are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.
View 4 Replies View RelatedERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1049] Unknown database 'psa' (Abstract.php:144)
View 3 Replies View RelatedI 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?
Any way to backup every SQL Databases at once ?
At the moment i need to configure each subscription on my backup program to backup each sql database.
there is any way to set a login that back's up all the databases?
And for the ftp files?
When copy a database, plesk would copy it but hung at creating the db user, therefore, the database cloning message keeps on showing
Cloning the database xxxxxx to the database xxxxx. You will be notified of the progress by email (xxxxxxx).
*I checked if the database was copied, it showed it did but the user was not created for that newly copied one.
I have a virtual server with CentOS 6.4 (Final) and Plesk 11.5.30 and I would like to increase the database size to import because right now it's only 2MB and I have to put online a website with 10MB.
View 5 Replies View Relatedif I can install plesk panel with a dedicated database server... and how.
View 3 Replies View Related