Kodi Community Forum
Can't use same database with Android and any other OS - Printable Version

Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
--- Thread: Can't use same database with Android and any other OS (/showthread.php?tid=355471)



Can't use same database with Android and any other OS - excelsi0r - 2020-06-26

I am trying to have several Kodi's to use the same database... as described below.


Image

All Kodi's are at version 18.2
Using the default estuary skin in all
Libreelec is at version 8.90.015
MariaDB version 10.5.4
Raspbian 9.11
Android is 10 QKQ1.190825.002

Everything works great between Libreelec and Raspbian. Watched status and resume points work normally.
However, when using the Android device, the left side icons aren't working (Not watched, Resume, Watched). The resume points work though... Meaning: If a file is marked as "Resume" in Libreelec. In Android is marked as "Not watched" but if I click on it, it says "Resume from XX:XX:XX".

Does anyone know what this might be?

I followed the tutorial: Kodi MySQL thoroughly. 
This is my advancedsettings.xml:


<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.64</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </videodatabase> 
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.1.64</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
</advancedsettings>

These are the commands that were used to setup MariaDB.


docker pull arm64v8/mariadb
docker run --name mariadb -e MYSQL_ROOT_PASSWORD=root -d -p 3306:3306 --restart unless-stopped arm64v8/mariadb

mysql -u root -p'root' -h 192.168.1.64
CREATE USER 'kodi' IDENTIFIED BY 'kodi';
GRANT ALL ON *.* TO 'kodi';
flush privileges;


One thing I noticed, the database created by the android device is:

Image

Whereas the one created by Raspbian or Libreelec is:

Image

Thanks in advance!


RE: Can't use same database with Android and any other OS - Klojum - 2020-06-26

We could use a full debug log (wiki) from the problematic Android device.


RE: Can't use same database with Android and any other OS - excelsi0r - 2020-06-27

(2020-06-26, 21:25)Klojum Wrote: We could use a full debug log (wiki) from the problematic Android device.

kodi.old.log

kodi.log

Here they are.
Also, I forgot to mention. I tried to use Kodi 18.0 and 18.7 in Android. It is the same behavior. The resume points work but the status icon are always as "not watched".


RE: Can't use same database with Android and any other OS - Klojum - 2020-06-27

(2020-06-27, 19:18)excelsi0r Wrote: Here they are.

2020-06-27 02:46:58.788 T:14709 NOTICE: MYSQL: Connected to version 10.5.4-MariaDB-1:10.5.4+maria~focal

The database connection is there, that's a good start.

2020-06-27 02:46:58.039 T:14692 NOTICE: Disabled debug logging due to GUI setting. Level 0.

Unfortunately, debug has not been enabled. Do so, restart Kodi, and reproduce the error(s) again. And then provide the new log file here, please.


RE: Can't use same database with Android and any other OS - excelsi0r - 2020-07-01

(2020-06-27, 19:18)excelsi0r Wrote:
(2020-06-26, 21:25)Klojum Wrote: We could use a full debug log (wiki) from the problematic Android device.

kodi.old.log

kodi.log

Here they are.
Also, I forgot to mention. I tried to use Kodi 18.0 and 18.7 in Android. It is the same behavior. The resume points work but the status icon are always as "not watched".

My bad.
Here it is with the same behavior. Opening a file, saving its status but the icon is still "Not watched"


kodi.log


This forum uses Lukasz Tkacz MyBB addons.