Raspi Kodi 17 can't connect to sql server with encryption

1st Official Post

    Hi guys

    So I have a shared library mariadb sql server which I have set up for TLS encryption. It works from my Windows 10 PC where I have added the certificate files to the kodi userdata folder and added the following lines in the advancedsettings.xml file

    <key>C:\Users\User\AppData\Roaming\Kodi\userdata\client-key.pem</key>

    <cert>C:\Users\User\AppData\Roaming\Kodi\userdata\client-cert.pem</cert>

    <ca>C:\Users\User\\AppData\Roaming\Kodi\userdata\ca-cert.pem</ca>

    However I can't get it to work on my Raspi's running Libreelec 8.0.2 where I have also put the cert files in the userdata folder and added the following to the advancedsettings.xml

    <key>/storage/.kodi/userdata/client-key.pem</key>

    <cert>/storage/.kodi/userdata/client-cert.pem</cert>

    <ca>/storage/.kodi/userdata/ca-cert.pem</ca>

    Does anyone have experience with using the sql encryption options in Kodi that can tell me how to get it working?

    I have tried setting the cert permissions to both 600 and 777 with no difference. I also did the verify command on my server to check that the certs match. Got the following:

    Code
    openssl verify -CAfile ca-cert.pem server-cert.pem client-cert.pem
server-cert.pem: OK
client-cert.pem: OK


    My log looks like this: Kodi.log

    Edited once, last by paplo (October 4, 2017 at 5:09 PM).