*/*: 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
Issue reported by repology : https://repology.org/repository/freebsd/problems

Approved by:	portmgr (blanket)
PR:		274888

net/linknx: Fix build with llvm16

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

net/linknx: Fix build with libesmtp 1.1.0

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.

net: remove 'Created by' lines

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

  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Aaron Straup Cope <ascope@cpan.org>
  *  Aaron Zauner <az_mail@gmx.at>
  *  Adam Jette <jettea46@yahoo.com>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Alan Eldridge <alane@geeksrus.net>
  *  Alex Bakhtin <Alex.Bakhtin@gmail.com>
  *  Alex Deiter <Alex.Deiter@Gmail.COM>
  *  Alex Dupre <ale@FreeBSD.org>
  *  Alex Dupre <sysadmin@alexdupre.com>

all: Remove all other $FreeBSD keywords.

Remove # $FreeBSD$ from Makefiles.

This port now builds on aarch64.

While here, pet portlint (ordering of BROKEN_* declarations).

Approved by:	portmgr (tier-2 blanket)

Move remaining USE_MYSQL, WANT_MYSQL_VER to USES=mysql

Add DOCS options to ports that should have one.

Also various fixes related to said option.

PR:		230864
Submitted by:	mat
exp-runs by:	antoine

net/linknx: Fix build with Clang 6

objectcontroller.cpp:659:27: error: non-constant-expression cannot be narrowed
from type 'int' to 'uint8_t' (aka 'unsigned char') in initializer list
[-Wc++11-narrowing]
    uint8_t buf[2] = { 0, (isWrite ? 0x80 : 0x40) | (getBoolObjectValue() ? 1 :
0) };
                         
^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

http://beefy12.nyi.freebsd.org/data/head-amd64-default/p479076_s338486/logs/errors/linknx-0.0.1.32.log

PR:		230897
Submitted by:	tobik
Approved by:	bkoenig@alpha-tierchen.de (maintainer timeout, 2 weeks)

Remove non ascii characters.

Sponsored by:	Absolight

Mark more recently failing ports broken on aarch64.

While here, pet portlint and reformat some other BROKEN statements.

Approved by:	portmgr (tier-2 blanket)

For ports that are marked BROKEN on armv6, and also fail to build on
armv7, mark them so.

This is part two of a multipart commit to bring armv7 ports to parity
with armv6.

Approved by:	portmgr (tier-2 blanket)
Obtained from:	lonesome.com -exp run

Mark some ports failing on armv6, for errors classified as "configure_error".

Note: this skips all the ports that _sometimes_ fail with CMake errors.  We
need to investigate that problem, and find out if it is specific to the qemu
environment.

While here, pet portlint.

Approved by:	portmgr (tier-2 blanket)

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

With hat:	portmgr
Sponsored by:	Absolight

Make buildable again by upgrading to 0.0.1.32.

Sponsored by:	Absolight

mail/libesmtp:
- Convert to USES=libtool and bump dependent ports
- Use option helpers
- Remove PTHREAD_CFLAGS and PTHREAD_LIBS
- Add INSTALL_TARGET=install-strip

Mark BROKEN: Fails to configure

===>  Configuring for linknx-0.0.1.30_1
configure.ac:33: error: possibly undefined macro: AC_DEFINE
      If this token and others are legitimate, please use m4_pattern_allow.
      See the Autoconf documentation.
configure.ac:88: error: possibly undefined macro: AC_MSG_RESULT
configure.ac:114: error: possibly undefined macro: AC_SUBST
*** [run-autotools-autoconf] Error code 1

Reported by:	pkg-fallout

Fix build with clang/libc++
Fix regeneration of the configure [1]
While here switch to lua 5.2

Reported by:	mat [1]

Try to unbreak after conversion to OPTIONS helpers

Reported by:	pkg-fallout

Add forgotten patch and fix build.

- Update to 0.0.1.30
- Add LUA and MySQL support
- Convert to new options framework
- Support staging
- Add LICENSE
- New LIB_DEPENDS format

maintainer timeout.

PR:		ports/184589
Submitted by:	mat

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

- Update to 7.31.0
- Bump PORTREVISION for ftp/curl shlib change
- Add TEST_DEPENDS
- Convert to new options framework
- Adjust options:
  - Add COOKIES
  - Add CYASSL, NSS, POLARSSL, THREADED_RESOLVER, TLS_SRP [1]
  - Add GSSAPI and SPNEGO [2]
  - Remove KERBEROS4
  - Rename LIBIDN to IDN
  - Remove TRACKMEMORY [1]
- Sort option handler
- Add SLAVEDIRS: ftp/curl-hiphop
- Cosmetic change
- Cleanup Makefile header
- While I'm here, fix typo (PORTREVSION) in x11-wm/ede/Makefile

Changes:	http://curl.haxx.se/changes.html
PR:		ports/172325 (-exp run), ports/177369 (based on) [1]
Submitted by:	Hirohisa Yamaguchi <umq@ueo.co.jp> [1], hrs (via email) [2]
Exp run by:	miwi

Convert to new options framework, while here cleanup linknx

- Chase libesmtp shlib bump

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.

Remove painful examples of foo="", with particular prejudice against
constructions that parse out to [ -z "$foo" ] && foo=""

These are bad examples that get copied and pasted into new code, so the
hope is that with less bad examples there will be less need for me to
bring this up in review.

In a few of these files all that were changed were comments so that next
time I search for these patterns I won't trip on the file for no reason.

In a few places, add $FreeBSD$

No functional changes, so no PORTREVISION bumps

- Get Rid MD5 support

Chase the ftp/curl shlib version bump.

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

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

Bump the version of the curl shared library after the ftp/curl update
to 7.19.2.
Bump PORTREVISION, even on the ports that do not have a versioned
dependency, since the binaries will most probably still stop working.

LinKNX is a backend for controlling a KNX/EIB home and building automation
system. It connects to eibd which is part of the BCU SDK and keeps state of
KNX devices such as lamps, window blinds, heating and so on.
Furthermore it provides a powerful, rule-based event after treatment, e.g.
for switching other KNX devices, sending e-mail or SMS or executing a shell
command. You can configure and control the LinKNX daemon using an XML-style
protocol via TCP network socket or Unix domain socket.

WWW: http://linknx.sourceforge.net/

PR:             ports/128320
Submitted by:   Björn König <bkoenig at alpha-tierchen.de>