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

paplo · September 29, 2017 at 12:54 PM

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?

marantz · September 30, 2017 at 10:01 AM

I use tls with mysql in libreelec and it works. Can you paste your kodi.log while trying to connect?

also check rights on your cert, think you need 600 or openssl wont use them

paplo · October 4, 2017 at 4:25 PM

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

**chewitt** · October 4, 2017 at 7:58 PM Official Post

No further support will be provided while you have banned (piracy) add-ons installed.

marantz · October 6, 2017 at 11:47 AM

when you have cleared your addons get back please.