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

*/*: Refactor with IGNORE_WITH_MYSQL

- There are multiple ports which has MYSQL options and are non-DEFAULT.
  Most of the time committers actually forget to check with the OPTION
  enabled and in some cases they are BROKEN with newr versions of mysql.
  So test with different versions of mysql and mark IGNOPRE_WITH_MYSQL
  appropriately. Due to the EOL of 5.7 this has not been checked.
- Unbreak sysutils/cfengine* with MySQL 8.0 and later
- The primary purpose of running this check is having statistics of the
  MySQL usability over MariaDB to explore the future possibility of
  shifting to MariaDB as the default as major ports upstream have moved
  their codebase to support MariaDB over MySQL.
- The following actions will also be taken after the sunset of MySQL 5.7
  If a port is broken on all instances of MySQL/MariaDB:
  - If a port has the option of multiple DB backends and MySQL is the
    default then the DEFAULT will be changed to PGSQL/SQLITE before
    2024Q1. And the OPTION will be removed before 2024Q2. If a
    MAINTAINER is aware about such cases and want to prefer PGSQL over
    SQLITE or vice versa please do so at your own accord. Otherwise
    PGSQL will be preferred over SQLITE.
  - If a port has the option of multiple DB backends and MySQL is not
    the default then the the OPTION will be removed before 2024Q1.

Approved by:	portmgr (blanket)

Mk/**ldap.mk: Convert USE_LDAP to USES=ldap

Convert the USE_LDAP=yes to USES=ldap and adds the following features:

- Adds the argument USES=ldap:server to add openldap2{4|5|6}-server as
  RUN_DEPENDS
- Adds the argument USES=ldap<version> and replaces WANT_OPENLDAP_VER
- Adds OPENLDAP versions in bsd.default-versions.mk
- Adds USE_OPENLDAP/WANT_OPENLDAP_VER in Mk/bsd.sanity.mk
- Changes consumers to use the features

Reviewed by:	delphij
Approved by:	portmgr
Differential Revision: https://reviews.freebsd.org/D38233

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.

mail: remove 'Created by' lines

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

  *  <ashish@FreeBSD.org>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam David <adam@FreeBSD.org>
  *  Adam McDougall <mcdouga9@egr.msu.edu>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alex Deiter <tiamat@komi.mts.ru>
  *  Alex Dupre <ale@FreeBSD.org>
  *  Alex Dupre <sysadmin@alexdupre.com>
  *  Alex Perel <veers@disturbed.net>

all: Remove all other $FreeBSD keywords.

Remove # $FreeBSD$ from Makefiles.

Move remaining USE_MYSQL, WANT_MYSQL_VER to USES=mysql

mail/tpop3d: remove support for expired mail/drac

Add forgotten patches by previous commit.

Pointy hat to:		krion

Add patches to avoid accessing unallocated memory.

buffer_consume_to_mark() was trying to use Boyer-Moore search to
find specified mark string but implementation was walking through
unallocated memory.

PR:		227543
Submitted by:	Jeremy Chadwick <jdc@koitsu.org>

Update `databases/gdbm' to version 1.18.1, an important bugfix release
which restores compatibility with old databases (version 1.8) and some
later versions which were built without mmap(2) support.  Due to shlib
version change, bump port revisions of the consumer ports.

PR:		233059
Exp-run by:	antoine
Approved by:	maintainer (johans, numerous timeouts)

mail/tpop3d: Configure SSL library properly

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

With hat:	portmgr
Sponsored by:	Absolight

Fixup some whitespace at the beginning of lines problems.

With hat:	portmgr
Sponsored by:	Absolight

MASTER_SITES cleanup.

- Replace ${MASTER_SITE_FOO} with FOO.
- Merge MASTER_SITE_SUBDIR into MASTER_SITES when possible. (This means 99.9%
  of the time.)
- Remove occurrences of MASTER_SITE_LOCAL when no subdirectory was present and
  no hint of what it should be was present.
- Fix some logic.
- And generally, make things more simple and easy to understand.

While there, add magic values to the FESTIVAL, GENTOO, GIMP, GNUPG, QT and
SAMBA macros.

Also, replace some EXTRACT_SUFX occurences with USES=tar:*.

Checked by:	make fetch-urlall-list
With hat:	portmgr
Sponsored by:	Absolight

- Fix build when GDBMAUTH=on [1]
- Use options helpers
- Correct CFLAGS handling - don't append "-g -O2" to our flags
- Remove optional installation of DOCS, staging takes care of that

PR:		198918 [1]
Reported by:	vas@mpeks.tomsk.su [1]

Finally retire USE_PGSQL

net/openldap24-*:
- Convert to USES=libtool and bump dependent ports
- Avoid USE_AUTOTOOLS
- Don't use PTHREAD_LIBS
- Use MAKE_CMD

databases/glom:
- Drop :keepla
- Add INSTALL_TARGET=install-strip

databases/libgda4* databases/libgda5*:
- Convert to USES=libtool and bump dependent ports
- USES=tar:xz
- Use INSTALL_TARGET=install-strip
- Use @sample

Fix some non default LIB_DEPENDS

With hat:	portmgr

Add DOCS to OPTIONS_DEFINE to ports that check for PORT_OPTIONS:MDOCS.

mail/tpop3d: stage and explicitly link libcrypto (dports)

* Use modern options for configuration and dependencies
* Use @sample keyword
* Use PORTDOCS unconditionally

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

With hat:	portmgr

Fix properties on pkg-plist

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

Move the rc.d scripts of the form *.sh.in to *.in

Where necessary add $FreeBSD$ to the file

No PORTREVISION bump necessary because this is a no-op

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.

- Track dependencies after databases/gdbm update

- remove MD5

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

- Update to 1.5.5.

PR:             ports/138329
Submitted by:   Sylvio Cesar <scjamorim@bsd.com.br>
Approved by:    Boris Kovalenko <boris@tagnet.ru> (maintainer)

Update CONFIGURE_ARGS for how we pass CONFIGURE_TARGET to configure script.
Specifically, newer autoconf (> 2.13) has different semantic of the
configure target. In short, one should use --build=CONFIGURE_TARGET
instead of CONFIGURE_TARGET directly. Otherwise, you will get a warning
and the old semantic may be removed in later autoconf releases.

To workaround this issue, many ports hack the CONFIGURE_TARGET variable
so that it contains the ``--build='' prefix.

To solve this issue, under the fact that some ports still have
configure script generated by the old autoconf, we use runtime detection
in the do-configure target so that the proper argument can be used.

Changes to Mk/*:
 - Add runtime detection magic in bsd.port.mk

- Update to 1.5.4

PR:             ports/125145
Submitted by:   Bartlomiej Syryjczyk <bartlomiej.syryjczyk@expro.pl>
Approved by:    Boris Kovalenko <boris@tagnet.ru> (maintainer)

- Add "Save mbox indices" option
- Accomodate OPTIONS algorithm change

PR:             112070
Submitted by:   Boris Kovalenko <boris@tagnet.ru> (maintainer)

- Install config files with right permissions by s/INSTALL_SCRIPT/INSTALL_DATA/
- Bump PORTREVISION

PR:             111845
Submitted by:   Alexander Logvinov <ports AT logvinov.com>
Approved by:    Boris Kovalenko <boris AT tagnet.ru> (maintainer),
                clsung (mentor)

- Add /etc/passwd authentication method support
- Bump PORTREVISION

PR:             111806
Submitted by:   Alexander Logvinov <ports AT logvinov.com>
Approved by:    Boris Kovalenko <boris AT tagnet.ru> (maintainer),
                clsung (mentor)

This update contains extra patch which is not approved by Chris Lightfoot
(the tpop3d author) as he is unreachable for a long time period. Indeed this
patch may help people who have coredumps with auth-perl and multithreaded perl.
Big thanks to George A Eliseeff <kuzmich at inbox.ru>.

PR:             ports/106365
Submitted by:   Boris Kovalenko <boris@tagnet.ru> (maintainer)

- Proper startup order for rcNG script

PR:             ports/103133
Submitted by:   Boris Kovalenko <boris@tagnet.ru> (maintainer)
Sponsored by:   FreeBSD Bug-a-thon #2

- Change the way OPTIONS is checked as suggested by Porters Handbook

PR:             ports/100158
Submitted by:   Boris Kovalenko <boris tagnet.ru> (maintainer)

- Update rcNG script to allow startup on 6.1-RELEASE.
  Bump PORTREVISION.
- Cosmetic fixes

PR:     ports/99537
Submitted by:   maintainer
Approved by:    delphij (mentor)

Remove USE_REINPLACE from ports starting with M

Remove the FreeBSD KEYWORD from all rc.d scripts where it appears.
We have not checked for this KEYWORD for a long time now, so this
is a complete noop, and thus no PORTREVISION bump. Removing it at
this point is mostly for pedantic reasons, and partly to avoid
perpetuating this anachronism by copy and paste to future scripts.

SHA256ify

Approved by: krion@

- Add option for optional DRAC RFC for POP-before-SMTP relaying (default off)

PR:             ports/85518
Submitted by:   Boris Kovalenko <boris@tagnet.ru> (maintainer)

At Kris's request, back out the MACHINE_ARCH spelling correction until
after 5.4-RELEASE.

Assist getting more ports working on AMD64 by obeying the
Ports Collection documentation and use 'ARCH' rather than 'MACHINE_ARCH'.

- Remove unnecessary IS_INTERACTIVE from Makefile
- Added patch to prevent crashing whith nonexistent maildir

PR:             ports/79495
Submitted by:   maintainer

Second patch form the PR was missed
- Found serious OPTIONS interaction errors. Fixed.

PR:             ports/78723
Submitted by:   Boris Kovalenko <boris@tagnet.ru> (maintainer)

- Minor changes to be sure Maildir will be properly compiled
  if options was changed.
-Pass maintainership to submitter

PR:             ports/78723
Submitted by:   Boris Kovalenko <boris@tagnet.ru>
Approved by:    Chris Elsworth <chris@shagged.org> (maintainer)

- Use OPTIONS, add more options
- Provide RCng script
- Tweaks

PR:             ports/78659
Submitted by:   Boris Kovalenko <boris@tagnet.ru>
Approved by:    Chris Elsworth <chris@shagged.org> (maintainer)

- Add missing TLS support

PR:             ports/75331
Submitted by:   Gea-Suan Lin <gslin(at)netnews.NCTU.edu.tw>
Approved by:    maintainer

- Change optional LDAP dependency from openldap20-client which is gone,
  to openldap22-client.

Bumped into by: Sean McNeil <sean@mcneil.com>

SIZEify (maintainer timeout)

- Update to 1.5.3

While I'm here:
- Group related Makefile variables together
- Combine some .if's
- Install some documentation

PR:             59689
Submitted by:   maintainer

use REINPLACE instead of perl to fix build on 5.x

Submitted by:   maintainer
Noticed by:     bento via kris

use USE_MYSQL

PR:             57645
Approved by:    maintainer timeout (3 weeks)

Update to 1.5.2
Added a better sample configuration file

PR:             56629
Submitted by:   maintainer

- Fix typo in CONFIGURE_ARGS

Submitted by:   maintainer

- Update to 1.5.1

PR:             55801
Submitted by:   maintainer

Fix non-default dependency on openldap2[012] which is broken by splitting.

# I'm not bumped port revision of them because this should not affect
# packages built on bento...

Point dependencies on net/openldap2 to net/openldap20

De-pkg-comment.

upgrade to 1.4.2

PR:             40016
Submitted by:   maintainer

Update to 1.4.1.
Add OpenLDAP support.

PR:             37141
Submitted by:   maintainer

Update to 1.3.5    

add tpop3d 1.3.4   Virtual-domain capable POP3 server supporting MySQL auth