Hello!
I set up a fresh v4 because i wanted to put my kodi DB on an sql server, and i couldnt get it installed/working with my old 2.x version, thats just for the history
I set up sql as shown in the 2 pics, and heres my advancedsettings
Code
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.2.106</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
<cache>
<buffermode>1</buffermode>
<memorysize>1100000000</memorysize>
<readfactor>10</readfactor>
</cache>
<video>
<playcountminimumpercent>95</playcountminimumpercent>
</video>
</advancedsettings>
Alles anzeigen
kodi log says unable to open the video DBs
i used telnet to check if the DB is reacting at all, and i get a "response":
Code
Trying 192.168.2.106...
Connected to 192.168.2.106.
Escape character is '^]'.
b
5.5.5-10.1.26-MariaDB-0+deb9u1�bI()4h1[-?�W#FwD/]iu10@mysql_native_passwordConnection closed by foreign host.
any ideas?