Kodi Community Forum

Kodi Community Forum > Support > General Support > Linux > KODI MysQL banging head
Full Version: KODI MysQL banging head
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

djb79

2015-05-21, 02:49
Hi All,
I Currently Have the following setup

MachineName = mediabox, 192.168.1.30
Ubuntu 14.04 Trusty
ZFS, Pool = Ocean (Shared to all via SAMBA)
Kodi
LAMP
PHPmyADMIN

I can get the HTPC scraping and building the database all okay and work fine when no AdvancedSetting.xml in place. When I copy in the file shown below, I get nothing.

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.30</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.30</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>

I am also unable to add sources and start a new scrape (so a to build the SQL database).

I have followed this guide http://kodi.wiki/view/MySQL to no avail.

I have been working on this for a number of weeks now and I am having no luck. Any help would be greatly appreciated

Below is shown kodi.log
17:38:40 T:140135947007936 NOTICE: special://profile/ is mapped to: special://masterprofile/
17:38:40 T:140135947007936 NOTICE: -----------------------------------------------------------------------
17:38:40 T:140135947007936 NOTICE: Starting Kodi (14.2 Git:7cc53a9). Platform: Linux x86 64-bit
17:38:40 T:140135947007936 NOTICE: Using Release Kodi x64 build
17:38:40 T:140135947007936 NOTICE: Kodi compiled Mar 27 2015 by GCC 4.8.2 for Linux x86 64-bit version 3.13.11 (199947)
17:38:40 T:140135947007936 NOTICE: Running on Ubuntu 14.04 LTS, kernel: Linux x86 64-bit version 3.13.0-24-generic
17:38:40 T:140135947007936 NOTICE: FFmpeg statically linked, version: 2.4.6-xbmc-2.4.6-Helix
17:38:40 T:140135947007936 NOTICE: Host CPU: AMD Athlon™ 7750 Dual-Core Processor, 2 cores available
17:38:40 T:140135947007936 NOTICE: special://xbmc/ is mapped to: /usr/share/kodi
17:38:40 T:140135947007936 NOTICE: special://xbmcbin/ is mapped to: /usr/lib/kodi
17:38:40 T:140135947007936 NOTICE: special://masterprofile/ is mapped to: /home/darryl/.kodi/userdata
17:38:40 T:140135947007936 NOTICE: special://home/ is mapped to: /home/darryl/.kodi
17:38:40 T:140135947007936 NOTICE: special://temp/ is mapped to: /home/darryl/.kodi/temp
17:38:40 T:140135947007936 NOTICE: The executable running is: /usr/lib/kodi/kodi.bin
17:38:40 T:140135947007936 NOTICE: Local hostname: MediaBox
17:38:40 T:140135947007936 NOTICE: Log File is located: /home/darryl/.kodi/temp/kodi.log
17:38:40 T:140135947007936 NOTICE: -----------------------------------------------------------------------
17:38:40 T:140135947007936 NOTICE: load settings...
17:38:40 T:140135947007936 NOTICE: Found 1 Lists of Devices
17:38:40 T:140135947007936 NOTICE: Enumerated PULSE devices:
17:38:40 T:140135947007936 NOTICE: Device 1
17:38:40 T:140135947007936 NOTICE: m_deviceName : Default
17:38:40 T:140135947007936 NOTICE: m_displayName : Default
17:38:40 T:140135947007936 NOTICE: m_displayNameExtra: Default Output Device (PULSEAUDIO)
17:38:40 T:140135947007936 NOTICE: m_deviceType : AE_DEVTYPE_PCM
17:38:40 T:140135947007936 NOTICE: m_channels : FL,FR
17:38:40 T:140135947007936 NOTICE: m_sampleRates : 5512,8000,11025,16000,22050,32000,44100,48000,64000,88200,96000,176400,192000,384000
17:38:40 T:140135947007936 NOTICE: m_dataFormats : AE_FMT_U8,AE_FMT_S16NE,AE_FMT_S24NE3,AE_FMT_S24NE4,AE_FMT_S32NE,AE_FMT_FLOAT
17:38:40 T:140135947007936 NOTICE: Device 2
17:38:40 T:140135947007936 NOTICE: m_deviceName : alsa_output.pci-0000_00_07.0.analog-stereo
17:38:40 T:140135947007936 NOTICE: m_displayName : Built-in Audio Analogue Stereo
17:38:40 T:140135947007936 NOTICE: m_displayNameExtra: Analogue Output (PULSEAUDIO)
17:38:40 T:140135947007936 NOTICE: m_deviceType : AE_DEVTYPE_PCM
17:38:40 T:140135947007936 NOTICE: m_channels : FL,FR
17:38:40 T:140135947007936 NOTICE: m_sampleRates : 5512,8000,11025,16000,22050,32000,44100,48000,64000,88200,96000,176400,192000,384000
17:38:40 T:140135947007936 NOTICE: m_dataFormats : AE_FMT_U8,AE_FMT_S16NE,AE_FMT_S24NE3,AE_FMT_S24NE4,AE_FMT_S32NE,AE_FMT_FLOAT
17:38:40 T:140135947007936 NOTICE: Device 3
17:38:40 T:140135947007936 NOTICE: m_deviceName : alsa_output.pci-0000_02_00.1.hdmi-stereo
17:38:40 T:140135947007936 NOTICE: m_displayName : GF119 HDMI Audio Controller Digital Stereo (HDMI)
17:38:40 T:140135947007936 NOTICE: m_displayNameExtra: HDMI / DisplayPort (PULSEAUDIO)
17:38:40 T:140135947007936 NOTICE: m_deviceType : AE_DEVTYPE_PCM
17:38:40 T:140135947007936 NOTICE: m_channels : FL,FR
17:38:40 T:140135947007936 NOTICE: m_sampleRates : 5512,8000,11025,16000,22050,32000,44100,48000,64000,88200,96000,176400,192000,384000
17:38:40 T:140135947007936 NOTICE: m_dataFormats : AE_FMT_U8,AE_FMT_S16NE,AE_FMT_S24NE3,AE_FMT_S24NE4,AE_FMT_S32NE,AE_FMT_FLOAT
17:38:40 T:140135947007936 NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
17:38:40 T:140135947007936 NOTICE: Loaded settings file from special://profile/advancedsettings.xml
17:38:40 T:140135947007936 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.30</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.30</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
17:38:40 T:140135947007936 WARNING: VIDEO database configuration is experimental.
17:38:40 T:140135947007936 NOTICE: Default DVD Player: dvdplayer
17:38:40 T:140135947007936 NOTICE: Default Video Player: dvdplayer
17:38:40 T:140135947007936 NOTICE: Default Audio Player: paplayer
17:38:40 T:140135947007936 NOTICE: Disabled debug logging due to GUI setting. Level 0.
17:38:40 T:140135947007936 NOTICE: Log level changed to "LOG_LEVEL_NORMAL"
17:38:40 T:140135947007936 NOTICE: CMediaSourceSettings: loading media sources from special://masterprofile/sources.xml
17:38:40 T:140135947007936 NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
17:38:40 T:140135947007936 NOTICE: Loaded playercorefactory configuration
17:38:40 T:140135947007936 NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
17:38:40 T:140135947007936 NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
17:38:40 T:140135471863552 NOTICE: Thread ActiveAE start, auto delete: false
17:38:40 T:140135531759360 NOTICE: Thread AESink start, auto delete: false
17:38:40 T:140135531759360 NOTICE: PulseAudio: Opened device Default in pcm mode with Buffersize 150 ms
17:38:40 T:140135947007936 NOTICE: Running database version Addons16
17:38:41 T:140135947007936 NOTICE: ADDONS: Using repository repository.xbmc.org
17:38:41 T:140135505757952 NOTICE: Thread PeripBusCEC start, auto delete: false
17:38:41 T:140135497365248 NOTICE: Thread PeripBusUSBUdev start, auto delete: false
17:38:41 T:140135947007936 NOTICE: Setup SDL
17:38:41 T:140135947007936 NOTICE: Checking resolution 16
17:38:41 T:140135947007936 NOTICE: Using visual 0x170
17:38:41 T:140135947007936 NOTICE: GL_VENDOR = nouveau
17:38:41 T:140135947007936 NOTICE: GL_RENDERER = Gallium 0.4 on NVD9
17:38:41 T:140135947007936 NOTICE: GL_VERSION = 3.0 Mesa 10.1.0
17:38:41 T:140135947007936 NOTICE: GL_SHADING_LANGUAGE_VERSION = 1.30
17:38:41 T:140135947007936 NOTICE: GL_EXTENSIONS = GL_ARB_multisample GL_EXT_abgr GL_EXT_bgra GL_EXT_blend_color GL_EXT_blend_minmax GL_EXT_blend_subtract GL_EXT_copy_texture GL_EXT_polygon_offset GL_EXT_subtexture GL_EXT_texture_object GL_EXT_vertex_array GL_EXT_compiled_vertex_array GL_EXT_texture GL_EXT_texture3D GL_IBM_rasterpos_clip GL_ARB_point_parameters GL_EXT_draw_range_elements GL_EXT_packed_pixels GL_EXT_point_parameters GL_EXT_rescale_normal GL_EXT_separate_specular_color GL_EXT_texture_edge_clamp GL_SGIS_generate_mipmap GL_SGIS_texture_border_clamp GL_SGIS_texture_edge_clamp GL_SGIS_texture_lod GL_ARB_framebuffer_sRGB GL_ARB_multitexture GL_EXT_framebuffer_sRGB GL_IBM_multimode_draw_arrays GL_IBM_texture_mirrored_repeat GL_ARB_texture_cube_map GL_ARB_texture_env_add GL_ARB_transpose_matrix GL_EXT_blend_func_separate GL_EXT_fog_coord GL_EXT_multi_draw_arrays GL_EXT_secondary_color GL_EXT_texture_env_add GL_EXT_texture_filter_anisotropic GL_EXT_texture_lod_bias GL_INGR_blend_func_separate GL_NV_blend_square GL_NV_light_max_exponent GL_NV_texgen_reflection GL_NV_texture_env_combine4 GL_S3_s3tc GL_SUN_multi_draw_arrays GL_ARB_texture_border_clamp GL_ARB_texture_compression GL_EXT_framebuffer_object GL_EXT_texture_compression_s3tc GL_EXT_texture_env_combine GL_EXT_texture_env_dot3 GL_MESA_window_pos GL_NV_packed_depth_stencil GL_NV_texture_rectangle GL_ARB_depth_texture GL_ARB_occlusion_query GL_ARB_shadow GL_ARB_texture_env_combine GL_ARB_texture_env_crossbar GL_ARB_texture_env_dot3 GL_ARB_texture_mirrored_repeat GL_ARB_window_pos GL_EXT_stencil_two_side GL_EXT_texture_cube_map GL_NV_depth_clamp GL_NV_fog_distance GL_APPLE_packed_pixels GL_APPLE_vertex_array_object GL_ARB_draw_buffers GL_ARB_fragment_program GL_ARB_fragment_shader GL_ARB_shader_objects GL_ARB_vertex_program GL_ARB_vertex_shader GL_ATI_draw_buffers GL_ATI_texture_env_combine3 GL_ATI_texture_float GL_EXT_shadow_funcs GL_EXT_stencil_wrap GL_MESA_pack_invert GL_NV_primitive_restart GL_ARB_depth_clamp GL_ARB_fragment_program_shadow GL_ARB_half_float_pixel GL_ARB_occlusion_query2 GL_ARB_point_sprite GL_ARB_shading_language_100 GL_ARB_sync GL_ARB_texture_non_power_of_two GL_ARB_vertex_buffer_object GL_ATI_blend_equation_separate GL_EXT_blend_equation_separate GL_OES_read_format GL_ARB_color_buffer_float GL_ARB_pixel_buffer_object GL_ARB_texture_compression_rgtc GL_ARB_texture_float GL_ARB_texture_rectangle GL_ATI_texture_compression_3dc GL_EXT_packed_float GL_EXT_pixel_buffer_object GL_EXT_texture_compression_dxt1 GL_EXT_texture_compression_rgtc GL_EXT_texture_mirror_clamp GL_EXT_texture_rectangle GL_EXT_texture_sRGB GL_EXT_texture_shared_exponent GL_ARB_framebuffer_object GL_EXT_framebuffer_blit GL_EXT_framebuffer_multisample GL_EXT_packed_depth_stencil GL_ARB_vertex_array_object GL_ATI_separate_stencil GL_ATI_texture_mirror_once GL_EXT_draw_buffers2 GL_EXT_draw_instanced GL_EXT_gpu_program_parameters GL_EXT_texture_array GL_EXT_texture_compression_latc GL_EXT_texture_integer GL_EXT_texture_sRGB_decode GL_EXT_timer_query GL_OES_EGL_image GL_ARB_copy_buffer GL_ARB_depth_buffer_float GL_ARB_draw_instanced GL_ARB_half_float_vertex GL_ARB_instanced_arrays GL_ARB_map_buffer_range GL_ARB_texture_rg GL_ARB_texture_swizzle GL_ARB_vertex_array_bgra GL_EXT_texture_swizzle GL_EXT_vertex_array_bgra GL_NV_conditional_render GL_AMD_conservative_depth GL_AMD_draw_buffers_blend GL_ARB_ES2_compatibility GL_ARB_blend_func_extended GL_ARB_debug_output GL_ARB_draw_buffers_blend GL_ARB_draw_elements_base_vertex GL_ARB_explicit_attrib_location GL_ARB_fragment_coord_conventions GL_ARB_provoking_vertex GL_ARB_sampler_objects GL_ARB_seamless_cube_map GL_ARB_shader_texture_lod GL_ARB_texture_cube_map_array GL_ARB_texture_multisample GL_ARB_texture_rgb10_a2ui GL_ARB_uniform_buffer_object GL_ARB_vertex_type_2_10_10_10_rev GL_EXT_provoking_vertex GL_EXT_texture_snorm GL_MESA_texture_signed_rgba GL_NV_texture_barrier GL_ARB_get_program_binary GL_ARB_robustness GL_ARB_shader_bit_encoding GL_ARB_timer_query GL_ARB_transform_feedback2 GL_ARB_transform_feedback3 GL_NV_vdpau_interop GL_ANGLE_texture_compression_dxt3 GL_ANGLE_texture_compression_dxt5 GL_ARB_base_instance GL_ARB_conservative_depth GL_ARB_internalformat_query GL_ARB_map_buffer_alignment GL_ARB_shading_language_420pack GL_ARB_shading_language_packing GL_ARB_texture_storage GL_ARB_transform_feedback_instanced GL_EXT_framebuffer_multisample_blit_scaled GL_EXT_transform_feedback GL_AMD_shader_trinary_minmax GL_ARB_clear_buffer_object GL_ARB_invalidate_subdata GL_ARB_texture_storage_multisample GL_ARB_vertex_attrib_binding GL_KHR_debug GL_ARB_texture_mirror_clamp_to_edge
17:38:41 T:140135947007936 NOTICE: Running database version Addons16
17:38:41 T:140135947007936 NOTICE: Running database version ViewModes6
17:38:41 T:140135947007936 NOTICE: Running database version Textures13
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic48 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic47 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic46 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic45 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic44 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic43 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic42 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic41 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic40 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic39 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic38 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic37 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic36 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic35 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic34 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic33 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic31 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic30 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic29 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic28 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic27 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic26 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic25 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic24 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic23 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic22 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic21 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic20 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic19 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic18 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyMusic48 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to create new database
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos90 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos89 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos88 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos87 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos86 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos85 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos84 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos83 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos82 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos81 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos80 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos79 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos78 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos77 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos76 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos75 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos74 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos73 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos72 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos71 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos70 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos69 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos68 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos67 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos66 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos65 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos64 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos63 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos62 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos61 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos60 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to open database: MyVideos90 [2003](Can't connect to MySQL server on '192.168.1.30' (111))
17:38:41 T:140135947007936 ERROR: Unable to create new database
17:38:41 T:140135947007936 NOTICE: Running database version TV26
17:38:41 T:140135947007936 NOTICE: Running database version Epg8
17:38:41 T:140135947007936 NOTICE: start dvd mediatype detection
17:38:41 T:140135945508608 NOTICE: Thread DetectDVDMedia start, auto delete: false
17:38:41 T:140135947007936 WARNING: JSONRPC: Could not parse type "PVR.Details.Channel"
17:38:41 T:140135947007936 WARNING: JSONRPC: Could not parse type "PVR.Details.ChannelGroup.Extended"
17:38:41 T:140135947007936 WARNING: JSONRPC: Could not parse type "GUI.Property.Value"
17:38:41 T:140135947007936 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList"
17:38:41 T:140135947007936 NOTICE: initialize done
17:38:41 T:140135947007936 NOTICE: Running the application...
17:38:41 T:140135052080896 NOTICE: Thread LanguageInvoker start, auto delete: false
17:38:41 T:140135052080896 NOTICE: -->Python Interpreter Initialized<--
17:38:41 T:140135033816832 NOTICE: Thread JobWorker start, auto delete: true
17:38:41 T:140135947007936 NOTICE: starting zeroconf publishing
17:38:41 T:140135947007936 NOTICE: ES: Starting event server
17:38:41 T:140135000246016 NOTICE: Thread TCPServer start, auto delete: false
17:38:41 T:140135008638720 NOTICE: Thread EventServer start, auto delete: false
17:38:41 T:140135008638720 NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777
17:38:41 T:140135008638720 NOTICE: UDP: Listening on port 9777
17:38:41 T:140135017031424 NOTICE: Thread JobWorker start, auto delete: true
17:38:41 T:140135945438976 NOTICE: Thread RSSReader start, auto delete: false
17:38:47 T:140135052080896 NOTICE: Thread BackgroundLoader start, auto delete: false
17:38:49 T:140135947007936 ERROR: GetResumeItemOffset - Cannot open VideoDatabase
17:39:03 T:140135052080896 NOTICE: Thread VideoInfoScanner start, auto delete: false
17:39:03 T:140135052080896 NOTICE: VideoInfoScanner: Starting scan ..
17:39:04 T:140135052080896 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
17:39:04 T:140135052080896 NOTICE: Thread BackgroundLoader start, auto delete: false
17:40:20 T:140135531759360 NOTICE: Previous line repeats 1 times.
17:40:20 T:140135531759360 NOTICE: PulseAudio: Opened device Default in pcm mode with Buffersize 150 ms
17:40:20 T:140135017031424 NOTICE: Thread JobWorker start, auto delete: true
17:40:38 T:140135947007936 NOTICE: Samba is idle. Closing the remaining connections
17:42:07 T:140135947007936 ERROR: Control 18 in window 10129 has been asked to focus, but it can't
17:42:28 T:140135523366656 NOTICE: Thread JobWorker start, auto delete: true
17:42:54 T:140135531759360 NOTICE: PulseAudio: Opened device Default in pcm mode with Buffersize 150 ms
17:43:04 T:140135523366656 NOTICE: Thread JobWorker start, auto delete: true
17:44:32 T:140135523366656 NOTICE: Previous line repeats 1 times.
17:44:32 T:140135523366656 WARNING: SMBFile::OpenForWrite() called with overwriting enabled! - smb://darryl:[email protected]/Ocean/MultiMedia/kodi.log

Ned Scott

2015-05-21, 09:03
As it says, it cannot connect to the MySQL server. If it cannot connect to the MySQL server then it cannot create or view any video database. Make sure you have set up the MySQL server correctly.

djb79

2015-05-21, 11:18
I figured that was the case and hence I've already checked:
- PHPmyADMIN has a user and password set for full access for kodi

I've logged into PHPmyADMIN as kodi and can do everything.

I can't telnet into the MySQL serve from another computer, but that problem should come later because at this stage the SQL server and kodi installation are on the same computer.

MikeB2013

2015-05-21, 11:55
Maybe mysql bind address is the problem. Your advanced settings file is telling kodi to use a network connection even though kodi is local.

Check the bind address and make sure it is set to the correct ip address 192.168.1.30

If you change the bind address you must restart mysql, or simply reboot the computer.

You should then be able to ssh to the computer running mysql, then do

mysql -ukodi -p

mysql should then respond with the password prompt

Mike

MikeB2013

2015-05-21, 17:19
Further to my previous post.

What version of mysql are you running?

I just hit a similar problem to you on a test system using ubuntu 15.04, which uses mysql 5.6, my main system is ubuntu 14.10 running mysql 5.5.

I fixed the problem by also changing bind-address in mysqld.cnf in /etc/mysql/mysql.conf.d to the ip of the server.

Mike

nickr

2015-05-24, 02:04
The other point is that you need to allow connections to localhost as well as from 192.168.1.*

Also bind address should be 0.0.0.0.
Kodi Community Forum > Support > General Support > Linux > KODI MysQL banging head