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 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 ] - Bugfix exception when quitting configuration of mail relay. [ Oleh Dmytrychenko github: @NitrogenUA ] - Improve code quality: implement typing, fstrings and make (mostly) PEP8 compliant. [Stefan Davis & Jeremy Davis * Firstboot Initialization (inithooks): - Refactor start up (now hooks into getty process, rather than having it's own service). [ Stefan Davis ] - 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Thu, 29 Jan 2009 14:31:46 +0200