MYSQL – Stumped

Posted on Author Kodi Community Forum - All Forums

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 Big Grin ) – see below for source section:

Code:
<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

Code:
<?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:

  1. Host = % (the default)
  2. Host = localhost
  3. Host = lockett12 (QNAP Name)

Any ideas on where to turn to next. I sure it is going to be a simple solution, but alas…