Re: TxRep can't use SQLBasedAddrList factory module

2017-08-16 Thread Christopher Engelhard
> 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. > I'll do that, unless you can spot an error below. > Do you have a line like user_awl_sql_table

Re: TxRep can't use SQLBasedAddrList factory module

2017-08-16 Thread Christopher Engelhard
> 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 j

Re: TxRep can't use SQLBasedAddrList factory module

2017-08-15 Thread Christopher Engelhard
On 08/14/2017 05:24 PM, Kevin A. McGrail wrote: > does mysql -u -p 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 r

TxRep can't use SQLBasedAddrList factory module

2017-08-13 Thread Christopher Engelhard
Hi, I'm trying to set up txrep with SQL storage, but TxRep does not seem to allow SQLBasedAddrList as factory module. Log: spamd[8299]: TxRep: illegal factory setting spamd[8299]: TxRep: could not open storages, quitting! spamd[8299]: TxRep: illegal factory setting spamd[8299]: TxRep: could not op