Hi,
>
> 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""
>
>
Solved ! I don't attempt to the modulesError messages and this module is
not present. Sorry !
> Did you run the assp module installer? - IMHO NO, because otherwise all
> required modules would be available!
>
> Really I did not run module installer . Sorry again.
Thanks Thomas,
Best regards
>
> 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* <adald...@gmail.com>> escreveu:
> Hi Thomas,
>
> Em ter., 1 de mar. de 2022 às 10:40, Thomas Eckardt <
> *thomas.ecka...@thockar.com* <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* <adald...@gmail.com>>
> An: "For Users of ASSP" <*assp-user@lists.sourceforge.net*
> <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* <Assp-user@lists.sourceforge.net>
> *https://lists.sourceforge.net/lists/listinfo/assp-user*
> <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* <Assp-user@lists.sourceforge.net>
> *https://lists.sourceforge.net/lists/listinfo/assp-user*
> <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
>
_______________________________________________
Assp-user mailing list
Assp-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-user
