Can't use same database with Android and any other OS
#1
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!
Reply


Messages In This Thread
Can't use same database with Android and any other OS - by excelsi0r - 2020-06-26, 20:58


Logout Mark Read Team Forum Stats Members Help
Can't use same database with Android and any other OS0
This forum uses Lukasz Tkacz MyBB addons.