https://bugs.contribs.org/show_bug.cgi?id=10434

            Bug ID: 10434
           Summary: smeserver-mailstats does not create mailstats user
                    when creating mailstats database
    Classification: Contribs
           Product: SME Contribs
           Version: 9.2
          Hardware: ---
                OS: ---
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: smeserver-mailstats
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
  Target Milestone: ---

I notice that #8957 is "CLOSED FIXED" however for sme8 upgraded in-place to 9.2
the user is still not created.
After issuing this in mysql it works;

[root@sme]$ mysql
mysql>grant all privileges on mailstats.* to 'mailstats'@'localhost' identified
by 'mailstats';


Maybe the solution is just a note on the contribs page for those upgrading from
8.x that this *may* need to be run if you see this error;

[root@sme]$ perl /usr/bin/spamfilter-stats-7.pl /var/log/qpsmtpd/@*
/var/log/qpsmtpd/current
DBI connect('database=mailstats;host=localhost;port=3306','mailstats',...)
failed: Access denied for user 'mailstats'@'localhost' (using password: YES) at
/usr/bin/spamfilter-stats-7.pl line 1703
Cannot open mailstats db - has it beeen created? at
/usr/bin/spamfilter-stats-7.pl line 1703.

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
_______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/

Reply via email to