Still problems with shared database on boot!

  • Hi together,

    i know it from openelec, there it was a known problem. Now, 3 Versions and 1,5 years later after setting up openelec i recognized Libreelec still got the same problem.

    on a fast connection kodi boots before a successful connection to the shared mysql database could be established. using a wlan or powerline adapter slows down the connection so far that it works. but that's not a solution if you want to watch full-hd-content.

    even there could be found some solutions on the net, none of them helped me.

    tried the autostart.sh solution with:

    "
    #!/bin/sh

    # Wait for network to come online....
    # The option in OpenELEC to wait for network doesn't work yet.
    while true ; do
    if ifconfig eth0 | grep -q "inet addr:" ; then
    echo "Network is up!"
    break
    else
    sleep 1
    fi
    done
    "


    and enabled the "wait for network"-option on libreelec.

    Nothing helps. Still have to reboot the raspberry(2) sometimes up to 3-4 times till it can connect the database on bootup. It drives me crazy.

    my network is a 10gbit fibrechannel network and the raspberry is connected to a gbit switchport and i'm using LE 7.0.3.

    my advancedsettings.xml is:
    <advancedsettings>
    <videodatabase>
    <type>mysql</type>
    <host>10.10.10.250</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
    </videodatabase>
    <musicdatabase>
    <type>mysql</type>
    <host>10.10.10.250</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
    </musicdatabase>
    <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
    </videolibrary>
    </advancedsettings>


    i would really appreciate, if someone got a final solution!


  • Settings and all are quite nice, but let's start with a debug enabled kodi.log will should give more information.

    the kodi.log isnt usefull cause it can only be accessed after a successful boot. so here is the kodi.log.old that gives you the infos you want

    09:52:42 38.701740 T:1962553344 NOTICE: special://profile/ is mapped to: special://masterprofile/
    09:52:42 38.701984 T:1962553344 NOTICE: -----------------------------------------------------------------------
    09:52:42 38.702080 T:1962553344 NOTICE: Starting Kodi (16.1 Git:c327c53). Platform: Linux ARM 32-bit
    09:52:42 38.702152 T:1962553344 NOTICE: Using Release Kodi x32 build (version for Raspberry Pi)
    09:52:42 38.702240 T:1962553344 NOTICE: Kodi compiled Dec 29 2016 by GCC 5.3.0 for Linux ARM 32-bit version 4.4.13 (263181)
    09:52:42 38.702629 T:1962553344 NOTICE: Running on LibreELEC (official) - Version: 7.0.3, kernel: Linux ARM 32-bit version 4.4.13
    09:52:42 38.702721 T:1962553344 NOTICE: FFmpeg version: 2.8.6
    09:52:42 38.702782 T:1962553344 NOTICE: WARNING: unsupported ffmpeg version detected
    09:52:42 38.702847 T:1962553344 NOTICE: Host CPU: ARMv7 Processor rev 5 (v7l), 4 cores available
    09:52:42 38.702908 T:1962553344 NOTICE: ARM Features: Neon enabled
    09:52:42 38.702969 T:1962553344 NOTICE: special://xbmc/ is mapped to: /usr/share/kodi
    09:52:42 38.703041 T:1962553344 NOTICE: special://xbmcbin/ is mapped to: /usr/lib/kodi
    09:52:42 38.703102 T:1962553344 NOTICE: special://masterprofile/ is mapped to: /storage/.kodi/userdata
    09:52:42 38.703163 T:1962553344 NOTICE: special://home/ is mapped to: /storage/.kodi
    09:52:42 38.703228 T:1962553344 NOTICE: special://temp/ is mapped to: /storage/.kodi/temp
    09:52:42 38.703438 T:1962553344 NOTICE: The executable running is: /usr/lib/kodi/kodi.bin
    09:52:42 38.703564 T:1962553344 NOTICE: Local hostname: LibreELEC
    09:52:42 38.703636 T:1962553344 NOTICE: Log File is located: /storage/.kodi/temp/kodi.log
    09:52:42 38.715015 T:1962553344 NOTICE: -----------------------------------------------------------------------
    09:52:42 38.870480 T:1962553344 ERROR: DBus: Error org.freedesktop.DBus.Error.ServiceUnknown - The name org.freedesktop.UPower was not provided by any .service files
    09:52:42 38.884373 T:1962553344 NOTICE: load settings...
    09:52:43 39.062424 T:1962553344 NOTICE: Found 2 Lists of Devices
    09:52:43 39.062599 T:1962553344 NOTICE: Enumerated PI devices:
    09:52:43 39.062668 T:1962553344 NOTICE: Device 1
    09:52:43 39.063232 T:1962553344 NOTICE: m_deviceName : HDMI
    09:52:43 39.063328 T:1962553344 NOTICE: m_displayName : HDMI
    09:52:43 39.063465 T:1962553344 NOTICE: m_displayNameExtra:
    09:52:43 39.063530 T:1962553344 NOTICE: m_deviceType : AE_DEVTYPE_HDMI
    09:52:43 39.063591 T:1962553344 NOTICE: m_channels : FL,FR
    09:52:43 39.063656 T:1962553344 NOTICE: m_sampleRates : 8000,11025,16000,22050,24000,32000,44100,48000,88200,96000,176400,192000
    09:52:43 39.063721 T:1962553344 NOTICE: m_dataFormats : AE_FMT_FLOAT,AE_FMT_S32NE,AE_FMT_S16NE,AE_FMT_S32LE,AE_FMT_S16LE,AE_FMT_FLOATP,AE_FMT_S32NEP,AE_FMT_S16NEP,AE_FMT_AC3,AE_FMT_DTS,AE_FMT_EAC3
    09:52:43 39.063816 T:1962553344 NOTICE: Device 2
    09:52:43 39.063946 T:1962553344 NOTICE: m_deviceName : Analogue
    09:52:43 39.064030 T:1962553344 NOTICE: m_displayName : Analogue
    09:52:43 39.064091 T:1962553344 NOTICE: m_displayNameExtra:
    09:52:43 39.064156 T:1962553344 NOTICE: m_deviceType : AE_DEVTYPE_PCM
    09:52:43 39.064217 T:1962553344 NOTICE: m_channels : FL,FR
    09:52:43 39.064278 T:1962553344 NOTICE: m_sampleRates : 48000
    09:52:43 39.064342 T:1962553344 NOTICE: m_dataFormats : AE_FMT_FLOAT,AE_FMT_S32LE,AE_FMT_S16LE,AE_FMT_FLOATP,AE_FMT_S32NEP,AE_FMT_S16NEP
    09:52:43 39.064404 T:1962553344 NOTICE: Device 3
    09:52:43 39.064518 T:1962553344 NOTICE: m_deviceName : Both
    09:52:43 39.064583 T:1962553344 NOTICE: m_displayName : HDMI and Analogue
    09:52:43 39.064644 T:1962553344 NOTICE: m_displayNameExtra:
    09:52:43 39.064705 T:1962553344 NOTICE: m_deviceType : AE_DEVTYPE_PCM
    09:52:43 39.064762 T:1962553344 NOTICE: m_channels : FL,FR
    09:52:43 39.064823 T:1962553344 NOTICE: m_sampleRates : 48000
    09:52:43 39.064934 T:1962553344 NOTICE: m_dataFormats : AE_FMT_FLOAT,AE_FMT_S32LE,AE_FMT_S16LE,AE_FMT_FLOATP,AE_FMT_S32NEP,AE_FMT_S16NEP
    09:52:43 39.064999 T:1962553344 NOTICE: Enumerated PULSE devices:
    09:52:43 39.065056 T:1962553344 NOTICE: Device 1
    09:52:43 39.065186 T:1962553344 NOTICE: m_deviceName : Default
    09:52:43 39.065247 T:1962553344 NOTICE: m_displayName : Default
    09:52:43 39.065308 T:1962553344 NOTICE: m_displayNameExtra: Bluetooth Audio (PULSEAUDIO)
    09:52:43 39.065369 T:1962553344 NOTICE: m_deviceType : AE_DEVTYPE_PCM
    09:52:43 39.065430 T:1962553344 NOTICE: m_channels : FL,FR
    09:52:43 39.065491 T:1962553344 NOTICE: m_sampleRates : 5512,8000,11025,16000,22050,32000,44100,48000,64000,88200,96000,176400,192000,384000
    09:52:43 39.065552 T:1962553344 NOTICE: m_dataFormats : AE_FMT_U8,AE_FMT_S16NE,AE_FMT_S24NE3,AE_FMT_S24NE4,AE_FMT_S32NE,AE_FMT_FLOAT
    09:52:43 39.099834 T:1962553344 NOTICE: Loaded settings file from special://xbmc/system/advancedsettings.xml
    09:52:43 39.105377 T:1962553344 NOTICE: Contents of special://xbmc/system/advancedsettings.xml are...
    <?xml version="1.0" encoding="UTF-8" ?>
    <advancedsettings>
    <showexitbutton>false</showexitbutton>
    <fanartres>720</fanartres>
    <imageres>540</imageres>
    <video>
    <busydialogdelayms>750</busydialogdelayms>
    </video>
    <samba>
    <clienttimeout>30</clienttimeout>
    </samba>
    <network>
    <readbufferfactor>4.0</readbufferfactor>
    </network>
    </advancedsettings>
    09:52:43 39.112385 T:1962553344 NOTICE: Loaded settings file from special://profile/advancedsettings.xml
    09:52:43 39.112667 T:1962553344 NOTICE: Contents of special://profile/advancedsettings.xml are...
    <advancedsettings>
    <videodatabase>
    <type>mysql</type>
    <host>10.10.10.250</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
    </videodatabase>
    <musicdatabase>
    <type>mysql</type>
    <host>10.10.10.250</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
    </musicdatabase>
    <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
    </videolibrary>
    </advancedsettings>
    09:52:43 39.112850 T:1962553344 WARNING: VIDEO database configuration is experimental.
    09:52:43 39.114777 T:1962553344 NOTICE: Default DVD Player: dvdplayer
    09:52:43 39.114861 T:1962553344 NOTICE: Default Video Player: dvdplayer
    09:52:43 39.114990 T:1962553344 NOTICE: Default Audio Player: paplayer
    09:52:43 39.115070 T:1962553344 NOTICE: Disabled debug logging due to GUI setting. Level 0.
    09:52:43 39.115131 T:1962553344 NOTICE: Log level changed to "LOG_LEVEL_NORMAL"
    09:52:43 39.115501 T:1962553344 NOTICE: CMediaSourceSettings: loading media sources from special://masterprofile/sources.xml
    09:52:43 39.120159 T:1962553344 NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
    09:52:43 39.122623 T:1962553344 NOTICE: Loaded playercorefactory configuration
    09:52:43 39.123169 T:1962553344 NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
    09:52:43 39.123535 T:1962553344 NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
    10:52:43 39.428707 T:1962553344 NOTICE: Running database version Addons20
    10:52:43 39.602245 T:1962553344 NOTICE: ADDONS: Using repository repository.xbmc.org
    10:52:43 39.602421 T:1962553344 NOTICE: ADDONS: Using repository repository.libreelec.tv
    10:52:43 39.689148 T:1962553344 NOTICE: Raspberry PI firmware version: Dec 3 2016 18:56:05
    Copyright (c) 2012 Broadcom
    version bc845578aa7adbf453bbda241faadbcde2e670bf (clean) (release)
    10:52:43 39.689320 T:1962553344 NOTICE: ARM mem: 752MB GPU mem: 256MB MPG2:0 WVC1:0
    10:52:43 39.689392 T:1962553344 NOTICE: cacheMemBufferSize: 20MB
    10:52:43 39.689823 T:1962553344 NOTICE: Config:
    arm_freq=900
    audio_pwm_mode=1
    config_hdmi_boost=5
    disable_commandline_tags=2
    disable_l2cache=1
    enable_uart=1
    force_eeprom_read=1
    force_pwm_open=1
    framebuffer_ignore_alpha=1
    framebuffer_swap=1
    hdmi_channel_map=8
    hdmi_force_cec_address=65535
    hdmi_ignore_cec_init=1
    init_uart_clock=0x2dc6c00
    lcd_framerate=60
    over_voltage_avs=0x1b774
    overscan_bottom=48
    overscan_left=48
    overscan_right=48
    overscan_top=48
    pause_burst_frames=1
    program_serial_random=1
    sdram_freq=450
    temp_limit=85
    10:52:43 39.690105 T:1962553344 NOTICE: Config:
    device_tree=-
    10:52:43 39.690224 T:1962553344 NOTICE: InitWindowSystem: Using EGL Implementation: raspberrypi
    10:52:43 39.693180 T:1962553344 NOTICE: Found resolution 640 x 480 for display 0 with 640 x 480 @ 60.000000 Hz
    10:52:43 39.693314 T:1962553344 NOTICE: Found resolution 640 x 480 for display 0 with 640 x 480 @ 59.940063 Hz
    10:52:43 39.693478 T:1962553344 NOTICE: Found resolution 640 x 480 for display 0 with 640 x 480 @ 72.000000 Hz
    10:52:43 39.693554 T:1962553344 NOTICE: Found resolution 640 x 480 for display 0 with 640 x 480 @ 71.928070 Hz
    10:52:43 39.693626 T:1962553344 NOTICE: Found resolution 640 x 480 for display 0 with 640 x 480 @ 75.000000 Hz
    10:52:43 39.693695 T:1962553344 NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 56.000000 Hz
    10:52:43 39.693768 T:1962553344 NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 60.000000 Hz
    10:52:43 39.693893 T:1962553344 NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 59.940063 Hz
    10:52:43 39.693970 T:1962553344 NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 72.000000 Hz
    10:52:43 39.694042 T:1962553344 NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 71.928070 Hz
    10:52:43 39.694115 T:1962553344 NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 75.000000 Hz
    10:52:43 39.694183 T:1962553344 NOTICE: Found resolution 800 x 600 for display 0 with 800 x 600 @ 120.000000 Hz
    10:52:43 39.694256 T:1962553344 NOTICE: Found resolution 1024 x 768 for display 0 with 1024 x 768 @ 60.000000 Hz
    10:52:43 39.694328 T:1962553344 NOTICE: Found resolution 1024 x 768 for display 0 with 1024 x 768 @ 59.940063 Hz
    10:52:43 39.694397 T:1962553344 NOTICE: Found resolution 1024 x 768 for display 0 with 1024 x 768 @ 70.000000 Hz
    10:52:43 39.694469 T:1962553344 NOTICE: Found resolution 1024 x 768 for display 0 with 1024 x 768 @ 75.000000 Hz
    10:52:43 39.694546 T:1962553344 NOTICE: Found resolution 1024 x 768 for display 0 with 1024 x 768 @ 120.000000 Hz
    10:52:43 39.694618 T:1962553344 NOTICE: Found resolution 1280 x 800 for display 0 with 1280 x 800 @ 60.000000 Hz
    10:52:43 39.694733 T:1962553344 NOTICE: Found resolution 1280 x 800 for display 0 with 1280 x 800 @ 59.940063 Hz
    10:52:43 39.694805 T:1962553344 NOTICE: Found resolution 1280 x 1024 for display 0 with 1280 x 1024 @ 75.000000 Hz
    10:52:43 39.694878 T:1962553344 NOTICE: Found resolution 1440 x 900 for display 0 with 1440 x 900 @ 60.000000 Hz
    10:52:43 39.694950 T:1962553344 NOTICE: Found resolution 1440 x 900 for display 0 with 1440 x 900 @ 59.940063 Hz
    10:52:43 39.695019 T:1962553344 NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 60.000000 Hz
    10:52:43 39.695091 T:1962553344 NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 59.940063 Hz
    10:52:43 39.695160 T:1962553344 NOTICE: Found resolution 1280 x 720 for display 0 with 1280 x 720 @ 60.000000 Hz
    10:52:43 39.695240 T:1962553344 NOTICE: Found resolution 1280 x 720 for display 0 with 1280 x 720 @ 59.940063 Hz
    10:52:43 39.695309 T:1962553344 NOTICE: Found resolution 720 x 480 for display 0 with 720 x 480 @ 60.000000 Hz
    10:52:43 39.695381 T:1962553344 NOTICE: Found resolution 720 x 480 for display 0 with 720 x 480 @ 59.940063 Hz
    10:52:43 39.695450 T:1962553344 NOTICE: Found resolution 720 x 576 for display 0 with 720 x 576 @ 50.000000 Hz
    10:52:43 39.695522 T:1962553344 NOTICE: Found resolution 1280 x 720 for display 0 with 1280 x 720 @ 50.000000 Hz
    10:52:43 39.695591 T:1962553344 NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 50.000000 Hz
    10:52:43 39.695663 T:1962553344 NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 24.000000 Hz
    10:52:43 39.695732 T:1962553344 NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 23.976025 Hz
    10:52:43 39.695801 T:1962553344 NOTICE: Found ([email protected]) at 40, setting to RES_DESKTOP at 16
    10:52:43 39.696259 T:1962553344 NOTICE: Checking resolution 46
    10:52:43 39.878906 T:1962553344 NOTICE: GL_VENDOR = Broadcom
    10:52:43 39.879063 T:1962553344 NOTICE: GL_RENDERER = VideoCore IV HW
    10:52:43 39.879135 T:1962553344 NOTICE: GL_VERSION = OpenGL ES 2.0
    10:52:43 39.879200 T:1962553344 NOTICE: GL_SHADING_LANGUAGE_VERSION = OpenGL ES GLSL ES 1.00
    10:52:43 39.879292 T:1962553344 NOTICE: GL_EXTENSIONS = GL_OES_compressed_ETC1_RGB8_texture GL_OES_compressed_paletted_texture GL_OES_texture_npot GL_OES_depth24 GL_OES_vertex_half_float GL_OES_EGL_image GL_OES_EGL_image_external GL_EXT_discard_framebuffer GL_OES_rgb8_rgba8 GL_OES_depth32 GL_OES_mapbuffer GL_EXT_texture_format_BGRA8888 GL_APPLE_rgb_422 GL_EXT_debug_marker
    10:52:45 41.158352 T:1962553344 NOTICE: Register - new cec device registered on cec->RPI: CEC Adapter (2708:1001)
    10:52:45 41.392456 T:1962553344 NOTICE: Running database version Addons20
    10:52:45 41.398693 T:1962553344 NOTICE: Running database version ViewModes6
    10:52:45 41.405762 T:1962553344 NOTICE: Running database version Textures13
    10:52:45 41.410530 T:1962553344 ERROR: Unable to open database: MyMusic56 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.410900 T:1962553344 ERROR: Unable to open database: MyMusic55 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.411144 T:1962553344 ERROR: Unable to open database: MyMusic54 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.411354 T:1962553344 ERROR: Unable to open database: MyMusic53 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.411545 T:1962553344 ERROR: Unable to open database: MyMusic52 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.411732 T:1962553344 ERROR: Unable to open database: MyMusic51 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.411915 T:1962553344 ERROR: Unable to open database: MyMusic50 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.412125 T:1962553344 ERROR: Unable to open database: MyMusic49 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.412315 T:1962553344 ERROR: Unable to open database: MyMusic48 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.412498 T:1962553344 ERROR: Unable to open database: MyMusic47 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.412670 T:1962553344 ERROR: Unable to open database: MyMusic46 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.412857 T:1962553344 ERROR: Unable to open database: MyMusic45 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.413036 T:1962553344 ERROR: Unable to open database: MyMusic44 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.413208 T:1962553344 ERROR: Unable to open database: MyMusic43 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.413536 T:1962553344 ERROR: Unable to open database: MyMusic42 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.413750 T:1962553344 ERROR: Unable to open database: MyMusic41 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.413937 T:1962553344 ERROR: Unable to open database: MyMusic40 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.414127 T:1962553344 ERROR: Unable to open database: MyMusic39 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.414310 T:1962553344 ERROR: Unable to open database: MyMusic38 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.414490 T:1962553344 ERROR: Unable to open database: MyMusic37 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.414665 T:1962553344 ERROR: Unable to open database: MyMusic36 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.414848 T:1962553344 ERROR: Unable to open database: MyMusic35 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.415035 T:1962553344 ERROR: Unable to open database: MyMusic34 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.415234 T:1962553344 ERROR: Unable to open database: MyMusic33 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.415405 T:1962553344 ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.415581 T:1962553344 ERROR: Unable to open database: MyMusic56 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.415653 T:1962553344 ERROR: Unable to create new database
    10:52:45 41.415943 T:1962553344 ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.416130 T:1962553344 ERROR: Unable to open database: MyVideos98 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.416309 T:1962553344 ERROR: Unable to open database: MyVideos97 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.416538 T:1962553344 ERROR: Unable to open database: MyVideos96 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.416775 T:1962553344 ERROR: Unable to open database: MyVideos95 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.416965 T:1962553344 ERROR: Unable to open database: MyVideos94 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.417152 T:1962553344 ERROR: Unable to open database: MyVideos93 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.417332 T:1962553344 ERROR: Unable to open database: MyVideos92 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.417500 T:1962553344 ERROR: Unable to open database: MyVideos91 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.417675 T:1962553344 ERROR: Unable to open database: MyVideos90 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.417866 T:1962553344 ERROR: Unable to open database: MyVideos89 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.418053 T:1962553344 ERROR: Unable to open database: MyVideos88 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.418228 T:1962553344 ERROR: Unable to open database: MyVideos87 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.418404 T:1962553344 ERROR: Unable to open database: MyVideos86 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.418579 T:1962553344 ERROR: Unable to open database: MyVideos85 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.418758 T:1962553344 ERROR: Unable to open database: MyVideos84 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.418934 T:1962553344 ERROR: Unable to open database: MyVideos83 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.419136 T:1962553344 ERROR: Unable to open database: MyVideos82 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.419323 T:1962553344 ERROR: Unable to open database: MyVideos81 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.419498 T:1962553344 ERROR: Unable to open database: MyVideos80 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.419674 T:1962553344 ERROR: Unable to open database: MyVideos79 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.419853 T:1962553344 ERROR: Unable to open database: MyVideos78 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.420135 T:1962553344 ERROR: Unable to open database: MyVideos77 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.420341 T:1962553344 ERROR: Unable to open database: MyVideos76 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.420525 T:1962553344 ERROR: Unable to open database: MyVideos75 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.420715 T:1962553344 ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '10.10.10.250' (101))
    10:52:45 41.420788 T:1962553344 ERROR: Unable to create new database
    10:52:45 41.427528 T:1962553344 NOTICE: Running database version TV29
    10:52:45 41.433880 T:1962553344 NOTICE: Running database version Epg11
    10:52:45 41.438972 T:1962553344 NOTICE: start dvd mediatype detection
    10:52:46 42.494751 T:1962553344 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList"
    10:52:46 42.833565 T:1962553344 NOTICE: ActiveAE DSP - starting
    10:52:46 42.849739 T:1962553344 NOTICE: initialize done
    10:52:46 42.849945 T:1962553344 NOTICE: Running the application...
    10:52:47 42.973808 T:1788867488 ERROR: CCurlFile::FillBuffer - Failed: Couldn't resolve host name(6)
    10:52:47 42.974083 T:1788867488 ERROR: CCurlFile::Open failed with code 0 for addons.xml.gz.md5
    10:52:47 42.974350 T:1788867488 ERROR: Open - failed to open source <addons.xml.gz.md5>
    10:52:47 42.974510 T:1788867488 ERROR: CRepositoryUpdateJob[repository.xbmc.org] failed read checksum for directory 'http://mirrors.kodi.tv/addons/jarvis/addons.xml.gz'
    10:52:47 43.397724 T:1788867488 ERROR: CCurlFile::FillBuffer - Failed: Couldn't resolve host name(6)
    10:52:47 43.398052 T:1788867488 ERROR: CCurlFile::Open failed with code 0 for addons.xml.gz.md5
    10:52:47 43.398323 T:1788867488 ERROR: Open - failed to open source <addons.xml.gz.md5>
    10:52:47 43.398464 T:1788867488 ERROR: CRepositoryUpdateJob[repository.libreelec.tv] failed read checksum for directory 'http://addons.libreelec.tv/7.0/RPi2/arm/addons.xml.gz'
    10:52:47 43.425205 T:1962553344 NOTICE: starting zeroconf publishing
    10:52:47 43.427063 T:1962553344 NOTICE: WebServer: Started the webserver
    10:52:47 43.427521 T:1962553344 NOTICE: starting upnp client
    10:52:47 43.441711 T:1719661472 NOTICE: ES: Starting UDP Event server on 127.0.0.1:9777
    10:52:47 43.442001 T:1719661472 NOTICE: UDP: Listening on port 9777
    10:52:48 43.956627 T:1805644704 NOTICE: ## LibreELEC Addon ## 0.7.5
    10:52:48 43.972099 T:1805644704 WARNING: CSkinInfo: failed to load skin settings
    10:52:56 52.515198 T:1962553344 NOTICE: Storing total System Uptime
    10:52:56 52.802425 T:1962553344 NOTICE: Saving settings
    10:52:56 52.830734 T:1962553344 NOTICE: Saving skin settings
    10:52:56 52.835758 T:1962553344 NOTICE: stop all
    10:52:56 52.836273 T:1962553344 NOTICE: stop player
    10:52:56 52.836441 T:1962553344 NOTICE: ES: Stopping event server
    10:52:56 52.840504 T:1962553344 NOTICE: stopping upnp
    10:52:57 52.991890 T:1962553344 NOTICE: stopping zeroconf publishing
    10:52:57 52.997101 T:1962553344 NOTICE: WebServer: Stopped the webserver
    10:52:57 53.452740 T:1719661472 NOTICE: ES: UDP Event server stopped
    10:52:57 53.505939 T:1962553344 NOTICE: stop dvd detect media
    10:52:59 55.666569 T:1962553344 NOTICE: stop sap announcement listener
    10:52:59 55.666821 T:1962553344 NOTICE: clean cached files!
    10:52:59 55.666901 T:1962553344 NOTICE: unload skin
    10:52:59 55.700672 T:1962553344 WARNING: Cleanup: Having to cleanup texture pointer-nofocus.png
    10:52:59 55.701019 T:1962553344 WARNING: Cleanup: Having to cleanup texture pointer-focus.png
    10:52:59 55.701141 T:1962553344 WARNING: Cleanup: Having to cleanup texture pointer-focus-drag.png
    10:52:59 55.701221 T:1962553344 WARNING: Cleanup: Having to cleanup texture pointer-focus-click.png
    10:52:59 55.732121 T:1805644704 NOTICE: ## LibreELEC Addon ## STOP SERVICE DONE !


    and even i never ever checked the log, i can see its the point i'm saying.
    its a years old problem..dont understand why nobody fix it.

    Edited once, last by ramses3 (February 11, 2017 at 4:14 PM).

  • chewitt... well..as i mentiont before..this wont help you cause it fetches the log when everything is running.. but here you go PXfN

    Klojum changed it by default to 30 seconds but this option is absolutely useless. no matter if i change it to 1 second or 5 minutes.
    [hr]
    maybe i should say i got 2 more raspberrys here ..one in the bedroom one for my daughter..one is connected via wifi , the other one with power-lan adapters. they work fine one EVERY boot with the same config.
    its only the rasyberry that is wired connected to a gbit switch directly!

    Edited once, last by ramses3 (February 11, 2017 at 6:07 PM).


  • What value is set in the "wait for network" option?
    Perhaps the default 10 seconds is not enough.

    Klojum, the wait for network is basically a timeout now, so if you set it to 10 seconds that will be the max time waiting if connman doesn't detect a network. If a network is detected it will just continue.


    ramses3

    can just sleep in the autostart.sh

    Code
    sleep 10

    We use the connman-wait-online utility. So if it detects a network then there isn't much we can do other than sleep for a few seconds.

    You could also try this

    Code
    wget -O /storage/.config/system.d/kodi-waitonnetwork.service http://sprunge.us/aKZc


    then make use "wait for network" is enabled and reboot. This adds an extra two seconds after connman-wait-online detects a network connection.


  • Thanks for your reply dude, i tried the autostart.sh sleeptime also with 30 seconds..no function at all.
    can you explain me what the thing does what you posted on aKZc ? i can see its doing a 2 sec sleep , but on what point? as you can see on the log i posted, no matter where i put delays before (autostart.sh, wait for network on kodi) it doesnt change anything.

    Edited once, last by ramses3 (February 11, 2017 at 6:31 PM).

  • Thanks for your reply dude, i tried the autostart.sh sleeptime also with 30 seconds..no function at all.
    can you explain me what the thing does what you posted on aKZc ? i can see its doing a 2 sec sleep , but on what point? as you can see on the log i posted, no matter where i put delays before (autostart.sh, wait for network on kodi) it doesnt change anything.

    I just tested with

    Code
    echo "sleep 30" > /storage/.config/autostart.sh


    and my system waited 30 seconds on the splash screen.


    The kodi-waitonnetwork.service file adds a "sleep 2" command that runs after connman-wait-online detects a network.

  • ok ..updated the file.. no change...
    first reboot..everything fine...second reboot...database not connected.

    damn it !


    @irusek.. tried it.. no change at all.. it even doesnt stay 30 seconds on the splash..
    and yeah, i did the +x thingy on the autostart.sh file :(

    the boot up is every time different..sometimes there are 10 seconds between the libreelec screen and the kodi screen ..sometimes only 3 seconds... i dont know what to change


    and the point is..that there is really no network after a failed bootup.. no ntp time, no network shares...

    Edited once, last by ramses3 (February 11, 2017 at 6:39 PM).

  • dude its FRESHLY installed on a clean sd card..the only thing i did is to copy the advancedsettings.xml and share xml ... i'm an it-engineer, so im not absolutely clueless

    seems like i have to use an old home consumer switch that isnt that fast as the enterprise hardware. :(


    well anyway..this will become a bigger problem if users got better hardware at home.


    and because i love to follow every tip, even i think its useless, i removed the complete autostart.sh...
    3 times boot up successful, 2 times failed, then it was ok again... its like playing russian roulette!
    [hr]
    my last thought is , that i damaged something when i added a reset button to the raspberry... but .. well.. not probable
    [hr]
    a solution would be if there is a way to completly reset the eth0 interface an reload kodi... that may take the double time till its useable but its still better as rebooting 4-5 times..


    just to be sure i tried the raspberry with a raspbian and retropie installation..the network connection is available on EVERY reboot.. so its for sure a openelec/libreelec problem.
    to be sure i do for fun a osmc installtion tomorrow.
    [hr]
    said, and did.. took a 10 year old 100mbit switch from tp-link and switched it between the ubiquiti enterprise switch... 10 reboot , 10 times fine. line timings raised to above 10 times higher (0,1ms to 1,4ms)

    libreelec.. we got a problem and for sure every developer will ignore it.

    Edited once, last by ramses3 (February 11, 2017 at 7:23 PM).

  • Same problem here, up to V7.0.3 no problems at all connecting mySQL DB, starting from V8.0 no connect any more. I changed the network waiting time to 30 seconds, but no connect at all.

    The second trial I started with a clean install V7.0.3 - no problems. Upgrading to V8 - no connect. Additionally, after a clean install there isn't any autostart.sh created. So, this can't really be the clue.

    Is V8 so much faster than V7? And my network from and to the machine is working, but only the DB connect is missing. Here is any bug in the V8 - as I mentioned in another thread, this is reproducible with two different intel machines (NUC and ZOTAC).

  • Wow, what a rude post. An IT engineer? You've been explained the problem and served multiple solutions to it, yet you still are unable to fix the issue and are even blaming the developers? Your degree is a fraud then.

    This is not even a LibreELEC specific issue, it's a Kodi problem known since forever. No network = no database, simple as that. You've been given the tools to diagnose and fix it in this thread, so stop your whining.

  • Finally, two days later, I succeeded in updating to V8 using the mysql database. Obviously the problem occured as a result of an interrupted migration process before. From that time on from this I wasn't able to re-connect to the database again.

    How did I succeed in the end?
    1. Downgrading to 7.0.3
    2. Soft Reset of 7.0.3
    3. Deleting all parts of Krypton db inside the KODI-environment
    (version 107 of video db - could be MyVideos107 or xbmc_video107 or whatever your special name-tag in advancedsettings.xml defines,
    version 60 of music db - could be MyMusic60 or xbmc_music60 or whatever your special name-tag in advancedsettings.xml defines,
    Addons27.db)
    4. if necessary dropping V8-databases in the environment of mysql-server
    (version 107 of video db - could be MyVideos107 or xbmc_video107 or whatever your special name-tag in advancedsettings.xml defines,
    version 60 of music db - could be MyMusic60 or xbmc_music60 or whatever your special name-tag in advancedsettings.xml defines)

    Starting from this cleaned up state, next time the database migration worked as designed. Updating the other clients to V8 there was no problem any more to connect immediately to the migrated database.

  • Seems my issue was the existence of the v107 videos database, maybe as a result of trying v8 beta's previously, once this was removed the database upgrade completed as expected.

    Edited once, last by ElGato (February 27, 2017 at 9:28 PM).