v16 - MYSQL Database doesn't work

v16 MYSQL Database doesn't work - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Linux (https://forum.kodi.tv/forumdisplay.php?fid=52)
+---- Thread: v16 MYSQL Database doesn't work (/showthread.php?tid=302833)

MYSQL Database doesn't work - Catskan - 2017-01-02

Hi all,

I'm trying to set up a mysql database for kodi with the advancedsettings file but doesn't work.

I was created this file with the exemple on kodi wiki and I place to .kodi/userdata .

When I start Kodi, my library doesn't load and the movie and series categories no longer appear. Furthermore, kodi doesn't create databases.

If I delete this file, kodi works fine and I can use my library.

My advancedsettings.xml

Code:
<advancedsettings>

  <videodatabase>

    <type>mysql</type>

    <host>192.168.1.14</host>

    <port>3306</port>

    <user>administrator</user>

    <pass>administrator</pass>

  </videodatabase> 

  <musicdatabase>

    <type>mysql</type>

    <host>192.168.1.14</host>

    <port>3306</port>

    <user>administrator</user>

    <pass>administrator</pass>

  </musicdatabase>

  <videolibrary>

    <importwatchedstate>false</importwatchedstate>

    <importresumepoint>false</importresumepoint>

  </videolibrary>

</advancedsettings>

Where could be the problem ?

Thanks you in advance for your help.

Catskan

RE: MYSQL Database doesn'y work - nickr - 2017-01-02

a debug log would help, but make sure you followed all the mysql instructions, particularly the server setup.

RE: MYSQL Database doesn'y work - asavah - 2017-01-03

A common mistake with mysql setup is that mysql server is not configured to listen for incoming connections on LAN,
by default it only listens on 127.0.0.1 , or username% was not configured.

As @nickr said a debug log might provide more clues about what's wrong.

RE: MYSQL Database doesn'y work - Catskan - 2017-01-03

Hi guys, thanks you for your help.

I have modify the ip by 127.0.0.1. My user can connect to my MYSQL Server because it's the administrator user (for the moment) ...

Kodi's log does not indicate an error but my library doesn't displayed .

Kodi.log

Code:
40:59 T:140650481686272  NOTICE: PVRManager - starting up

40:59 T:140651473344832  NOTICE: starting zeroconf publishing

40:59 T:140651473344832  NOTICE: starting upnp client

40:59 T:140649617671936  NOTICE: ES: Starting UDP Event server on 127.0.0.1:9777

40:59 T:140649617671936  NOTICE: UDP: Listening on port 9777

40:59 T:140650464900864  NOTICE: VideoInfoScanner: Starting scan ..

40:59 T:140650464900864  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00

41:02 T:140650464900864  NOTICE: Start - EPG thread started

41:05 T:140650498471680  NOTICE: Skin Helper Service --> skin helper service version 1.0.100 started

41:05 T:140650498471680  NOTICE: Skin Helper Service --> WebService - start helper webservice on port 52307

RE: MYSQL Database doesn'y work - Prof Yaffle - 2017-01-03

Debug log, please, and no snippets - use pastebin.com for the whole log and provide the link here.

RE: MYSQL Database doesn'y work - Catskan - 2017-01-03

Hi,

I have enabled log level 2 : http://pastebin.com/mar2g8th

Now, I have the two databases but, when I imported my library, nothing happens ...

RE: MYSQL Database doesn't work - nickr - 2017-01-03

Is your mysql server on the same machine as kodi?

RE: MYSQL Database doesn't work - Catskan - 2017-01-03

Yes yes.

I have the databases "MyVideoxx" and "MyMusicxx" but I can't import my backed up library. Films and Series menus no longer display.