Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 12-15-2016, 07:58 AM   #1
LQ Newbie
Registered: Dec 2016
Posts: 1

Rep: Reputation: Disabled
MailWatch and Mailscanner not logging in MySQL

Hi all, I am new to LinuxQuestions so I am posting my first question...

I am having this issue for quite some time and it seems that I can't find
solution... and I think that I read the "whole internet". It's really
driving me mad.

Anyway, my Linux distro is Centos 7. I set up email postfix server with
MailScanner and spamassasin and everything is working as it should.

I wanted to deploy Mailwatch in order to be able to monitor spam messages
and to release quarantined messages from quarantine. I followed
instructions on Mailwatch site, installed MySQL version 5.6.35, MailWatch
1.2.0 RC3, followed all instructions about setting up MailScanner.conf,
installed all Perl modules (DBI, DBD-MySQL, Perl Encoding::FixLatin...). Of
course double checked db name, db user, db passwd in in
/usr/share/MailScanner/MailScanner/CustomFunctions but my DB not logging
any message...

From MailWatch web interface I can "see" my qurantine folders (named by
date) but when I click on any of those links it just show "Displaying page
0 of 0 - Records 1 to 0 of 0".

I double checked permissions in /var/spool/MailScanner/quarantine and they
are owned by user postfix and group is apache with permissions 770.

In /var/log/maillog I can see "Config: calling custom end function
MailWatchLogging", "Started SQL Logging child", "Config: calling custom end
function SQLWhitelist", "Starting up SQL Whitelist" and "Logging message
BB09129AA2.A4AEB to SQL" but no "BB09129AA2.A4AEB: Logged to MailWatch SQL"

In addition I can insert white and black list entries to mailscanner db
from MailWatch web interface...

Any help would be appreciated, I am really stacked here...


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailwatch Setting alphatest Linux - Software 0 08-31-2010 11:53 PM
MailWatch subject problen wines Linux - Server 0 08-20-2010 06:06 AM
LXer: Virtual Users And Domains With Postfix, MailScanner, Mailwatch & MySQL On CentO LXer Syndicated Linux News 0 03-09-2008 09:20 AM
Mailwatch Quarantine Report. waelaltaqi Linux - Server 0 02-05-2008 09:50 AM
mailscanner & mysql jrafalek Linux - Security 1 02-08-2005 10:47 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:43 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration