turnkey-mysql-18.0 (1) turnkey; urgency=low

  * Debian default PHP updated to v8.2 (Adminer requires php).

  * Use MariaDB (MySQL replacement) v10.11.3 (from debian repos).

  * Upgraded base distribution to Debian 12.x/Bookworm.

  * Configuration console (confconsole):
    - Support for DNS-01 Let's Encrypt challenges.
      [ Oleh Dmytrychenko <dmytrychenko.oleh@gmail.com> github: @NitrogenUA ]
    - Support for getting Let's Encrypt cert via IPv6 - closes #1785.
    - Refactor network interface code to ensure that it works as expected and
      supports more possible network config (e.g. hotplug interfaces & wifi).
    - Show error message rather than stacktrace when window resized to
      incompatable resolution - closes  #1609.
      [ Stefan Davis <stefan@turnkeylinux.org> ]
    - Bugfix exception when quitting configuration of mail relay.
      [ Oleh Dmytrychenko <dmytrychenko.oleh@gmail.com> github: @NitrogenUA ]
    - Improve code quality: implement typing, fstrings and make (mostly) PEP8
      compliant.
      [Stefan Davis <stefan@turnkeylinux.org> & Jeremy Davis

  * Firstboot Initialization (inithooks):
    - Refactor start up (now hooks into getty process, rather than having it's
      own service).
      [ Stefan Davis <stefan@turnkeylinux.org> ]
    - Refactor firstboot.d/01ipconfig (and 09hostname) to ensure that hostname
      is included in dhcp info when set via inithooks.
    - Package turnkey-make-ssl-cert script (from common overlay - now packaged
      as turnkey-ssl). Refactor relevant scripts to leverage turnkey-ssl.
    - Refactor run script - use bashisms and general tidying.
    - Show blacklisted password characters more nicely.
    - Misc packaging changes/improvements.
    - Support returning output from MySQL - i.e. support 'SELECT'. (Only
      applies to apps that include MySQL/MariaDB).

  * Web management console (webmin):
    - Upgraded webmin to v2.0.21.
    - Removed stunnel reverse proxy (Webmin hosted directly now).
    - Ensure that Webmin uses HTTPS with default cert
      (/etc/ssl/private/cert.pem).
    - Disabled Webmin Let's Encrypt (for now).

  * Web shell (shellinabox):
    - Completely removed in v18.0 (Webmin now has a proper interactive shell).

  * Backup (tklbam):
    - Ported dependencies to Debian Bookworm; otherwise unchanged.

  * Security hardening & improvements:
    - Generate and use new TurnKey Bookworm keys.
    - Automate (and require) default pinning for packages from Debian
      backports. Also support non-free backports.

  * IPv6 support:
    - Adminer (only on LAMP based apps) listen on IPv6.
    - Nginx/NodeJS (NodeJS based apps only) listen on IPv6.

  * Misc bugfixes & feature implementations:
    - Remove rsyslog package (systemd journal now all that's needed).
    - Include zstd compression support.
    - Enable new non-free-firmware apt repo by default.
    - Improve turnkey-artisan so that it works reliably in cron jobs (only
      Laravel based LAMP apps).

 -- Jeremy Davis <jeremy@turnkeylinux.org>  Fri, 22 Sep 2023 02:42:38 +0000

turnkey-mysql-17.1 (1) turnkey; urgency=low

  * Updated all Debian packages to latest.
    [ autopatched by buildtasks ]

  * Patched bugfix release. Closes #1734.
    [ autopatched by buildtasks ]

 -- Jeremy Davis <jeremy@turnkeylinux.org>  Fri, 11 Nov 2022 02:00:46 +0000

turnkey-mysql-17.0 (1) turnkey; urgency=low

  * Bugfix 'turnkey-mysql-ssl disable' script - closes #1614.
    [Jeremy Davis jeremy@turnkeylinux.org]

  * Updating mysql appliance and its dependencies to v17.0.

  * Update appliance landing page with lighttpd refactoring. Includes adding
    adding lighty openssl module to plan, and using new common make files.

  * Replace php-cgi with php-fpm.

 -- Mattie Darden <mattie@turnkeylinux.org>  Fri, 14 Oct 2022 17:22:10 -0400

turnkey-mysql-16.1 (1) turnkey; urgency=low

  * Rebuild on latest Debian Buster.

  * Note: Please refer to turnkey-core's 16.1 changelog for changes common to
    all appliances. Here we only describe changes specific to this appliance.

 -- Jeremy Davis <jeremy@turnkeylinux.org>  Tue, 30 Mar 2021 13:53:20 +1100

turnkey-mysql-16.0 (1) turnkey; urgency=low

  * Updated all relevant Debian packages to Buster/10 versions; including
    MariaDB & PHP 7.3 (for Adminer).

  * New user account, named "remote" configured for remote connections.

  * Explicitly enabled SSL for MySQL network connections via port 3306.

  * New inithooks to set hostname for remote user host and regenerate MariaDB
    connection SSL certifcates/keys.

  * CLI script 'turnkey-mysql-ssl' and Confconsole plugin to enable/disable
    MySQL/MariaDB SSL requirement for remote connections.

  * Explcitly disable TLS<1.2 (i.e. SSLv3, TLSv1, TLSv1.1) for WebCP & Adminer.
    (v15.x TurnKey releases supported TLS 1.2, but could fallback as low as
    TLSv1).

  * Update SSL/TLS cyphers webservers to provide "Intermediate" browser/client
    support (suitable for "General-purpose servers with a variety of clients,
    recommended for almost all systems"). As provided by Mozilla via
    https://ssl-config.mozilla.org/.

  * Updated version of mysqltuner script - now installed as per upstream
    recommendation.

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Jeremy Davis <jeremy@turnkeylinux.org>  Fri, 10 Jul 2020 16:47:16 +1000

turnkey-mysql-15.1 (1) turnkey; urgency=low

  * Rebuild to resolve inadvertent removal of mariadb during sec-updates
    - part of #1246.

 -- Jeremy Davis <jeremy@turnkeylinux.org>  Thu, 22 Nov 2018 13:54:31 +1100

turnkey-mysql-15.0 (1) turnkey; urgency=low

  * Install Adminer directly from stretch/main repo

  * Provide "adminer" root-like user for Adminer and remote MySQL access

  * Replace MySQL with MariaDB (drop-in MySQL replacement)

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Vlad Kuzmenko <vlad@turnkeylinux.org>  Wed, 20 Jun 2018 07:34:42 +0200

turnkey-mysql-14.2 (1) turnkey; urgency=low

  * Updated Adminer to 4.2.5

  * Installed security updates.

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Jeremy Davis <jeremy@turnkeylinux.org>  Wed, 19 Apr 2017 12:03:48 +1000

turnkey-mysql-14.1 (1) turnkey; urgency=low

  * Mysql:

    - Latest Debian Jessie package version of MySQL.
    - Bugfixed lighttpd configuration [#552].

  * Fix lighttpd bug in 15regen-sllcert [#512].

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Stefan Davis <nafets.sivad@gmail.com>  Thu, 28 Jan 2016 00:20:44 +1100

turnkey-mysql-14.0 (1) turnkey; urgency=low

  * Mysql:

    - Latest Debian Jessie package version of MySQL.

  * Replaced PHPMyAdmin with Adminer

  * Hardened default SSL settings

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Ken Robinson <ken@robinsonshome.net>  Fri, 17 Jul 2015 19:48:22 -0400

turnkey-mysql-13.0 (1) turnkey; urgency=low

  * Mysql:

    - Latest Debian Wheezy package version of MySQL.
    - Bugfixed lighttpd configuration [#75].

  * PHPMyAdmin:

    - Configured to allow users preferences stored in database.
    - Specified blowfish_secret and regeneration on firstboot (security).

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Alon Swartz <alon@turnkeylinux.org>  Thu, 10 Oct 2013 18:34:20 +0300

turnkey-mysql-12.1 (1) turnkey; urgency=low

  * Latest Debian Squeeze package version of MySQL.

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Alon Swartz <alon@turnkeylinux.org>  Sun, 07 Apr 2013 08:00:00 +0200

turnkey-mysql-12.0 (1) turnkey; urgency=low

  * Major component versions

    lighttpd        1.4.28-2+squeeze1
    mysql-server    5.1.63-0+squeeze1
    phpmyadmin      4:3.3.7-7

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Alon Swartz <alon@turnkeylinux.org>  Wed, 01 Aug 2012 08:00:00 +0200

turnkey-mysql-11.3 (1) turnkey; urgency=low

  * Installed security updates.
  * Enabled etckeeper garbage collection by default.
  * Upgraded to latest inithooks version (adhoc re-initialization via turnkey-init)

 -- Alon Swartz <alon@turnkeylinux.org>  Mon, 05 Dec 2011 10:48:44 +0000

turnkey-mysql-11.2 (1) turnkey; urgency=low

  * Installed security updates.
  * Added HubDNS package and firstboot configuration.

 -- Alon Swartz <alon@turnkeylinux.org>  Fri, 15 Jul 2011 07:47:08 +0000

turnkey-mysql-11.1 (1) turnkey; urgency=low

  * Set MySQL root password on firstboot (convenience, security).

  * Force MySQL to use Unicode/UTF8.

  * Enabled tracking in PHPMyAdmin.

  * Major component versions:

    mysql-server    5.1.41-3ubuntu12.8
    phpmyadmin      4:3.3.2-1
    lighttpd        1.4.26-1.1ubuntu3

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Alon Swartz <alon@turnkeylinux.org>  Sun, 19 Dec 2010 15:01:05 +0200

turnkey-mysql-2009.10 (2) hardy; urgency=low

  * Installed all security updates (see manifest for package versions).

  * Install security updates on firstboot (except when running live).

  * Bugfix: Updated apt preferences for auto-security updates (LP#550307).

  * Trick webmin into not checking for upgrades (managed by apt).

  * Updated di-live mysql mechanism and secret regeneration.

  * Included latest version of inithooks and updated scripts.

  * Included wget as per common request.

 -- Alon Swartz <alon@turnkeylinux.org>  Mon, 29 Mar 2010 09:02:11 +0200

turnkey-mysql-2009.10 (1) hardy; urgency=low

  * PHPMyAdmin improvements:

    - Added pmadb (linked tables) advanced features to PHPMyAdmin (LP#426303).
    - Pinned PHPMyAdmin to update directly from Debian (security).

  * di-live (installer) MySQL component:

    - Added support for complex passwords (LP#416515).
    - Added CLI options (user/pass/query/chroot).

  * Bugfix: Removed build systems hostname from MySQL user table.

  * Regenerates all secrets during installation / firstboot (security).

  * Major component versions:

    phpmyadmin      2.11.8.1-5+lenny1
    mysql-server    5.0.51a-3ubuntu5.4
    lighttpd        1.4.19-0ubuntu3.1

  * Note: Please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Alon Swartz <alon@turnkeylinux.org>  Tue, 29 Sep 2009 15:39:41 +0200

turnkey-mysql-2009.02 (1) hardy; urgency=low

  * configured mysql to accept connections from all hosts by default
    (convenience)

  * updated confconsole usage template to describe connecting with mysql client 

  * setting password for mysql is required during installation
  * including webmin-mysql (convenience)

  * major component versions

    phpmyadmin      2.11.8.1-5
    mysql-server    5.0.51a-3ubuntu5.4
    lighttpd        1.4.19-0ubuntu3

  * note: please refer to turnkey-core's changelog for changes common to all
    appliances. Here we only describe changes specific to this appliance.

 -- Alon Swartz <alon@turnkeylinux.org>  Thu, 29 Jan 2009 14:31:46 +0200