+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Video Support (https://forum.kodi.tv/forumdisplay.php?fid=264)
+--- Thread: Kodi 18.9 - question on video database and profiles (/showthread.php?tid=367744)
Kodi 18.9 - question on video database and profiles - tiaderosa - 2022-04-05
Hi,
As far as I have understood with the use of profile, among all kind of settings, you can have separate video source and database. So profile 1 has is own video and libraries and profile 2 as well.
In fact the database folders are stored in different userdata folders.
I'm sorry if the following appears as a dummy question, but I 'm new on kodi and mysql.
What happen if I want to use a mysql common database setup for several istance of kodi ?
Do I have to implemend two different users in mysql database (ie kodi1 and kodi2) and address the specific user with the related advancedsettings.xml ?
I mean I create user kodi1 and user kodi2 in mysql.
In the advance "videodatabase" settings of profile 1 I put:
<videodatabase>
<type>mysql</type>
<host>HpstIP</host>
<port>3306</port>
<user>kodi1</user>
<pass>kodi</pass>
</videodatabase>
In the advance "videodatabase" settings of profile 2 I put:
<videodatabase>
<type>mysql</type>
<host>HpstIP</host>
<port>3306</port>
<user>kodi2</user>
<pass>kodi</pass>
</videodatabase>
Is that right ?
Do I need to have kodi1 and kodi2 instead of just kodi as user of mysql database to keep the video separate ?
Many thanks
RE: Kodi 18.9 - question on video database and profiles - beeswax - 2022-04-05
If you only change the user in your AdvancedSettings.xml then you'll still be connecting to the same database with the same movie/tv data.
If you want to maintain 2 separate libraries for these users/profiles you'll need to look at the <name> tag on the AdvancedSettings.xml wiki page. I've never tried that but by simply specifying a different name for the db, kodi will create a separate MySQL database for that user. Of course, this will double your admin/scraping overhead so you might want to consider just using a skin that supports Smart Playlists (e.g. Aeon Knox Silvo) and customising the skin for each user. That's the method I went with and now I have profiles for adults/kids which show specific content in Movies/TV but still use a single shared mysql db.
RE: Kodi 18.9 - question on video database and profiles - Klojum - 2022-04-05
(2022-04-05, 08:37)tiaderosa Wrote: I'm sorry if the following appears as a dummy question, but I 'm new on kodi and mysql.Dumb/dummy questions are those questions not asked.
Yes, you can use separate databases for those people(s) who want their own watched statuses. It will however also mean that per profile/database, the video/music source(s) will have to be scraped separately. All profiles can have the same video/music sources, but not necessarily.
(2022-04-05, 08:37)tiaderosa Wrote: In fact the database folders are stored in different userdata folders.Each profile has its own "root" folder, which includes a 'userdata/Database' folder, but that is for local SQLite databases.
A profile will have its own advancedsettings.xml file, which will point to the database server with its own user settings.
(2022-04-05, 08:37)tiaderosa Wrote: Do I need to have kodi1 and kodi2 instead of just kodi as user of mysql database to keep the video separate ?Technically no, you don't need separate logins per database, but security-wise it is recommended (which also goes for their passwords).
RE: Kodi 18.9 - question on video database and profiles - tiaderosa - 2022-04-05
Thank you Both for your hints!
I'll try and come back should I have hard times