HOW-TO:Share libraries using MySQL: Wiki Edition
Hey Guys,

I somehow can't get Kodi to create a Database in Mysql.

I am running
Ubuntu 16.04 x64
Kodi 17 B3,
mysql Ver 15.1 Distrib 10.0.27-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

i did check the credentials and wether or not i could create a db successfully
(mysql -u kodi -h 127.0.0.1 -p) -> "Password: kodi" -> create database wow;
I also connected without -h and with the device's local ip instead of the localhost.

Since i'm running 16.04, i did follow the Autostart Guide on the Kodi wiki, which said if you need mysql include
Code:
if you need the MySQL DB backend, use this block instead of the previous
After = systemd-user-sessions.service network.target sound.target mysql.service
Wants = mysql.service
That's why i believe Mysql is already up and running when kodi tries to work its magic.

Code:
21:15:16 T:140097862826368  NOTICE: Running database version Addons26
21:15:16 T:140097862826368   DEBUG: Initialize, updating databases...
21:15:16 T:140097862826368  NOTICE: Running database version ViewModes6
21:15:16 T:140097862826368  NOTICE: Running database version Textures13
21:15:16 T:140097862826368   ERROR: Unable to open database: MyMusic60 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
21:15:16 T:140097862826368   ERROR: Unable to open database: MyMusic59 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
21:15:16 T:140097862826368   ERROR: Unable to open database: MyMusic58 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
21:15:16 T:140097862826368   ERROR: Unable to open database: MyMusic57 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
21:15:16 T:140097862826368   ERROR: Unable to open database: MyMusic56 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
21:15:16 T:140097862826368   ERROR: Unable to open database: MyMusic55 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
...
21:15:16 T:140097862826368   ERROR: Unable to create new database
21:15:16 T:140097862826368   ERROR: Unable to open database: MyVideos107 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
21:15:16 T:140097862826368   ERROR: Unable to open database: MyVideos106 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
21:15:16 T:140097862826368   ERROR: Unable to open database: MyVideos105 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
21:15:16 T:140097862826368   ERROR: Unable to open database: MyVideos104 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
21:15:16 T:140097862826368   ERROR: Unable to open database: MyVideos103 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
...
21:15:16 T:140097862826368   ERROR: Unable to create new database

my advancedsettings.xml
Code:
<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>127.0.0.1</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </videodatabase>
  <musicdatabase>
    <type>mysql</type>
    <host>127.0.0.1</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
</advancedsettings>

Anyone 's got an idea?
Reply


Messages In This Thread
RE: HOW-TO:Share libraries using MySQL: Wiki Edition - by Y05H10 - 2016-10-12, 21:42


Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition2
This forum uses Lukasz Tkacz MyBB addons.