Advertising (This ad goes away for registered users. You can Login or Register)

kodi mariadb Share strm

PC, Mac, Windows, Linux... they're not dedicated gaming devices, it doesn't mean we don't love them!
Locked
nvieen69
Posts: 4
Joined: Mon Jan 10, 2022 2:43 am

kodi mariadb Share strm

Post by nvieen69 »

Share STRM library with multiple devices
Stefano Gottardo edited this page on Dec 29, 2020 · 1 revision
Pages 22
User Documentation

How install the addon
Login with Authentication key
Sync of watched status with Netflix
FAQ (Audio, Video, Subtitle, Other)
FAQ (Errors)
Library settings
Expert settings
How to export and sync tv shows and movies in Kodi library
Share STRM library with multiple devices
List of 1080P 4k Android tested devices
My credentials are safe?
VPN and Proxy
Key mapping
Development

Dev. guidelines and philosophy
Dev. documentation
Dev. basic info
Dev. unresolved issues
Dev. Add-on versioning
Dev. PyCrypto packages
About

The project
Kodi forum
Contribute and donations
Business collaboration
Clone this wiki locally
https://github.com/CastagnaIT/plugin.vi ... x.wiki.git
When you need to share the same Kodi exported library (of Netflix videos) with multiple devices, there are two possibilities of setting.

Choose the case that suits your needs.

OPTION 1 - All devices can manage and play from the same Kodi library of Netflix exported items
In this case every devices can manage the Kodi library of Netflix exported items (e.g. export, remove).

Recommended method
Needed a shared network folder (like SMB)
Needed a MySQL server (MySQL => 5.5.3 or MariaDB => 5.5)
How to configure:

To first you must create a shared network folder (using SMB or other services) where place the exported library items.

Then will be needed to configure all Kodi installations, with a central MySQL server. You can follow the official Kodi MySQL setup instructions at Kodi Wiki.

When done, in each device, open the add-on settings and under Library page:

Turn ON Enable custom library folder and choose the path of the shared network folder Custom library path. The path must be the exact the same to all devices. (in the path selection window press the back button several times to have full access)
Enable Use MySQL shared library database, then set the same connection parameters used in Kodi MySQL setup.
Now you have set what main device that is responsible for updating the library (e.g. check for new episodes): Then in the device you have choose, under Library page settings, click on Set this device as main auto-updates manager.

To configure the main device to auto-update the library see How to export and sync tv shows and movies in Kodi library.

Now you can manage and play the Netflix exported items from all configured devices.

OPTION 2 - Only a main device must manage the Kodi library of Netflix exported items, all devices can play from same library
In this case only the main device must manage the Kodi library (e.g. export, remove) netflix exported items, any other device must access to the library as "read-only" mode, so you should not modify the exported library items from the other devices.

Method to be used carefully, can causing problems explained below
Needed a shared network folder (like SMB)
STRM resume workaround will not work from other devices
UpNext add-on will not work from other devices
It is not recommended to use the Export to Library feature to export STRM from other devices
Pay attention!

This add-on makes use of an internal database to manage the videos exported to the Kodi library, to avoid compromising the internal database you should never modify the Kodi library of Netflix exported items from the other devices.

Otherwise this will cause in the best cases inconsistencies with the menus to manage the exported videos (e.g. export, remove), in the worst cases increasing the risk of ban cases of Netflix account due to a too heavy synchronization.

How to configure:

To first you must create a shared network folder (using SMB or other services) where place the exported library items.

In the main device:

Open the add-on settings and under Library page: Turn ON Enable custom library folder and choose the path of the shared network folder Custom library path. (in the path selection window press the back button several times to have full access)
If you want configure also the auto-update feature see How to export and sync tv shows and movies in Kodi library
In the other devices:

Install the add-on
In the Kodi Video browser and add the path of the shared network folder.
It is recommended but not mandatory disable Export to Library feature, to prevent wrong behaviours of Up Next add-on and STRM resume workaround (if you do not use them and have disabled them, you can ignore this step). From add-on Library settings, set Auto update mode to Disabled.
Remember not to modify the Kodi library of Netflix exported items from these devices.
Now you can play the Netflix exported items from all configured devices.

MySQL
Jump to navigationJump to search
NOTICE: This is considered an advanced (complicated) and experimental feature.
NOTICE: Every Kodi "client" must run the same version of Kodi.
Otherwise they will not be sharing the same library. There can even be differences between development builds, so make sure you always use the same build dates. See Version table for more info.
Share libraries w/MySQL, guide:

