I have a Pi4 with LE12 and the mariadb addon.
I have a Pi3 with LE12
Both are a new clean install (I decided to make a clean start vs upgrading).
i used to run LE11 with the mariadb addon on both machines and the watched state was populated from one to the other. Loved it. So I have some familiarity.
The watched state isn't populated between the machines. The advancedsettings.xml points to the Pi4 on both machines. mysqld.log is clean (just shows the service started on 0.0.0.0) yet I see no connection attempts failing or otherwise from the Pi3 to the Pi4.
I cannot connect to the mariadb (Pi 4) whilst ssh'd into it using:
Lounge:~ # mariadb -u kodi -p -h 192.168.68.51
Enter password:
ERROR 2026 (HY000): TLS/SSL error: self-signed certificate
When I do that I see an error in mysqld.log of:
2024-06-11 16:50:35 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-06-11 16:50:35 0 [Note] Server socket created on IP: '::'.
2024-06-11 16:50:35 0 [Note] /storage/.kodi/addons/service.mariadb/bin/mariadbd: ready for connections.
Version: '11.4.2-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
2024-06-11 17:00:46 4 [Warning] IP address '192.168.68.51' could not be resolved: Name or service not known
2024-06-11 17:00:47 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'kodi' host: '' (Got an error reading communication packets)
my.cnf says:
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
I can locally connect to the mariadb ....
Lounge:~ # mariadb -u kodi -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 11.4.2-MariaDB 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)]>
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.68.51</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.68.51/host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
I am hoping someone can give me pointers as I am a little stumped where to look.
Thanks, Duncan
