Vero 4k can't connect to mySQL Server on my NAS

Help and Support
1

Hi!
As I bought a second Vero, this time 4k+, I wanted to transfer the database to mySQL and use the two devices with one database. I found a lot of guides how to do that , but all of them are different in some details. To make a long story short, it doesn’t work so far, Vero cannot access the mySQL Server on my NAS. This is what I did:

  1. I exported the database fom the Vero 4k to The NAS, to a folder that is accessible for Vero 4k. NAS (QNAP 853) has a fixed IP (192.168.1.75).

  2. I created a new user “kodi” on the NAS that has access to my movies-folder, protocol NFS.

  3. I downloaded QMariaDB from QNAP-Club and installed it to have an actual version, the one that is part of NAS firmware is pretty old. So I have now QMariaDB 10.5.8 and phpMyAdmin 5.0.4 installed on my NAS. QMariaDB listens on port 3308, not to interfere with the original QMariaDB on port 3306.

  4. I created a new user “kodi” with the following code:
    GRANT ALL PRIVILEGES ON . TO ‘kodi’@’192.168.1.%’ IDENTIFIED BY ‘kodi’ WITH GRANT OPTION;
    This should grants user ‘kodi’ permissions to connect from anywhere on the 192.168.1.0/24 LAN.

  5. I created 3 .xml files and copied them via Fillezilla to /home/osmc/.kodi/userdata. all three have attributes 644.

advancedsettings.xml:
advancedsettings
videodatabase
type>mysql</type
host>192.168.1.75</host
port>3308</port
user>kodi</user
pass>kodi</pass
/videodatabase
pathsubstitution
substitute
from>special://masterprofile/Thumbnails/</from
to>nfs://192.168.1.75/Filmdatenbank/Thumbnails/</to
/substitute
/pathsubstitution
videolibrary
importwatchedstate>true</importwatchedstate
importresumepoint>true</importresumepoint
/videolibrary
cache
buffermode>2</buffermode
memorysize>500170752</memorysize
readfactor>5</readfactor
curlclienttimeout>10</curlclienttimeout
curllowspeedtime>10</curllowspeedtime
/cache
/advancedsettings

sources.xml:
sources
programs
default pathversion=“1”></default
/programs
video
default pathversion=“1”></default
source
name>Drohnenmovies</name
path pathversion=“1”>nfs://192.168.1.75/Filmdatenbank/Drohnenmovies/</path
/source
source
name>Movies</name
path pathversion=“1”>nfs://192.168.1.75/Filmdatenbank/Movies/</path
/source
/video
/sources