Introduction
Setting up MySQL
Setting up Kodi
Sharing artwork
Sync other parts of Kodi
Upgrading XBMC/Kodi
Portable devices and profiles
Advanced notes
Backup and restore databases
Update paths in MySQL
See also: Databases
Network.png
Introduction
If you have more than one Kodi device on your local network then you might want to synchronize them by sharing the Kodi library databases via the MySQL protocol. Using shared library databases allows you to store information for either your video or music library in a central database, so that multiple devices can access the same information at the same time.

This gives you the ability to do things like:

Share watched and unwatched status for your media on all devices
Stop watching a movie or TV show in one room then finish watching it in another room automatically
Only one library to maintain for all devices

MySQL Protocol & MariaDB
When setting up shared Library databases either MySQL or MariaDB can be used as they both use the same MySQL protocol. Since many Linux distributions have dropped including MySQL and now instead now ship MariaDB, it is being more common to use MariaDB for shared Library databases.

How to export and sync tv shows and movies in Kodi library
Stefano Gottardo edited this page on Jul 25, 2020 · 7 revisions
Pages 22
User Documentation

How install the addon
Login with Authentication key
Sync of watched status with Netflix
FAQ (Audio, Video, Subtitle, Other)
FAQ (Errors)
Library settings
Expert settings
How to export and sync tv shows and movies in Kodi library
Share STRM library with multiple devices
List of 1080P 4k Android tested devices
My credentials are safe?
VPN and Proxy
Key mapping
Development

Dev. guidelines and philosophy
Dev. documentation
Dev. basic info
Dev. unresolved issues
Dev. Add-on versioning
Dev. PyCrypto packages
About

The project
Kodi forum
Contribute and donations
Business collaboration
Clone this wiki locally
https://github.com/CastagnaIT/plugin.vi ... x.wiki.git
You can export in two ways
1. Export movies and tv shows (with manual updates for tv shows)

This mode involves manual export of each tv show/movie through the context menu, in this case new seasons or episodes must be updated manually.

Some tips:

To export, open context menu of a tv show and select Export to library.
To export new seasons/episodes, open context menu of a tv show and select Export new episodes.
To force a tv show update, open context menu of a tv show and select Update inside library, this function will completely delete all files exported of the tv show and export them again.
2. Export movies and tv shows (with auto updates for tv shows)

This mode involves manual export of each tv show/movie through the context menu, but with scheduled automatic updates for the search for new seasons and episodes.

If you decide to use this feature pay attention to the notice written at the end.

How to enable the automatic updates:

Open add-on settings, and go to the page Library
Auto update mode set to Scheduled
Perform auto-update set how often updates are performed
Time of Day set the start time, if when open Kodi the time has already elapsed, the update will still be performed at a later time.
Only start after 5 minutes of idle if turned on updates will only start when you do not use Kodi for at least 5 minutes. If turned off updates will start when you open Kodi.
Where are the exported files?
By default the files are located in the add-on user data folder with a path like

…\Kodi\userdata\addon_data\plugin.video.netflix\shows
…\Kodi\userdata\addon_data\plugin.video.netflix\movies

but the full path may change depending on the type of operating system, the file path scheme is viewable in Kodi Wiki https://kodi.wiki/view/Userdata

For easier an access to your exported files, you can change the default path and choose a custom one.

So in add-on settings, go to Library page and:

Turn on Enable custom library folder
Click on Custom library path, to set up your preferred folder
Select your preferred path (in the path selection window press the back button several times to have full access)
Create a new folder like "Netflix exported", where within it the add-on will create two new subfolders shows and movies
WARNING: If this setting is changed after you have already exported tv shows or movies, you must reset the database data! This implies the loss of all exports!

To reset database, in add-on settings, go to Library page and:

Select Delete library contents
NOTE: if you are an experienced user, instead of resetting you can move the folders of the files manually

How to synchronize Kodi library with Netflix "My List" of an profile
Synchronization with My List involves the automatic export and removal from the Kodi library of what is added/removed from My List of a specific profile.

When you make changes to My List from another device or from another app or website, the changes will not be reported in the add-on in real time, but you will have to wait for the schedule to run.

If you decide to use this feature pay attention to the notice written at the end.

Note that when you enable this feature the context menus like Export/Remove from library, will no longer be accessible, because all these operations will be performed automatically from the context menus Add/Remove to My List.

Before continuing you must complete the point 2 of You can export in two ways, in order to enable the scheduled mode.

How to enable the sync of Kodi library with My List:

