<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:verdana,helvetica,sans-serif;font-size:10pt"><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt;">The MailScanner not write in MySQL...<br><br>Is empity:<br><br>mysql> select count(*) from mailscanner.maillog;<br>+----------+<br>| count(*) |<br>+----------+<br>| 0 |<br>+----------+<br>1 row in set (0.00 sec)<br><br><br>Tanks<br>Faria, Bernardo<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Mensagem original ----<br>De: tlum <mailscanner.info@tedworld.com><br>Para: MailScanner discussion <mailscanner@lists.mailscanner.info><br>Enviadas: Quinta-feira, 13 de Março de 2008 16:48:31<br>Assunto: Re: Res: Problems in write maillog to SQL<br><br>CORRECTION:
I
meant
to
say:<br><br>At
this
point
I
would
bet
you
have
a
problem
with
MailWatch
retrieving <br>the
data
from
the
database.<br><br>tlum
wrote:<br>>
Are
you
sure
the
record
is
not
in
the
database
and
its
not
a
MailWatch <br>>
issue?
If
you
got
that
far
so
silently
-
no
errors
-
then
it
almost <br>>
certainly
has
put
the
record
in
the
table.
I
would
check
the
database.<br>><br>>
#
mysql
-u
<username>
-p
(if
the
db
is
not
local
you
need
-h <br>>
<hostname>
also)<br>>
Enter
password:
<enter
the
password
you
created><br>>
Welcome
to
the
MySQL
monitor.
Commands
end
with
;
or
\g.<br>>
Your
MySQL
connection
id
is
19266
to
server
version:
5.0.22<br>><br>>
Type
'help;'
or
'\h'
for
help.
Type
'\c'
to
clear
the
buffer.<br>><br>>
mysql><br>><br>>
then
try
"select
count(*)
from
<database>.maillog;"<br>><br>>
and
you'll
get
something
like
this:<br>><br>>
mysql>
select
count(*)
from
mailscanner.maillog;<br>>
+----------+<br>>
|
count(*)
|<br>>
+----------+<br>>
|
1875
|<br>>
+----------+<br>>
1
row
in
set
(0.01
sec)<br>><br>>
mysql><br>><br>>
At
this
point
I
would
bet
you
have
a
problem
with
MailScanner <br>>
retrieving
the
data
from
the
database.<br>><br>>
Bernardo
Goulart
de
Faria
wrote:<br>>>
Hi,<br>>><br>>>
I
have
these
three
messages
on
my
maillog:<br>>><br>>>
Mar
12
13:08:23
angra-ms
MailScanner[7185]:
Config:
calling
custom <br>>>
init
function
MailWatchLogging<br>>>
Mar
12
13:08:23
angra-ms
MailScanner[7185]:
Started
SQL
Logging
child<br>>>
Mar
12
13:17:56
angra-ms
MailScanner[7147]:
Logging
message <br>>>
562BB168F42.D55BE
to
SQL<br>>><br>>>
What
perl
module
might
be
missing?<br>>><br>>>
Tanks<br>>>
Faria,
Bernardo<br>>><br>>>
-----
Mensagem
original
----<br>>>
De:
tlum
<<a ymailto="mailto:mailscanner.info@tedworld.com" href="mailto:mailscanner.info@tedworld.com">mailscanner.info@tedworld.com</a>><br>>>
Para:
MailScanner
discussion
<<a ymailto="mailto:mailscanner@lists.mailscanner.info" href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a>><br>>>
Enviadas:
Quinta-feira,
13
de
Março
de
2008
12:59:07<br>>>
Assunto:
Re:
Problems
in
write
maillog
to
SQL<br>>><br>>>
When
MailScanner
starts
up
you
should
see
message
similar
to
following<br>>>
in
maillog:<br>>><br>>>
Mar
13
11:22:25
ms1srvp01
MailScanner[23349]:
Started
SQL
Logging
child<br>>><br>>>
When
mail
is
received
you
should
see
message
similar
to
following
in<br>>>
maillog:<br>>><br>>>
Mar
13
11:22:47
ms1srvp01
MailScanner[23336]:
Logging
message<br>>>
4A8CC900F9.7D18D
to
SQL<br>>>
Mar
13
11:22:47
ms1srvp01
MailScanner[23338]:
4A8CC900F9.7D18D:
Logged<br>>>
to
MailWatch
SQL<br>>><br>>>
If
you
don't
see
the
first
one
then
custom
logging
is
not
being<br>>>
registered.
If
you
don't
see
the
second
then
there
is
a
problem
with<br>>>
"Always
Looked
Up
Last
=
&MailWatchLogging"
in
MailScanner.conf.<br>>><br>>>
Probably
the
most
common
reason
is
not
connecting
to
the
database
for<br>>>
some
reason...
missing
perl
module,
wrong
credentials
(bad
connect<br>>>
strings),
wrong
permissions,
etc.<br>>><br>>>
Bernardo
Goulart
de
Faria
wrote:<br>>>
>
Hello,<br>>>
><br>>>
>
I
have
one
MailServer
using
Fedora
7
(2.6.21-1.3194.fc7)
i686
i386<br>>>
>
GNU/Linux
+
Postfix
2.5.1
+
MailScanner
4.66.5-3
+
MYSQL
Ver
14.12<br>>>
>
Distrib
5.0.45
+
mailwatch-1.0.4
+
PHP
5.2.4.<br>>>
>
>
I
followed
the
guide
instructions
for
the
site.
On
file
header_check<br>>>
>
of
postfix,
I
put
/
^
Received:
/
HOLD,
set
all
permissions
in<br>>>
>
/var/postfix
and
/var/MailScanner.
I
installed
the
MailWatch
and<br>>>
>
changed
information,
User
and
Password
in
MailWatch.pm
and<br>>>
>
SQLBlacklist.pm,
moved
to<br>>>
>
/usr/lib/MailScanner/MailScanner/CustomFunctions/.<br>>>
>
Start
the
MailScanner
and
everything
works
normally,
but
the
messages<br>>>
>
are
not
recorded
in
the
table
in
MySQL
maillog.
The
permissions
of<br>>>
>
GRANT
in
the
bank
also
has
been
set.<br>>>
><br>>>
>
Tanks!<br>>>
>
Faria,
Bernardo<br>>>
><br>>>
> <br>>>
------------------------------------------------------------------------<br>>>
>
Abra
sua
conta
no
Yahoo!
Mail<br>>>
> <br>>>
<<a href="http://br.rd.yahoo.com/mail/taglines/mail/*http://br.mail.yahoo.com/" target="_blank">http://br.rd.yahoo.com/mail/taglines/mail/*http://br.mail.yahoo.com/</a>>,<br>>>
>
o
único
sem
limite
de
espaço
para
armazenamento!<br>>>
>
--<br>>>
>
This
message
has
been
scanned
for
viruses
and<br>>>
>
dangerous
content
by
*MailScanner*
<<a href="http://www.mailscanner.info/" target="_blank">http://www.mailscanner.info/</a>>, <br>>>
and
is<br>>>
>
believed
to
be
clean.<br>>><br>>><br>>>
-- <br>>>
This
message
has
been
scanned
for
viruses
and<br>>>
dangerous
content
by
MailScanner,
and
is<br>>>
believed
to
be
clean.<br>>><br>>>
-- <br>>>
MailScanner
mailing
list<br>>>
<a ymailto="mailto:mailscanner@lists.mailscanner.info" href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a> <br>>>
<mailto:<a ymailto="mailto:mailscanner@lists.mailscanner.info" href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a>><br>>>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>>><br>>>
Before
posting,
read
<a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>>><br>>>
Support
MailScanner
development
-
buy
the
book
off
the
website!<br>>><br>>><br>>>
------------------------------------------------------------------------<br>>>
Abra
sua
conta
no
Yahoo!
Mail <br>>>
<<a href="http://br.rd.yahoo.com/mail/taglines/mail/*http://br.mail.yahoo.com/" target="_blank">http://br.rd.yahoo.com/mail/taglines/mail/*http://br.mail.yahoo.com/</a>>, <br>>>
o
único
sem
limite
de
espaço
para
armazenamento!<br>>>
-- <br>>>
This
message
has
been
scanned
for
viruses
and<br>>>
dangerous
content
by
*MailScanner*
<<a href="http://www.mailscanner.info/" target="_blank">http://www.mailscanner.info/</a>>, <br>>>
and
is<br>>>
believed
to
be
clean. <br>><br>><br><br><br>-- <br>This
message
has
been
scanned
for
viruses
and<br>dangerous
content
by
MailScanner,
and
is<br>believed
to
be
clean.<br><br>-- <br>MailScanner
mailing
list<br><a ymailto="mailto:mailscanner@lists.mailscanner.info" href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br><a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br><br>Before
posting,
read
<a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br><br>Support
MailScanner
development
-
buy
the
book
off
the
website! <br></div><br></div></div><br>
<hr size=1>Abra sua conta no <a href="http://br.rd.yahoo.com/mail/taglines/mail/*http://br.mail.yahoo.com/">Yahoo! Mail</a>, o único sem limite de espaço para armazenamento!
</body></html>