You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@spamassassin.apache.org by bu...@bugzilla.spamassassin.org on 2018/12/11 13:06:01 UTC
[Bug 7668] New: TXREP: Can't call method "execute" on an undefined
value with SQLite
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7668
Bug ID: 7668
Summary: TXREP: Can't call method "execute" on an undefined
value with SQLite
Product: Spamassassin
Version: 3.4.2
Hardware: PC
OS: FreeBSD
Status: NEW
Severity: normal
Priority: P2
Component: spamassassin
Assignee: dev@spamassassin.apache.org
Reporter: max@kostikov.co
Target Milestone: Undefined
Dec 11 13:57:30 eprove spamd[1334]: rules: failed to run TXREP test, skipping:
Dec 11 13:57:30 eprove spamd[1334]: (Can't call method "execute" on an
undefined value at
/usr/local/lib/perl5/site_perl/Mail/SpamAssassin/SQLBasedAddrList.pm line 223.
Dec 11 13:57:30 eprove spamd[1334]: )
Dec 11 13:57:30 eprove spamd[1334]: plugin: eval failed: Can't call method
"execute" on an undefined value at
/usr/local/lib/perl5/site_perl/Mail/SpamAssassin/SQLBasedAddrList.pm line 223.
root@eprove:~ # sqlite3 --version
3.26.0 2018-12-01 12:34:55
bf8c1b2b7a5960c282e543b9c293686dccff272512d08865f4600fb58238b4f9
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 7668] TXREP: Can't call method "execute" on an undefined value
with SQLite
Posted by bu...@bugzilla.spamassassin.org.
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7668
Giovanni Bechis <gi...@paclan.it> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |giovanni@paclan.it
--- Comment #1 from Giovanni Bechis <gi...@paclan.it> ---
Could you share your TXRep related config to be able to reproduce ?
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 7668] TXREP: Can't call method "execute" on an undefined value
with SQLite
Posted by bu...@bugzilla.spamassassin.org.
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7668
Giovanni Bechis <gi...@paclan.it> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
--- Comment #3 from Giovanni Bechis <gi...@paclan.it> ---
sqlite database should be initialized with database schema,
I added a schema in r1848827.
If you are using 3.4.2 you can grab sqlite schema from svn
(https://svn.apache.org/repos/asf/spamassassin/trunk/sql/txrep_sqlite.sql) and
rename "msgcount" field in "count".
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 7668] TXREP: Can't call method "execute" on an undefined value
with SQLite
Posted by bu...@bugzilla.spamassassin.org.
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7668
--- Comment #4 from Max Kostikov <ma...@kostikov.co> ---
Thanks!
There was the old table schema here with `time` instead `last_hit` column.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 7668] TXREP: Can't call method "execute" on an undefined value
with SQLite
Posted by bu...@bugzilla.spamassassin.org.
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7668
Max Kostikov <ma...@kostikov.co> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |max@kostikov.co
--- Comment #2 from Max Kostikov <ma...@kostikov.co> ---
Sure.
1. Spamassassin config
txrep_factory Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn
DBI:SQLite:dbname=/var/spool/mqueue/.spamassassin/txrep.sqlite3
use_txrep 1
txrep_autolearn 1
user_awl_sql_table txrep
2. Perl
root@eprove:~ # pkg info | grep -E "perl5|p5-"
p5-Algorithm-C3-0.10_1 Module for merging hierarchies using the C3
algorithm
p5-B-Hooks-EndOfScope-0.24 Execute code after a scope finished compilation
p5-Class-C3-0.34 Pragma to use the C3 method resolution order
algorithm
p5-Class-Data-Inheritable-0.08_1 Inheritable, overridable class data
p5-Class-Method-Modifiers-2.12 Provides Moose-like method modifiers
p5-Crypt-OpenSSL-Bignum-0.09 OpenSSL's multiprecision integer arithmetic
p5-Crypt-OpenSSL-RSA-0.31 Perl5 module to RSA encode and decode strings
using OpenSSL
p5-Crypt-OpenSSL-Random-0.15 Perl5 interface to the OpenSSL pseudo-random
number generator
p5-DBD-SQLite-1.60 Provides access to SQLite3 databases through the
DBI
p5-DBD-mysql-4.048 MySQL driver for the Perl5 Database Interface
(DBI)
p5-DBI-1.642 Perl5 Database Interface, required for DBD::*
modules
p5-Data-OptList-0.110 Parse and validate simple name/value option
pairs
p5-Devel-GlobalDestruction-0.14 Expose PL_dirty, the flag which marks global
destruction
p5-Devel-StackTrace-2.03 Stack trace and stack trace frame objects
p5-Digest-HMAC-1.03_1 Perl5 interface to HMAC Message-Digest
Algorithms
p5-Digest-SHA1-2.13_1 Perl interface to the SHA-1 Algorithm
p5-Dist-CheckConflicts-0.11_1 Declare version conflicts for your dist
p5-Email-Abstract-3.008_1 Unified interface to mail representations
p5-Email-Address-1.909 RFC 2822 Address Parsing and Creation
p5-Email-Date-Format-1.005 Produce RFC 2822 date strings
p5-Email-Sender-1.300031 Library for sending email
p5-Email-Simple-2.216 Simple parsing of RFC2822 message format and
headers
p5-Email-Valid-1.202 Check validity of Internet email addresses
p5-Encode-Detect-1.01_1 Encode::Encoding subclass that detects the
encoding of data
p5-Encode-Locale-1.05 Determine the locale encoding
p5-Error-0.17027 Error/exception handling in object-oriented
programming style
p5-Eval-Closure-0.14 Safely and cleanly create closures via string
eval
p5-Exception-Class-1.44 Real exception classes in Perl
p5-Exporter-Tiny-1.002001 Exporter with features of Sub::Exporter but only
core dependencies
p5-Filter-1.59 Number of source filters for perl5 programs
p5-HTML-Parser-3.72 Perl5 module for parsing HTML documents
p5-HTML-Tagset-3.20_1 Some useful data table in parsing HTML
p5-HTTP-Date-6.02_1 Conversion routines for the HTTP protocol date
formats
p5-HTTP-Message-6.18 Representation of HTTP style messages
p5-IO-HTML-1.001_1 Open an HTML file with automatic charset
detection
p5-IO-Socket-INET6-2.72_1 Perl module with object interface to AF_INET6
domain sockets
p5-IO-Socket-SSL-2.060 Perl5 interface to SSL sockets
p5-LWP-MediaTypes-6.02_1 Guess media type for a file or a URL
p5-List-MoreUtils-0.428 Provide the stuff missing in List::Util
p5-List-MoreUtils-XS-0.428 Provide compiled List::MoreUtils functions
p5-Locale-gettext-1.07 Message handling functions
p5-Locale-libintl-1.31 Internationalization library for Perl
p5-Log-Dispatch-2.68 Suite of OO modules for logging messages to
multiple outputs
p5-Log-Log4perl-1.49 Log4j implementation for Perl
p5-MIME-Charset-1.012.2 Charset Informations for MIME
p5-MIME-EncWords-1.014.3 Deal with RFC 2047 encoded words (improved)
p5-MRO-Compat-0.13 Add mro::* interface compatibility for Perls <
5.9.5
p5-Mail-DKIM-0.54 Perl5 module to process and/or create DKIM email
p5-Mail-SPF-2.9.0_4 Object-oriented implementation of Sender Policy
Framework
p5-Mail-Sendmail-0.80 Perl module implementing a simple,
platform-independent mailer
p5-Mail-Tools-2.19 Perl5 modules for dealing with Internet e-mail
messages
p5-Module-Implementation-0.09_1 Loads one of several alternate underlying
implementations for a module
p5-Module-Pluggable-5.2 Automatically give your module the ability to
have plugins
p5-Module-Runtime-0.016 Runtime module handling
p5-Moo-2.003004 Minimalist Object Orientation (with Moose
compatibility)
p5-MooX-Types-MooseLike-0.29 Some Moosish types and a typer builder
p5-Mozilla-CA-20180117 Perl extension for Mozilla CA cert bundle in PEM
format
p5-Net-DNS-1.19,1 Perl5 interface to the DNS resolver, and dynamic
updates
p5-Net-DNS-Resolver-Mock-1.20171219 Mock a DNS Resolver object for testing
p5-Net-DNS-Resolver-Programmable-0.009 Programmable DNS resolver for off-line
testing
p5-Net-Domain-TLD-1.74 Look up and validate TLDs
p5-Net-IDN-Encode-2.400 Internationalizing Domain Names in Applications
(RFC 3490)
p5-Net-LibIDN-0.12_4 This module provides access to the libidn
library
p5-Net-SSLeay-1.85 Perl5 interface to SSL
p5-NetAddr-IP-4.079 Work with IPv4 and IPv6 addresses and subnets
p5-Package-Stash-0.37_1 Routines for manipulating stashes
p5-Package-Stash-XS-0.28_2 Faster and more correct implementation of the
Package::Stash API
p5-Params-Util-1.07_2 Utility functions to aid in parameter checking
p5-Params-ValidationCompiler-0.30 Build an optimized subroutine parameter
validator once, use it forever
p5-Role-Tiny-2.000006 Roles, like a nouvelle cusine portion size slice
of Moose
p5-Socket6-0.29 IPv6 related part of the C socket.h defines and
structure manipulators
p5-Specio-0.43 Type constraints and coercions for Perl
p5-Sub-Exporter-0.987_1 Sophisticated exporter for custom-built routines
p5-Sub-Exporter-Progressive-0.001013 Only use Sub::Exporter if you need it
p5-Sub-Identify-0.14 Retrieve names of code references
p5-Sub-Install-0.928_1 Install subroutines into packages easily
p5-Sub-Quote-2.005001 Efficient generation of subroutines via string
eval
p5-Switch-2.17_1 Switch - A switch statement for Perl
p5-Text-Unidecode-1.30 Text::Unidecode -- US-ASCII transliterations of
Unicode text
p5-Throwable-0.200013 Easy-to-use class for error objects
p5-TimeDate-2.30_2,1 Perl5 module containing a better/faster date
parser for absolute dates
p5-Try-Tiny-0.30 Minimal try/catch with proper localization of $@
p5-URI-1.74 Perl5 interface to Uniform Resource Identifier
(URI) references
p5-Unicode-EastAsianWidth-1.40 East Asian Width properties
p5-Variable-Magic-0.62 Associate user-defined magic to variables from
Perl
p5-namespace-autoclean-0.28 Keep imports out of your namespace
p5-namespace-clean-0.27 Keep imports and functions out of your namespace
perl5-5.26.3 Practical Extraction and Report Language
3. SQLite
root@eprove:~ # sqlite3 --version
3.26.0 2018-12-01 12:34:55
bf8c1b2b7a5960c282e543b9c293686dccff272512d08865f4600fb58238b4f9
4. System
root@eprove:~ # uname -v
FreeBSD 12.0-RELEASE r341666 GENERIC
--
You are receiving this mail because:
You are the assignee for the bug.