Posts by Schnabulator

Schnabulator · Problem with docker daemon in 11.0.5 Schnabulator January 29, 2024 at 5:29 PM

solved - it looks like overlay2 does not work on nfs shares. My libreelec pi's are netbooted

Schnabulator · Problem with docker daemon in 11.0.5 Schnabulator January 28, 2024 at 10:31 AM

Hello again,

if i try to start docker in libreelec 11.0.5 on a rpi4 via commandline it looks like it have problems with "graphdriver: driver not supportet". Does anyone know a solution for this?

Here is the output of systemctl status docker:

Code

...
Jan 28 11:15:44 rpi4one dockerd[1254]: time="2024-01-28T11:15:44.680520545+01:00" level=info msg="stopping event stream following graceful shutdown" error="context canceled" modu
Jan 28 11:15:45 rpi4one dockerd[1254]: failed to start daemon: error initializing graphdriver: driver not supported
Jan 28 11:15:45 rpi4one systemd[1]: docker.service: Main process exited, code=exited, status=1/FAILURE
Jan 28 11:15:45 rpi4one systemd[1]: docker.service: Failed with result 'exit-code'.

Thank you in advance for your help

Schnabulator · LibreElec 11 - mysql Schnabulator January 20, 2023 at 6:13 PM

Hi, i tested the latest LE 11 nightly. Sadly movies and series database folders from the mysql database are without content.

I can reach the nfs files directly, playing a video file was also not possible.

I use LE 10 official on two rpi4´'s with pxe tftpboot (symlinked directorys) and mysql database.

If i use the existing home from LE 10 --> Movies and Series have no content.

If i let LE 11 create a new home directory, and copy advancedsettings.xml to to .kodi/userdata i have the same result and a welcome dialog

Do you have any advice how to debug mysql connection in LE11?

here the errors in kodi.log

Code

2023-01-19 19:49:56.971 T:1208    error <general>: SQL: Can't determine list of routines to drop.
2023-01-19 19:49:56.971 T:1208    error <general>: Exception droping old analytics from MyVideos121
2023-01-19 19:49:56.978 T:1208    error <general>: Unable to open database: MyVideos120 [1049](Unknown database 'MyVideos120')
2023-01-19 19:49:56.991 T:1208    error <general>: SQL: Can't create database for copy: 'MyVideos119' (1007)
2023-01-19 19:49:56.991 T:1208    error <general>: Unable to copy old database MyVideos119 to new version MyVideos121
2023-01-19 19:49:57.465 T:1197    error <general>: SQL: [MyMusic82] The table does not exist
2023-01-19 19:49:57.465 T:1197    error <general>: GetSongsCount() failed
2023-01-19 19:49:57.810 T:1208    error <general>: SQL: [MyMusic82] The table does not exist
2023-01-19 19:49:57.810 T:1208    error <general>: GetRecentlyAddedAlbumSongs failed
2023-01-19 19:49:57.811 T:1208    error <general>: SQL: [MyMusic82] The table does not exist
2023-01-19 19:49:57.812 T:1208    error <general>: GetRecentlyAddedAlbums failed
2023-01-19 19:49:57.836 T:1208    error <general>: SQL: [MyMusic82] The table does not exist
2023-01-19 19:49:57.836 T:1208    error <general>: GetSingleValueInt - failed on query 'SELECT COUNT(1) FROM artistview  WHERE (EXISTS (SELECT 1 FROM song_artist WHERE song_artist.idArtist = artistview.idArtist AND song_artist.idRole = 1) OR EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artistview.idArtist)) AND (artistview.strArtist != '')'
2023-01-19 19:49:57.837 T:1208    error <general>: SQL: [MyMusic82] The table does not exist
2023-01-19 19:49:57.837 T:1208    error <general>: GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
2023-01-19 19:49:57.838 T:1208    error <general>: SQL: [MyMusic82] The table does not exist
2023-01-19 19:49:57.838 T:1208    error <general>: GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
2023-01-19 19:50:22.811 T:1225    error <general>: CCurlFile::CReadState::FillBuffer - (0xee334d40) Failed: Couldn't connect to server(7)

Display More

here is my advancedsettings.xml

Code

<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.2.249</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>mysafepassword</pass>
  </videodatabase> 
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.2.249</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>mysafepassword</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
    <recentlyaddeditems>50</recentlyaddeditems> <!-- number of recently added items. Defaults to 25 -->
    <dateadded>0</dateadded> <!-- 0 results in using the current datetime when adding a video;
                                  1 (default) results in prefering to use the files mtime (if it's valid) and only using the file's ctime if the mtime isn't valid;
                                  2 results in using the newer datetime of the file's mtime and ctime -->
  </videolibrary>
  <pathsubstitution>
    <substitute>
        <from>special://profile/sources.xml</from>
        <to>nfs://192.168.2.249/srv/tftpstorage/sources.xml</to>
  </substitute>
  </pathsubstitution>
</advancedsettings>

Display More