Kodi Community Forum
Multiple users one mysql database - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Multiple users one mysql database (/showthread.php?tid=363581)



Multiple users one mysql database - nilsee - 2021-07-15

Hi,id like to follow up on 223162 (thread) (from 2015) where a user wanted to have one datebase and multible profiles run on it, with the same librays but seperate watchtimes etc... Back in 2015 he was told Not possible at this point.
By now quite some time has passed and maybe there is a way for it, that i didnt find.

Here is my setup:
Raspberry runs the Database and via advancedsettings.xml file on each device (2 laptops and one tv with fire tv stick). My 2 Flatmates each have a firetv stick and run kodi on it...

Here is the problem: Both of them complain that the movie is not there... and just have to refresh the list.

Id love to have profiles on database lev, so that i am just pushing the advancedsettings.xml file to their devices, they choose the profile (maybe even opt it, that it is always that profile on that mashine) and have the same libraby as erveryone but with a seperate watchlist/-times... Really kind of like netflix with their Profiles.

I tired to create profiles on each device with the advancedsettings.xml file, but it just didnt work as i wanted it too...

Hope thas possible.
Regards


RE: Multiple users one mysql database - Klojum - 2021-07-15

(2021-07-15, 11:22)nilsee Wrote: By now quite some time has passed and maybe there is a way for it, that i didnt find.

Nope. No official multi-user support has been implemented in Kodi at this time.
There is a community solution for a 5-user MySQL setup floating around on this forum which might help you out.

(2021-07-15, 11:22)nilsee Wrote: Here is the problem: Both of them complain that the movie is not there... and just have to refresh the list.

You can also create a separate database via each advancedsettings.xml file on each device, by using unique database names.
That way everyone has its own library, downside is that everyone needs to scrape and fill its own library.


RE: Multiple users one mysql database - nilsee - 2021-07-15

(2021-07-15, 11:43)Klojum Wrote: 5-user MySQL setup

Can you point me to that?
 
(2021-07-15, 11:43)Klojum Wrote: scrape and fill its own library.
Thats want i am trying to avoid.

Is there a point in making a feature request for a multiuser on database level?


RE: Multiple users one mysql database - Klojum - 2021-07-15

(2021-07-15, 12:13)nilsee Wrote: Is there a point in making a feature request for a multiuser on database level?

(Proper) Multi-user support would require a massive overhaul of Kodi's core code.
I don't see anyone brave enough at the moment to go or lead to that route, which is a shame.

(2021-07-15, 12:13)nilsee Wrote: Can you point me to that?

https://forum.kodi.tv/showthread.php?tid=196821&pid=3030544#pid3030544


RE: Multiple users one mysql database - LongMan - 2021-07-15

@nilsee,
There is also the option of using a server to manage your media library and users and syncing data or accessing it dynamically from Kodi. The media servers supported are Jellyfin, Emby and Plex. In each case you will need to install a video addon for syncing or dynamic access.

Jellyfin  Server JellyfinKodi and JellyCon
Emby   Server  Emby Next Gen and EmbyCon
Plex      Server  Composite Plex Kodi Connect

In Addition there is a version of Kodi being developed with the functionality built in. It is called MediaImport. You can use one , two or all there servers listed above. You could also use another instance of Kodi acting as a server but you would still have the multiple user limitation.
MediaImport is not mainline Kodi so you would have to use the builds listed here. The required addons are available from the mediaimport repo included in the build, activate the repo, and install the appropriate importer addon. (NB The emby importer should work for both emby and jellyfin)

I use Emby server with Emby Next Gen and MediaImport. If you have questions just fire away, I will answer as much as I can.

Just sharing other options.

Cheers,
LongMan