Zentrale mysql Datenbank wird auf dem Synology NAS nicht eingerichtet...

  • Liebe Kodi-Freunde,

    ich habe vor paar Tagen festgestellt, dass nach dem Zidoo-Update, die Box sehr lange braucht um die Filme zu zeigen.

    Leider liegt das Problem nicht an dem Zidoo-Update, sondern an Synology MYSQL Datenbank.
    Aus dem Grund habe ich die ganze Datenbank (MariaDB 5) deinstalliert und wie ich schon paar mal gemacht habe;
    - MariaDB 5 installiert (root/admin) und den Benutzer kodi eingerichtet
    - Benutzername kodi, Passwort kodi, Gewähre alle Rechte auf Datenbanken die mit dem Benutzernamen beginnen (username\_%). und Alle auswählen angeklickt.

    Wenn ich unter /Kodi/userdata meine (abgespeckte) [definition='2','1']advancedsettings[/definition].xml

    Spoiler anzeigen

    <[definition='2','1']advancedsettings[/definition]>
    <videodatabase>
    <type>mysql</type>
    <host>192.168.0.15</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
    </videodatabase>
    <musicdatabase>
    <type>mysql</type>
    <host>192.168.0.15</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
    </musicdatabase>
    </[definition='2','1']advancedsettings[/definition]>

    einfüge, dann startet Kodi nicht mehr und die MYSQL Datenbank wird auch nicht um die Datensätze Video/Music erweitert.

    Ich habe schon mehrmals versucht von Synalogy NAS (neueste FW installert), die 3 Programme; Web Station, MariaDB 5 und phpMyAdmin
    zu deinstallieren und dann nach Neuinstallation, neu einzurichten.
    Leider ohne Erfolg, obwohl sie auf dem NAS laufen!
    MariaDB 10 verlangt nach einem 10 Zeichen längeren Passwort und läuft mit den Daten
    Port 3307 kodi/Passwort1%
    auch nicht.
    kodi-18.4-Leia-x64.exe habe ich auch neu installiert.

    Kann jemand den Wurm bei meinem Synology NAS erkennen?

    Herzlichen Dank für Eure Hilfe
    Tenker

  • Bei Zidoo ist ZDMC/Kodi 18.4 drauf, deshalb habe ich auf dem PC auch die Version.

    Bei MariaDB 5 ist der Port 3306
    Bei MariaDB 10 ist der Port 3307

    Beide funktionieren leider nicht.

    Ich hätte gerne gewusst, warum die mysql Datenbank auf meinem NAS nicht eingerichtet wird, bevor ich auf die Embdy-Empfehlung umsteige.

    Test mit einer neuen Installation von
    kodi-18.8-Leia-x64.exe
    Gleiches Problem, die Datenbank wird nicht erzeugt!

  • [definition=9,2]kodi.[definition='1','0']log[/definition][/definition]

    Spoiler anzeigen

    2020-07-09 16:49:34.905 T:10916 NOTICE: -----------------------------------------------------------------------
    2020-07-09 16:49:34.905 T:10916 NOTICE: Starting Kodi (18.7 (18.7.200) Git:20200616-1bcc91bb25). Platform: Windows NT x86 64-bit
    2020-07-09 16:49:34.905 T:10916 NOTICE: Using Release Kodi x64 build
    2020-07-09 16:49:34.905 T:10916 NOTICE: Kodi compiled 2020-07-08 by MSVC 191627035 for Windows NT x86 64-bit version 10.0 (0x0A000006)
    2020-07-09 16:49:34.905 T:10916 NOTICE: Running on Windows 10, kernel: Windows NT x86 64-bit version 10.0.18363
    2020-07-09 16:49:34.905 T:10916 NOTICE: FFmpeg version/source: 4.0.4-Kodi
    2020-07-09 16:49:34.905 T:10916 NOTICE: Host CPU: Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz, 8 cores available
    2020-07-09 16:49:34.906 T:10916 NOTICE: Desktop Resolution: 1920x1080 32Bit at 60Hz
    2020-07-09 16:49:34.906 T:10916 NOTICE: Running with restricted rights
    2020-07-09 16:49:34.906 T:10916 NOTICE: Aero is enabled
    2020-07-09 16:49:34.906 T:10916 NOTICE: special://xbmc/ is mapped to: C:\Program Files\Kodi
    2020-07-09 16:49:34.906 T:10916 NOTICE: special://xbmcbin/ is mapped to: C:\Program Files\Kodi
    2020-07-09 16:49:34.906 T:10916 NOTICE: special://xbmcbinaddons/ is mapped to: C:\Program Files\Kodi/addons
    2020-07-09 16:49:34.906 T:10916 NOTICE: special://masterprofile/ is mapped to: C:\Users\Asus-NTB\AppData\Roaming\Kodi\userdata
    2020-07-09 16:49:34.906 T:10916 NOTICE: special://home/ is mapped to: C:\Users\Asus-NTB\AppData\Roaming\Kodi\
    2020-07-09 16:49:34.906 T:10916 NOTICE: special://temp/ is mapped to: C:\Users\Asus-NTB\AppData\Roaming\Kodi\cache
    2020-07-09 16:49:34.906 T:10916 NOTICE: special://logpath/ is mapped to: C:\Users\Asus-NTB\AppData\Roaming\Kodi\
    2020-07-09 16:49:34.906 T:10916 NOTICE: The executable running is: C:\Program Files\Kodi\kodi.exe
    2020-07-09 16:49:34.915 T:10916 NOTICE: Local hostname: Asus-NTB
    2020-07-09 16:49:34.915 T:10916 NOTICE: Log File is located: C:\Users\Asus-NTB\AppData\Roaming\Kodi\[definition=9,2]kodi.[definition='1','0']log[/definition][/definition]
    2020-07-09 16:49:34.915 T:10916 NOTICE: -----------------------------------------------------------------------
    2020-07-09 16:49:34.915 T:10916 INFO: loading settings
    2020-07-09 16:49:34.918 T:10916 NOTICE: special://profile/ is mapped to: special://masterprofile/
    2020-07-09 16:49:34.923 T:10916 DEBUG: CSkinSettings: no <skinsettings> tag found
    2020-07-09 16:49:34.923 T:10916 NOTICE: No settings file to load (special://xbmc/system/[definition='2','1']advancedsettings[/definition].xml)
    2020-07-09 16:49:34.924 T:10916 NOTICE: Loaded settings file from special://profile/[definition='2','1']advancedsettings[/definition].xml
    2020-07-09 16:49:34.924 T:10916 NOTICE: Contents of special://profile/[definition='2','1']advancedsettings[/definition].xml are...
    <[definition='2','1']advancedsettings[/definition]>
    <videodatabase>
    <type>mysql</type>
    <host>192.168.0.15</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>*****</pass>
    </videodatabase>
    <musicdatabase>
    <type>mysql</type>
    <host>192.168.0.15</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>*****</pass>
    </musicdatabase>
    </[definition='2','1']advancedsettings[/definition]>
    2020-07-09 16:49:34.924 T:10916 WARNING: VIDEO database configuration is experimental.
    2020-07-09 16:49:34.924 T:10916 WARNING: CSettingsManager: missing version attribute
    2020-07-09 16:49:34.924 T:10916 NOTICE: Default Video Player: VideoPlayer
    2020-07-09 16:49:34.924 T:10916 NOTICE: Default Audio Player: paplayer
    2020-07-09 16:49:34.924 T:10916 NOTICE: Disabled [definition=12,0]debug[/definition] [definition=12,9]logging[/definition] due to GUI setting. Level 0.
    2020-07-09 16:49:34.924 T:10916 NOTICE: Log level changed to "LOG_LEVEL_NORMAL"
    2020-07-09 16:49:34.925 T:10916 NOTICE: CMediaSourceSettings: loading media sources from special://masterprofile/sources.xml
    2020-07-09 16:49:34.934 T:10916 NOTICE: Running database version Addons27
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: audioencoder.kodi.builtin.aac v1.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: audioencoder.kodi.builtin.wma v1.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: game.controller.default v1.0.8 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: game.controller.snes v1.0.8 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.global.audioengine v1.0.1 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.global.filesystem v1.0.2 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.global.general v1.0.3 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.global.gui v5.12.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.global.main v1.0.14 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.global.network v1.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.audiodecoder v2.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.audioencoder v2.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.game v1.1.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.imagedecoder v2.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.inputstream v2.0.8 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.peripheral v1.3.7 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.pvr v5.10.3 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.screensaver v2.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.vfs v2.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.videocodec v1.0.1 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.binary.instance.visualization v2.0.1 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: kodi.resource v1.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.album.universal v3.1.3 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.artists.universal v4.3.3 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.common.allmusic.com v3.2.2 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.common.fanart.tv v3.6.3 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.common.imdb.com v3.1.5 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.common.musicbrainz.org v2.2.4 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.common.theaudiodb.com v2.0.3 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.common.themoviedb.org v3.2.3 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.local v1.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.themoviedb.org v5.2.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: metadata.tvshows.themoviedb.org v3.5.3 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: peripheral.joystick v1.4.9 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: repository.xbmc.org v3.1.6 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: resource.images.weathericons.default v1.1.8 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: resource.language.de_de v9.0.21 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: resource.language.en_gb v2.0.1 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: resource.uisounds.kodi v1.0.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: screensaver.xbmc.builtin.black v1.0.33 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: screensaver.xbmc.builtin.dim v1.0.59 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: script.module.pil v1.1.7 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: script.module.pycryptodome v3.4.3 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: service.xbmc.versioncheck v0.5.5 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: skin.estouchy v2.0.28 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: skin.estuary v2.0.27 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: webinterface.default v18.x-2.4.6 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: xbmc.addon v18.7 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: xbmc.core v0.1.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: xbmc.gui v5.14.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: xbmc.json v10.3.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: xbmc.metadata v2.1.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: xbmc.python v2.26.0 installed
    2020-07-09 16:49:34.958 T:10916 NOTICE: ADDON: xbmc.webinterface v1.0.0 installed
    2020-07-09 16:49:35.004 T:14712 NOTICE: Found 2 Lists of Devices
    2020-07-09 16:49:35.004 T:14712 NOTICE: Enumerated DIRECTSOUND devices:
    2020-07-09 16:49:35.004 T:14712 NOTICE: Device 1
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_deviceName : {EA9A54A7-F125-4152-B3FF-849BF21DB15B}
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_displayName : Speakers - Lautsprecher (Realtek High Definition Audio)
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_displayNameExtra: DIRECTSOUND: Lautsprecher (Realtek High Definition Audio)
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_deviceType : AE_DEVTYPE_PCM
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_channels : FL, FR
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_sampleRates : 48000
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_dataFormats : AE_FMT_FLOAT
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_streamTypes : No passthrough capabilities
    2020-07-09 16:49:35.004 T:14712 NOTICE: Device 2
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_deviceName : default
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_displayName : default
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_displayNameExtra:
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_deviceType : AE_DEVTYPE_PCM
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_channels : FL, FR
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_sampleRates : 48000
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_dataFormats : AE_FMT_FLOAT
    2020-07-09 16:49:35.004 T:14712 NOTICE: m_streamTypes : No passthrough capabilities
    2020-07-09 16:49:35.004 T:14712 NOTICE: Enumerated WASAPI devices:
    2020-07-09 16:49:35.005 T:14712 NOTICE: Device 1
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_deviceName : {EA9A54A7-F125-4152-B3FF-849BF21DB15B}
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_displayName : Speakers - Lautsprecher (Realtek High Definition Audio)
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_displayNameExtra: WASAPI: Lautsprecher (Realtek High Definition Audio)
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_deviceType : AE_DEVTYPE_PCM
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_channels : FL, FR
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_sampleRates : 192000,96000,48000,44100
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_dataFormats : AE_FMT_S24NE4MSB,AE_FMT_S16NE,AE_FMT_S16LE,AE_FMT_S16BE
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_streamTypes : No passthrough capabilities
    2020-07-09 16:49:35.005 T:14712 NOTICE: Device 2
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_deviceName : default
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_displayName : default
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_displayNameExtra:
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_deviceType : AE_DEVTYPE_PCM
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_channels : FL, FR
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_sampleRates : 192000,96000,48000,44100
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_dataFormats : AE_FMT_S24NE4MSB,AE_FMT_S16NE,AE_FMT_S16LE,AE_FMT_S16BE
    2020-07-09 16:49:35.005 T:14712 NOTICE: m_streamTypes : No passthrough capabilities
    2020-07-09 16:49:35.043 T:10916 NOTICE: Primary mode: Generic PnP Monitor #1: 1920x1080 @ 60.00Hz
    2020-07-09 16:49:35.043 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 320x200 @ 60.00Hz
    2020-07-09 16:49:35.043 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 320x240 @ 60.00Hz
    2020-07-09 16:49:35.044 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 400x300 @ 60.00Hz
    2020-07-09 16:49:35.044 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 512x384 @ 60.00Hz
    2020-07-09 16:49:35.044 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 640x400 @ 60.00Hz
    2020-07-09 16:49:35.044 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 640x480 @ 60.00Hz
    2020-07-09 16:49:35.044 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 800x600 @ 60.00Hz
    2020-07-09 16:49:35.045 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1024x768 @ 60.00Hz
    2020-07-09 16:49:35.045 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1152x864 @ 60.00Hz
    2020-07-09 16:49:35.045 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1280x600 @ 60.00Hz
    2020-07-09 16:49:35.045 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1280x720 @ 60.00Hz
    2020-07-09 16:49:35.045 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1280x768 @ 60.00Hz
    2020-07-09 16:49:35.046 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1280x800 @ 60.00Hz
    2020-07-09 16:49:35.046 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1280x960 @ 60.00Hz
    2020-07-09 16:49:35.046 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1280x1024 @ 60.00Hz
    2020-07-09 16:49:35.046 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1360x768 @ 60.00Hz
    2020-07-09 16:49:35.047 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1366x768 @ 60.00Hz
    2020-07-09 16:49:35.047 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1400x1050 @ 60.00Hz
    2020-07-09 16:49:35.047 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1440x900 @ 60.00Hz
    2020-07-09 16:49:35.047 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1600x900 @ 60.00Hz
    2020-07-09 16:49:35.047 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1680x1050 @ 60.00Hz
    2020-07-09 16:49:35.048 T:10916 NOTICE: Additional mode: Generic PnP Monitor #1: 1920x1080 @ 60.00Hz
    2020-07-09 16:49:35.048 T:10916 NOTICE: Checking resolution 16
    2020-07-09 16:49:35.305 T:6972 NOTICE: Running database version Addons27
    2020-07-09 16:49:35.306 T:6972 NOTICE: Running database version ViewModes6
    2020-07-09 16:49:35.307 T:6972 NOTICE: Running database version Textures13
    2020-07-09 16:49:45.326 T:6972 NOTICE: MYSQL: Connected to version 5.5.62-MariaDB
    2020-07-09 16:49:45.333 T:6972 ERROR: Unable to open database: MyMusic72 [1049](Unknown database 'MyMusic72')

  • Wenn ich aber den Eingangspost nochmal lese, dann denke ich, dass das Problem auf der Seite des NAS zu suchen ist. So wie es klingt läuft da MySQL/MariaDB nicht richtig. Stimmt das? Wenn ja, dann kann Kodi auch nichts finden. Da wäre es ggf. besser Support bei Synology zu suchen.

  • Wenn ich aber den Eingangspost nochmal lese, dann denke ich, dass das Problem auf der Seite des NAS zu suchen ist. So wie es klingt läuft da MySQL/MariaDB nicht richtig. Stimmt das?
    ...

    Ich glaube auch, dass die mysql Datenbank nach dem letzten DSM Update die Probleme verursacht hat.

  • Naja, es ist dein NAS und nur du hast Zugriff darauf. Läuft die Datenbank oder nicht?

    Ich werde das nicht beurteilen können

Jetzt mitmachen!

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