at startup assp will show the DBI connection string in the maillog.txt -
like
Mar-01-22 08:52:44 [init] Info: the DBI connection string is set to:
'DBI:mysql:database=assp;host=127.0.0.1;autocommit=0'
check that the assp process uses the right perl distro (the same like root
?!)
some times more than one distro (version) of perl is on a system after a
linux distro upgrade
Tie::RDBM is missing ?? - DBI is loaded there in assp! If this module is
not installed and enabled, DBI is not available in assp -> leads in to "
Can't locate object method "connect" via package "DBI""
Did you run the assp module installer? - IMHO NO, because otherwise all
required modules would be available!
Notice:
If the module installer was not run after the linux upgrade and before the
first assp start - assp.pl will destroy the assp.cfg (all encrypted values
and files), if the module Crypt::GOST was installed and used before the
linux upgrade!
Thomas
Von: "Alexandre Arruda" <adald...@gmail.com>
An: "For Users of ASSP" <assp-user@lists.sourceforge.net>
Datum: 02.03.2022 15:26
Betreff: Re: [Assp-user] Can't locate object method "connect" via
package "DBI"
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
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
