Cannot login to mariadb on VM hosted on TrueNAS

by James McDonald | Aug 4, 2026 | IT Tips | 0 comments

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

Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.