giovanni@paclan.it skrev den 2023-03-27 10:06:
> On 3/26/23 00:33, Benny Pedersen wrote:
>>
>> # log
>>
>> Mar 23 05:54:55 localhost spamd[4127]: DMARC: report could not be
>> saved: DBI connect('dbname=dmarc_reports.sqlite','',...) failed:
>> unable to open database file at
>> /usr/lib64/perl5/vendor_perl/5.36/Mail/DMARC/Report/Store/SQL.pm line
>> 551.
>>
>> # ini file in mail::dmarc
>>
>> [report_store]
>> backend = SQL
>> dsn = dbi:Pg:dbname=dmarc;host=127.0.0.1;port=5432;
>> user = user
>> pass = pass
>> auto_save = 0
>>
>> mail::dmarc do work with postgres, but the report in spamassassin
>> fails
>>
>> can it be solved to just ignore the ini file, and do dbi: as other in
>> spamassassin already does ?, or is mail::dmarc not tested well here ?
> DMARC reports are working with MySQL, is this one-liner reading the
> correct file on your setup ?
> perl -e 'use Mail::DMARC; use Data::Dumper; my $ds = new Mail::DMARC;
> print Dumper($ds->config);'
mx ~ # perl -e 'use Mail::DMARC; use Data::Dumper; my $ds = new
Mail::DMARC; print Dumper($ds->config);'
$VAR1 = bless( {
'organization' => {
'extra_contact_info' =>
'
http://www.example.com/dmarc-policy/', 'domain' => 'example.com',
'email' => 'noreply@example.com',
'org_name' => 'My Great Company'
},
'smtp' => {
'cc' => 'set.this@for.a.while.example.com',
'smartuser' => '',
'hostname' => 'mail.example.com',
'smarthost' => '',
'whitelist' =>
'/path/to/etc/dmarc_whitelist',
'smartpass' => ''
},
'report_sign' => {
'domain' => 'signer.example.com',
'algorithm' => 'rsa-sha1',
'method' => 'relaxed',
'keyfile' => '/path/to/private.key',
'selector' => 'dkim'
},
'report_store' => {
'auto_save' => '0',
'backend' => 'SQL',
'pass' => '',
'user' => '',
'dsn' =>
'dbi:SQLite:dbname=dmarc_reports.sqlite'
},
'dns' => {
'public_suffix_list' =>
'share/public_suffix_list',
'timeout' => '5'
},
'imap' => {
'f_done' => 'dmarc.forensic',
'folder' => 'dmarc',
'pass' => '',
'server' => 'mail.example.com',
'user' => '',
'a_done' => 'dmarc.aggregate'
},
'http' => {
'port' => '8080'
},
'dmarc' => {
'backend' => 'perl'
},
'https' => {
'port' => '8443',
'ssl_key' => '',
'ssl_crt' => ''
},
'report_sending' => {}
}, 'Config::Tiny' );
mx ~ #
seems no
mx ~ # eix --nocolor -e Mail-DMARC
[I] dev-perl/Mail-DMARC
Available versions: 1.202.109.270-r1^t (~)1.202.302.150^t {minimal
test}
Installed versions: 1.202.302.150^t(22:56:24 03/20/23)(-minimal
-test)
Homepage:
https://metacpan.org/release/Mail-DMARC Description: Perl implementation of DMARC
>
> Giovanni
