Category: Ubuntu

Ubuntu 20.04 LTS with fully encrypted ZFS root FS ? Yes, please!

Release notes state that ZFS on Linux is shipping with Ubuntu 20.04. Nice.

But encryption capability is not integrated into ubiquity – the graphical installer. OOB ZFS is not available with root FS encryption.

But making it work is super easy thanks to Sean Reifschneider who modified a gist that Garrett Fields had written for 19.10.

Literally a 3 minute job. Instructions here: link


Installing yourls on Ubuntu 18.04 with MariaDB 10.1.x Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Issue:
When installing yourls and clicking the INSTALL button under /admin/install.php you get a server Error 500 and the following error shows up in the log:

2018/12/08 21:22:10 [error] 21768#21768: *2 FastCGI sent in stderr: “PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes in /home/webuser/public_html/includes/vendor/aura/sql/src/ExtendedPdo.php:748

Stack trace:
#0 /home/webuser/public_html/includes/vendor/aura/sql/src/ExtendedPdo.php(748): PDOStatement->execute()

#1 /home/webuser/public_html/includes/functions-install.php(252): Aura\Sql\ExtendedPdo->perform(‘CREATE TABLE IF…’)