How to install MailWatch for MailScanner?

[shaky]

I installed MailScanner from Layer1, and have stumbled upon MailWatch http://mailwatch.sourceforge.net/

This script looks great anyone have a "cpanel how to" install MailWatch after installing MailScanner fromLayer1?

Many Thanks.

[shaky]

Anyone using MailWatch?

[fizz]

looks nice, wouldnt mind seeing a howto

[shaky]

Yeah, I'm sure it's fairly easy to install probably a few lines of command in SSH but not really sure of the step-bystep process for cpanel config.

[fizz]

Ive got it installed, but have one problem..
# I keep getting the error 'MySQL server has gone away' in the mail logs since I installed MailWatch, how do I fix this?

According to thier FAQ: This is caused by using the latest version of Perl DBD-MySQL (2.9002 at the time of writing), downgrade to version 2.1028 which you can get from here and this will fix the problem.

However i downloaded this module, and installed, but still have the problem.

[fizz]

Well, got everything workin, but I dont see a huge reason to use this as most of the functionality of this problem is built into WHM. It does have a few nice features such as virus trending and more detailed reports, but sending by volumn, and amount and received and what not is alrready part of WHM. Just my .02

[shaky]

Originally posted by fizz
Well, got everything workin, but I dont see a huge reason to use this as most of the functionality of this problem is built into WHM. It does have a few nice features such as virus trending and more detailed reports, but sending by volumn, and amount and received and what not is alrready part of WHM. Just my .02

Shame I was hoping it would be a strong GUI report and analysis program for MailScanner.

Would you be kind enough to post a step-by-step SSH instructions on how to install this on cpanel, so I can check it out on my own server?

Thanks for your help fizz.

[fizz]

Wont be huge in detail, but here goes,,
ssh to your box
wget the file from the site and untar

mysql -uroot -p'yourpass' < create.sql
mysql -uroot -p'yourpass' mailscanner
GRANT ALL ON mailscanner.* TO mailwatch@localhost IDENTIFIED BY 'yourpass'

Next, edit the MailWatch.pm and put in yout db details like this

# Modify this as necessary for your configuration
my($db_name) = "mailscanner";
my($db_host) = "localhost";
my($db_user) = "root";
my($db_pass) = "yourpass";

Save, and move to /usr/mailscanner/lib/MailScanner
Next, Edit CustomConfig.pm and add the following to the top of the file just beneath the line that starts '$VERSION = substr...':

require 'MailScanner/MailWatch.pm';

### The package version, both in 1.23 style *and* usable by MakeMaker:
$VERSION = substr q$Revision: 1.3.2.8 $, 10;
require 'MailScanner/MailWatch.pm';

Next, we need to insert a user for MailWatch
mysql -uroot -p'yourpass' mailscanner
INSERT INTO users VALUES ('mailwatch',md5('yourpass'),'MailWatch','A');
quit

Next, move the mailscanner dir (from the mailwatch tar file) to a public www.
- Check the permissions of /var/www/html/mailscanner/images and /var/www/html/images/cache - they should be ug+rwx and owned by root and in the same group as the web server user (apache on R$

# chown root:apache images
# chmod ug+rwx images
# chown root:apache images/cache
# chmod ug+rwx images/cache

- Create conf.php by copying conf.php.example and edit the values to suit, you will need to set DB_USER and DB_PASS to the MySQL user and password that you created earlier.

# cp conf.php.example conf.php
pico conf.php and insert the SQL details (user=root, pass=yourpass, db=mailscanner(

Edit your MailScanner.conf (pico /usr/mailscanner/etc/MailScanner.conf)

Search with (ctrl+w)
Always Looked Up Last = &MailWatchLogging
Detailed Spam Report = yes
Quarantine Whole Message = yes
Quarantine Whole Message As Queue Files = no
Include Scores In SpamAssassin Report = yes
Quarantine User = root
Quarantine Group = apache (this should be the same group as your web server)
Quarantine Permissions = 0660

Now, goto http://www.yoursite.com/mailscanner
it will prompt you for the user/pass
user=mailwatch
pass=yourpass


That should do it.

[fizz]

Only problem ive run into, is that cpanel auto updated dbd-mysql package thus breaking mailwatch. The author of this program really needs to fix the program to keep up with the new

[shaky]

Thanks for checking it out and letting the forum know

[fizz]

Im afraid i didnt encounter that.. Where abouts are you getting the need for that and what error?

[shaky]

Thaphantom did you find a fix for the:

fizz: Only problem ive run into, is that cpanel auto updated dbd-mysql package thus breaking mailwatch.

Thx.

[VultureCP]

I was able to get everything installed after upgrading perl, and downgrading DBD. However I have one last problem.

When I click quarantine I get "Cannot open directory: /var/spool/MailScanner/quarantine." My apache runs from user/group nobody. MailScanner runs from user: mailnull group: nobody. In fix_qauarantine_permissions I have GROUP=nobody, DIRMODE=0770, FILEMODE=0660. The quarantine dir and files inside are all set according to the fix script. Any help would be appreciated.

[cwihost]

I am having a problem with releasing the messages from the quarantine. In MailWatch it says

Release: error

I can delete messages from Quarantine OK. Any Ideas?

[perlchild]

Originally posted by VultureCP
I was able to get everything installed after upgrading perl, and downgrading DBD. However I have one last problem.

When I click quarantine I get "Cannot open directory: /var/spool/MailScanner/quarantine." My apache runs from user/group nobody. MailScanner runs from user: mailnull group: nobody. In fix_qauarantine_permissions I have GROUP=nobody, DIRMODE=0770, FILEMODE=0660. The quarantine dir and files inside are all set according to the fix script. Any help would be appreciated.

I had something similar, until I ran the fix_quiarantine_permissions script that comes with mailwatch.
I didn't follow the howto(just saw it AFTER I installed) but the installation was relatively painless even without it.