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