Posts by topsy

I have been running LibreELEC 10 (Kodi 19.5) with the MariaDB addon as a server on an ASUS Beebox computer very successfully for months. The Kodi client hardware I have used is:-

1. Amazon Firestick

2. Amazon Firestick Max

3. Amazon Firestick Cube (current version)

4. Android smart phone

5. Linux Laptop.

I dedided to upgrade as LibreELEC 11 (Kodi20) has had a final release.

ALL the clients upgraded without any configuration or issues.

LibreELEC upgraded but was unusable and required a complete reinstall to get to the same state I had with the previous version.

All good with LibreELEC 11 and the MariaDB server now.

Thanks to all involved with the development of the LibreELEC MariaDB addon it is excellent.

I'm currently running LE10.04 with the MariaDB addon and loving it.

Has anyone run LE11, with the MariDB addon ?

Hi Osoa

Did you manage to get MariDB addon running under LE11?

I have a working system with MariaDB and LE10 and I'm considering upgrading.

Libreelec has a Snapcast addon.

I searched the Playstore on my Android phone and found a Snapcast client.

If you get it working please post for others to enjoy/discuss.

After much late night messing I've got this working and I like the results.

Using a Acer Aspire R3700 with wifi adaptor and LE10 as the server and a Amazon Firestick 3rd Generation using only wifi.

1. Install the addon and changed default password both to 'kodi'

2. SSH into the server and use a text editor to edit

/storage/.kodi/userdata/addon_data/service.mariadb/my.cnf

I removed the hash from below on both lines of # skip-grant-tables

user = root

pid-file = /run/mysqld/mysqld.pid

socket = /run/mysqld/mysqld.sock

skip-grant-tables

[client]

port = 3306

socket = /var/run/mysqld/mysqld.sock

skip-grant-table

3. Installed kodi 19.5 on the firestick

added the below advancedsettings.xml file to BOTH instances of kodi i.e. server and client in the userdata folder.

<advancedsettings>

<videodatabase>

<type>mysql</type>

<host>172.20.6.2</host>

<port>3306</port>

<user>root</user>

<pass>kodi</pass>

</videodatabase>

<musicdatabase>

<type>mysql</type>

<host>172.20.6.2</host>

<port>3306</port>

<user>root</user>

<pass>kodi</pass>

</musicdatabase>

<videolibrary>

<importwatchedstate>true</importwatchedstate>

<importresumepoint>true</importresumepoint>

</videolibrary>

</advancedsettings>

4. setup smb on kodi to share files using zeroconf.

5. setup video libraries on both client for movies and tvshows and setup and selected the default scraper.

and scanned for content.

I used user 'root' I probably I could have used user 'kodi' but it's a home media server not an international bank so security is of no issue.

BTW

connecting from terminal did work.

mysql -u kodi -p -h 192.168.0.2

Thanks vpeter, that will be encouraging news for some.

Unfortunately on my Firestick install and kodi on Linux mint install I get no connection due to access denied.

My smb shares and local library scanning is working well on all installs so I'm going to abandon this project I just can't get it to work.

Thanks vpeter, yes i have done both default password then I changed it in the gui to "kodi".

The set_mysql_passwords.sql is below

SET PASSWORD FOR 'root' localhost=PASSWORD('kodi');

CREATE USER IF NOT EXISTS 'kodi';

CREATE USER IF NOT EXISTS 'kodi' localhost;

SET PASSWORD FOR 'kodi'=PASSWORD('kodi');

SET PASSWORD FOR 'kodi' localhost=PASSWORD('kodi');

GRANT ALL ON *.* TO 'kodi';

GRANT ALL ON *.* TO 'kodi' localhost;

flush privileges;

So I'm fairly sure all is good with passwords and in the original log file it references serving on 0.0.0.0.0 so I'm guessing there are no network restrictions.

I have a few services running on Docker so that is going to be my next approach.

I just thought the LibreELEC MariaDB addon looked like an easy install, two words in a GUI, a simple advanced settings.xml and good to go.

On a positive note, as an alternative I installed the Jellyfin server addon in LE10.

I got it working in minutes on both Kodi and web clients and appears to behave very well.

I'm disappointed I didn't have a similar experience with MariaDB since I'm moving over to Kodi clients on firesticks and this would have been a nice light approach with the entire database hosted on the server machine.

Has anyone out there managed to make the MariaDB addon work on LE10 or the beta LE11?

oh and yes 192.168.2 is the box with MariaDB on.

192.168.0.2 is the ip address of the box with the files (server) and the client is 192.168.0.39.

here you go text only as .xml is not allowed as an attachment.

<advancedsettings>

<videodatabase>
<type>mysql</type>
<host>192.168.0.2</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>

</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.0.2</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>

</musicdatabase>

<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>

</videolibrary>

</advancedsettings>

Thanks guys, I have had a look at the above link and the paths refer to an Ubuntu install and I am finding it difficult to follow.

I was under the impression that the Libreelec mariadb addon just required the passwords setting and an advancedsettingd.xml installing on the client. This I have done.

There appears to be 2 directories concerned with the addon

1 /storage/.kodi/addons/service.mariadb/

2 /storage/.kodi/userdata/addon_data/service.mariadb/

In the 2nd directory I found some config files and the mysqld.log generated (which I have attached) and it appears the database is up and running and trying to serve on 0.0.0.0, but the client is unrecognised and unreachable.

Any help as to how I can debug the connection would be most appreciated.

Does the MariaDB addon work in LE10?

I can get it to install but can't connect clients.

Quote from Wheemer

I found the downloaders don't work, but sonarr, radarr, jacket seem to work well. I've been experimenting more with docker lately. I sure miss thoradia too. Docker is just another layer of needless complication.

Any joy with sabnzb or nzbget using Thoradia in LE10 with sonarr or radarr ?or are these the downloaders that don't work?