MySql Datenbank

  • in Hinweis bei der Installation wie z.B., das bei der Nutzung später Kosten anfallen, und ich dann ggf., sofern ich mich dagegen entscheide, die Installation abbrechen kann, und mich nicht mehr, in Unwissenheit, mit dem Setup beschäftigen muss.

    Naja, beim Installieren ist "enthällt In-App Einkäufe" ja schon ein kleiner Hinweis :)

    --------------
    Guides nicht mehr verfügbar wegen Youtube unvermögen guten von schlechten Kodi Videos zu unterscheiden.

  • Hallo Leute Ich versuch seit 2 tagen meine Pis und meine QNAP zu koppeln

    Ich habe 2 Pis udn eine Qnap auf der Kodi 18.9 laufen


    Meine [definition='2','1']advancedsettings[/definition].xml sieht so aus

    XML-Quellcode: [definition='2','1']advancedsettings[/definition].xmlQuellcode bearbeiten


    Ich habe auf der QNAP einen SQL Server MariaDB 5.5.57 laufen..
    und eine WD My Cloud mit einem MariaDB 10.3.27


    Ich hab beide Geräte getestet ein mal die Ip 253 ( QNAP) und ein mal die IP 220 ( WD)

    Ich hab es versucht bei beiden Geräten nur den User anzulegen und dann noch ein mal mit DB anzulegen
    QuellcodeQuellcode bearbeiten


    <[definition='2','1']advancedsettings[/definition]>
    <videodatabase>
    <type>mysql</type>
    <host>192.168.0.253</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
    </videodatabase>
    <musicdatabase>
    <type>mysql</type>
    <host>192.168.0.253</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
    </musicdatabase>
    <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
    </videolibrary>
    </[definition='2','1']advancedsettings[/definition]>


    SQL-AbfrageQuellcode bearbeiten


    You have added a new user.
    CREATE USER 'kodi'@'%' IDENTIFIED VIA mysql_native_password USING '***';GRANT ALL PRIVILEGES ON *.* TO 'kodi'@'%' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `kodi`;GRANT ALL PRIVILEGES ON `kodi`.* TO 'kodi'@'%';


    Bei allen versuchen steht im Logg immer das gleiche


    Quellcode: Kodi LogggQuellcode bearbeiten
    QuellcodeQuellcode bearbeiten


    2019-04-11 18:28:42.501 T:2875597680 DEBUG: Initialize, updating databases...
    2019-04-11 18:28:42.504 T:2875597680 NOTICE: Running database version Addons27
    2019-04-11 18:28:42.511 T:2875597680 NOTICE: Running database version ViewModes6
    2019-04-11 18:28:42.984 T:2875597680 NOTICE: Running database version Textures13
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic72 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic71 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic70 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic69 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic68 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic67 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic66 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic65 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic64 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.989 T:2875597680 ERROR: Unable to open database: MyMusic63 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic62 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic61 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic60 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic59 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic58 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic57 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic56 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic55 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic54 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic53 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.990 T:2875597680 ERROR: Unable to open database: MyMusic52 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic51 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic50 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic49 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic48 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic47 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic46 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic45 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic44 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic43 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic42 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic41 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.991 T:2875597680 ERROR: Unable to open database: MyMusic40 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyMusic39 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyMusic38 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyMusic37 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyMusic36 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyMusic35 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyMusic34 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyMusic33 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyMusic32 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyMusic72 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to create new database
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyVideos116 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.992 T:2875597680 ERROR: Unable to open database: MyVideos115 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos114 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos113 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos112 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos111 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos110 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos109 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos108 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos107 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos106 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos105 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.993 T:2875597680 ERROR: Unable to open database: MyVideos104 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos103 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos102 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos101 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos100 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos99 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos98 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos97 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos96 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos95 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos94 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos93 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.994 T:2875597680 ERROR: Unable to open database: MyVideos92 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos91 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos90 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos89 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos88 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos87 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos86 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos85 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos84 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos83 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos82 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.995 T:2875597680 ERROR: Unable to open database: MyVideos81 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.996 T:2875597680 ERROR: Unable to open database: MyVideos80 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.996 T:2875597680 ERROR: Unable to open database: MyVideos79 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.996 T:2875597680 ERROR: Unable to open database: MyVideos78 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.996 T:2875597680 ERROR: Unable to open database: MyVideos77 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.996 T:2875597680 ERROR: Unable to open database: MyVideos76 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.996 T:2875597680 ERROR: Unable to open database: MyVideos75 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.996 T:2875597680 ERROR: Unable to open database: MyVideos116 [2002](Can't connect to MySQL server on '192.168.0.220' (101))
    2019-04-11 18:28:42.996 T:2875597680 ERROR: Unable to create new database


    Ich weiss echt nicht mehr weiter ??

    Auch mein Kodi speichert jetzt die Einstellungen nicht mehr also wenn ich einem Netzwerklaufwerk den Inhalt Festlegen will sind die einstellungen nach dem nächsten mal rein gehen wieder weg, Also ob Film Serie Musik usw.. und die Informationsquelle usw...


    Vielleicht weis einer von Euch noch rat ?? Ich leider nicht mehr.

  • Hi,

    MySQL und auch MariaDB lassen von Haus immer nur Anfragen von localhost (127.0.0.1) zu. Wenn diese Datenbanken im Netzwerk erreichbar sein sollen, dann ist der Eintrag bind-adress anzupassen.
    Diesen Eintrag findest du im Fall von MySQL in /etc/my.cnf und bei MariaDB in /etc/mysql/mariadb.conf.d/50-server-cnf
    Suche dort nach bind-adress und setze dort den Wert 0.0.0.0 für alle Netzwerke können zugreifen oder wenn du den Zugriff nur auf dein Netzwerk beschränken möchtest auf 192.168.0.0/24
    Diese Änderung macht einen Neustart des Service erforderlich.

    Grüße

    Radagast

    Edited once, last by Radagast (May 14, 2021 at 4:49 AM).

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!