Posts by topsy

  • MariaDB Add-on LE11

    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.

  • MariaDB addon

    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.

  • MariaDB addon

    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.

  • MariaDB addon

    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.

  • MariaDB addon

    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?

  • MariaDB addon

    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>

  • MariaDB addon

    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.

  • Thoradia Add-ons

    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?