On Tue, 15 Aug 2017, Christopher Engelhard wrote:
On 08/14/2017 05:24 PM, Kevin A. McGrail wrote:
does mysql -u <user> -p<password> localhost spamdb work?
Yes, that works. The user has INSERT, DELETE, UPDATE, SELECT privileges.
Does it need CREATE? The table 'txrep' exists with columns username,
email, ip, count, totscore, signedby.
The Bayes-related tables reside in the same DB, and those can be
accessed (though I've only tried it with amavis, not with pure spamd/spamc).
christopher
I've not looked at the TxRep code but some kinds of SQL operations need to be
able to create temporary tables.
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.
--
Dave Funk University of Iowa
<dbfunk (at) engineering.uiowa.edu> College of Engineering
319/335-5751 FAX: 319/384-0549 1256 Seamans Center
Sys_admin/Postmaster/cell_admin Iowa City, IA 52242-1527
#include <std_disclaimer.h>
Better is not better, 'standard' is better. B{