Perl and Opendmarc issues

["Richard Sass" <richard.sass%seqent.com@localhost>]

Hoping someone can point me in the right direction.

Also note that the opendmarc binary package appears to be missing from the
repository

#Uname info

NetBSD 9.0 NetBSD 9.0 (GENERIC) #0: Fri Feb 14 00:06:28 UTC 2020
mkrepro%mkrepro.NetBSD.org@localhost:/usr/src/sys/arch/amd64/compile/GENERIC amd64

#Running opendmarc-expire

Can't locate DBD/mysql.pm in @INC (you may need to install the DBD::mysql
module) (@INC contains:
/usr/pkg/lib/perl5/site_perl/5.34.0/x86_64-netbsd-thread-multi
/usr/pkg/lib/perl5/site_perl/5.34.0
/usr/pkg/lib/perl5/vendor_perl/5.34.0/x86_64-netbsd-thread-multi
/usr/pkg/lib/perl5/vendor_perl/5.34.0
/usr/pkg/lib/perl5/5.34.0/x86_64-netbsd-thread-multi
/usr/pkg/lib/perl5/5.34.0) at /usr/pkg/sbin/opendmarc-expire line 21.

Line 21 = require DBD::mysql;

# Installed binaries (what I think is pertinent to this issue)

pkgin ls|egrep -i 'perl|mysql|dmarc'

boost-libs-1.76.0    Free, peer-reviewed portable C++ source libraries
(binary libraries) mysql-client-5.7.35  MySQL 5, a free SQL database
(client)
mysql-server-5.7.35  MySQL 5, a free SQL database (server)
opendmarc-1.4.0b1nb3 Open source DMARC library, MTA filter implementation
and tools 
p5-DBD-mysql-4.050nb4 Perl DBI/DBD driver for MySQL databases
p5-DBI-1.643nb3      The database-independent Perl database access API
p5-Date-Calc-6.4nb7  Perl5 module for Gregorian calendar date calculations
p5-Devel-CheckLib-1.14nb2 Perl extension to check that a library is
available
p5-Filter-1.60nb1    Perl5 classes representing a number of source filters
p5-HTML-Parser-3.76nb1 Perl5 module to parse HTML text documents
p5-HTML-Tagset-3.20nb13 Perl5 module of data tables useful in parsing HTML
p5-HTTP-Date-6.05nb2 Perl 5 module providing date conversion routines
p5-IO-CaptureOutput-1.1105nb2 Capture STDOUT and STDERR from Perl code,
subprocesses, or XS
p5-JSON-4.03nb1      Perl module converts between JSON and Perl data
structure
p5-MailTools-2.21nb2 Perl5 modules related to mail applications
p5-Switch-2.17nb5    Switch statement for Perl
p5-TimeDate-2.33nb1  Perl5 TimeDate distribution
p5-URI-5.09nb1       Perl5 Uniform Resource Identifiers class (URI, RFC
2396)
pcre-8.45            Perl Compatible Regular Expressions library
pcre2-10.37          Perl Compatible Regular Expressions library (major
version 2)
perl-5.34.0nb3       Practical Extraction and Report Language

#Tried re-installing p5-DBD-mysql-4.050nb4

pkgin in p5-DBD-mysql-4.050nb4
calculating dependencies...done.

1 package to install:
  mariadb-client-10.5.12nb1

0 to refresh, 0 to upgrade, 1 to install
0B to download, 50M to install

proceed ? [Y/n] y
installing mariadb-client-10.5.12nb1...
pkg_install warnings: 0, errors: 1
pkg_install error log can be found in /var/db/pkgin/pkg_install-err.log

#From /var/db/pkgin/pkg_install-err.log

