databases/pgpool-II-40: Remove expired port

2023-12-31 databases/pgpool-II-40: Upstream EOL reaches on 2023-12-31

databases/pgpool-II-40: Update version 4.0.22=>4.0.24

- Mark DEPRECATED as upstream EOL reaches on 2023-12-31
- Set EXPIRATION_DATE 2023-12-31

Changelog:
https://www.pgpool.net/docs/latest/en/html/release-4-0-24.html
Approved by:	tz (private mail)
Sponsored by:	Bounce Experts

*/*: llvm15 build fixes

llvm15 was also merged into 13.2-STABLE effective from OSVERSION
1302505. Fix the ports that failed to build with llvm15.

Approved by:	portmgr (blanket)

*/*: Remove pointers to EOLed pgsql versions

- Remove dotted pgsql versions

Approved by:	portmgr

databases/pgpool-II-40: Update version 4.0.21=>4.0.22

Changelog:
https://www.pgpool.net/docs/latest/en/html/release-4-0-22.html

Approved by:	tz (mail)
Sponsored by:	Bounce Experts

databases/pgpool-II-40: Update version 4.0.20=>4.0.21

Approved by:	tz (by private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-0-21.html
Sponsored by:	Bounce Experts

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/pgpool-II-40: Update version 4.0.19=>4.0.20

Approved by:	tz (By private mail)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-0-20.html
Sponsored by:	Bounce Experts

Fix CONFLICTS_INSTALL in the databases category

Approved by:	portmgr (implicit)

databases/pgpool-II-40: Update version 4.0.17=>4.0.19

Approved by:	tz (private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-0-19.html
Sponsored by:	Bounce Experts

databases/pgpool-II-40: Update version 4.0.9=>4.0.17

Approved by:	tz (private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-0-17.html
Sponsored by:	Bounce Experts

*/*: Remove redundant '-[0-9]*' from CONFLICTS

The conflict checks compare the patterns first against the package
names without version (as reported by "pkg query "%n"), then - if
there was no match - agsinst the full package names including the
version (as reported by "pkg query "%n-%v").

Many CONFLICTS definitions used patterns like "bash-[0-9]*" to filter
for the bash package in any version. But that pattern is functionally
identical with just "bash".

Approved by:	portmgr (blanket)

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

all: Remove all other $FreeBSD keywords.

Remove # $FreeBSD$ from Makefiles.

databases/pgpool-II-40: fix broken SIZE in distinfo

File has not changed, it was just broken on my latest download
because of bad internet connection.

Sponsored by:	Bounce Experts

databases/pgpool-II-40: Update from 4.0.8 to 4.0.9

Changelog: Bug fixes

    Fix build error on some system (Fedora 32). (Tatsuo Ishii)

    Fix pgpool ssl front end accept all ciphers. (bug 608) (Muhammad Usama)

    Downgrade too verbose authentication logs. (Tatsuo Ishii)

    Fix unnecessary checks. (Tatsuo Ishii)

    Doc: Fix typo. (Tatsuo Ishii)

    Fix for segmentation fault in PCP process. (bug 598) (Muhammad Usama)

databases/pgpool-II-40: Upgrade from 4.0.6 to 4.0.8

Changelog for 4.0.7:

Bug fixes

    Fix incorrect query rewrite in replication mode. (Bo Peng)

    Fix that health check timeout does work in certain case. (Tatsuo Ishii)

    Discussion: [pgpool-hackers: 3458], [pgpool-hackers: 3459]

    Doc: add failover_command description when all standby nodes are down.
(Takuma Hoshiai)

    Doc: add note not to assign PostgreSQL servers to trusted_servers. (Tatsuo
Ishii)

databases/pgpool-II-40: Upgrade from 4.0.5 to 4.0.6

Changelog:

    Enhancements:
    - Doc: Update "Pgpool-II + Watchdog Setup Example" to support PostgreSQL 12.
(Bo Peng)
    - Import some of memory manager debug facilities from PostgreSQL. (Tatsuo
Ishii)
    - Use pg_get_expr() instead of pg_attrdef.adsrc to support for PostgreSQL
12. (Bo Peng)
    - Enhance shutdown script of pgpool_setup. (Tatsuo Ishii)
        - Make shutdownall to wait for completion of shutdown of Pgpool-II.
        - If environment variable CHECK_TIME_WAIT is set to true, use netstat
command to confirm usage of the TCP/IP port while executing shutdown script.
    - Doc: add description to pg_md5 man page how to show pool_passwd hashed
string. (Tatsuo Ishii)
    - Doc: add general description about failover. (Tatsuo Ishii)
    - Deal pgpool_adm extension with PostgreSQL 12. (Tatsuo Ishii)

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

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

databases/pgpool-II-40: Upgrade from 4.0.4 to 4.0.5

Changelog:

  Enhancements

    - Doc: Improve Reference II, PCP commands document. (Tatsuo Ishii)
    - Speed up failover when all of backends are down. (Tatsuo Ishii)
    - pgpool-recovery extension and pgpool_setup is now ready for the next major
release PostgreSQL 12. (Tatsuo Ishii)
    - Doc: add restrictions entry. (Takuma Hoshiai)

  Bug fixes

    - Fix the wrong error message "ERROR: connection cache is full", when all
backend nodes are down. (bug 487) (Bo Peng)
    - Remove unused .sgml file. (Takuma Hoshiai)

databases/pgpool-II-40: Upgrade from 4.0.3 to 4.0.4

Changelog:

Enhancements

    * Add new configuration option ssl_prefer_server_ciphers. (Muhammad Usama)

      Add the new setting ssl_prefer_server_ciphers to let users configure if
they want client's or server's cipher order to take preference.

      The default for this parameter is off, which prioritize the client's
cipher order as usual. However this is just for keeping backward compatibility,
and it is possible that a malicious client uses weak ciphers. For this reason we
recommend to set this parameter to on at all times.

    * Allow to set a client cipher list. (Tatsuo Ishii, Yugo Nagata)

      For this purpose new parameter ssl_ciphers, which specifies the cipher
list to be accepted by Pgpool-II, is added. This is already implemented in
PostgreSQL and useful to enhance security when SSL is enabled.

databases/pgpool-II-40: Update from 4.0.2 to 4.0.3

Changelog:

- Skip over "host=" when getting info from conninfo string. (Bo Peng)
- Test: Fix old JDBC functions and typos in regression test 068.memqcache_bug.
(Takuma Hoshiai)
- Doc: Fix configuration change timing regarding memory_cache_enabled. (Tatsuo
Ishii)
- Fix online recovery failed due to client_idle_limit_in_recovery in certain
cases. (bug 431) (Tatsuo Ishii)
- Reduce memory usage when large data set is returned from backend. (bug 462)
(Tatsuo Ishii)
- Test: Fix syntax error in extended query test script. (Tatsuo Ishii)
- Fix corner case bug when strip_quote() handle a empty query string. (bug 458)
(Tatsuo Ishii)
- Doc: Mention that schema qualifications cannot be used in
white/black_function_list. (Tatsuo Ishii)
- Fix typo about wd_priority in watchdog_setup. (Takuma Hoshiai)
- Fixed segfault when wd_lifecheck_method = 'query'. (bug 455) (Muhammad Usama)
- The fix was proposed by Muhammad Usama and some adjustments to the patch and
testing is done by Yugo Nagata.
- Fix Pgpool child segfault if failover occurs when trying to establish a
connection. (Tatsuo Ishii)
- Doc: fix typo in logdir description. (bug 453) (Tatsuo Ishii)
- Fix PAM authentication failed. (Takuma Hoshiai)
- Fix Pgpool-II hang if a client sends a extended query message such as close
after sync message but before next simple query. (Tatsuo Ishii)
- Fix Pgpool-II hang when idle_in_transaction_session_timeout = on. (bug 448)
(Tatsuo Ishii)

Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-4-0-3.html

MFH:		2019Q1

databases/pgpool-II-40: add new configuration files to rc-script

pgpool 4.0 adds the configuration files "pool_hba.conf" and "pcp.conf", but
they weren't used until now. Also its possible to change there location
via rc.conf

PR:		235059
Submitted by:	 Franco Ricci <franco.ricc@gmail.com>

databases/pgpool-II-40: Actually unbreak PAM option after r490475

Do not pass --without-pam to configure as it does not appear to
work correctly.  It also defines USE_PAM in config.h even when it
should not be defined and the build breaks.

auth/pool_hba.c:157:24: error: variable has incomplete type 'struct pam_conv'
static struct pam_conv pam_passw_conv = {
                       ^

http://beefy3.nyi.freebsd.org/data/112amd64-quarterly/490502/logs/errors/pgpool-II40-4.0.2_2.log

Pointy hat:	tobik
Approved by:	tz (maintainer)

databases/pgpool-II-40: Unbreak PAM option

The PAM option is tangled up with the SSL option in a weird way.
SSL_CONFIGURE_WITH is set once before bsd.port.options.mk for
enabling SSL support and overwritten again after including
bsd.port.options.mk but only when PAM=on.

Setting options helper after this point is not really supported,
but --with-pam actually makes it to CONFIGURE_ARGS.  When options
helpers are processed the results are only realized later by make(1).
SSL_CONFIGURE_WITH has been defined before including bsd.port.options.mk,
so this sort of "works".

This, however, is presumably an implementation detail and enabling
the PAM option breaks SSL support since SSL_CONFIGURE_WITH is
overwritten with a new value: CONFIGURE_ARGS only has --with-pam
left and is missing --with-openssl.

PAM support does not depend on SSL support.  Just switch everything
to options helpers to fix this.

PR:		234817
Submitted by:	tobik
Approved by:	tz (maintainer)

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

databases/pgpool-II-40: Upgrade from 4.0.1 to 4.0.2

Changelog: http://www.pgpool.net/docs/latest/en/html/release-4-0-2.html

databases/pgpool-II-40: Drop incorrect BROKEN_SSL

openssl-devel was removed a while ago in favor of openssl111, but
pgpool-II-40 builds fine with OpenSSL 1.1.1, so BROKEN_SSL is not
needed in the first place.

http://beefy5.nyi.freebsd.org/data/120i386-default/485373/logs/pgpool-II40-4.0.1.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II40-4.0.1.log

Pointy hat:	joneum

Fix WWW

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH

New Port: databases/pgpool-II-40

pgpool is a connection pool server for PostgreSQL. pgpool runs between
PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can
connect to pgpool as if it were a standard PostgreSQL server.

pgpool caches the connection to PostgreSQL server to reduce the overhead to
establish the connection to it.

WWW: http://pgpool.net/

PR:		232957
Reported by:	Franco Ricci <franco.ricc@gmail.com>
Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH