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

Categories: MySQL/MariaDB, Ubuntu

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 … Read More

CentOS 7 fix for “perl: warning: Please check that your locale settings are supported and installed on your system.”

Categories: bash, CentOS / RHEL

Issue: Logging in via SSH you are greeted with: perl: warning: Setting locale failed.perl: warning: Please check that your locale settings:LANGUAGE = (unset),LC_ALL = (unset),LC_CTYPE = “en_US.UTF-8”,LANG = “C.UTF-8”are supported and installed on your system.perl: warning: Falling back to the standard locale (“C”). Solution: Edit /etc/environment and add the following. Replace en_US with your actual … Read More

Public NTP Servers

Categories: Uncategorized

time1.google.com 216.239.35.0 time.apple.com 17.253.82.253 time.nist.gov 129.6.15.29 Hitting these directly has not been best practice for a while now. One should use the public pool from NTPpool.org