First important thing, login with the profile containing the My List to synchronize!
Open add-on settings, go to Library page
Turn on Keep My List and Kodi Library in sync
Click on Set a profile for synchronization, to sync the library with the My List of the chosen profile
If you want customize the export folder go to paragraph Where are the exported files?. If you want to customize it must be done before before the next points
Click on Perform full sync now, to start the synchronization immediately
Notice for the use of auto-update and auto-sync with Netflix "My List" feature
AN INTENSIVE USE OF THIS FEATURES due to many exported tv shows MAY CAUSE A TEMPORARY BAN OF THE ACCOUNT that varies starting from 24/48 hours. Use at your own risk.

If it happens often, there is the possibility to exclude the auto update from the tv shows, by open context menu on a tv show and selecting Exclude from auto update.
Advertising
nvieen69
Posts: 4
Joined: Mon Jan 10, 2022 2:43 am

Re: kodi mariadb Share strm

Post by nvieen69 »

MySQL/Setting up MySQL
< MySQL
Jump to navigationJump to search
Share libraries w/MySQL, guide:

Introduction
Setting up MySQL
Setting up Kodi
Sharing artwork
Sync other parts of Kodi
Upgrading XBMC/Kodi
Portable devices and profiles
Advanced notes
Backup and restore databases
Update paths in MySQL
Home icon grey.png ▶ MySQL ▶ Setting up MySQL
You'll need to choose which of your computers, Kodi devices, or NAS will be the MySQL server. The server needs to be on 24/7 or have wake-on-lan (preferably the former), and needs to have a local static IP. You will probably want the Kodi device that is hosting most or all of your videos and music to also be the MySQL server, but this is not required.
Please Note: Do not manually create the MySQL/MariaDB databases on your database server. Set up the MySQL/MariaDB server, and Kodi will create the specific databases for you.
Also: Some versions of MySQL set their passwords to expire by default, even the root password! If the password expires, Kodi cannot access the database and the TV Series and Movies libraries will disappear.
To avoid this and/or fix it after it happens, make sure the account's password does not expire. (See: https://dev.mysql.com/doc/refman/5.7/en ... ement.html )

MySQL/MariaDB can be installed on just about every major OS and NAS:

Important: Please use only supported versions of the MySQL or MariaDB server. As of January 2019, this is MySQL in at least version 5.7 or MariaDB in at least version 5.5, but version 10.3+ is recommended.


Contents
1 Ubuntu Linux
2 Arch Linux
3 RedHat based Linux
4 RaspberryPi Raspbian
5 Mac OS X
6 Windows
6.1 Installing MySQL on Windows
6.1.1 Windows 7/8/8.1 Built-in Firewall
6.2 Setup users in MySQL for Kodi clients
7 Other NAS
8 FreeNAS and freeBSD
8.1 About FreeNAS
8.2 How to
8.2.1 Make a jail
8.2.2 Prepare the jail
8.2.3 Install mysql
8.2.4 Configure mysql ready for Kodi to use
9 Restricting MySQL access rights
Ubuntu Linux
Arch Linux
RedHat based Linux
RaspberryPi Raspbian
Mac OS X
Windows
Other NAS
FreeNAS and freeBSD
Restricting MySQL access rights

[edit]
Ubuntu Linux:

$sudo apt-get install mysql-server (see also: https://help.ubuntu.com/18.04/serverguide/mysql.html )
Create a password when asked
To configure MySQL to listen for connections from network hosts, edit /etc/mysql/mysql.conf.d/mysqld.cnf and change the bind-address directive to the server's IP address:
from: bind-address = 127.0.0.1
to: bind-address = 192.168.0.5
Note: Replace 192.168.0.5 with the appropriate address.
Note: To allow both local and remote access (i.e. from both the MySQL host to itself and also from other clients), either comment out the bind-address using a hash (#) to disable it, or use bind-address = 0.0.0.0 to open it completely.
When using MySQL8 or higher (Ubuntu 20.04 or later), add the following line at the end of /etc/mysql/mysql.conf.d/mysqld.cnf:
default_authentication_plugin=mysql_native_password
Restart your MySQL server. sudo service mysql restart
Get into the MySQL command line utility: mysql -u root -p
Enter the following commands:
Type in: CREATE USER 'kodi' IDENTIFIED BY 'kodi'; and press return
Note: When using MySQL8 or higher, there are additional password requirements and new authentication methods. Using the following command should avoid errors. Type in: CREATE USER 'kodi' IDENTIFIED WITH mysql_native_password BY 'kodi123#'; and press return
Type in: GRANT ALL ON *.* TO 'kodi'; and press return
Type in: flush privileges; and press return
Close out the command line tool with \q
Advertising
Locked

Return to “Keyboard (PC, Mac,...)”