---Nov 26 14:19:13: installing mariadb-client-10.5.12nb1...
pkg_add: Package `mariadb-client-10.5.12nb1' conflicts with
`mysql-client-[0-9]*', and `mysql-client-5.7.35' is installed.
pkg_add: 1 package addition failed
pkg_admin: Dependency mariadb-client>=10.5.0<10.6.0 of p5-DBD-mysql-4.050nb4
unresolved

# Looked for opendmarc to see if there was a newer version

pkgin av|grep opendmarc
Nothing found - package no longer exists in repository
https://nyftp.netbsd.org/pub/pkgsrc/packages/NetBSD/$arch/$osrelease/All


# looking back in the /var/db/pkgin/pkg_install-err.log I think the problem
may have started back in May

---May 29 11:34:25: upgrading opendmarc-1.4.0b1nb3...
pkg_delete: couldn't entirely delete package `opendmarc-1.4.0b1'
---May 29 11:34:26: refreshing p5-Switch-2.17nb4...
---May 29 11:34:28: refreshing p5-HTTP-Message-6.29...
---May 29 11:34:29: refreshing p5-DBI-1.643nb1...
---May 29 11:34:31: refreshing p5-DBD-mysql-4.050nb2...
---May 29 11:34:32: refreshing p5-Devel-CheckLib-1.14nb1...
---May 29 11:34:34: refreshing mysql-client-5.7.33...
---May 29 11:34:38: refreshing p5-URI-1.76nb2...
---May 29 11:34:40: refreshing p5-Try-Tiny-0.30nb3...
---May 29 11:34:41: refreshing p5-LWP-MediaTypes-6.04nb1...
---May 29 11:34:43: refreshing p5-IO-HTML-1.004...
---May 29 11:34:44: refreshing p5-HTTP-Date-6.05nb1...
---May 29 11:34:45: refreshing p5-HTML-Parser-3.76...
---May 29 11:34:47: refreshing p5-Encode-Locale-1.05nb6...
---May 29 11:34:48: refreshing perl-5.32.1...
---May 29 11:34:55: refreshing p5-Text-Balanced-2.03nb6...
---May 29 11:34:56: refreshing p5-Filter-1.60...
---May 29 11:34:58: refreshing p5-HTML-Tagset-3.20nb12...
---May 29 11:34:59: upgrading boost-libs-1.75.0...
---May 29 11:35:01: refreshing p5-IO-CaptureOutput-1.1105nb1...
---May 29 11:35:02: refreshing icu-68.2...
pkg_admin: Dependency boost-libs-1.73.* of mysql-server-5.7.31nb1 unresolved
---May 29 11:35:30: upgrading opendkim-2.10.3nb7...
pkg_admin: Dependency boost-libs-1.73.* of mysql-server-5.7.31nb1 unresolved

#Also seeing a lot of the following when trying to upgrade p5 modules

---Nov 26 09:03:51: upgrading p5-IO-CaptureOutput-1.1105nb2...
pkg_admin: Dependency perl>=5.32.0<5.34.0 of p5-HTTP-Date-6.05nb1 unresolved
pkg_admin: Dependency perl>=5.32.0<5.34.0 of p5-DBD-mysql-4.050nb2
unresolved
pkg_admin: Dependency perl>=5.32.0<5.34.0 of p5-Devel-CheckLib-1.14nb1
unresolved
pkg_admin: Dependency boost-libs-1.73.* of mysql-server-5.7.31nb1 unresolved
pkg_admin: Dependency perl>=5.32.0<5.34.0 of p5-HTML-Tagset-3.20nb12
unresolved
pkg_admin: Dependency perl>=5.32.0<5.34.0 of p5-DBI-1.643nb1 unresolved
pkg_admin: Dependency perl>=5.32.0<5.34.0 of p5-Encode-Locale-1.05nb6
unresolved
pkg_admin: Dependency perl>=5.32.0<5.34.0 of p5-HTTP-Message-6.29 unresolved
pkg_admin: Dependency perl>=5.32.0<5.34.0 of p5-HTML-Parser-3.76 unresolved