(Error) OSMC + shared library on mysql

hello all,

i found here some topics regarding shared library, but i didnt found any guide how to correctly set this up…
i followed some guide on kodi website, created a advancedsettings.xml file, but when i connect from another device as my osmc, i dont see there watched or paused movies… so i thing something is wrong…

here is my debug log

thanks for any help.

http://kodi.wiki/view/MySQL/Setting_up_MySQL

do that server side

then use to setup in kodi
use myosmc to setup mysql settings

thanks for quick reply…

on my server i have now all the settings related to kodi… should i clear the existing db?

and what about the advancedsettings.xml file? should i delete it before setup the new settings?

if you done as the wiki said then you can keep your existing db

as for advancedsetting.xml delete it and use myosmc instead to enter your credentials

so without success… i enter credentials, ip address of my server, deleted old databases that created advancedsettngs.xml file, granted all to kodi user and nothing happen…
im not able to click exit after filling up the OSMC mysql connection screen…

i found this in log:

19:09:15 481.165497 T:1473246240 DEBUG: actionID = 999 19:09:15 481.165649 T:1473246240 DEBUG: focused_control = <type 'int'>, 666 19:09:15 481.165802 T:1473246240 DEBUG: actionID = 7 19:09:15 481.165924 T:1473246240 DEBUG: focused_control = <type 'int'>, 666 19:09:15 481.412323 T:1473246240 DEBUG: ctl 910511 : sql item name : 19:09:15 481.412659 T:1473246240 DEBUG: ctl 910512 : sql item host : 192.168.1.80 19:09:15 481.412811 T:1473246240 DEBUG: ctl 910513 : sql item port : 3306 19:09:15 481.412933 T:1473246240 DEBUG: ctl 910514 : sql item user : kodi 19:09:15 481.413086 T:1473246240 DEBUG: ctl 810515 : sql item pass : kodi 19:09:15 481.414398 T:1473246240 ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<-- - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS! Error Type: <type 'exceptions.TypeError'> Error Contents: 'NoneType' object does not support item assignment Traceback (most recent call last): File "/usr/share/kodi/addons/script.module.osmcsetting.networking/resources/lib/networking_gui.py", line 409, in onClick self.shutdown_process() File "/usr/share/kodi/addons/script.module.osmcsetting.networking/resources/lib/networking_gui.py", line 419, in shutdown$ self.read_mysql_settings(self.advs_dict) File "/usr/share/kodi/addons/script.module.osmcsetting.networking/resources/lib/networking_gui.py", line 741, in read_mys$ sub_dict['videolibrary']['importwatchedstate'] = 'true' TypeError: 'NoneType' object does not support item assignment -->End of Python script error report<-- 19:09:15 481.414673 T:1473246240 DEBUG: actionID = 999 19:09:15 481.414795 T:1473246240 DEBUG: focused_control = <type 'int'>, 666 19:09:15 481.414978 T:1473246240 DEBUG: actionID = 7 19:09:15 481.415100 T:1473246240 DEBUG: focused_control = <type 'int'>, 666 19:09:15 481.678925 T:1473246240 DEBUG: ctl 910511 : sql item name : 19:09:15 481.679260 T:1473246240 DEBUG: ctl 910512 : sql item host : 192.168.1.80 19:09:15 481.679413 T:1473246240 DEBUG: ctl 910513 : sql item port : 3306 19:09:15 481.679565 T:1473246240 DEBUG: ctl 910514 : sql item user : kodi 19:09:15 481.679688 T:1473246240 DEBUG: ctl 810515 : sql item pass : kodi 19:09:15 481.681061 T:1473246240 ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<-- - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS! Error Type: <type 'exceptions.TypeError'> Error Contents: 'NoneType' object does not support item assignment Traceback (most recent call last): File "/usr/share/kodi/addons/script.module.osmcsetting.networking/resources/lib/networking_gui.py", line 409, in onClick

another error regarding nwgui script:

19:09:16 481.897675 T:1473246240 DEBUG: actionID = 999
19:09:16 481.897797 T:1473246240 DEBUG: focused_control = <type ‘int’>, 666
19:09:16 481.897949 T:1473246240 DEBUG: actionID = 7
19:09:16 481.898041 T:1473246240 DEBUG: focused_control = <type ‘int’>, 666
19:09:17 482.805084 T:1473246240 DEBUG: actionID = 3
19:09:17 482.805450 T:1473246240 DEBUG: focused_control = <type ‘int’>, 105
19:09:17 483.405060 T:1473246240 DEBUG: actionID = 4
19:09:17 483.405426 T:1473246240 DEBUG: focused_control = <type ‘int’>, 666
19:09:18 484.344971 T:1473246240 DEBUG: ctl 910511 : sql item name :
19:09:18 484.345306 T:1473246240 DEBUG: ctl 910512 : sql item host : 192.168.1.80
19:09:18 484.345459 T:1473246240 DEBUG: ctl 910513 : sql item port : 3306
19:09:18 484.345612 T:1473246240 DEBUG: ctl 910514 : sql item user : kodi
19:09:18 484.345734 T:1473246240 DEBUG: ctl 810515 : sql item pass : kodi
19:09:18 484.346985 T:1473246240 ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<–
- NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
Error Type: <type ‘exceptions.TypeError’>
Error Contents: ‘NoneType’ object does not support item assignment
Traceback (most recent call last):
File “/usr/share/kodi/addons/script.module.osmcsetting.networking/resources/lib/networking_gui.py”, line 409, in onClick
self.shutdown_process()
File “/usr/share/kodi/addons/script.module.osmcsetting.networking/resources/lib/networking_gui.py”, line 419, in shutdown$
self.read_mysql_settings(self.advs_dict)
File “/usr/share/kodi/addons/script.module.osmcsetting.networking/resources/lib/networking_gui.py”, line 741, in read_mys$
sub_dict[‘videolibrary’][‘importwatchedstate’] = ‘true’
TypeError: ‘NoneType’ object does not support item assignment
–>End of Python script error report<–