Hello,

​

I try to run a central database in docker on a raspberrypi4 in my home network. I think the issue is somewhere how I set it up.

On the device which runs kodi I start a browser and can browse to phpmyadmin with the MYSQL_USER username and password which is in the advancedsettings.xml. I can create and write data in the database. So it can be reached and the user has the necessary permission. I think. Or the problem is somewhere else.

I'm also a little bit confused because the error says "SqliteDatabase: cant't open" Shouldn't it be MySQL Database?

​

Error in kodi.log

2022-10-02 11:39:52.443 T:11552    INFO <general>: Running database version Addons33
2022-10-02 11:39:52.444 T:11552    INFO <general>: Running database version ViewModes6
2022-10-02 11:39:52.444 T:11552    INFO <general>: Running database version Textures13
2022-10-02 11:39:52.445 T:11552    INFO <general>: Running database version MyMusic82
2022-10-02 11:39:52.445 T:11552   FATAL <general>: SqliteDatabase: can't open 192.168.2.22/MyVideos119.db

​

docker-compose with network mode bridge

101   KodiDatabase:
102     image: lscr.io/linuxserver/mariadb:10.5.17-alpine
103     container_name: kodiDatabase
104     environment:
105       - PUID=1000
106       - PGID=1000
107       - MYSQL_ROOT_PASSWORD=ROOTPASSWORD
108       - TZ=Europe/London
109       - MYSQL_DATABASE=kodiDatabase
110       - MYSQL_USER=USERNAME
111       - MYSQL_PASSWORD=USERPASSWORD
112       - REMOTE_SQL=http://URL1/your.sql,https://URL2/your.sql
113     volumes:
114       - /media/Data/KodiDB:/config
115     ports:
116       - 3306:3306
117     dns:
118       - 192.168.2.1
119     networks:
120       dNet:
121         ipv4_address: 172.20.0.10
122     restart: always

​

advancedsettings.xml

<advancedsettings>
  <videodatabase>
    <type>MariaDB</type>
    <host>192.168.2.22</host>
    <port>3306</port>
    <user>USERNAME</user>
    <pass>USERPASSWORD</pass>
  </videodatabase>
</advancedsettings>