[dbenyakar]

Hi

I have few issue that I would like to get assistance with. This for syncing few kodi instances with MySQL on a NAS.

My setup is as follows:
I have 2 RPIs running Kodi 17 and a third installation of Kodi 17 on android device.
My movies and music libraries are on a NAS and this is where the MySQL is installed.

All kodi instances have the same advancesettings.xml.

I had to drop the databases myVideos107 and myMusic60 from MySQL so these will be recreated, so I shut all kodi instances and started only one, then started library scanning process.

1. Now, I have noticed that in databases folder in the running RPi, the MyVideos107.db and the MyMusic60.db were not created. How could that be? I thought it should have created those when the tables in MySQL have been filled with the information on each of the Kodi instances.
2. I found out that after scanning, the movies somehow already include the information of watched, unwatched, and resume in the case movie started and stopped in the middle. Where did it get that info from?

The third issue is about the thumbnails. Should I copy the thumbnails folder from one RPi to the other instances? Or it is copied automatically?


Regards

[ActionA]

The whole point of using mysql is that the pi doesn't need it's own .db. They are now reading the central nas .db.

No need to worry about thumbs, they will be cached on first read by each device.

[dbenyakar]

But I looked at the two RPIs and the one that scan the library, the MyVideos107.db and the MyMusic60.db were not created, but the other RPI they were created.
The only difference between them was that one was upgraded from 16.1 and the other was freshly installed with 17 and this is the one that has these files.

[ActionA]

View the log. This will explain if mysql is in use or not.

[dbenyakar]

But what puzzled me is how does it have the information of which movie was watched or movie started and stopped in the middle?

[ActionA]

Because it's reading from the shared mysql.

[zerocool_ie]

But what puzzled me is how does it have the information of which movie was watched or movie started and stopped in the middle?

Your 16.1 db had that information, so kodi 17 migrated it during the upgrade.

[dbenyakar]

But what puzzled me is how does it have the information of which movie was watched or movie started and stopped in the middle?

Your 16.1 db had that information, so kodi 17 migrated it during the upgrade.

But I dropped all databases before scanning and populating the new ones.

[zerocool_ie]

Did you leave any dbs on your MySQL server from versions 16.1 or lower?
database_versions (wiki)

[dbenyakar]

Did you leave any dbs on your MySQL server from versions 16.1 or lower?
database_versions (wiki)

Besides the MyMusic60 and the MyVideos107 databases that I know what these are, I havent created any of the others and Im not sure what they are.
as_photo_gallery
information_schema
MyMusic60
mysql
MyVideos107
performance_schema

[TRaSH]

Are you also using the trakt add-on ?

Verstuurd vanaf mijn GT-I9505 met Tapatalk

[dbenyakar]

I dont think so cause I dont know what it is

[zerocool_ie]

Good call!

[zerocool_ie]

As ActionA said, check your logs to make sure you are using MySQL and not local dbs

[dbenyakar]

And also the thumbnails arent being copied to the new device after startup. I have checked the logs and found the following errors:

Code:

09:42:39.938 T:1938813936  NOTICE: Running database version Addons27
09:42:39.941 T:1938813936  NOTICE: Running database version ViewModes6
09:42:39.945 T:1938813936  NOTICE: Running database version Textures13
09:42:39.983 T:1938813936  NOTICE: Running database version MyMusic60
09:42:40.015 T:1938813936  NOTICE: Running database version MyVideos107
09:42:40.018 T:1938813936  NOTICE: Running database version TV29
09:42:40.022 T:1938813936  NOTICE: Running database version Epg11
09:42:40.025 T:1958773680  NOTICE: start dvd mediatype detection
09:42:40.765 T:1958773680 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList"
09:42:41.485 T:1958773680  NOTICE: initialize done
09:42:41.486 T:1958773680  NOTICE: Running the application...
09:42:41.494 T:1958773680  NOTICE: starting zeroconf publishing
09:42:41.495 T:1958773680  NOTICE: CWebServer[8080]: Started
09:42:41.495 T:1958773680  NOTICE: starting upnp client
09:42:41.497 T:1607726064  NOTICE: ES: Starting UDP Event server on port 9777
09:42:41.497 T:1607726064  NOTICE: UDP: Listening on port 9777 (ipv6 : false)
09:00:44.040 T:1565783024   ERROR: COMXImageFile::ReadFile nfs....-poster.jpg not found
09:00:44.049 T:1565783024   ERROR: Previous line repeats 1 times.
09:00:44.049 T:1565783024  NOTICE: LoadJpeg: unable to load nfs....-poster.jpg
09:00:44.099 T:1691874288   ERROR: COMXImageFile::ReadFile nfs....-poster.jpg not found
09:00:44.112 T:1691874288   ERROR: Previous line repeats 1 times.
09:00:44.113 T:1691874288  NOTICE: LoadJpeg: unable to load nfs....-poster.jpg
09:00:44.159 T:1565783024   ERROR: COMXImageFile::ReadFile nfs....-poster.jpg not found
09:00:44.167 T:1938813936   ERROR: COMXImageFile::ReadFile nfs....-poster.jpg not found
09:00:44.167 T:1938813936  NOTICE: LoadJpeg: unable to load nfs....-poster.jpg
09:00:44.176 T:1565783024   ERROR: COMXImageFile::ReadFile nfs....-poster.jpg not found
09:00:44.176 T:1565783024  NOTICE: LoadJpeg: unable to load nfs....-poster.jpg
09:00:44.232 T:1938813936   ERROR: COMXImageFile::ReadFile nfs....-poster.jpg not found

The strange thing is that the two RPis running same version of Kodi 17, one of them loads the files with no issues and the other doesn't. (replaced the path to jpg with '....')
So connects properly to MySQL and reads from the databases on MySQL but for some reason it has issues reading the jpgs.