Hi there.
I'm running a central MySQL DB with multiple clients. All clients are Kodi 18.5. All clients save the resume points if watching a video:
Laptop (Bionic): (tail -f kodi.log | grep -i mysql)
2019-12-05 09:46:50.895 T:140293067859712 DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=74502019-12-05 09:46:50.910 T:140293067859712 DEBUG: Mysql execute: update files set playCount=NULL,lastPlayed='2019-12-05 09:46:50' where idFile=74502019-12-05 09:46:50.919 T:140293067859712 DEBUG: Mysql execute: insert into bookmark (idBookmark, idFile, timeInSeconds, totalTimeInSeconds, thumbNailImage, player, playerState, type) values(NULL,7450,1809.793130,7001.630000,'','VideoPlayer','', 1)
This is Amlogic Box running Coreelec:
2019-12-05 09:25:00.400 T:3610657664 DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=74502019-12-05 09:25:00.422 T:3766551424 DEBUG: Mysql execute: update files set playCount=NULL,lastPlayed='2019-12-05 09:25:00' where idFile=7450
2019-12-05 09:25:00.431 T:3766551424 DEBUG: Mysql execute: insert into bookmark (idBookmark, idFile, timeInSeconds, totalTimeInSeconds, thumbNailImage, player, playerState, type) values(NULL,7450,3055.282872,7001.630000,'','VideoPlayer','', 1)
This is Libreelec (9.2.0) (Rpi3):
2019-12-05 09:51:11.188 T:1793299328 DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=7448
As you can see, all systems (except LE) do execute the insert into the Mysql DB!?
# grep -i mysql .kodi/temp/kodi.log <type>mysql</type>
<type>mysql</type>
2019-12-05 09:35:16.603 T:1807721344 NOTICE: MYSQL: Connected to version 10.4.10-MariaDB-1:10.4.10+maria~bionic-log
2019-12-05 09:35:26.481 T:1648538496 NOTICE: [plugin.video.mediathekview-0.6.2:Updater]: Database driver: External (mysql)
2019-12-05 09:35:26.481 T:1648538496 NOTICE: [plugin.video.mediathekview-0.6.2:StoreMySQL]: Using MySQL connector version 1.1.7
2019-12-05 09:35:26.695 T:1648538496 NOTICE: [plugin.video.mediathekview-0.6.2:StoreMySQL]: Connected to server 192.168.5.13 running 10.4.10-MariaDB-1:10.4.10+maria~bionic-log
2019-12-05 09:38:01.949 T:1249416064 DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=7448
2019-12-05 09:51:11.188 T:1793299328 DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=7448
As you can see, the connection is established, no errors regarding MySQL and even Mediathekview is able to connect to the DB.
Only thing is, there's no bookmark execution running into the DB if a video is played from LE.
I noticed that even playcounts for audio aren't saved into the DB from LE, but I have no logs available atm.