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 <https://github.com/marcos-mendez>]
* 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 <jeremy@turnkeylinux.org> 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 <stefan@turnkeylinux.org> ]
* Upstream/Debian Adminer update - closes #1758.
[ Stefan Davis <stefan@turnkeylinux.org> ]
* 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> 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 <jeremy@turnkeylinux.org> 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 <mira@turnkeylinux.org> ]
* 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 <jeremy@turnkeylinux.org> 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 <jeremy@turnkeylinux.org> 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 <jeremy@turnkeylinux.org> 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 <nafets.sivad@gmail.com> 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 <jeremy@turnkeylinux.org> 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 <nafets.sivad@gmail.com> 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 <ken@robinsonshome.net> 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 <alon@turnkeylinux.org> 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 <alon@turnkeylinux.org> 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 <alon@turnkeylinux.org> 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 <alon@turnkeylinux.org> 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 <alon@turnkeylinux.org> 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 <alon@turnkeylinux.org> 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 <alon@turnkeylinux.org> 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 <alon@turnkeylinux.org> 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 <alon@turnkeylinux.org> Thu, 29 Jan 2009 13:56:27 +0200