Apologies as I know there are many threads out there discussing this but even with these all I am not having much joy with setting up MySQL shared library no my NAS.
I have followed the steps as detailed here: MySQL (wiki)
My NAS is a ZyXEL 540 running MySQL – 5.1.73 (installed via the built in App Center and PHP-MySQL-phpMyAdmin 1.0zypkg007)
I have created a user ‘kodi’ and granted it all privileges.
On my Pi I am running kodi on OSMC 2017.03-1
In my advancedsettings.xml I have the following:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.134</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.134</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
I have created sources the both my TV and Movie shared on my NAS but on setting the content nothing happens.
Via the logfile uploader I see the following:
22:03:06.498 T:3026345984 NOTICE: Checking resolution 22
22:03:06.864 T:3026345984 NOTICE: GL_VENDOR = Broadcom
22:03:06.865 T:3026345984 NOTICE: GL_RENDERER = VideoCore IV HW
22:03:06.865 T:3026345984 NOTICE: GL_VERSION = OpenGL ES 2.0
22:03:06.865 T:3026345984 NOTICE: GL_SHADING_LANGUAGE_VERSION = OpenGL ES GLSL ES 1.00
22:03:06.865 T:3026345984 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
22:03:10.831 T:2903254000 NOTICE: Register – new cec device registered on cec->RPI: CEC Adapter (2708:1001)
22:03:10.840 T:3006264304 NOTICE: Running database version Addons27
22:03:10.852 T:3006264304 NOTICE: Running database version ViewModes6
22:03:10.862 T:3006264304 NOTICE: Running database version Textures13
22:03:10.877 T:3006264304 ERROR: Unable to open database: MyMusic60 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.881 T:3006264304 ERROR: Unable to open database: MyMusic59 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.884 T:3006264304 ERROR: Unable to open database: MyMusic58 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.887 T:3006264304 ERROR: Unable to open database: MyMusic57 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.890 T:3006264304 ERROR: Unable to open database: MyMusic56 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.893 T:3006264304 ERROR: Unable to open database: MyMusic55 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.895 T:3006264304 ERROR: Unable to open database: MyMusic54 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.898 T:3006264304 ERROR: Unable to open database: MyMusic53 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.901 T:3006264304 ERROR: Unable to open database: MyMusic52 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.903 T:3006264304 ERROR: Unable to open database: MyMusic51 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.905 T:3006264304 ERROR: Unable to open database: MyMusic50 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.908 T:3006264304 ERROR: Unable to open database: MyMusic49 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.910 T:3006264304 ERROR: Unable to open database: MyMusic48 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.914 T:3006264304 ERROR: Unable to open database: MyMusic47 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.916 T:3006264304 ERROR: Unable to open database: MyMusic46 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.919 T:3006264304 ERROR: Unable to open database: MyMusic45 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.922 T:3006264304 ERROR: Unable to open database: MyMusic44 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.924 T:3006264304 ERROR: Unable to open database: MyMusic43 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.926 T:3006264304 ERROR: Unable to open database: MyMusic42 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.929 T:3006264304 ERROR: Unable to open database: MyMusic41 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.932 T:3006264304 ERROR: Unable to open database: MyMusic40 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.934 T:3006264304 ERROR: Unable to open database: MyMusic39 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.937 T:3006264304 ERROR: Unable to open database: MyMusic38 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.939 T:3006264304 ERROR: Unable to open database: MyMusic37 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.941 T:3006264304 ERROR: Unable to open database: MyMusic36 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.944 T:3006264304 ERROR: Unable to open database: MyMusic35 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.946 T:3006264304 ERROR: Unable to open database: MyMusic34 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.948 T:3006264304 ERROR: Unable to open database: MyMusic33 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.950 T:3006264304 ERROR: Unable to open database: MyMusic32 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.953 T:3006264304 ERROR: Unable to open database: MyMusic60 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.953 T:3006264304 ERROR: Unable to create new database
22:03:10.955 T:3006264304 ERROR: Unable to open database: MyVideos107 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.958 T:3006264304 ERROR: Unable to open database: MyVideos106 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.961 T:3006264304 ERROR: Unable to open database: MyVideos105 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.963 T:3006264304 ERROR: Unable to open database: MyVideos104 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.965 T:3006264304 ERROR: Unable to open database: MyVideos103 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.968 T:3006264304 ERROR: Unable to open database: MyVideos102 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.972 T:3006264304 ERROR: Unable to open database: MyVideos101 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.975 T:3006264304 ERROR: Unable to open database: MyVideos100 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.977 T:3006264304 ERROR: Unable to open database: MyVideos99 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.980 T:3006264304 ERROR: Unable to open database: MyVideos98 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.983 T:3006264304 ERROR: Unable to open database: MyVideos97 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.985 T:3006264304 ERROR: Unable to open database: MyVideos96 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.987 T:3006264304 ERROR: Unable to open database: MyVideos95 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.990 T:3006264304 ERROR: Unable to open database: MyVideos94 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.993 T:3006264304 ERROR: Unable to open database: MyVideos93 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.995 T:3006264304 ERROR: Unable to open database: MyVideos92 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:10.998 T:3006264304 ERROR: Unable to open database: MyVideos91 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.001 T:3006264304 ERROR: Unable to open database: MyVideos90 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.003 T:3006264304 ERROR: Unable to open database: MyVideos89 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.005 T:3006264304 ERROR: Unable to open database: MyVideos88 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.007 T:3006264304 ERROR: Unable to open database: MyVideos87 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.010 T:3006264304 ERROR: Unable to open database: MyVideos86 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.012 T:3006264304 ERROR: Unable to open database: MyVideos85 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.015 T:3006264304 ERROR: Unable to open database: MyVideos84 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.017 T:3006264304 ERROR: Unable to open database: MyVideos83 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.019 T:3006264304 ERROR: Unable to open database: MyVideos82 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.021 T:3006264304 ERROR: Unable to open database: MyVideos81 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.023 T:3006264304 ERROR: Unable to open database: MyVideos80 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.026 T:3006264304 ERROR: Unable to open database: MyVideos79 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.028 T:3006264304 ERROR: Unable to open database: MyVideos78 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.034 T:3006264304 ERROR: Unable to open database: MyVideos77 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.037 T:3006264304 ERROR: Unable to open database: MyVideos76 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.039 T:3006264304 ERROR: Unable to open database: MyVideos75 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.044 T:3006264304 ERROR: Unable to open database: MyVideos107 [2003](Can’t connect to MySQL server on ‘192.168.1.134’ (111))
22:03:11.044 T:3006264304 ERROR: Unable to create new database
22:03:11.051 T:3006264304 NOTICE: Running database version TV29
22:03:11.059 T:3006264304 NOTICE: Running database version Epg11
22:03:11.067 T:3026345984 NOTICE: start dvd mediatype detection
22:03:13.621 T:3026345984 WARNING: JSONRPC: Could not parse type “Setting.Details.SettingList”
22:03:16.440 T:3026345984 NOTICE: UpdateLibraries: Starting video library startup scan
22:03:17.671 T:3026345984 NOTICE: initialize done
22:03:17.671 T:3026345984 NOTICE: Running the application…
22:03:17.730 T:3026345984 NOTICE: starting zeroconf publishing
22:03:17.740 T:3026345984 NOTICE: CWebServer[8080]: Started
22:03:17.740 T:3026345984 NOTICE: starting upnp client
22:03:17.788 T:2727756784 NOTICE: ES: Starting UDP Event server on port 9777
22:03:17.788 T:2727756784 NOTICE: UDP: Listening on port 9777 (ipv6 : true)
22:03:26.954 T:2803778544 ERROR: GetDirectory – Error getting
22:03:29.462 T:3026345984 ERROR: Previous line repeats 6 times.
22:03:29.463 T:3026345984 ERROR: GetResumeItemOffset – Cannot open VideoDatabase
22:03:54.701 T:2813477872 WARNING: CSkinInfo: failed to load skin settings
I have seen references to updating the bind-address but I have not been able to locate this on my NAS. I do see the following references in the mySQL directories but unsure if this is where I should be updating these.
File: bin/reset_zyadmin
./bin/mysqld_safe –skip-grant-table –bind-address=127.0.0.1 &
./bin/mysqld_safe –user=mysql –bind-address=127.0.0.1 &
File: bin/init
./bin/mysqld_safe –skip-grant-table –bind-address=127.0.0.1 &
File: bin/reset
./bin/mysqld_safe –user=mysql –bind-address=127.0.0.1 &
Any help would be gladly welcomed as I have been going around in circles on this for a considerable time now.
Thanks,
Hi66y