Good morning and Merry Christmas to everyone
I have been using Kodi (Jarvis v16.0) for a while now, with one install on the AFTV and another on my Windows 10 laptop. Both have their separate libraries – but now I want to just manage the one library. I am trying this on the Windows 10 machine first. I am not going to import an existing library, just build one from scratch, as I do not want the clutter of the NFO files.
The libraries are on my QNAP TS-219P II – Version 4.2.2 – file path “//192.168.1.200/Multimedia/Video”.
I have MYSQL (5.1.73) enabled on the QNAP, using Port 3306. I have set up a user (using myPHPAdmin) and password (kodi) to have full access rights to the Multimedia shared folder.
My source file path is SMB (I will eventually move this to NFS – but need to read more of the wiki – as my initial attempts have failed ) – see below for source section:
<video>
<default pathversion="1"></default>
<source>
<name>Movies</name>
<path pathversion="1">smb://192.168.1.200/Multimedia/Video/Movies/</path>
<allowsharing>true</allowsharing>
</source>
<source>
<name>TV</name>
<path pathversion="1">smb://192.168.1.200/Multimedia/Video/TV/</path>
<allowsharing>true</allowsharing>
</source>
</video>
Without the advancedsettings.xml in the userdata folder the library builds ok locally, indicating that the source.xml file is fine.
When I place the advancedsettings.xml file in the userdata folder (below), I am unable to connect to the MYSQL server database – and I’m not sure why. The log file can be found here
<?xml version="1.0" encoding="utf-8"?>
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.200</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.200</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
</advancedsettings>
In MYPHPAdmin, I have played around with the setting for the user kodi, trying the below – none of which gets me to connect:
- Host = % (the default)
- Host = localhost
- Host = lockett12 (QNAP Name)
Any ideas on where to turn to next. I sure it is going to be a simple solution, but alas…