Posts by duncang92

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

Hi people,

I have been using LibreELEC across my home with 3 Raspberry Pi's and an HTPC.

I have a "server" where I store all the movies, tv shows and music .... running Fedora.

I use the MariaDB addon on the HTPC (pointed at the "server") to keep track of the watched state etc. and it works well. The HTPC also includes a TV-in card for over the air TV.

The HTPC is reaching the end of its life, slow and struggling with video decodes at times.

I have built a Raspberry Pi 4 to replace the HTPC but this needs a separate/new TV-in solution with a USB TV-in. This requires that I build the driver ... I can't do this in LiberELEC and so installed Raspberry Pi OS (Raspian).

I know I can setup mysql or mariadb (used to use MySql on the HTPC until LibreELEC introduced the mariadb addon) - the mariadb addon is soooo much easier to use BUT doesn't exist as I don't have the LibreELEC addons repository obviously. Using the addon would also simplify the transition and I can just port the databases from HTPC to new Pi 4.

Is there a way to get just the mariadb addon or add LibreELEC repository? I understand that this will NOT be supported as the LibreELEC respoitory and addons are targetted for LibreELEC and NOT Raspian.

Any pointers etc. would be great as I am going blind keep googling.

Duncan

Running Kodi Leia on Libreelec and added your addon successfully. No username or password entered (if I do then "kodi lounge" cannot be seen in the list on my phone. I have a free Spotify account.

I see "kodi lounge" as an option on my phone and can click connect but always stays at "connecting" and never connects.

My son comes over for a visit and bam he can connect straight away and it works awesomely. He has a Premium Spotify account. If he is connected and then I try connecting then it kicks him off but I still stay at "connecting" until it times out.

Both our phones are Android.

I also have a PC running on Fedora Linux and can see "kodi lounge" but same result ... always "connecting".

No problems from my phone or PC to my Google Home speaker.

Quote from DaVu

The system is an htpc with 2 sata hard drives (non-SSD) on the latest LibreELEC downloaded and installed yesterday.

There is/was content on the 2nd hard drive but nothing that I care about.

The hard drive is listed in /dev/sdb and I can go into parted and work on it but e2label always gives me an error "Bad magic number in super-block ....."

From what I read the drive should mount if it has a label associated with it but lots of very confusing and contradictory info out there.

The 2nd hard drive is 160Gb and I'm trying to get it into ext4 format and use it as local storage and as my PVR hard drive.

Thanks, Duncan

Many open questions...

I guess it's a USB HDD?
To which kind of hardware is it plugged?
Which LibreELEC version do you use?
Is there already some content on the drive?
To what is the drive formatted?
Have you tried using a different USB-port?

Display More

I just installed libreelec for the first time .,..... been using openelec for years.

My 2nd 160Gb hard drive is seen as sdb but doesn't automount and I can't seem to name it etc. etc..

Any hints and tips and pointers so that it gets mounted at boot? I've done a ton of reading but can't seem to work it out for libreelec being such a stripped down Linux.

Cheers, Duncan