passwords.xml:
passwords
path
from pathversion=“1”>nfs://192.168.1.75/</from
to pathversion=“1”>nfs://kodi:kodi@192.168.1.75/</to
/path
/passwords

  1. I restarted the Vero 4k and, navigated to the exported datbase file and clicked on " import database"

  2. Nothing happened, in MySQL is no new database created and the log of the Vero 4k says:
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.hy_am v9.0.4 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.id_id v9.0.10 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.is_is v9.0.14 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.it_it v9.0.17 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.ja_jp v9.0.10 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.ko_kr v9.0.10 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.lt_lt v9.0.22 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.lv_lv v9.0.12 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.mi v9.0.6 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.mk_mk v9.0.8 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.ml_in v9.0.1 installed
    2021-02-18 17:41:52.489 T:4071452688 NOTICE: ADDON: resource.language.mn_mn v9.0.4 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.ms_my v9.0.13 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.mt_mt v9.0.6 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.my_mm v9.0.6 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.nb_no v9.0.12 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.nl_nl v9.0.22 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.os_os v1.0.2 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.pl_pl v9.0.16 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.pt_br v9.0.25 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.pt_pt v9.0.11 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.ro_ro v9.0.13 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.ru_ru v9.0.18 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.si_lk v9.0.4 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.sk_sk v9.0.20 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.sl_si v9.0.10 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.sq_al v9.0.7 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.sr_rs v9.0.10 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.sr_rs@latin v9.0.7 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.sv_se v9.0.19 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.szl v9.0.7 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.ta_in v9.0.8 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.te_in v9.0.2 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.tg_tj v9.0.6 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.th_th v9.0.7 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.uk_ua v9.0.11 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.uz_uz v9.0.4 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.vi_vn v9.0.6 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.zh_cn v9.0.16 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.language.zh_tw v9.0.23 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: resource.uisounds.kodi v1.0.0 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: screensaver.xbmc.builtin.black v1.0.33 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: screensaver.xbmc.builtin.dim v1.0.59 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.globalsearch v8.0.13 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.image.resource.select v2.0.4 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.certifi v2019.9.11 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.chardet v3.0.4 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.elementtree v1.2.8 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.idna v2.8 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.osmccommon v0.0.1 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.osmcsetting.apfstore v0.0.1 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.osmcsetting.logging v0.0.1 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.osmcsetting.networking v0.0.3 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.osmcsetting.remotes v0.0.1 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.osmcsetting.services v0.0.3 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.osmcsetting.updates v0.0.3 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.pil v1.1.7 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.pycryptodome v3.4.3 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.requests v2.22.0 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.six v1.13.0 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.urllib3 v1.25.6 installed
    2021-02-18 17:41:52.490 T:4071452688 NOTICE: ADDON: script.module.xmltodict v0.11.0 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: script.rss.editor v3.0.3 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: service.osmc.settings v0.0.1 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: skin.estouchy v2.0.28 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: skin.estuary v2.0.27 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: skin.osmc v18.5.0 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: skin.osmc.scope v18.5.0 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: vfs.libarchive v1.0.7 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: vfs.rar v2.3.2 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: vfs.sacd v1.0.4 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: vfs.sftp v1.0.6 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: webinterface.default v18.x-2.4.6 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: xbmc.addon v18.9 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: xbmc.core v0.1.0 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: xbmc.gui v5.14.0 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: xbmc.json v10.3.0 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: xbmc.metadata v2.1.0 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: xbmc.python v2.26.0 installed
    2021-02-18 17:41:52.491 T:4071452688 NOTICE: ADDON: xbmc.webinterface v1.0.0 installed
    2021-02-18 17:41:52.612 T:4071452688 ERROR: DBus error: org.freedesktop.DBus.Error.ServiceUnknown - The name org.freedesktop.UPower was not provided by any .service files
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: Found 1 Lists of Devices
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: Enumerated ALSA devices:
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: Device 1
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_deviceName : default
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_displayName : Default (AML-M8AUDIO: HDMI, S/PDIF & analogue)
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_displayNameExtra:
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_deviceType : AE_DEVTYPE_PCM
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_channels : FL, FR, UNKNOWN1, LFE, FC, BC, BL, BR, BLOC, BROC
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_sampleRates : 32000,44100,48000,88200,96000,176400,192000
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_dataFormats : AE_FMT_S32NE,AE_FMT_S16NE,AE_FMT_S16LE
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_streamTypes : No passthrough capabilities
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: Device 2
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_deviceName : hdmi:CARD=AMLM8AUDIO,DEV=0
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_displayName : AML-M8AUDIO
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_displayNameExtra: HDMI
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_deviceType : AE_DEVTYPE_HDMI
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_channels : FL, FR, BL, BR, FC, LFE, SL, SR
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_sampleRates : 32000,44100,48000,88200,96000,176400,192000
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_dataFormats : AE_FMT_S16NE,AE_FMT_S16LE,AE_FMT_RAW
    2021-02-18 17:41:52.724 T:4029673696 NOTICE: m_streamTypes : STREAM_TYPE_AC3,STREAM_TYPE_DTSHD,STREAM_TYPE_DTSHD_MA,STREAM_TYPE_DTSHD_CORE,STREAM_TYPE_DTS_1024,STREAM_TYPE_DTS_2048,STREAM_TYPE_DTS_512,STREAM_TYPE_EAC3,STREAM_TYPE_TRUEHD
    2021-02-18 17:41:52.901 T:4071452688 ERROR: GetString: error reading /sys/firmware/devicetree/base/buggymali
    2021-02-18 17:41:52.904 T:4071452688 ERROR: GetString: error reading /home/osmc/.kodi/userdata/disp_cap
    2021-02-18 17:41:52.905 T:4071452688 ERROR: GetString: error reading /sys/class/amhdmitx/amhdmitx0/vesa_cap
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Current display setting is 0192001080060.00000pstd
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Current output resolution is 0192001080050.00000pstd
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Found resolution 720 x 480 with 720 x 480 @ 60.000000 Hz
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Fallback resolution at 16 + 0 00480060.00000pstd
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Found resolution 720 x 480 with 720 x 480 @ 59.940060 Hz
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Found resolution 720 x 576 with 720 x 576 @ 50.000000 Hz
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Fallback resolution at 16 + 2 00576050.00000pstd
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Found resolution 1280 x 720 with 1280 x 720 @ 50.000000 Hz
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Fallback resolution at 16 + 3 00720050.00000pstd
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Found resolution 1280 x 720 with 1280 x 720 @ 60.000000 Hz
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Fallback resolution at 16 + 4 00720060.00000pstd
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Found resolution 1280 x 720 with 1280 x 720 @ 59.940060 Hz
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080 @ 24.000000 Hz
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Fallback resolution at 16 + 6 01080024.00000pstd
    2021-02-18 17:41:52.905 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080 @ 23.976025 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080 @ 25.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Fallback resolution at 16 + 8 01080025.00000pstd
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080 @ 30.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Fallback resolution at 16 + 9 01080030.00000pstd
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080 @ 29.970030 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080i @ 50.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Fallback resolution at 16 + 11 01080050.00000istd
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080 @ 50.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Fallback resolution at 16 + 12 01080050.00000pstd
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080i @ 60.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Fallback resolution at 16 + 13 01080060.00000istd
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080i @ 59.940060 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080 @ 60.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Current resolution setting found at 16 + 15
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 1920 x 1080 @ 59.940060 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 3840 x 2160 @ 24.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 3840 x 2160 @ 23.976025 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 3840 x 2160 @ 25.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 3840 x 2160 @ 30.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 3840 x 2160 @ 29.970030 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 3840 x 2160 @ 50.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 3840 x 2160 @ 60.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 3840 x 2160 @ 59.940060 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 4096 x 2160 @ 24.000000 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found resolution 1920 x 1080 with 4096 x 2160 @ 23.976025 Hz
    2021-02-18 17:41:52.906 T:4071452688 NOTICE: Found best resolution 0192001080060.00000pstd at 31, setting to RES_DESKTOP at 16
    2021-02-18 17:41:52.917 T:4071452688 NOTICE: EGL_VERSION = 1.4 Linux-r5p1-01rel0
    2021-02-18 17:41:52.917 T:4071452688 NOTICE: EGL_VENDOR = ARM
    2021-02-18 17:41:52.917 T:4071452688 NOTICE: EGL_EXTENSIONS = EGL_KHR_image EGL_KHR_image_base EGL_KHR_image_pixmap EGL_KHR_gl_texture_2D_image EGL_KHR_gl_texture_cubemap_image EGL_KHR_gl_renderbuffer_image EGL_KHR_reusable_sync EGL_KHR_fence_sync EGL_KHR_lock_surface EGL_KHR_lock_surface2 EGL_EXT_create_context_robustness EGL_ANDROID_blob_cache EGL_KHR_create_context
    2021-02-18 17:41:52.917 T:4071452688 NOTICE: EGL_CLIENT_EXTENSIONS = NULL
    2021-02-18 17:41:52.919 T:4071452688 NOTICE: Checking resolution 16
    2021-02-18 17:41:53.341 T:4071452688 ERROR: GetString: error reading /sys/firmware/devicetree/base/buggymali
    2021-02-18 17:41:53.494 T:4071452688 NOTICE: GL_VENDOR = ARM
    2021-02-18 17:41:53.494 T:4071452688 NOTICE: GL_RENDERER = Mali-450 MP
    2021-02-18 17:41:53.494 T:4071452688 NOTICE: GL_VERSION = OpenGL ES 2.0
    2021-02-18 17:41:53.494 T:4071452688 NOTICE: GL_SHADING_LANGUAGE_VERSION = OpenGL ES GLSL ES 1.00
    2021-02-18 17:41:53.494 T:4071452688 NOTICE: GL_EXTENSIONS = GL_OES_texture_npot GL_OES_vertex_array_object GL_OES_compressed_ETC1_RGB8_texture GL_EXT_compressed_ETC1_RGB8_sub_texture GL_OES_standard_derivatives GL_OES_EGL_image GL_OES_depth24 GL_ARM_rgba8 GL_ARM_mali_shader_binary GL_OES_depth_texture GL_OES_packed_depth_stencil GL_EXT_texture_format_BGRA8888 GL_OES_vertex_half_float GL_EXT_blend_minmax GL_OES_EGL_image_external GL_OES_EGL_sync GL_OES_rgb8_rgba8 GL_EXT_multisampled_render_to_texture GL_EXT_discard_framebuffer GL_OES_get_program_binary GL_ARM_mali_program_binary GL_EXT_shader_texture_lod GL_EXT_robustness GL_OES_depth_texture_cube_map GL_KHR_debug GL_ARM_shader_framebuffer_fetch GL_ARM_shader_framebuffer_fetch_depth_stencil GL_OES_mapbuffer
    2021-02-18 17:41:54.021 T:4071452688 ERROR: GetString: error reading /sys/firmware/devicetree/base/buggymali
    2021-02-18 17:41:54.675 T:4071452688 NOTICE: WaitForNet: Waiting for a network interface to come up (Timeout: 1 s)
    2021-02-18 17:41:54.675 T:4071452688 NOTICE: WaitForNet: A network interface is up after waiting 0 ms
    2021-02-18 17:41:54.678 T:3969036512 NOTICE: Running database version Addons27
    2021-02-18 17:41:54.679 T:3969036512 NOTICE: Running database version ViewModes6
    2021-02-18 17:41:54.682 T:3969036512 NOTICE: Running database version Textures13
    2021-02-18 17:41:54.690 T:3969036512 NOTICE: Running database version MyMusic72
    2021-02-18 17:41:54.693 T:3969036512 ERROR: Unable to open database: MyVideos116 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.694 T:3969036512 ERROR: Unable to open database: MyVideos115 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.695 T:3969036512 ERROR: Unable to open database: MyVideos114 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.696 T:3969036512 ERROR: Unable to open database: MyVideos113 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.697 T:3969036512 ERROR: Unable to open database: MyVideos112 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.698 T:3969036512 ERROR: Unable to open database: MyVideos111 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.699 T:3969036512 ERROR: Unable to open database: MyVideos110 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.699 T:3969036512 ERROR: Unable to open database: MyVideos109 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.700 T:3969036512 ERROR: Unable to open database: MyVideos108 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.701 T:3969036512 ERROR: Unable to open database: MyVideos107 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.702 T:3969036512 ERROR: Unable to open database: MyVideos106 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.703 T:3969036512 ERROR: Unable to open database: MyVideos105 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.704 T:3969036512 ERROR: Unable to open database: MyVideos104 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.705 T:3969036512 ERROR: Unable to open database: MyVideos103 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.706 T:3969036512 ERROR: Unable to open database: MyVideos102 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.707 T:3969036512 ERROR: Unable to open database: MyVideos101 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.707 T:3969036512 ERROR: Unable to open database: MyVideos100 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.708 T:3969036512 ERROR: Unable to open database: MyVideos99 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.709 T:3969036512 ERROR: Unable to open database: MyVideos98 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.710 T:3969036512 ERROR: Unable to open database: MyVideos97 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.711 T:3969036512 ERROR: Unable to open database: MyVideos96 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.712 T:3969036512 ERROR: Unable to open database: MyVideos95 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.713 T:3969036512 ERROR: Unable to open database: MyVideos94 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.714 T:3969036512 ERROR: Unable to open database: MyVideos93 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.715 T:3969036512 ERROR: Unable to open database: MyVideos92 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.716 T:3969036512 ERROR: Unable to open database: MyVideos91 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.716 T:3969036512 ERROR: Unable to open database: MyVideos90 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.717 T:3969036512 ERROR: Unable to open database: MyVideos89 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.718 T:3969036512 ERROR: Unable to open database: MyVideos88 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.719 T:3969036512 ERROR: Unable to open database: MyVideos87 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.720 T:3969036512 ERROR: Unable to open database: MyVideos86 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.721 T:3969036512 ERROR: Unable to open database: MyVideos85 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.722 T:3969036512 ERROR: Unable to open database: MyVideos84 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.723 T:3969036512 ERROR: Unable to open database: MyVideos83 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.723 T:3969036512 ERROR: Unable to open database: MyVideos82 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.724 T:3969036512 ERROR: Unable to open database: MyVideos81 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.725 T:3969036512 ERROR: Unable to open database: MyVideos80 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.726 T:3969036512 ERROR: Unable to open database: MyVideos79 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.727 T:3969036512 ERROR: Unable to open database: MyVideos78 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.728 T:3969036512 ERROR: Unable to open database: MyVideos77 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.729 T:3969036512 ERROR: Unable to open database: MyVideos76 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.730 T:3969036512 ERROR: Unable to open database: MyVideos75 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.730 T:3969036512 ERROR: Unable to open database: MyVideos116 [2002](Can’t connect to MySQL server on ‘192.168.1.75’ (115))
    2021-02-18 17:41:54.731 T:3969036512 ERROR: Unable to create new database
    2021-02-18 17:41:54.733 T:3969036512 NOTICE: Running database version TV32
    2021-02-18 17:41:54.735 T:3969036512 NOTICE: Running database version Epg12
    2021-02-18 17:41:54.735 T:4071452688 NOTICE: start dvd mediatype detection
    2021-02-18 17:41:54.800 T:4071452688 NOTICE: load skin from: /usr/share/kodi/addons/skin.estuary (version: 2.0.27)
    2021-02-18 17:41:55.356 T:4071452688 ERROR: GetDirectory - Error getting replace
    2021-02-18 17:41:55.356 T:4071452688 ERROR: CGUIMediaWindow::GetDirectory(replace) failed
    2021-02-18 17:41:55.393 T:4071452688 WARNING: JSONRPC: Could not parse type “Setting.Details.SettingList”
    2021-02-18 17:41:55.468 T:4071452688 NOTICE: Register - new keyboard device registered on application->keyboard: Tastatur (0000:0000)
    2021-02-18 17:41:55.469 T:4071452688 NOTICE: Register - new mouse device registered on application->mouse: Maus (0000:0000)
    2021-02-18 17:41:55.477 T:4071452688 NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
    2021-02-18 17:41:55.481 T:4071452688 NOTICE: Loaded playercorefactory configuration
    2021-02-18 17:41:55.482 T:4071452688 NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
    2021-02-18 17:41:55.482 T:4071452688 NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
    2021-02-18 17:41:55.502 T:4071452688 NOTICE: initialize done
    2021-02-18 17:41:55.502 T:4071452688 NOTICE: Running the application…
    2021-02-18 17:41:55.511 T:4071452688 NOTICE: starting zeroconf publishing
    2021-02-18 17:41:55.512 T:4071452688 NOTICE: CWebServer[8080]: Started
    2021-02-18 17:41:55.513 T:3845079264 NOTICE: ES: Starting UDP Event server on port 9777
    2021-02-18 17:41:55.514 T:3845079264 NOTICE: UDP: Listening on port 9777 (ipv6 : true)
    2021-02-18 17:41:55.782 T:3920613600 NOTICE: Register - new cec device registered on cec->AOCEC: CEC Adapter (0000:0000)
    2021-02-18 17:41:55.819 T:3929006304 NOTICE: Register - new hid device registered on usb->/sys/devices/c9000000.dwc3/xhci-hcd.0.auto/usb1/1-1: OSMC RF Remote (2252:1037)
    2021-02-18 17:41:59.440 T:4062593248 ERROR: CCurlFile::FillBuffer - Failed: SSL peer certificate or SSH remote key was not OK(60)
    2021-02-18 17:41:59.441 T:4062593248 ERROR: CCurlFile::Open failed with code 0 for https://blog-cdn.osmc.tv/rss/:
    2021-02-18 17:42:05.015 T:4062593248 ERROR: CCurlFile::FillBuffer - Failed: SSL peer certificate or SSH remote key was not OK(60)
    2021-02-18 17:42:05.015 T:4062593248 ERROR: CCurlFile::Open failed with code 0 for https://blog-cdn.osmc.tv/rss/:
    2021-02-18 17:42:10.069 T:4062593248 ERROR: CCurlFile::FillBuffer - Failed: SSL peer certificate or SSH remote key was not OK(60)
    2021-02-18 17:42:10.069 T:4062593248 ERROR: CCurlFile::Open failed with code 0 for https://blog-cdn.osmc.tv/rss/:
    2021-02-18 17:42:10.070 T:4062593248 ERROR: Unable to obtain rss feed: https://blog-cdn.osmc.tv/rss/
    2021-02-18 17:42:26.176 T:4071452688 NOTICE: Stopping player
    2021-02-18 17:42:26.176 T:4071452688 NOTICE: Stopping all
    2021-02-18 17:42:26.177 T:4071452688 NOTICE: ES: Stopping event server
    2021-02-18 17:42:26.177 T:4071452688 NOTICE: stopping zeroconf publishing
    2021-02-18 17:42:26.182 T:4071452688 NOTICE: CWebServer[8080]: Stopped
    2021-02-18 17:42:27.065 T:3845079264 NOTICE: ES: UDP Event server stopped
    2021-02-18 17:42:27.065 T:4071452688 NOTICE: stop dvd detect media
    2021-02-18 17:42:27.480 T:3895435488 WARNING: CPythonInvoker(0, /usr/share/kodi/addons/script.module.osmcsetting.updates/service.py): the python script “/usr/share/kodi/addons/script.module.osmcsetting.updates/service.py” has left several classes in memory that we couldn’t clean up. The classes include: N9XBMCAddon7xbmcgui12ControlImageE,N9XBMCAddon7xbmcgui6WindowE,N14PythonBindings31XBMCAddon_xbmc_Monitor_DirectorE
    2021-02-18 17:42:27.819 T:4071452688 NOTICE: Application stopped
    2021-02-18 17:42:28.020 T:4071452688 NOTICE: XBApplicationEx: destroying…
    2021-02-18 17:42:29.957 T:4071452688 NOTICE: unload skin
    2021-02-18 17:42:30.004 T:4071452688 NOTICE: unload sections
    2021-02-18 17:42:30.473 T:4071452688 NOTICE: XBApplicationEx: application stopped!

