Res: Problems in write maillog to SQL

[tlum]

CORRECTION: I meant to say:

At this point I would bet you have a problem with MailWatch retrieving 
the data from the database.

tlum wrote:
> Are you sure the record is not in the database and its not a MailWatch 
> issue? If you got that far so silently - no errors - then it almost 
> certainly has put the record in the table. I would check the database.
>
> # mysql -u <username> -p (if the db is not local you need -h 
> <hostname> also)
> Enter password: <enter the password you created>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 19266 to server version: 5.0.22
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>
>
> then try "select count(*) from <database>.maillog;"
>
> and you'll get something like this:
>
> mysql> select count(*) from mailscanner.maillog;
> +----------+
> | count(*) |
> +----------+
> |     1875 |
> +----------+
> 1 row in set (0.01 sec)
>
> mysql>
>
> At this point I would bet you have a problem with MailScanner 
> retrieving the data from the database.
>
> Bernardo Goulart de Faria wrote:
>> 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 
>> <mailto: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 
>> <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.