Logging into mariadb on a VM hosted on TrueNAS
mysql -uroot -p
Enter password:
ERROR 2026 (HY000): TLS/SSL error: certificate is not yet valid
Date in VM is set to UTC
date
Tue Aug 4 06:38:39 AM UTC 2026
Fix
Change the VM settings in TrueNAS to have System Clock be UTC instead of local and reboot. After this change the login happened without having to use --skip-ssl
mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 11.8.6-MariaDB-5ubuntu0.1 from Ubuntu -- Please help get to 10k stars at https://github.com/MariaDB/Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>


0 Comments