turnkey-postgresql-19.0 (1) turnkey; urgency=low * Upgraded base distribution to Debian 13.x/Trixie. * Replace TurnKey custom Debian-Installer based 'di-live' with new custom TurnKey installer built from scratch; 'tkl-installer'. * Updated release signing keys & apt repo keys - now included as 'turnkey-keys' deb package. * Replace legacy '.list' apt remote config files with Deb822 '.sources' files. * "Proper" IPv6 support. May still have some gaps and still requires cosmetic work but fully functional. * Improved fail2ban config: - Increased default findtime (10 minutes) & bumped maxretry (3) to minimize risk of user accidentally locking themself out. - Removed redundant v18.x custom patches. * Include 'zstd' by default to support smaller initramfs that unpacks faster. * Replace 'ifupdown' with 'ifupdown-ng' (and 'ifupdown-ng-compat'). * Replace 'udhcpc' (IPv4 only) with 'dhcpcd-base' (dual stack ipv4/6). Also include custom TurnKey config (if-pre-up & if-post-down scripts provided by 'tkl-dhcpcd-ifupdown-glue') to ensure DHCP config is in sync with /etc/network/interfaces file. * General code cleanup of TurnKey code; build code, build tools and TurnKey custom tools & libraries. Updates include linting, formating and style updates. Still WIP but solid start. * Configuration console (confconsole): - Bugfixes: - Support for firewall config when setting a static IP. Particularly affected OpenVPN (which ships with firewall enabled by default). Closes #2037. - Fix Let's Encrypt integration failing back-to-back runs. Closes #2121. - Features: - "Proper" support for IPv6: - Make ifutil.py module code "IPv6 aware", including reliable management of /etc/network/interfaces with "inet6" stanza/s. - Show IPv6 info on "usage" page - only shown if IPv6 configured. Special thanks to Marcos: https://github.com/marcos-mendez - https://popsolutions.co/ - Misc clean up and improvements in code and packaging. See Confconsole release notes for full details. * Firstboot Initialization (inithooks): - Bugfixes: - Ensure everyboot scripts only run once per boot. - firstboot.d/15regen-sslcert: - Only services which are already running need to be restarted as restart is only to apply updated certs. - firstboot.d/01ipconfig: - Minor bugfix. - Features/improvements and other changes of significance: - Reimplement an 'inithooks.service' and refactor integration with getty1. - Delay start of inithooks/confconsole at boot time to reduce chance of boot messages overwriting inithooks/confconsole. - Developers - please note that hooks with a prefix less than '30' will still run early, so should _always_ be non-interactive. - TurnKey 'init-fence' (blocks web access at firstboot): - Run by default on all builds pre firstboot initialization (previously only enabled on "headless" builds). - New pre-seed variable 'AUTO_RUN' to skip interactive config (re-implements previous "headless" build functionality). - Replace legacy init.d script with systemd 'turnkey-init-fence.service' (& script which is called by the service). - Add support for 'systemctl reload turnkey-init-fence.service' - which restarts 'simplehttpd.py' (init-fence mini web server) but does not disable the firewall rules. - Support for custom init-fence content. - Update dynamically generated SSH information for IPv6 address display. - Add IPv6 support to mini server. - Ensure inithook 'SEC_UPDATES' pre-seed variable test is case insensitive; eliminates risk of unintended behavior when pre-seeding. - Misc clean up and improvements in code and packaging. See Inithooks release notes for full details. * Web management console (webmin): - Upgraded Webmin to latest upstream. - Refactored TurnKey Webmin packaging process to support easier updates; with the intention of following upstream releases as closely as possible (provided via TurnKey apt repo). - Updated default Webmin config: - Listen on IPv6 by default. - Preconfigured IPv6 firewall matching IPv4 rules (but not enabled - as per historical IPv4 default). - Auto redirect http => https. - Default 30 min user logout (can be overridden via login page "remember me" checkbox or webmin "authentication" config). - Updated logging paths and fixed log file rotation. * Backup (tklbam): - Bugfixes: - Fix broken help pager (not sure how long that has been broken!?). - Fix broken tar command (deprecated functionality removed in Debian Trixie). - Features/improvements: - Migrate core program and direct dependency python2 runtime from cpython2 (EOL) to Pypy (still supported - packaged by TurnKey). - Migrate all other components to python3. Note: remaining python2 TKLBAM code port to python3 is in progress but no ETA yet... - Misc clean up and improvements in code and packaging. See TKLBAM release notes for full details. * Misc code cleanup and improvements. * Updated SSL/TLS cipher list - "intermediate" level as recommended by Mozilla. Aims to balance security and support for older clients. * Block access to all '.' paths by default (e.g. '.env', '.git', etc). Note this will break third party Let's Encrypt integrations using HTTP-01 validation - e.g. certbot. TurnKey's integration is unaffected as it uses a custom HTTP server to serve the challenges. * Explicitly set elliptic curves offered for ECDH key exchange. * Redirect HTTP => HTTPS by default. * Enable HTTP/2 by default. * Enable php-fpm by default in common config. * Create default '/var/lib/php/sessions' cache dir and ensure it is writable by the webserver (default PHP session cache location for some PHP apps). -- Jeremy Davis Tue, 18 Aug 2026 12:54:44 +1000 turnkey-postgresql-18.1 (1) turnkey; urgency=low * v18.1 rebuild - includes latest Debian & TurnKey packages. * Ensure hashfile includes URL to public key - closes #1864. * Configuration console (confconsole) - v2.1.6: - Bugfix broken DNS-01 Let's Encrypt challenge - closes #1876 & #1895. Fixed in v2.1.5 - already included in some appliances. - Let's Encrypt/Dehydrated - bugfix cron failure - closes #1962. - General dehydrated-wrapper code cleanup - now passes shellcheck. * Include webmin-logviewer module by default - closes #1866. * Web management console (webmin): - Include webmin-logviewer module by default - closes #1866. - Upgraded webmin to v2.105. - Replace webmin-shell with webmin-xterm module by default - closes #1904. * Includes new 'tkl-upgrade-php' helper script - to allow easy update/change of PHP version - closes #1892. [Marcos Méndez @ POPSOLUTIONS ] * DEV: Add support for setting max_execution_time & max_input_vars in php.ini via appliance Makefile (PHP_MAX_EXECUTION_TIME & PHP_MAX_INPUT_VARS). -- Jeremy Davis Fri, 05 Jul 2024 11:50:32 +0000 turnkey-postgresql-18.0 (1) turnkey; urgency=low * Debian default PHP updated to v8.2. * Use PostgreSQL v15 (from debian repos). [ Stefan Davis ] * Upstream/Debian Adminer update - closes #1758. [ Stefan Davis ] * 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 Thu, 21 Sep 2023 03:16:20 +0000 turnkey-postgresql-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:07:16 +0000 turnkey-postgresql-17.0 (1) turnkey; urgency=low * Updated PostgreSQL to the latest Debian Bullseye package - v13. [ Mira Heichenko ] * Include lighttpd-mod-openssl module (new for Bullseye). * Use new common make files. * Use PHP-FPM (replaces PHP-CGI). * Note: Please refer to turnkey-core's 17.0 changelog for changes common to all appliances. Here we only describe changes specific to this appliance. -- Jeremy Davis Wed, 19 Oct 2022 08:45:59 +0000 turnkey-postgresql-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 Thu, 01 Apr 2021 17:40:50 +1100 turnkey-postgresql-16.0 (1) turnkey; urgency=low * Updated PostgreSQL to latest Debian Buster package - v11. * Dependencies for postgresql-x.x-postgis-y.y package have been fixed so we no longer need to consider removing it from the build (i.e. nothing to do on our end) - closes #1154. * 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, 06 May 2020 13:06:11 +1000 turnkey-postgresql-15.0 (1) turnkey; urgency=low * Updated PostgreSQL to latest Debian Stretch package. * Install Adminer directly from stretch/main repo * 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 Tue, 26 Jun 2018 23:16:36 +1100 turnkey-postgresql-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:32:17 +1000 turnkey-postgresql-14.1 (1) turnkey; urgency=low * PostgreSQL: - Latest Debian Jessie package version of PostgreSQL. - 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 01:27:36 +1100 turnkey-postgresql-14.0 (1) turnkey; urgency=low * PostgreSQL: - Latest Debian Jessie package version of PostgreSQL. - Build error due to new postgis package [#377][#383]. * 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 06:02:00 -0400 turnkey-postgresql-13.0 (1) turnkey; urgency=low * PostgreSQL: - Latest Debian Wheezy package version of PostgreSQL. - Bugfix for package transition [#80]. - Removed hardcoded PGSQL version [#107], thanks Jenny Qian! * 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 Fri, 11 Oct 2013 10:54:09 +0300 turnkey-postgresql-12.1 (1) turnkey; urgency=low * Latest Debian Squeeze package version of PostgreSQL. * 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-postgresql-12.0 (1) turnkey; urgency=low * PostgreSQL: - Reduced default shared_buffers to 24MB, as default Debian kernel SHMMAX is too low for the default 32MB. Increase per deployment: - /proc/sys/kernel/shmmax - /etc/postgres/8.4/main/postgresql.conf (shared_buffers) * Major component versions lighttpd 1.4.28-2+squeeze1 postgresql 8.4.12-0squeeze1 phppgadmin 4.2.3-1.1squeeze2 * 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-postgresql-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-postgresql-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-postgresql-11.1 (1) turnkey; urgency=low * Set PostgreSQL password is on firstboot (convenience, security). * Force PostgreSQL to use Unicode/UTF8. * Major component versions: phppgadmin 4.2.2-1ubuntu1 postgresql 8.4.5-0ubuntu10.04 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-postgresql-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). * 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-postgresql-2009.10 (1) hardy; urgency=low * di-live (installer) PostgreSQL component: - Added support for complex passwords (LP#416515). - Added CLI options (user/pass/query/chroot). * Pinned PHPPgAdmin to update directly from Debian (security). * Regenerates all secrets during installation / firstboot (security). * Major component versions: phppgadmin 4.2.2-1 postgresql 8.3.8-0ubuntu8.04 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-postgresql-2009.02 (1) hardy; urgency=low * support configuring postgresql password during installation * postgres password encryption enabled by default (security) * trust "postgres" user when connecting over local unix sockets (convenience) * set postgres password to "postgres" in live/demo mode * updated confconsole usage template to describe connecting with psql client * added postgis support * including webmin-postgresql * major component versions phppgadmin 4.2.2-1 postgresql 8.3.5-0ubuntu0.8.04 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 13:56:27 +0200 .