Kodi kann keine Datenbank erstellen - MYSQL 5.7 - Ubuntu 16.04 LTS ( Xubuntu minimal Installation )

  • 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 :D

    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

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!