•   
  • 1
  • 33
  • 34
  • 35
  • 36
  • 37(current)
HOW-TO:Share libraries using MySQL: Wiki Edition
(2019-03-18, 16:01)mataus19 Wrote: You mention SQ Lite... can this be used on a QNAP NAS?
SQLite is the 'normal file' based version of MySQL server.
You can only install MySQL or its sister MariaDB onto your NAS.
SQLite is not designed for NAS devices.
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
(2019-03-18, 16:35)Klojum Wrote: SQLite is the 'normal file' based version of MySQL server.
You can only install MySQL or its sister MariaDB onto your NAS.
SQLite is not designed for NAS devices.

Ok Thanks for the info. do all machines running kodi have to have the same kodi version when using MariaDB too?
Reply
(2019-03-14, 04:53)Milhouse Wrote:
(2019-03-14, 00:11)mataus19 Wrote: Hi,

I have recently chaned my Pi2 OS from LibreElec to OSMC. I also have a NUC running latest version of LibreElec. I have MySQL setup on my NAS. The NUC and Pi2 (when running LibreElec) worked fine with MySQL.

However since changing the Pi2 from LbreElec to OSMC I cannot get the NUC and Pi2 to sync using MySQL. I am using the same 'advancedsettings.xml'

In order to use MySQL do you have to have all machines using the same OS, e.g. LibreElec? Also do all machines have to be running the same version of Kodi? I only ask because the NUC is running latest version LibreElec 9.0 (Kodi Leia V18.1) but the Pi2 is running latest version of OSMC compiled 31/12/18 (Kodi Kyrpton V17.6)

Thanks!
Different Kodi releases use different database versions, Kodi 18.x and Kodi 17.x are not compatible so yes, in simple terms, you need to use the same Kodi version everywhere. 
Is this the same for MariaDB also?

MySQL requires the same Kodi version but does it require the same OS also, e.g are LibreELEC and OSMC compatible?

Thanks!
Reply
(2019-03-21, 00:21)mataus19 Wrote: Is this the same for MariaDB also?
Sorry, I was referring to Kodi's different database schema versions. Not so much the differences between MySQL/MariaDB SERVER versions.
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
For those interested in MySQL 8, I just tried to do a clean install and Kodi couldn't create the database completely with some error of Trigger creation; I have a feeling it has to do with the DELIMITER.
The workaround was to spin up an instance of MySQL 5 and have Kodi create the databases, tables, views, and triggers on that one, and then move the databases (both structure and data) from MySQL 5 to MySQL 8, either using mysqldump or any MySQL client you might have. If you do this, make sure the user account Kodi uses to log into the databases is exactly the same on both; the username and the hostname in the databases must match or else the views being created will not be consumable by Kodi.

For those asking about running MySQL or MariaDB on a NAS: depending on how big your data gets, the extremely limited amount of RAM on the NAS will limit the speed at which Kodi will be able to get data from it. With large databases, Kodi is pretty much already handicapped by having to transfers hundreds of MB over your network and being low on memory forces your MySQL to provide the data even slower. Depending on how perceptive you are of the slowness, having 4GB of RAM on your NAS and letting MySQL use 3 of it might be good enough. Additionally, keep in mind that the database writing to disk will wear out the HDD and that is probably something you want to avoid.

For those asking about different versions of Kodi and the database: each version of Kodi looks for a database with a specific name; it doesn't care what OS they are running on or what flavor or version of MySQL they are on. For example, Kodi v18 looks for a database named <prefix>116 for the video library; the prefix is whatever you defined as name in your advancedsettings.xml file. You can have MySQL 5 running on Windows at your home and MySQL 8 running on a Linux server on your yacht and setup some form of replication between them (if that is even possible); as long as both have a database named <prefix>116, your Kodi v18 setups will show the same data at home and on your yacht.
Reply
On Windows 10, Leia, MySql 5.5. I have seen it mentioned that after 5.7, the password will expire automatically after a year, I wonder if this is the same for 5.5, and if so, I have not really found a good description of how to make it permanent (if needed). (The link from the wiki page throws a 404 error).
Reply
(2019-04-15, 05:15)clones Wrote: On Windows 10, Leia, MySql 5.5. I have seen it mentioned that after 5.7, the password will expire automatically after a year, I wonder if this is the same for 5.5, and if so, I have not really found a good description of how to make it permanent (if needed). (The link from the wiki page throws a 404 error).

I am using mysql-5.5.30-winx64 and its been installed few years, most likely around 3 years i think. No password has expired on this version for me.
Reply
(2019-04-15, 05:15)clones Wrote: On Windows 10, Leia, MySql 5.5. I have seen it mentioned that after 5.7, the password will expire automatically after a year, I wonder if this is the same for 5.5
I've been running MySQL 5.5 on Linux for 4.5 years now, and not ever did I have to change the password. Perhaps on Windows MySQL has some extra admin tools active, but still, it's the 1st time I hear of this for MySQL.

(2019-04-15, 05:15)clones Wrote: The link from the wiki page throws a 404 error)
Which exact wiki page is that?
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
(2019-04-15, 10:46)Klojum Wrote:
(2019-04-15, 05:15)clones Wrote: On Windows 10, Leia, MySql 5.5. I have seen it mentioned that after 5.7, the password will expire automatically after a year, I wonder if this is the same for 5.5
I've been running MySQL 5.5 on Linux for 4.5 years now, and not ever did I have to change the password. Perhaps on Windows MySQL has some extra admin tools active, but still, it's the 1st time I hear of this for MySQL.
(2019-04-15, 05:15)clones Wrote: The link from the wiki page throws a 404 error)
Which exact wiki page is that?   
That's good to hear, and thank you both for your responses 

From the MySQL/Setting_up_MySQL (wiki), 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/...olicy.html  (Throws the 404 error)
Reply
(2019-04-15, 14:05)clones Wrote: That's good to hear, and thank you. 
I've updated the wiki page with a different/similar mysql documentation webpage, that should do it for now.
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
  •   
  • 1
  • 33
  • 34
  • 35
  • 36
  • 37(current)
 
Thread Rating:
  • 2 Vote(s) - 5 Average



Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition52