Res: Problems in write maillog to SQL

[Bernardo Goulart de Faria]

Hi,

        I have these three messages on my maillog: 

Mar 12 13:08:23 angra-ms MailScanner[7185]: Config: calling custom init function MailWatchLogging
Mar 12 13:08:23 angra-ms MailScanner[7185]: Started SQL Logging child
Mar 12 13:17:56 angra-ms MailScanner[7147]: Logging message 562BB168F42.D55BE to SQL

What perl module might be missing?

Tanks
Faria, Bernardo

----- Mensagem original ----
De: tlum <mailscanner.info at tedworld.com>
Para: MailScanner discussion <mailscanner at lists.mailscanner.info>
Enviadas: Quinta-feira, 13 de Março de 2008 12:59:07
Assunto: Re: Problems in write maillog to SQL

When MailScanner starts up you should see message similar to following 
in maillog:

Mar 13 11:22:25 ms1srvp01 MailScanner[23349]: Started SQL Logging child

When mail is received you should see message similar to following in 
maillog:

Mar 13 11:22:47 ms1srvp01 MailScanner[23336]: Logging message 
4A8CC900F9.7D18D to SQL
Mar 13 11:22:47 ms1srvp01 MailScanner[23338]: 4A8CC900F9.7D18D: Logged 
to MailWatch SQL

If you don't see the first one then custom logging is not being 
registered. If you don't see the second then there is a problem with 
"Always Looked Up Last = &MailWatchLogging" in MailScanner.conf.

Probably the most common reason is not connecting to the database for 
some reason... missing perl module, wrong credentials (bad connect 
strings), wrong permissions, etc.

Bernardo Goulart de Faria wrote:
> Hello,
>
>   I have one MailServer using Fedora 7 (2.6.21-1.3194.fc7) i686 i386 
> GNU/Linux + Postfix 2.5.1 + MailScanner 4.66.5-3 + MYSQL Ver 14.12 
> Distrib 5.0.45 + mailwatch-1.0.4 + PHP 5.2.4.
>  
> I followed the guide instructions for the site. On file header_check 
> of postfix, I put / ^ Received: / HOLD, set all permissions in 
> /var/postfix and /var/MailScanner. I installed the MailWatch and 
> changed information, User and Password in MailWatch.pm and 
> SQLBlacklist.pm, moved to 
> /usr/lib/MailScanner/MailScanner/CustomFunctions/.
> Start the MailScanner and everything works normally, but the messages 
> are not recorded in the table in MySQL maillog. The permissions of 
> GRANT in the bank also has been set.
>
> Tanks!
> Faria, Bernardo
>
> ------------------------------------------------------------------------
> Abra sua conta no Yahoo! Mail 
> <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.mail.yahoo.com/>, 
> o único sem limite de espaço para armazenamento!
> -- 
> This message has been scanned for viruses and
> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is
> believed to be clean. 


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-- 
MailScanner mailing list
mailscanner at lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner

Before posting, read http://wiki.mailscanner.info/posting

Support MailScanner development - buy the book off the website! 






      Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento!
http://br.mail.yahoo.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20080313/411d730e/attachment-0001.html