Hi there,
Today I stepped through the Mailstats contrib on a fully-up-to-date 7.3 server.
I am aware of this thread
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
http://mirror.pacific.net.au/linux/smeserver/contribs//bread/mailstats/sql%20create/create-mysql.sh
and saw this:
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:
...
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,
2 Replies
2860 Views