Re: SA::DBI plugin and SA 3.1.3
Michael Monnerie wrote: > On Samstag, 24. Juni 2006 02:30 Michael Parker wrote: >> Add --debug dbiplugin to your starup command line. > > Sorry I checked that already, but forgot to post it: > # spamd -D dbiplugin -q -c -l -r /var/run/spamd.pid --min-children=2 > --max-children=15 --min-spare=2 > [27733] dbg: dbiplugin: Creating uncached database handle to > 'dbname=zmi_sa_bayes;host=localhost_zmi_sa_bayes_bayes_AutoCommit=0_PrintError=0_Username=zmi_sa_bayes' > [27733] info: spamd: server started on port 783/tcp (running version 3.1.3) > [27733] info: spamd: server pid: 27733 > [27746] dbg: dbiplugin: In spamd_child_init > [27733] info: spamd: server successfully spawned child process, pid 27746 > [27747] dbg: dbiplugin: In spamd_child_init > [27733] info: spamd: server successfully spawned child process, pid 27747 > [27733] info: prefork: child states: II > > # spamassassin --debug dbiplugin --lint 2>&1 > [27929] dbg: dbiplugin: Creating uncached database handle to > 'dbname=zmi_sa_bayes;host=localhost_zmi_sa_bayes_bayes_AutoCommit=0_PrintError=0_Username=zmi_sa_bayes' > > Looks good? > > mfg zmi The first one in spamd will not be cached (really anything that isn't in a child), and will never be cached in spamassassin. So you'd have to look at the subsequent accesses in spamd to know for sure. Michael
Re: SA::DBI plugin and SA 3.1.3
On Samstag, 24. Juni 2006 02:30 Michael Parker wrote: > Add --debug dbiplugin to your starup command line. Sorry I checked that already, but forgot to post it: # spamd -D dbiplugin -q -c -l -r /var/run/spamd.pid --min-children=2 --max-children=15 --min-spare=2 [27733] dbg: dbiplugin: Creating uncached database handle to 'dbname=zmi_sa_bayes;host=localhost_zmi_sa_bayes_bayes_AutoCommit=0_PrintError=0_Username=zmi_sa_bayes' [27733] info: spamd: server started on port 783/tcp (running version 3.1.3) [27733] info: spamd: server pid: 27733 [27746] dbg: dbiplugin: In spamd_child_init [27733] info: spamd: server successfully spawned child process, pid 27746 [27747] dbg: dbiplugin: In spamd_child_init [27733] info: spamd: server successfully spawned child process, pid 27747 [27733] info: prefork: child states: II # spamassassin --debug dbiplugin --lint 2>&1 [27929] dbg: dbiplugin: Creating uncached database handle to 'dbname=zmi_sa_bayes;host=localhost_zmi_sa_bayes_bayes_AutoCommit=0_PrintError=0_Username=zmi_sa_bayes' Looks good? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660/4156531 .network.your.ideas. // PGP Key:"curl -s http://zmi.at/zmi3.asc | gpg --import" // Fingerprint: 44A3 C1EC B71E C71A B4C2 9AA6 C818 847C 55CB A4EE // Keyserver: www.keyserver.net Key-ID: 0x55CBA4EE pgp3NxuOdJJ0D.pgp Description: PGP signature
Re: SA::DBI plugin and SA 3.1.3
Michael Monnerie wrote: > On Dienstag, 20. Juni 2006 18:09 Michael Parker wrote: >> You're pointed at the wrong DBI.pm. I updated the wiki to make it >> more obvious. > > It's running now, but I can't see caching to happen. Below some > log lines. Any ideas? Add --debug dbiplugin to your starup command line. Michael
Re: SA::DBI plugin and SA 3.1.3
On Dienstag, 20. Juni 2006 18:09 Michael Parker wrote: > You're pointed at the wrong DBI.pm. I updated the wiki to make it > more obvious. It's running now, but I can't see caching to happen. Below some log lines. Any ideas? 2006-06-24 00:12:22 CEST [unbekannt] 2006-06-24 00:12:22 CEST LOG: Verbindung empfangen: Host=127.0.0.1 Port=47353 2006-06-24 00:12:22 CEST zmi_sa_bayes 127.0.0.1(47353) 2006-06-24 00:12:22 CEST LOG: Verbindung authorisiert: Benutzer=zmi_sa_bayes Datenbank=zmi_sa_bayes 2006-06-24 00:12:23 CEST zmi_sa_bayes 127.0.0.1(47353) 2006-06-24 00:12:22 CEST LOG: Verbindungsende: Sitzungszeit: 0:00:00.90 user=zmi_sa_bayes database=zmi_sa_bayes host=127.0.0.1 port=47353 2006-06-24 00:12:40 CEST [unbekannt] 2006-06-24 00:12:40 CEST LOG: Verbindung empfangen: Host=127.0.0.1 Port=47366 2006-06-24 00:12:40 CEST zmi_sa_bayes 127.0.0.1(47366) 2006-06-24 00:12:40 CEST LOG: Verbindung authorisiert: Benutzer=zmi_sa_bayes Datenbank=zmi_sa_bayes 2006-06-24 00:12:43 CEST zmi_sa_bayes 127.0.0.1(47366) 2006-06-24 00:12:40 CEST LOG: Verbindungsende: Sitzungszeit: 0:00:03.22 user=zmi_sa_bayes database=zmi_sa_bayes host=127.0.0.1 port=47366 2006-06-24 00:12:49 CEST [unbekannt] 2006-06-24 00:12:49 CEST LOG: Verbindung empfangen: Host=127.0.0.1 Port=47440 2006-06-24 00:12:49 CEST zmi_sa_bayes 127.0.0.1(47440) 2006-06-24 00:12:49 CEST LOG: Verbindung authorisiert: Benutzer=zmi_sa_bayes Datenbank=zmi_sa_bayes 2006-06-24 00:12:51 CEST zmi_sa_bayes 127.0.0.1(47440) 2006-06-24 00:12:49 CEST LOG: Verbindungsende: Sitzungszeit: 0:00:02.03 user=zmi_sa_bayes database=zmi_sa_bayes host=127.0.0.1 port=47440 2006-06-24 00:14:17 CEST [unbekannt] 2006-06-24 00:14:17 CEST LOG: Verbindung empfangen: Host=127.0.0.1 Port=47527 2006-06-24 00:14:17 CEST zmi_sa_bayes 127.0.0.1(47527) 2006-06-24 00:14:17 CEST LOG: Verbindung authorisiert: Benutzer=zmi_sa_bayes Datenbank=zmi_sa_bayes 2006-06-24 00:14:19 CEST zmi_sa_bayes 127.0.0.1(47527) 2006-06-24 00:14:17 CEST LOG: Verbindungsende: Sitzungszeit: 0:00:01.55 user=zmi_sa_bayes database=zmi_sa_bayes host=127.0.0.1 port=47527 2006-06-24 00:14:21 CEST [unbekannt] 2006-06-24 00:14:21 CEST LOG: Verbindung empfangen: Host=127.0.0.1 Port=47529 2006-06-24 00:14:21 CEST zmi_sa_bayes 127.0.0.1(47529) 2006-06-24 00:14:21 CEST LOG: Verbindung authorisiert: Benutzer=zmi_sa_bayes Datenbank=zmi_sa_bayes 2006-06-24 00:14:22 CEST zmi_sa_bayes 127.0.0.1(47529) 2006-06-24 00:14:21 CEST LOG: Verbindungsende: Sitzungszeit: 0:00:01.02 user=zmi_sa_bayes database=zmi_sa_bayes host=127.0.0.1 port=47529 2006-06-24 00:15:29 CEST [unbekannt] 2006-06-24 00:15:29 CEST LOG: Verbindung empfangen: Host=127.0.0.1 Port=34099 2006-06-24 00:15:29 CEST zmi_sa_bayes 127.0.0.1(34099) 2006-06-24 00:15:29 CEST LOG: Verbindung authorisiert: Benutzer=zmi_sa_bayes Datenbank=zmi_sa_bayes 2006-06-24 00:15:30 CEST zmi_sa_bayes 127.0.0.1(34099) 2006-06-24 00:15:29 CEST LOG: Verbindungsende: Sitzungszeit: 0:00:01.26 user=zmi_sa_bayes database=zmi_sa_bayes host=127.0.0.1 port=34099 2006-06-24 00:15:32 CEST [unbekannt] 2006-06-24 00:15:32 CEST LOG: Verbindung empfangen: Host=127.0.0.1 Port=34101 2006-06-24 00:15:32 CEST zmi_sa_bayes 127.0.0.1(34101) 2006-06-24 00:15:32 CEST LOG: Verbindung authorisiert: Benutzer=zmi_sa_bayes Datenbank=zmi_sa_bayes 2006-06-24 00:15:33 CEST zmi_sa_bayes 127.0.0.1(34101) 2006-06-24 00:15:32 CEST LOG: Verbindungsende: Sitzungszeit: 0:00:00.70 user=zmi_sa_bayes database=zmi_sa_bayes host=127.0.0.1 port=34101 2006-06-24 02:03:13 CEST zmi_sa_bayes 127.0.0.1(42737) 2006-06-24 02:03:13 CEST LOG: Verbindung authorisiert: Benutzer=zmi_sa_bayes Datenbank=zmi_sa_bayes 2006-06-24 02:03:15 CEST zmi_sa_bayes 127.0.0.1(42737) 2006-06-24 02:03:13 CEST LOG: Verbindungsende: Sitzungszeit: 0:00:02.05 user=zmi_sa_bayes database=zmi_sa_bayes host=127.0.0.1 port=42737 2006-06-24 02:03:18 CEST [unbekannt] 2006-06-24 02:03:18 CEST LOG: Verbindung empfangen: Host=127.0.0.1 Port=42746 2006-06-24 02:03:18 CEST zmi_sa_bayes 127.0.0.1(42746) 2006-06-24 02:03:18 CEST LOG: Verbindung authorisiert: Benutzer=zmi_sa_bayes Datenbank=zmi_sa_bayes 2006-06-24 02:03:20 CEST zmi_sa_bayes 127.0.0.1(42746) 2006-06-24 02:03:18 CEST LOG: Verbindungsende: Sitzungszeit: 0:00:01.95 user=zmi_sa_bayes database=zmi_sa_bayes host=127.0.0.1 port=42746 2006-06-24 02:04:41 CEST [unbekannt] 2006-06-24 02:04:41 CEST LOG: Verbindung empfangen: Host=127.0.0.1 Port=42959 -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660/4156531 .network.your.ideas. // PGP Key:"curl -s http://zmi.at/zmi3.asc | gpg --import" // Fingerprint: 44A3 C1EC B71E C71A B4C2 9AA6 C818 847C 55CB A4EE // Keyserver: www.keyserver.net Key-ID: 0x55CBA4EE pgpE196aNcnSM.pgp Description: PGP signature
Re: SA::DBI plugin and SA 3.1.3
On Dienstag, 20. Juni 2006 18:09 Michael Parker wrote: > You're pointed at the wrong DBI.pm. I updated the wiki to make it > more obvious. Thank you. Now I found my error. Is there a way to download that DBI.pm other can copy&paste from the Wiki? I can't see a link. Anyway, I copied it and now it seems to work. Thank you. BTW, I wanted to contact you directly, but that doesn't seem to work: B4AB45825F42442 Tue Jun 20 06:28:55 [EMAIL PROTECTED] (connect to parkerm.com[205.178.189.131]: Connection timed out) [EMAIL PROTECTED] What's wrong there? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660/4156531 .network.your.ideas. // PGP Key:"curl -s http://zmi.at/zmi3.asc | gpg --import" // Fingerprint: 44A3 C1EC B71E C71A B4C2 9AA6 C818 847C 55CB A4EE // Keyserver: www.keyserver.net Key-ID: 0x55CBA4EE pgpFBvOzqd8Rl.pgp Description: PGP signature
Re: SA::DBI plugin and SA 3.1.3
Michael Monnerie wrote: > Hi, I'm using it, but there are a lot of warnings. I have > loadplugin Mail::SpamAssassin::Plugin::DBI > /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm > in my v310.pre config file. What could be the problem? > I checked the logs, and can't see persistent connections. You're pointed at the wrong DBI.pm. I updated the wiki to make it more obvious. Michael
SA::DBI plugin and SA 3.1.3
Hi, I'm using it, but there are a lot of warnings. I have loadplugin Mail::SpamAssassin::Plugin::DBI /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm in my v310.pre config file. What could be the problem? I checked the logs, and can't see persistent connections. [11538] warn: plugin: failed to create instance of plugin Mail::SpamAssassin::Plugin::DBI: Can't locate object method "new" via package "Mail::SpamAssassin::Plugin::DBI" (perhaps you forgot to load "Mail::SpamAssassin::Plugin::DBI"?) at (eval 66) line 1. [11538] warn: Subroutine DBI::SQL_UDT redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_LONGVARCHAR redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_CLOB redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_VARBINARY redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_GUID redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_INTERVAL_MINUTE_TO_SECOND redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_CURSOR_KEYSET_DRIVEN redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::DBIpp_cm_hs redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_CURSOR_STATIC redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_UDT_LOCATOR redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_ARRAY redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_MULTISET_LOCATOR redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_CHAR redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_DATE redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::DBIpp_ph_XX redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_INTERVAL_MONTH redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_TINYINT redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_ROW redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_TYPE_TIME redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_BOOLEAN redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_REF redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_DATETIME redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::DBIpp_ph_cs redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_INTERVAL_MINUTE redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_ALL_TYPES redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_TYPE_TIME_WITH_TIMEZONE redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::DBIpp_st_bs redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::DBIpp_cm_cs redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_INTERVAL redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_INTERVAL_DAY redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_DECIMAL redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_BLOB_LOCATOR redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_ARRAY_LOCATOR redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI::SQL_BINARY redefined at /usr/lib/perl5/site_perl/5.8.6/i586-linux-thread-multi/DBI.pm line 158. [11538] warn: Subroutine DBI: