databases/ateam_mysql57_ldap_auth: Remove expired port

Depends on upstream EOL MySQL 5.7

*/*: 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)

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

Homepage link is permanent redirected to its HTTPS counterpart

databases/mysql-udf: Mark DEPRECATED

- Upstream mentions about using MySQL 4.0 and has not been updated since
  2007
- Set EXPIRATION_DATE on 2023-12-31 along with MySQL 5.7
- Add LICENSE=BSD2CLAUSE as mentioned in their homepage
- Mark to ignore with mysql 8.0 [1]

PR:		269203 [1]
Reported by:	exp-run [1]

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/mysql-udf: always add -fPIC

This fixes build for armv6 and armv7

PR:	265565
Reported by:	fuz@fuz.su (maintainer)
MFH:	2022Q3 (build fixes)

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>

databases/mysql-udf: fix build on riscv64

Same issue as other architectures.

databases/mysql-udf: remove redundant +

While here, add the same for armv7 to fix build.

Remove # $FreeBSD$ from Makefiles.

Canonicalize flags for powerpc64le as per powerpc64.

databases/mysql-udf: fix build on powerpc(64) with clang

Error:
ld: error: relocation R_PPC64_TOC16_LO cannot be used against symbol
compare_doubles(void const*, void const*); recompile with -fPIC

Convert to UCL & cleanup pkg-message (categories d)

databases/mysql-udf: enable PIC on arm64 and i386, for lld

Shared objects should be built as PIC, and lld enforces this by default.
Add aarch64 and i386 cases to the existing set of per-arch CFLAGS, and
remove the BROKEN_aarch64.

Approved by:	portmgr (lld blanket)
Sponsored by:	The FreeBSD Foundation

Mark these ports as broken on aarch64, and, where appropriate, armvX.

While here, pet portlint and modernize.

Approved by:	portmgr (tier-2 blanket)

databases/mysql-udf: Fix building with MariaDB

  - Work around MySQL's include/mysql/mysql directory
    - Add -I ${LOCALBASE}/include to CFLAGS
  - Move from USE_MYSQL to USES= mysql

PR:		199556

- Fix trailing whitespace in pkg-descrs, categories [a-f]*

Approved by:	portmgr blanket

Cleanup plist

Support STAGEDIR.

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

- Install files to correct plugins path [1]
- Do silent cat pkg-message

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_plugin_dir

PR:             ports/162562 [1]
Submitted by:   Panagiotis Christias <p.christias@noc.ntua.gr> [1]

Feature safe:   yes

- remove maintainer tags from pkg-descr

Approved by:    portmgr
Approved by:    bapt (mentor)

Remove references to mysql 323 and 40, most commonly of the form:

IGNORE_WITH_MYSQL=     323 40

Transfer maintainer back to ports@FreeBSD.org

Approved by:    maintainer (myself)

- Get Rid MD5 support

Bump PORTREVISION for ports linking to default libmysqlclient.

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

This package adds several user-defined statistical functions
to the MySQL server providing the ability to:

    * calculate the median of any values,
    * calculate the skewness and kurtosis of a distribution of value
    * retrieve the effective length of the longest value in a STRING column,
    * get the longest value from a STRING column,
    * calculate the faculty of a value,
    * calculate linear regression parameters (intercept, slope, correlation
      coefficent) of any values

WWW: http://mysql-udf.sourceforge.net/