DecodeShortURLs not working

[JohnnyD]

An OOTB install has DecodeShortURLs enabled it seems, but it does not work with missing components, how do I get it working? Or does it need disabling somehow?

WARNING: DecodeShortURLs: cache connect failed: Can't locate DBD/SQLite.pm in @INC (you may need to install the DBD::SQLite module) (@INC contains: lib /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl) at /usr/share/perl5/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm line 488, <GEN8618> line 1833.#012

 

[dcsapak]

seems the missing dependency is 'libdbd-sqlite3-perl' so a a

apt install libdbd-sqlite3-perl

should fix it. i'll open a bug to include that dependency

EDIT: taking a closer look, did you configure a caching for decodeshorturls ? by default that shouldn't be the case and without caching configured, it should not need a database...(
EDIT2: taking an even closer look, the caching is by default enabled and we forgot the dependency, just as i originally wrote

 

[itNGO]

Looks like this is still the case in 8.2.0?
Had to "apt install libdbd-sqlite3-perl" to get rid of this in a fresh installation....

2025-03-20T10:35:06.906538+01:00 PMG pmg-smtp-filter[248077]: WARNING: DecodeShortURLs: cache connect failed: Can't locate DBD/SQLite.pm in @INC (you may need to install the DBD::SQLite module) (@INC contains: lib /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.36.0 /usr/local/share/perl/5.36.0 /usr/lib/x86_64-linux-gnu/perl5/5.36 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.36 /usr/share/perl/5.36 /usr/local/lib/site_perl) at /usr/share/perl5/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm line 492.#012
2

 

[Stoiko Ivanov]

Looks like this is still the case in 8.2.0?
Had to "apt install libdbd-sqlite3-perl" to get rid of this in a fresh installation....

How did you install - from ISO, on top of Debian, Container template?

Thanks for the report!

 

[itNGO]

From official ISO-Image.