---------------------- Kodi Old Log END --------------- 2qaAc90c

  1. I tried some more things via console:

osmc@Vero4k:~$ mysql -h 192.168.1.75 -u kodi -p

Enter password:

ERROR 2002 (HY000): Can’t connect to MySQL server on ‘192.168.1.75’ (115)

osmc@Vero4k:~$ nmap -p3308 192.168.1.75
Starting Nmap 7.70 ( https://nmap.org ) at 2021-02-18 15:56 CET
Nmap scan report for 192.168.1.75
Host is up (0.00092s latency).

PORT STATE SERVICE
3308/tcp closed tns-server

Nmap done: 1 IP address (1 host up) scanned in 0.24 seconds
osmc@Vero4k:~$

osmc@Vero4k:~$ arp -n
Address HWtype HWaddress Flags Mask Iface
192.168.1.1 ether a0:63:91:2f:cb:63 C eth0
192.168.1.75 ether 00:08:9b:f6:d0:59 C eth0
192.168.1.2 ether 08:60:6e:eb:7e:c3 C eth0
192.168.1.5 ether 54:b2:03:8b:9a:a6 C eth0
osmc@Vero4k:~$

This is what I tried so far. I hope somebody can help me!
Kind regards!
G

2

Nevermind - re-read the earlier part of the post!

What port did you configure the database instance to use?

Default is 3306 but you’re trying 3308 in that output.

3

As I said:
I downloaded QMariaDB from QNAP-Club and installed it to have an actual version, the one that is part of NAS firmware is pretty old. So I have now QMariaDB 10.5.8 and phpMyAdmin 5.0.4 installed on my NAS. QMariaDB listens on port 3308, not to interfere with the original QMariaDB on port 3306.

Kind regards!
G

MySQL
MySQL1914×937 194 KB

4

This command would connect to the MySQL server on port 3306 to test to connect to the one on 3308 you would use mysql -P 3308 -h 192.168.1.75 -u kodi -p

This would indicate that either a firewall is blocking access or the port is not open on the LAN address.
Suggest to check your MySQL config that it is bound to all IP’s not only localhost.

5

Many thanks for your input.
The firewall is not the problem, I turned it off and the result is the same. After reading in the MariaDB documentation I guess I need to out-comment the bind address which limits the access to local host. But, how to do that?? How can I use a text editor, when I cannot get access from outside. Can I do this via the console of MariaDB and if so how?
Kind regards!
G

6

Searching on the QNAP forum is probably prudent. I did a quick search and from this it looks like you can just ssh into the box and directly edit…

https://forum.qnap.com/viewtopic.php?t=91936

7

Yes, I know, but the “just” is not that easy for me. I have no idea how to open a file and edit it via console, I always do that with FTP, but that doesn’t work here.

8

That post I linked to seemed to indicate that the vi editor was already installed and could be used. For that you could just google “how to use vi editor” which would probably be necessary as it is not particularly intuitive. You could also find instructions on their forum on how to install nano which is a pretty easy editor to use even with no instructions.