databases/p5-DBD-mysql: Fix for MariaDB users

Add a new variable DBD_MYSQL, use that in *_DEPENDS and add mysql to USES
where required. DBD_MYSQL will automatically set the correct DBD dependency.

In cd16748194e2 databases/p5-DBD-mysql was updated to 5.x, in 5.x the
support for MariaDB was removed and only MySQL >= 8.0 is supported.

In the 4.x releases MariaDB is still supported, according to upstream 4.x
will still be supported for a while [1], so use that for now when we detect
that MYSQL_FLAVOUR is set to mariadb. databases/p5-DBD-mysql4 was added in
d95f49cb3b54.

DBD:MariaDB would be another alternative, but migrating to it might need
more analysis than just staying with the 4.x releases of p5-DBD-mysql. This

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>

Remove # $FreeBSD$ from Makefiles.

Fix every instance of RUN_DEPENDS:=${BUILD_DEPENDS} in p5 ports, except
for where it resulted in a change in output from build-depends-list or
run-depends-list.

Approved by:	portmgr (adamw)

Update WWW

search.cpan.org is shutting down.
It will redirect to metacpan.org after June 25, 2018.

With hat:	perl

Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight

Reassign databases/ perl modules to perl@.

Also:
- Sort plists
- Sort DEPENDS
- Add TEST_DEPENDS where necessary
- p5-Class-DBI-DDL: switch to USE_PERL5=configure
- Remove unnecessary or unusual stuff from pkg-descr's
- Regenerate patches using makepatch where necessary
- Based on the description from p5-DBIx-Password (most of which I've
  excised), it isn't clear whether this module even works when it's
  built non-interactive
- p5-DBIx-Simple: Make all the OPTIONS dependencies BUILD_DEPENDS
  as well
- p5-T2: Fails 'make test' (as it did before). The module isn't even
  present on CPAN or Meta::CPAN, and should probably be considered
  for deletion

Change the way Perl modules are installed, update the default Perl to 5.18.

Before, we had:

  site_perl :           lib/perl5/site_perl/5.18
  site_perl/perl_arch : lib/perl5/site_perl/5.18/mach
  perl_man3 :           lib/perl5/5.18/man/man3

Now we have:

  site_perl : lib/perl5/site_perl
  site_arch : lib/perl5/site_perl/mach/5.18
  perl_man3 : lib/perl5/site_perl/man/man3

Modules without any .so will be installed at the same place regardless of the

Cleanup plist

Support STAGEDIR.

Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)

- Convert to new perl framework

- Reassign to the heap at maintainer's request

- Remove SITE_PERL from *_DEPENDS

Approved by: portmgr@ (bapt@)

At the moment 1385 ports use BUILD_DEPENDS= ${RUN_DEPENDS} and 450
ports use BUILD_DEPENDS:= ${RUN_DEPENDS}. This patch fixes ports that are
currently broken. This is a temporary measure until we organically stop using
:= or someone(s) spend a lot of time changing all the ports over.

Explicit duplication > := > = and this just moves ports one step to the left

Approved by:    portmgr

- Get Rid MD5 support

- Take advantage of CPAN macro from bsd.sites.mk, change
${MASTER_SITE_PERL_CPAN} to CPAN.

PR:             ports/122674
Submitted by:   Philip M. Gollucci <pgollucci@p6m7g8.com>
Reworked by:    araujo (myself)
Approved by:    portmgr (pav)

Update to 1.00

PR:             ports/93861
Submitted by:   lth
Approved by:    maintainer

SHA256ify

Approved by:    krion@

Replace ugly "@unexec rmdir %D... 2>/dev/null || true" with @dirrmtry

Approved by:    krion@
PR:             ports/88711 (related)

update p5-Class-DBI-mysql to 0.23

PR:             67234
Submitted by:   Andrew McNaughton <andrew@scoop.co.nz>

SIZEify (maintainer timeout)

Updated to 0.21

PR:     ports/58076

Add p5-Class-DBI-mysql 0.17, extensions to Class::DBI for MySQL.

PR:             55583
Submitted by:   Andrew McNaughton <andrew@scoop.co.nz>