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

MANPREFIX: eleminate its usage  and move man to share/man

*/*: Update WWW to use HTTPS for sourceforge.net projects

Homepage link is permanent redirected to its HTTPS counterpart

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.

Mk/Uses/perl5.mk: Remove outdated P5_POD_PARSER

lang/perl5.30 has been removed in b3fb5d8b3c860bd3c3ebcffafe621aea61379539.

mail/sqlgrey: Use P5_POD_PARSER

With hat:	perl

One more small cleanup, forgotten yesterday.
Reported by:	lwhsu

all: Remove all other $FreeBSD keywords.

Remove # $FreeBSD$ from Makefiles.

Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330

Remove Created by lines where I am the one.

Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590

Fix rc Script

PR:		209448
Submitted by:	Miroslav Lachman

Remove ${PORTSDIR}/ from dependencies, categories m, n, o, and p.

With hat:	portmgr
Sponsored by:	Absolight

- Clarify LICENSE
- Add LICENSE_FILE
- Add NO_ARCH
- Cleanup etcdir handling
- Switch to options helpers
- Cosmetic fixes

mail/sqlgrey: Fix missing dependencies (bash, wget, md5sum)

PR:		205754
Submitted by:	me@cschwarz.com

Fix usage of ${PERL5}.

${PERL5} points to a specific version of perl, say, perl5.22.1, it is
fine to use it in a ports Makefile to do Perly things, but ports using
it must use ${PERL}, that points to /usr/local/bin/perl so that if the
minor version is updated, the shebang keep working.

While there, make some ports use shebangfix, regen a few patches, and
bump PORTREVISION where a shebang went from PERL5 to PERL.

PR:		205367
With hat:	portmgr
Sponsored by:	Absolight

Cleanup plist

License is supposed to have a lower case "v" or some build
environments will error with:

 License GPLV2 needs confirmation, but BATCH is defined

as it will be an unrecognized license.

Revive from the dead. This port is too important to let slip through the
cracks.

- Support STAGE
- Appease rclint and portlint
- Remove pkg-install. We can do this in @unexec and rc script.
- Set a default database option -- PGSQL will be default as recommended
upstream.
- Use new @sample capability
- SHEBANGFIX

Sponsored by:	SupraNet Communications, Inc

Remove non staged ports without pending PR from ma*

Resetting maintainership on ports that have not been staged and without any
pending PR (related to stage)

With hat:	portmgr

Import patch to fix IPv6 greylisting

This patch is floating in the bug system on SourceForge. Upstream
develoment is slow/nonexistent.

If you have IPv6 mail servers and run sqlgrey you may notice emails from
places like GMail sometimes get lost or take forever to get be received.
This is because GMail does not retry from the same server, and they have
a large pool of IPv6 capable MTAs. For IPv4 sqlgrey handles this by
whitelisting the entire /24, but similar logic for whitelisting a /64 in
sqlgrey doesn't work consistently. This fixes it.

PR:		ports/182440
Approved by:	crees (mentor), maintainer timeout

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

- convert to the new perl5 framework
- convert USE_GMAKE to Uses

Approved by:	portmgr (bapt@, blanket)

Convert to new options framework

- Remove SITE_PERL from *_DEPENDS

Approved by: portmgr@ (bapt@)

Update SQLgrey to 1.8.0
Use UIDs/GIDs infractructure (new uid/gid 226)

PR:             ports/165103
Approved by:    maintainer

In the rc.d scripts, change assignments to rcvar to use the
literal name_enable wherever possible, and ${name}_enable
when it's not, to prepare for the demise of set_rcvar().

In cases where I had to hand-edit unusual instances also
modify formatting slightly to be more uniform (and in
some cases, correct). This includes adding some $FreeBSD$
tags, and most importantly moving rcvar= to right after
name= so it's clear that one is derived from the other.

Add corrections in RC script from Doug.

Submitted by:   dougb@

- Update to 1.8.0rc2.
- Rename RC script.

PR:             ports/157485
Submitted by:   Ryan Steinmetz (rpsfa@rit.edu)
Approved by:    chifeng <chifeng@gmail.com> (maintainer)

Begin the process of deprecating sysutils/rc_subr by
s#. %%RC_SUBR%%#. /etc/rc.subr#

Fix dependency

PR:             140102
Submitted by:   Frank Wall <fw@moov.de>
Approved by:    maintainer

- Switch SourceForge ports to the new File Release System: categories starting
with M

- Pass maintainership to submitter

Submitted by:   chifeng via freebsd-ports@

- Update to 1.7.6

PR:             120259
Submitted by:   bartlomiej.syryjczyk@expro.pl

- Update to 1.7.5

- Convert to OPTIONS
- Add optional rundep on Date::Calc for sqlgrey-logstats.pl script

Requested by:   Miroslav Lachman <000.fbsd@quip.cz>

- Remove old Perl support from unmaintained ports in categories starting
  with letter k-n

- Typo in Makefile (RUN_DEPENDS) prevent mail/sqlgrey from install with
  pgsql support.
- Some cosmetic cleanup patch for fresh install.

PR:             ports/104881
Submitted by:   Olli Hauer <ohauer@gmx.de>

- Update to 1.7.4

Unbreak by removing manual attempt to install rc.d script,
and a few other fixes.

Pet portlint.

BROKEN: Uses USE_RC_SUBR incorrectly; incorrect pkg-plist

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

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

Upgrade to 1.7.3

Update to 1.6.7
give back to ports@ (ENOTIME)

PR:             89418
Submitted by:   den

Be hipe and add SHA256

- Update to 1.4.8

PR:             ports/82318
Submitted by:   Alex Kapranoff <kappa@rambler-co.ru>
Approved by:    mat (maintainer)

* reflect renaming on CPAN File-Spec to PathTools
   + add devel/p5-PathTools, remove devel/p5-File-Spec
   + update dependencies for all affected ports (make them unconditional),
     bump PORTREVISION for these ports
module was renamed
* reflect renaming on CPAN PodParser to Pod-Parser
   + add textproc/p5-Pod-Parser, remove textproc/p5-PodParser
   + update dependencies for all affected ports (make them unconditional),
     bump PORTREVISION for these ports

* for all changed ports make dependencies on File::Temp, Digest::MD5,
  Storable unconditional

* remove 'CONFIGURE_ARGS= INSTALLDIRS=site' from Makefile's
  (this variable is forced by bsd.port.mk now)

* update Class-Autouse to 1.17

* update POE-API-Hooks to 1.05

* make portlint happy (clean IGNORE, convert spaces to tabs and so on)

Fix sqlgrey.conf's path in sqlgrey.sh [1]
fixup a few other things while I'm there
bump PORTREVISION

Poked by: flz [1]

Don't mix SUB_LIST and PLIST_SUB, it's a bad idea [1] :-)
+ minor fix in the Makefile

Pointed out by: [1] kris via pointyhat

Add sqlgrey 1.4.5, greylisting policy server for Postfix using an SQL backend.