On 8/16/2017 4:38 AM, Christopher Engelhard wrote:
I'd start by giving it all perms (excepting things like GRANT), see if
it works, and then scale back the perms until you find the minimal
necessary set.
After giving the user full permissions I still get the exact same error
message(s).
For completeness' sake I tried the Bayes module with just spamassassin
(no amavis), that works as well. 'spamdb' contains the tables for Bayes
and TxRep, and all are accessed using the same user/password/privileges.
Bayes works, TxRep doesn't, even with full privileges.
Please open a bug on bugzilla. Nothing jumps to mind. If you can
include the version of mysql just for completeness sake as well as how
you created the tables, that would be good.
Actually one more set of questions before a bug.
Do you have a line like user_awl_sql_table txrep?
And can you run a show tables and describe like such?
show tables;
describe txrep;
+----------+--------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+-------------------+-------+
| username | varchar(100) | NO | PRI | | |
| email | varchar(255) | NO | PRI | | |
| ip | varchar(40) | NO | PRI | | |
| count | int(11) | NO | | 0 | |
| totscore | float | NO | | 0 | |
| signedby | varchar(255) | NO | PRI | | |
| last_hit | timestamp | NO | MUL | CURRENT_TIMESTAMP | |
+----------+--------------+------+-----+-------------------+-------+
7 rows in set (0.00 sec)
Regards,
KAM
