LE12 Mariadb can't connect

    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

    duncang92 we are trying to test this ssl issue, and can’t reproduce it yet.


    Can your please confirm the password to your mariadb matches between the advancedsettings.xml and the mariadb. The password won’t be “kodi”. Please don’t share your password here - but it should be the ddddd line.

    please also test the following line - it should let you in to the database.
    # mariadb -h 192.168.68.51 --skip-ssl-verify-server-cert -u kodi -p