Hallo liebe Foren Gemeinde ,
ich habe mir vor 2 Tagen vorgenommen fix von kodibuntu 16.X auf Ubuntu mit Kodi 17.04 umzusteigen. Die Installation lief auch ohne Probleme. Aber ich bekomme es nicht hin das Kodi Mysql nutzt.
Egal welche IP ich in die addvancedsettings.xml eintrage er wirft immer den selben Fehler aus. Eigentlich will ich 192.168.178.21 nutzen 
User kodi mit GRANT Rechten und Zugriff per Host % ist natürlich vorhanden.
Die mysqld.cnf unter /etc/mysql/mysql.conf.d hab ich angepasst.
bind-address= 127.0.0.1 zu bind-address= 0.0.0.0
Hier nun einige Informationen , die hoffe ich helfen um mein Problem zu finden.
netstat -nat |grep :3306
Spoiler anzeigen
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
[definition='2','1']advancedsettings[/definition].xml
Spoiler anzeigen
<[definition='2','1']advancedsettings[/definition]>
<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>
<epgdatabase>
<type>mysql</type>
<host>127.0.0.1</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</epgdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
<useddsfanart>true</useddsfanart>
<samba>
<clienttimeout>30</clienttimeout>
</samba>
<network>
<disableipv6>true</disableipv6>
</network>
</[definition='2','1']advancedsettings[/definition]>
Hier das kodi Log
Spoiler anzeigen
23:58:45.988 T:140076801582848 ERROR: Unable to open database: MyVideos89 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.988 T:140076801582848 ERROR: Unable to open database: MyVideos88 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.988 T:140076801582848 ERROR: Unable to open database: MyVideos87 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.988 T:140076801582848 ERROR: Unable to open database: MyVideos86 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.989 T:140076801582848 ERROR: Unable to open database: MyVideos85 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.989 T:140076801582848 ERROR: Unable to open database: MyVideos84 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.989 T:140076801582848 ERROR: Unable to open database: MyVideos83 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.989 T:140076801582848 ERROR: Unable to open database: MyVideos82 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.989 T:140076801582848 ERROR: Unable to open database: MyVideos81 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.989 T:140076801582848 ERROR: Unable to open database: MyVideos80 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.990 T:140076801582848 ERROR: Unable to open database: MyVideos79 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.990 T:140076801582848 ERROR: Unable to open database: MyVideos78 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.990 T:140076801582848 ERROR: Unable to open database: MyVideos77 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.990 T:140076801582848 ERROR: Unable to open database: MyVideos76 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.990 T:140076801582848 ERROR: Unable to open database: MyVideos75 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.990 T:140076801582848 ERROR: Unable to open database: MyVideos107 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.990 T:140076801582848 ERROR: Unable to create new database
23:58:45.991 T:140076801582848 NOTICE: Running database version TV29
23:58:45.992 T:140076801582848 ERROR: Unable to open database: Epg11 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.992 T:140076801582848 ERROR: Unable to open database: Epg10 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.992 T:140076801582848 ERROR: Unable to open database: Epg9 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.992 T:140076801582848 ERROR: Unable to open database: Epg8 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.992 T:140076801582848 ERROR: Unable to open database: Epg7 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.992 T:140076801582848 ERROR: Unable to open database: Epg6 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.992 T:140076801582848 ERROR: Unable to open database: Epg5 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.992 T:140076801582848 ERROR: Unable to open database: Epg4 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.992 T:140076801582848 ERROR: Unable to open database: Epg11 [2003](Can't connect to MySQL server on '127.0.0.1' (111))
23:58:45.992 T:140076801582848 ERROR: Unable to create new database
23:58:45.995 T:140077448989056 NOTICE: start dvd mediatype detection
23:58:46.177 T:140077448989056 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList"
23:58:46.271 T:140077448989056 NOTICE: initialize done
23:58:46.271 T:140077448989056 NOTICE: Running the application...
23:58:46.278 T:140077448989056 NOTICE: starting zeroconf publishing
23:58:46.278 T:140077448989056 NOTICE: starting upnp client
23:58:46.285 T:140075568449280 NOTICE: ES: Starting UDP Event server on port 9777
23:58:46.285 T:140075568449280 NOTICE: UDP: Listening on port 9777 (ipv6 : false)
Vielen Dank
