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

net/rtg: Moved man to share/man

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

*/*: Remove merged or non-existent USE_PHP directives

- Remove USE_PHP=hash which is available in default php installation of
  all versions of php
  * security/pear-Horde_Crypt_Blowfish: Remove OPTION MHASH
- Remove USE_PHP=json which is available in default php installation of
  all versions of php
  * devel/pear-PHPTAL: Remove OPTION JSON
  * www/ilias: Remove OPTION SCORM2004
- Remove USE_PHP=mssql which is no longer available in php from php80
  and later and has been replaced with sqlsrv module which is Windows
  only
  * www/codeigniter: Remove OPTION MSSQL
  * www/moodle311: Remove OPTION MSSQL
  * www/moodle39: Remove OPTION MSSQL

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.

net/rtg: Update to 0.7.5

* Updated to latest cgilib (0.7)
* Removed old GD/PNG/ZLIB bundled libraries for ease of upgrading
* Added -b (background/daemonise) flag to rtgpoll
* Added -p <file> (PID file) flag to rtgpoll
* Added graph titles and legends to rtgplot
* Updated PHP scripts from ancient mysql to newer mysqli library
* Fixed many potential SQL injection and other vulnerabilities
* Updated MySQL support to compile against MySQL 8.0+
* Updated MySQL support to use mysql_config to pull in
  CFLAGS/LDFLAGS required depending on MySQL build
* Updated MySQL table schemas to support clustered MySQL setups
* Updated MySQL table schemas to improve speed (indexes)
* Added MySQL option to auto-reconnect if MySQL server goes away

Fix build with -fno-common

Add more missing USES=php

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

(and missed 3 missed files from previous categories.)

Patch createdb script to avoid race condition / file tampering

During the initialization net/rtg uses the /tmp/mysql.sql
and /tmp/rtg.sql to store the SQL commands executed in the
database with special user privileges.

Using well known files can lead to a race condition between
two process who uses the same file names and allow file
tampering by a malicious user.

This fix uses mktemp command to create temporary files
in a safe way

PR:		238262
Submitted by:	rodrigo
Approved by:	freebsd-ports@dan.me.uk (maintainer timeout)
MFH:	2019Q3

Fix net/rtg with modern perl and php

 * Fix runtime PHP errors if short_opentag is disabled (default)
 * Remove most PHP warnings/notices that go to error_log
 * Fix HTML output to be valid
 * Fix quoting of SQL objects
 * Fix escaping of user-provided SQL data (potential sql injection)
 * Widen fields in 95.php and 95.pl for interface and router names
 * Fix warnings in perl modules in newer perl versions
 * Fix createdb script to use CREATE USER/GRANT not manipulate user db directly
 * Add "Update_desc" config entry to auto-update port descriptions from snmp
 * Update default SNMP version to 2

PR:		227376
Submitted by:	<freebsd-ports@dan.me.uk> (maintainer)

net/rtg: Drop nop WANT_PERL

Perl seems to be wanted so add USES=perl5 instead.

Revert r484406, it was never approved.

Pointy hat:	mfechner
With hat:	portmgr

* Fix runtime PHP errors that stop the code working if short_opentag is disabled
(default!)
* Remove most PHP warnings/notices that go to error_log
* Convert patches to new format where needed
* Fix HTML output to be valid
* Fix quoting of SQL objects
* Fix escaping of user-provided SQL data (potential sql injection)
* Widen fields in 95.php and 95.pl for interface and router names
* Fix warnings in perl modules in newer perl versions
* Fix createdb script to use CREATE USER/GRANT not manipulate user db directly
* Add "Update_desc" config entry to auto-update port descriptions from snmp
* Update default SNMP version to 2
* Although this doesn't reference any CVE's, it does contain fixes for potential
security issues

PR:		227376
Submitted by:	freebsd-ports@dan.me.uk (maintainer)
Reported by:	freebsd-ports@dan.me.uk (maintainer)
Reviewed by:	mfechner
Approved by:	mentors (timeout), portmgr (timeout)
MFC after:	2 days
Differential Revision:	https://reviews.freebsd.org/D17637

Patch based off of revision 434135

Fix configuration paths in CGIs and reports to include /usr/local/etc/rtg.
Affects common.php, reports.pl, and 95.pl.  This will fix the CGIs to almost
work out of the box.

Improve rtgtargmkr.pl to skip unresponsive routers rather than dying.

Add USES=ssl

PR:		217108
Submitted by:	andrew.fengler@scaleengine.com
Approved by:	maintainer timeout (15 days)

Improve RTG port

Summary:
Add 'rtg' user and group in UIDs/GIDs.
Use daemon(8) to daemonize rtgpoll.
Add prestart commands to set correct permissions for RTG's files.

Reviewers: swills, allanjude, xmj, andrew.fengler_scaleengine.com,
#contributor_reviewers_ports, matthew

Reviewed By: #contributor_reviewers_ports, matthew

Subscribers: matthew, mat

Differential Revision: https://reviews.freebsd.org/D7486

Unmark broken on powerpc64

These ports built successfully

- Fix trailing whitespace in pkg-descrs, categories [g-n]*

Approved by:	portmgr blanket

many ports: mark broken on powerpc64

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

With hat:	portmgr
Sponsored by:	Absolight

- Fix shebangs

Approved by:	portmgr blanket
MFH:		2015Q3 (blanket)

Remove OSVERSION checks that do not make sense any more.

For example (${OSVERSION} >= 900000 && ${OSVERSION} < 900021) is always true,
as is (${OSVERSION} > 900002 || ${OSVERSION} < 900000 && ${OSVERSION} > 800107).

Regarding patches, when an EXTRA_PATCHES is no longer needed, I remove it, when
it is always needed, I renamed it, in one case, I merged two patches.

Differential Revision:	https://reviews.freebsd.org/D2209

net category: Remove $PTHREAD_LIBS

openafs did not pass check-plist (pre-existing) so fixed and bumped.
Also, pkg-plist was sorted.  mediatomb and spread also fail plist-checks
but they weren't fixed.

approved by:	PTHREAD blanket

Cleanup plist

Remove indefinite articles and trailing periods from COMMENT, plus minor
COMMENT typos and surrounding whitespace fixes. A few Makefiles where not
included as they contain Latin-1 characters that break the Phabricator
workflow. Category N.

CR:		D307
Approved by:	portmgr (bapt)

- Update to use PHP mysqli extensions (as mysql extension is deprecated
  these days)
- Fix runtime dependencies to pull in perl's DBI and DBD::mysql modules for
  target maker.
- Add some options to pull in dependencies for mysql server and php web
  modules if needed.

PR:		191276
Submitted by:	 Daniel Austin <freebsd-ports@dan.me.uk> (maintainer)

- Add a backup mirror

PR:		191013

- Convert to STAGE

PR:		ports/189620
Submitted by:	maintainer

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

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.

- Chase net-snmp shlib version bump.

- Get Rid MD5 support

Bump PORTREVISION for ports linking to default libmysqlclient.

- Use .sample for sample config so that upgrades dont overwrite
  user-modified config files
- Added note to explain where/how to use rtgplot
- Added graph titles and friendly legend tags
- Modified rc script to load after mysql

PR:             ports/148363
Submitted by:   Daniel Austin MBCS <freebsd-ports AT dan.me.uk> (maintainer)

- Add rc.d script.
- Optimise db table creation with indexes.
- Add PID file option.
- Fix a few warnings in the Makefile.
- Assign maintainership to submitter.

PR:             145924
Submitted by:   Daniel Austin <freebsd-ports@dan.me.uk>
Feature safe:   yes

- Chase net-snmp shlib bump

- Fix custom LOCALBASE build
- USE_MYSQL macro unless there is a reason to depend specifically on mysql41
- Use SF MASTER_SITES abbreviation

PR:             136678
Submitted by:   Sahil Tandon <sahil@tandon.net>
Feature safe:   yes

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

- Chase shlib version of net-mgmt/net-snmp which I've forgotten.
- Bump PORTREVISIONs again.

- Chase shlib version of net-mgmt/net-snmp.
- Bump PORTREVISIONs.

- Bump shlib version to libnetsnmp.so.10 and bump $PORTREVISION.

Remove USE_REINPLACE from all categories starting with N

Try to clean up www/data

- Drop maintainership. ENOTIME for ports, so let someone else take better care
  of them.

Submitted by:   Brad Davis <so14k@so14k.com>

SHA256ify

Approved by: krion@

Chase shlib version bump of net-snmp.

- Makefile cleanup
- Silence build warnings
- Fix plist

PR:             ports/81007
Submitted by:   Jeremy Chadwick <freebsd@jdc.parodius.com>
Approved by:    Brad Davis <so14k@so14k.com> (maintainer)

SIZEify (maintainer timeout)

Say hello to the new "net-mgmt" category.  There are probably more
ports that belong here than the ones I have identified and moved in
this, first, pass.

Approved in principle by: marcus

Add rtg 0.7.4, a flexible, high-performance SNMP statistics monitoring
system.

Submitted by:   Brad Davis <so14k@so14k.com>