Hi, Tried a fresh Debian install and the error persists. I tried SQLite and Mysql too. Same problem:
Mar-02-22 14:02:34 [init] Try using mysql database <assp> for selected tables Mar-02-22 14:02:34 [init] Whitelist database error: Can't locate object method "connect" via package "DBI" at sub main::initDBHashes line 47. Mar-02-22 14:02:34 [init] Warning: can not use defined database - switching over to use files instead of database assp! (...) Mar-02-22 14:03:00 [Worker_10001] Spamdb.helo database error: Can't locate object method "connect" via package "DBI" at sub main::checkDBCon line 63. Mar-02-22 14:03:00 [Worker_10001] Error: unable to use defined database - switching over to use /usr/local/assp/database/spamdb.helo instead of table spamdbhelo! Connection is successful if I try to connect directly via command line: root@deb11assp:/usr/local/assp# perl -e 'use DBI; DBI->connect("DBI:Pg:database=assp;host=127.0.0.1;user=assp;password=assp","","");' root@deb11assp:/usr/local/assp# perl -MDBI -e 'DBI->installed_versions' Perl : 5.032001 (x86_64-linux-gnu-thread-multi) OS : linux (4.19.0) DBI : 1.643 DBD::mysql : 4.050 DBD::Sponge : 12.010003 DBD::SQLite : 1.66 DBD::Proxy : install_driver(Proxy) failed: Can't locate RPC/PlClient.pm in @INC (you may need to install the RPC::PlClient module) DBD::Pg : 3.14.2 DBD::Mem : 0.001 DBD::MariaDB : 1.21 DBD::Gofer : 0.015327 DBD::File : 0.44 DBD::ExampleP : 12.014311 DBD::DBM : 0.08 Best regards, Alexandre Em qua., 2 de mar. de 2022 às 10:02, Alexandre Arruda <adald...@gmail.com> escreveu: > Hi Thomas, > > Em ter., 1 de mar. de 2022 às 10:40, Thomas Eckardt < > thomas.ecka...@thockar.com> escreveu: > >> seems the database driver is not installed >> >> DBD::Pg >> >> possibly because perl was updated and the assp module installer was not >> used >> >> antispam-assp:/usr/local/assp# dpkg -l | grep -i dbd > ii libdbd-pg-perl 3.14.2-1+b1 > amd64 Perl DBI driver for the PostgreSQL database server > ii libdbd-pgsql:amd64 0.9.0-9 > amd64 PostgreSQL database server driver for libdbi > > I updated DBD::Pg via cpan to version 3.15, without success too. > I will try to install ASSP in a fresh Debian 11 and I will report here. > > Best regards, > > Alexandre > > > > > >> >> Thomas >> >> >> >> >> >> Von: "Alexandre Arruda" <adald...@gmail.com> >> An: "For Users of ASSP" <assp-user@lists.sourceforge.net> >> Datum: 28.02.2022 15:10 >> Betreff: [Assp-user] Can't locate object method "connect" via >> package "DBI" >> ------------------------------ >> >> >> >> Hi, >> >> ASSP version 2.6.5(21218) (Perl 5.032001) (on linux) >> DBI is up to date. (1.643) >> >> I upgraded my Debian 10 install to Debian 11. After that, my ASSP >> connection to my Postgresql DB failed with this errors: >> >> 22-02-28 10:50:35 [init] Try using Pg database <assp> for selected tables >> 22-02-28 10:50:36 [init] Whitelist database error: Can't locate object >> method "connect" via package "DBI" at sub main::initDBHashes line 47. >> 22-02-28 10:50:36 [init] Warning: can not use defined database - >> switching over to use files instead of database assp! >> >> Best regards, >> >> Alexandre >> >> >> _______________________________________________ >> Assp-user mailing list >> Assp-user@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/assp-user >> >> >> >> >> DISCLAIMER: >> ******************************************************* >> This email and any files transmitted with it may be confidential, legally >> privileged and protected in law and are intended solely for the use of the >> individual to whom it is addressed. >> This email was multiple times scanned for viruses. There should be no >> known virus in this email! >> ******************************************************* >> >> _______________________________________________ >> Assp-user mailing list >> Assp-user@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/assp-user >> >
_______________________________________________ Assp-user mailing list Assp-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-user