mysql logging issues]

[Chris Trudeau]

Take a look here:

http://sourceforge.net/projects/mailwatch/

Mailwatch uses a different SQL loging function that is called from a
seperate module.  It works well from everything I have seen.  Steve has also
built a decent PHP front end that produces some JPGraph plotted graphs and
such.

instead of three seperate tables message related detail is all in a single
table, with other relvant information in the other adjoining tables.

Maybe this project will hepl you?...just a thought.

CT


----- Original Message -----
From: "Brent Addis" <brent.addis at ROAMAD.COM>
To: <MAILSCANNER at JISCMAIL.AC.UK>
Sent: Wednesday, September 10, 2003 11:27 PM
Subject: [Fwd: mysql logging issues]


> Hey there.
>
> Im new to the list, and had a quick look through the archives and couldnt
> find much on it.
> Im having a few problems getting mailscanner logging to an sql database.
>
> for some reason mailscanner inists on putting NULL into mysql rather than
> what the results should have been.
> IE:
>
>                     155 Query       INSERT INTO maillog_mail (time,
>                     msg_id, size, from_user, from_domain, subject,
>                     clientip, archives, isspam, ishighspam, sascore,
>                     spamreport) VALUES
>
('NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL
','NULL')                    156 Query       INSERT INTO maillog_mail (time,
>                     msg_id, size, from_user, from_domain, subject,
>                     clientip, archives, isspam, ishighspam, sascore,
>                     spamreport) VALUES
>
('NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL
','NULL')                    155 Quit
>                     156 Quit
>                     157 Query       INSERT INTO maillog_mail (time,
>                     msg_id, size, from_user, from_domain, subject,
>                     clientip, archives, isspam, ishighspam, sascore,
>                     spamreport) VALUES
>
('NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL
','NULL')                    157 Quit
>
>
>
>
> mysql> SELECT time, msg_id, size, from_user, from_domain FROM
> maillog_mail;
> +----------------+--------+------+-----------+-------------+
> | time           | msg_id | size | from_user | from_domain |
> +----------------+--------+------+-----------+-------------+
> | 00000000000000 | NULL   |    0 | NULL      | NULL        |
> +----------------+--------+------+-----------+-------------+
> 1 row in set (0.00 sec)
>
> I am using version 4.23-11.
>
> To create the tables I used a slightly modified version of what comes
> with mailscanner in the readme-sql. I had to remove the binary part from
> the msg_id lines as it would not work. I dont see that causing the
> current problems I am seeing however. Everything else was followed as
> per.
>
> I also had to alter the CustomConfig.pm, as it had the wrong ip address
> entered, and also needed a password:
> <snip>
> use DBI;
> <snip>
> # Create database connection
>   my($dbh);
>   $dbh = DBI->connect("DBI:mysql:mailscanner:localhost",
>                       "mailscanner", "password",
>                       {'PrintError' => 0})
>
> <snip>
>
> Is there somewhere I have to actually speicify what to log? I have unyet
> been able to find out exactly what it requires.
> Any help would be appeciated.
>
> Thanks.
>
>
>
>
>
>
> --
> Brent Addis
> Systems Administrator
> RoamAD