Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 19th February 2007, 19:05
bluethunder82 bluethunder82 is offline
Member
 
Join Date: Sep 2006
Posts: 92
Thanks: 0
Thanked 9 Times in 5 Posts
Cool Getting sa-update running automatically

In order to get your spam under control (well in the right direction) you can run the sa-update command and keep your 'rules' up-to-date. I'll outline what I have been using and am happy with. This may be obvious for some but hopefully helpful for others.

First, sa-update needs to have two additional perl modules installed that are not needed required for spamassassin to function. These are LWP, Archive::Tar (Nov 2006 bug report). It was also mentioned that UserAgent.pm was not installed by default elsewhere in this forum. In order get all the required perl modules installed use the following command:

Code:
apt-get install libwww-perl libarchive-tar-perl
This will allow the script sa-update to run and update your rules. However who wants to do this manually? I have created by own script that emails me the results of the updates each morning. For me this is preferred as I get many other daily emails from the servers so I can keep an eye on my background tasks.

(I'll assume you know how to create and make executable the sh script)

Code:
#!/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/home/admispconfig/ispconfig/tools/spamassassin/usr/bin

#########################################################################################################################
#Written by Jason Shewchuk                                                                                              #
#E-Mail: jason <> shewchuk.ca                                                                                           #
#Version: 0                                                                                                             #
#Date Created: Sept. 20, 2006                                                                                           #
#Date Modified: Sept. 20, 2006                                                                                          #
#Feel free to use and modify this script.  Let me know of changes you have made so I can learn and improve this script  #
#########################################################################################################################

#Today's date
today=$(date +%Y_%m_%d)

#Run sa-update
/home/admispconfig/ispconfig/tools/spamassassin/usr/bin/sa-update

exitcode=$?     #Exit code from sa-update

#Find version of sa-update
version=$(/home/admispconfig/ispconfig/tools/spamassassin/usr/bin/sa-update -V | grep "sa-update")

if [ $exitcode = 0 ]; then
        echo "An update was available, and was downloaded and installed successfully.  You are now running $version."  | formail -c -I"Subject: sa-update Updated for $today - Updated" -I"From: sa-update@localhost" -I"To: postmaster@{YOURDOMAIN.TLD}" -I"Received: from {YOURDOMAIN.TLD} ([{IP Address If You Wish}])" | sendmail postmaster@{YOURDOMAIN.TLD}

elif [ $exitcode = 1 ]; then
        echo "No update was available.  You are still running $version." | formail -c -I"Subject: sa-update Update Status for $today - No Update" -I"From: sa-update@localhost" -I"To: postmaster@{YOURDOMAIN.TLD}" -I"Received: from {YOURDOMAIN.TLD} ([{IP Address If You Wish}])" | sendmail postmaster@{YOURDOMAIN.TLD}

else
        echo "An error occured while attempting to download and extract updates.  You are still running $version." | formail -c -I"Subject: sa-update Update Status for $today - Error" -I"From: sa-update@localhost" -I"To: postmaster@{YOURDOMAIN.TLD}" -I"Received: from {YOURDOMAIN.TLD} ([{IP Address If You Wish}])" | sendmail postmaster@{YOURDOMAIN.TLD}
fi

exit 0
You will need to update anything located in the {} brackets.

Once this is done jump into your crontab.
Code:
crontab -e
Then make your entry. My script in this example is located in the root of 'root's' directory. I've also got the script running at 03:00.

Code:
0 3 * * * /root/sa-updater &> /dev/null
If you don't want the emails sent to you daily then just use the following crontab statement.

Code:
0 3 * * * /home/admispconfig/ispconfig/tools/spamassassin/usr/bin/sa-update &> /dev/null
That should be about it.

Hope this is helpful. I'm running this with Ubuntu 6.06 (PPC and x86) I'd like feedback on how this performs in other environments.
Reply With Quote
The Following 5 Users Say Thank You to bluethunder82 For This Useful Post:
commentator (26th May 2009), madmucho (16th April 2009), nfomaniak (13th March 2011), sm0rgm (4th January 2010), zetnsh (26th May 2009)
Sponsored Links
  #2  
Old 19th February 2007, 20:20
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,033
Thanks: 261
Thanked 150 Times in 130 Posts
Default

Nice one!

I'll give it a go on one of my servers that does still get a lot of spam
__________________
Never execute code written on a Friday or a Monday.
Reply With Quote
  #3  
Old 19th February 2007, 20:37
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Seems to run nicely. You have to change the permission though to make it executable:
Code:
chmod 750 /root/sa-updater
. I'll see if it catches more spam now.

Edit: I'm running Ubuntu Edge Eft 6.10

Last edited by martinfst; 19th February 2007 at 20:40.
Reply With Quote
  #4  
Old 19th February 2007, 20:49
bluethunder82 bluethunder82 is offline
Member
 
Join Date: Sep 2006
Posts: 92
Thanks: 0
Thanked 9 Times in 5 Posts
Default

I have found that running the update rules helps clean up the last bit of spam I get. The other prevention I use is zen.spamhaus.org. SPAM still gets through but nothing that has anyone commenting.

Hope you get good results as well.
Reply With Quote
  #5  
Old 19th February 2007, 22:34
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,033
Thanks: 261
Thanked 150 Times in 130 Posts
Default

The script is working nice on my Debian Sarge server.
I'll add it tomorrow to my other two server.
__________________
Never execute code written on a Friday or a Monday.

Last edited by edge; 19th February 2007 at 23:26.
Reply With Quote
  #6  
Old 25th February 2007, 07:47
djtremors djtremors is offline
Senior Member
 
Join Date: Apr 2006
Location: Sydney
Posts: 278
Thanks: 0
Thanked 12 Times in 10 Posts
Default

I just use the rules_du_jour script

http://sandgnat.com/rdj/rules_du_jour

you have to tell it where your spamassassin rules folder is which I just do a simple

PHP Code:
ln -/home/admispconfig/ispconfig/tools/spamassassin/etc/mail/spamassassin /etc/spamassassin 
and then crontab run

PHP Code:
 sh /home/admispconfig/ispconfig/tools/spamassassin/etc/mail/spamassassin/RulesDuJour/rules_du_jour 
Reply With Quote
  #7  
Old 19th February 2009, 06:51
collimic collimic is offline
Member
 
Join Date: Dec 2008
Posts: 43
Thanks: 7
Thanked 0 Times in 0 Posts
Default update errors.

Hello, I followed the instructions and yet I am getting errors when I try and update.

error: no mirror data available for channel updates.spamassassin.org
channel: MIRRORED.BY file location was not in DNS, channel failed

Any help would be great.
Reply With Quote
  #8  
Old 20th February 2009, 17:54
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

What happens when you run
Code:
/home/admispconfig/ispconfig/tools/spamassassin/usr/bin/sa-update
manually?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 16th April 2009, 21:24
madmucho madmucho is offline
Senior Member
 
Join Date: Oct 2006
Location: Czech republic, Karlovy Vary
Posts: 158
Thanks: 78
Thanked 11 Times in 11 Posts
Send a message via ICQ to madmucho
Thumbs up Nice script

Thank you for that script i use it on testing server now with some specific changes and works ok :-) nice help against spam.

PS: Mandriva, i know mandriva again, there is stupid change in path ../usr/local/bin/....
Reply With Quote
  #10  
Old 17th April 2009, 09:21
Hagforce Hagforce is offline
Senior Member
 
Join Date: Feb 2006
Posts: 210
Thanks: 37
Thanked 1 Time in 1 Post
 
Default

When i run "/home/admispconfig/ispconfig/tools/spamassassin/usr/bin/sa-update" nothing happends.
Is there supposed to be some sort of confirmation?
How can I check if the update was made?

I added "23 4 */2 * * /home/admispconfig/ispconfig/tools/spamassassin/usr/bin/sa-update &> /dev/null" to a file and placed it in /etc/cron.daily would this work for updating?
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fedora 4 TPS mail problem Hagforce HOWTO-Related Questions 13 10th February 2010 18:23
php 5.2.0 update! cybereatl Installation/Configuration 1 15th November 2006 09:22
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19
install Net::DNS chrno Installation/Configuration 4 5th September 2006 17:01
WARNING: services not running MicCo Installation/Configuration 31 4th September 2006 12:16


All times are GMT +2. The time now is 13:59.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.