Kodi Community Forum
HOW-TO:Share libraries using MySQL: Wiki Edition - Printable Version

Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Tips, tricks, and step by step guides (https://forum.kodi.tv/forumdisplay.php?fid=110)
--- Thread: HOW-TO:Share libraries using MySQL: Wiki Edition (/showthread.php?tid=157572)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - shaktoo - 2020-07-11

I had to follow a few tutorials and managed to setup mySQL server and now its working like a charm across 2 x Nvidia Sheilds & main PC which has the main Kodi & the mySQL server.
I had many setbacks and took a month for things to smooth out.
My main mistake was that ALL the clients ( including install on main PC ) have to have libraries setup as "smb shares " . I think this is one of the steps where I made mistake and had to redo everything.
The inprogress media widget has a lag and i wanted to bring this to someones attention but just wasnt bothered enough. ( ANS skin & Bingie )
As stated Movies are updated instantly but the inprogress shows arent updated quickly. I found that if i play an episode of whatever on one of the machine then once that episode finishes the widget updates to the appropriate episodes.
Similar things might happen on another slave kodi install. 
As klojum has mentioned I might get the skin refresh as a startup task to see if this reolves it .


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Klojum - 2020-07-11

(2020-07-11, 14:14)IamDan Wrote: Ive quit and restarted my windows kodi instance and still dont see a result. The movies do seem to update the in progress widget when I restart

Check the content of the debug log (wiki) files. Be sure to first enable debugging and restart Kodi. Connection problems should be identifiable in the log files.

What sort of machine is running the MySQL/MariaDB server? And which version?


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - IamDan - 2020-07-12

(2020-07-11, 14:37)Klojum Wrote:
(2020-07-11, 14:14)IamDan Wrote: Ive quit and restarted my windows kodi instance and still dont see a result. The movies do seem to update the in progress widget when I restart

Check the content of the debug log (wiki) files. Be sure to first enable debugging and restart Kodi. Connection problems should be identifiable in the log files.

What sort of machine is running the MySQL/MariaDB server? And which version?

Here is my log -    https://paste.kodi.tv/yocebodasa.kodi

Here is another log. I played a tv show and stopped it. Not sure if its of value -  https://paste.kodi.tv/awivupapas.kodi

Im running mariadb 10.3.21 on my Synology 1513+.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - IamDan - 2020-07-12

(2020-07-11, 14:35)shaktoo Wrote: I had to follow a few tutorials and managed to setup mySQL server and now its working like a charm across 2 x Nvidia Sheilds & main PC which has the main Kodi & the mySQL server.
I had many setbacks and took a month for things to smooth out.
My main mistake was that ALL the clients ( including install on main PC ) have to have libraries setup as "smb shares " . I think this is one of the steps where I made mistake and had to redo everything.
The inprogress media widget has a lag and i wanted to bring this to someones attention but just wasnt bothered enough. ( ANS skin & Bingie )
As stated Movies are updated instantly but the inprogress shows arent updated quickly. I found that if i play an episode of whatever on one of the machine then once that episode finishes the widget updates to the appropriate episodes.
Similar things might happen on another slave kodi install. 
As klojum has mentioned I might get the skin refresh as a startup task to see if this reolves it .
When you say SMB shares what are you refering to? I currently use NFS. I just find it a whole lot easier. Sureley it shouldnt make any difference between SMB and NFS


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - shaktoo - 2020-07-12

(2020-07-12, 02:05)IamDan Wrote:
(2020-07-11, 14:35)shaktoo Wrote: I had to follow a few tutorials and managed to setup mySQL server and now its working like a charm across 2 x Nvidia Sheilds & main PC which has the main Kodi & the mySQL server.
I had many setbacks and took a month for things to smooth out.
My main mistake was that ALL the clients ( including install on main PC ) have to have libraries setup as "smb shares " . I think this is one of the steps where I made mistake and had to redo everything.
The inprogress media widget has a lag and i wanted to bring this to someones attention but just wasnt bothered enough. ( ANS skin & Bingie )
As stated Movies are updated instantly but the inprogress shows arent updated quickly. I found that if i play an episode of whatever on one of the machine then once that episode finishes the widget updates to the appropriate episodes.
Similar things might happen on another slave kodi install. 
As klojum has mentioned I might get the skin refresh as a startup task to see if this reolves it .
When you say SMB shares what are you refering to? I currently use NFS. I just find it a whole lot easier. Sureley it shouldnt make any difference between SMB and NFS
SMB is similar sharing protocol to NFS. 
Most of the tutorials I watched  were recommending SMB , plus I had setup SMB shares and was more comfortable with it so went with it.
It isnt any difference and does not really matter.
what matters is that ALL the server & clients running Kodi access the server library via a share SMB or NFS . Otherwise it does not work.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Klojum - 2020-07-12

(2020-07-11, 14:35)shaktoo Wrote: As klojum has mentioned I might get the skin refresh as a startup task to see if this reolves it .
A skin refresh at a startup of a Kodi client is a bit nonsense, as everything gets refreshed already.
I mean using a keymapped like F5 so you can refresh a Kodi skin at any time.

(2020-07-12, 00:00)IamDan Wrote: Im running mariadb 10.3.21 on my Synology 1513+.
That version should be just fine.

NOTICE: ADDON: skin.estuary.modv2 v3.0.5 installed
That skin comes with plenty of "extra functionality" from what I remember. Maybe it is a bit disruptive of normal Kodi proceedings. Try switching to the default Estuary skin, and restart Kodi.

ERROR: Failed to close(volume1/video/TV Shows/Hitler's Last Year/poster.jpg) - close call failed with "NFS: Commit failed with NFS3ERR_ACCES(-13)"
This should be harmless and only on a file handling level, and not affect Kodi's database handling.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - IamDan - 2020-07-12

(2020-07-12, 05:10)Klojum Wrote:
(2020-07-11, 14:35)shaktoo Wrote: As klojum has mentioned I might get the skin refresh as a startup task to see if this reolves it .
A skin refresh at a startup of a Kodi client is a bit nonsense, as everything gets refreshed already.
I mean using a keymapped like F5 so you can refresh a Kodi skin at any time.
(2020-07-12, 00:00)IamDan Wrote: Im running mariadb 10.3.21 on my Synology 1513+.
That version should be just fine.

NOTICE: ADDON: skin.estuary.modv2 v3.0.5 installed
That skin comes with plenty of "extra functionality" from what I remember. Maybe it is a bit disruptive of normal Kodi proceedings. Try switching to the default Estuary skin, and restart Kodi.

ERROR: Failed to close(volume1/video/TV Shows/Hitler's Last Year/poster.jpg) - close call failed with "NFS: Commit failed with NFS3ERR_ACCES(-13)"
This should be harmless and only on a file handling level, and not affect Kodi's database handling.

I switched back to estuary. Im now getting In progress items being added from my pi running libreelec however my windows machine will not update. Even when I play something on the windows machine it wont update the in progress list.

EDIT: OK I thinkits all working now. As soon as I completed a full episode it all sprang into life (weird). I really appreciate the help!! Ill start adding the advancedsettings etc to other clients and see how i go! Thanks again


This forum uses Lukasz Tkacz MyBB addons.