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