Re: Perl and Opendmarc issues

[John Nemeth <jnemeth%cue.bc.ca@localhost>]

On Nov 26, 19:32, Greg Troxel wrote:
} "Richard Sass" <richard.sass%seqent.com@localhost> writes:
} 
} > Can't locate DBD/mysql.pm in @INC (you may need to install the 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=20
} > p5-DBD-mysql-4.050nb4 Perl DBI/DBD driver for MySQL databases
} > p5-DBI-1.643nb3      The database-independent Perl database access API
} >
} > #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>=3D10.5.0<10.6.0 of p5-DBD-mysql-4.0=
} 50nb4
} > unresolved
} 
} I think your problem is that the default mysql implementation has
} changed to mariadb, and your system has not yet been updated to cope
} with that.
} 
} So
} 0) first make  a backup, and then a second backup
} 1) figure out what you have to do to convert from mysql 5.7 to mariadb
} 2) export your mysql data
} 3) remove mysql and install maridb
} 4) restore
} 5) install p5-DBD-mysql

     Alternatively to all this, add

MYSQL_VERSION_DEFAULT=          57

to /etc/mk.conf and re-install p5-DBD-mysql

}-- End of excerpt from Greg Troxel