Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: bloodshoteye on April 26, 2008, 12:13:37 PM

Title: Mailstats - hiccup
Post by: bloodshoteye on April 26, 2008, 12:13:37 PM

Hi there,
Today I stepped through the Mailstats contrib on a fully-up-to-date 7.3 server.
I am aware of this thread

Quote

http://forums.contribs.org/index.php?topic=40709.0

but decided to start a new one here in the Contribs forum - hope I did the right thing...

At the correct point in the howto I ran the create MySQL script obtained here

Quote

http://mirror.pacific.net.au/linux/smeserver/contribs//bread/mailstats/sql%20create/create-mysql.sh

and saw this:

Quote

Database "mailstats" dropped
Database creation :                     [OK]
Creation of mysql user :                [OK]
/root/scripts/./mailStats_createMysql.sh: line 38: tables.sql: No such file or d                                                                                                               irectory
Error in the creation of the tables : Mailstats data save enabled
mailstats=report
    Email=admin
    SARulePercentThreshold=0.5
    SaveDataToMySQL=yes
    Status=enabled
/n

Then I ran the manual command as per the wiki contrib:
perl /usr/bin/spamfilter-stats-7.pl /var/log/qpsmtpd/@* /var/log/qpsmtpd/current
Following is a portion of the output:

Quote

...
g/qpsmtpd/current

DBD::mysql::st execute failed: Table 'mailstats.date' doesn't exist at /usr/bin/spamfilter-stats-7.pl line 1531.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/bin/spamfilter-stats-7.pl line 1539.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1485.
DBD::mysql::st execute failed: Table 'mailstats.SAscores' doesn't exist at /usr/bin/spamfilter-stats-7.pl line 1488.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/bin/spamfilter-stats-7.pl line 1496.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1363.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/bin/spamfilter-stats-7.pl line 1363.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1376.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND servername='tincan.ehs.wcape.school.za'' at line 1 at /usr/bin/spamfilter-stats-7.pl line 1376.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1379.
DBD::mysql::db do failed: Table 'mailstats.JunkMailStats' doesn't exist at /usr/bin/spamfilter-stats-7.pl line 1379.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1379.
DBD::mysql::db do failed: Table 'mailstats.JunkMailStats' doesn't exist at /usr/bin/spamfilter-stats-7.pl line 1379.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1379.
DBD::mysql::db do failed: Table 'mailstats.JunkMailStats' doesn't exist at /usr/bin/spamfilter-stats-7.pl line 1379
...
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1459.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1459.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ','Non.Conf.',1,'tincan.ehs.wcape.school.za')' at line 1 at /usr/bin/spamfilter-stats-7.pl line 1459.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1459.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1459.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ','Qued.Spam?',1,'tincan.ehs.wcape.school.za')' at line 1 at /usr/bin/spamfilter-stats-7.pl line 1459.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1459.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1459.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ','Ham',3,'tincan.ehs.wcape.school.za')' at line 1 at /usr/bin/spamfilter-stats-7.pl line 1459.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1459.
Use of uninitialized value in concatenation (.) or string at /usr/bin/spamfilter-stats-7.pl line 1459.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ','TOTALS',5,'tincan.ehs.wcape.school.za')' at line 1 at /usr/bin/spamfilter-stats-7.pl line 1459
...

Can someone shed any light, please, or must I take this to the bug tracker?
I was wondering if the above indicates I have something else skewed in the mail sub-system?

Thanks,

Title: Re: Mailstats - hiccup
Post by: brianr on April 26, 2008, 03:55:30 PM

bug tracker please and I'll look at it...

(post link here..)

Title: Re: Mailstats - hiccup
Post by: bloodshoteye on April 26, 2008, 05:51:31 PM

brianr

Created bug http://bugs.contribs.org/show_bug.cgi?id=4275

Thanks,