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 Kevin A. McGrail
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

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

Re: TxRep can't use SQLBasedAddrList factory module

2017-08-15 Thread David B Funk
On Tue, 15 Aug 2017, Christopher Engelhard wrote: 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,

Re: TxRep can't use SQLBasedAddrList factory module

2017-08-15 Thread Kevin A. McGrail
On 8/15/2017 9:22 AM, Christopher Engelhard wrote: 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,

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

Re: TxRep can't use SQLBasedAddrList factory module

2017-08-14 Thread Kevin A. McGrail
On 8/13/2017 8:49 AM, Christopher Engelhard wrote Log: spamd[8299]: TxRep: illegal factory setting spamd[8299]: TxRep: could not open storages, quitting! Config: header TXREP eval:check_senders_reputation() describe TXREP Score normalizing based on

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