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 <[email protected]>
escreveu:
> Hi Thomas,
>
> Em ter., 1 de mar. de 2022 às 10:40, Thomas Eckardt <
> [email protected]> 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" <[email protected]>
>> An: "For Users of ASSP" <[email protected]>
>> 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
>> [email protected]
>> 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
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/assp-user
>>
>
_______________________________________________
Assp-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-user
