Simple as that, got two raspberry pi media centres sharing an SQL database hosted on my NAS now :) I also have my Sickrage and Sab services running on my NAS now, so I'm nearly in a position to be able to sell my Mac Mini, I just don't need a full-on computer in the lounge any more :) Great video man, very clear instructions, thanks a lot!
This is true.. if I have some free time I will make some updated videos. The process is much easier now and I've started using Docker for everytng now and I'd love too help others do the same thing..
I tried doing this and in principle it worked. That is to say, the database was created on the NAS and populated nicely. But the other client didn't read from it. It started its own database on the NAS. So effectively, I ended up with two Music and two Video databases... Even if I added a name tag in the advancedsettings.xml-file, that name would then be suffixed with the default MyVideos###/MyMusic###. I suppose this is because there is an inevitable version difference between my two clients. One is an RPi1 with OSMC and runs Kodi v18 RC2; the other is an Apple TV gen 4 on which I sideloaded the most recent Kodi build available for it, which is based on version 17.6. The official Kodi wiki clearly states that, for this to work properly, _all_ clients should run the same version of Kodi. The exact flavour (XBMC/OpenElec/OSMC) doesn't matter as much, as long as the version of Kodi upon which it is based is identical. So I suppose that is part of what is going on here. Anyhow, setting up a centralised database kind of defeats its purpose when this phenomenon keeps unfolding itself. OSMC seems not to want to parse the NAME tag properly, meaning that it still uses the default naming scheme in some way. The 'official' Kodi client on Apple TV (I say official because it's just Kodi with nothing else around it) does parse it. Which is a good thing, because in the default scheme, the number would be different from that of the OSMC client. As I've said, there is presently no way to go beyond version 17.6 on the Apple TV. So I left the centralised database for what it was and reverted to the default local database for the time being. I might get lucky sometime and be able to run the same version of Kodi on both clients...
Great video, the only issue I had is that my database was not on port 3306 but on 3307. I found this by going to the variables tab in myPHPAdmin and scrolling down to 'port'
I don't have an option of "Web Services" & PhPmyadmin comes up with "The following packages are missing in the package server. Please contact the Synology support team for help. PHP7.4" and I already have MariaDB 10 installed and running. I do have an option of installing MariaDB 5 ... any suggestions as I'm running a clone of Synology??
Does it take longer time to start Kodi(/xbmc) the first time if you have a larger library than a couple of "movies" that you have? Because it takes a loong time to start Kodi. I haven't even been able to start it yet. Any suggestions?
Hello Mark. if i have a windows-kodi and two raspberry with openelec. i have copied the same advancedsettings.xml in the 3 right folders and it seems work fine. so now if i see a film and i tag it as yet seen, in the other two kodi i have to see it as yet seen right?
I got everything running on the win 8 and Synology, I copied the two files over to the Mac and the database shows up. When I try to play a video on the Mac from the database, I get a message "This File is no longer available, would you like to delete it?" message. The file will play just fine on the Win 8, I have tried smb, and nfs with the same issues
Hi Mark, Excellent guide! I have used this setup since about 4 months or so. I recently have had extremely slow response times in XBMC (13.2 Frodo). But it is the same version I installed MariaDB and PHPMyAdmin with. Have you experienced anything like this? And do you have any suggestions on what I could do to fix this? Thank’s
Thank you for this video. I followed it step by step, but the "set content" isn't staying. As soon as I set the content and tell it to refresh, Kodi does a 2 second scan and then stops. When I go back into "set content" it shows nothing. Did I miss something?
+kme06d I also have that same problem. When I set the content, Kodi ask If I want to scan the location. Choose yes, but nothing happening... How did you solve it? I enabled debugging in kodi to see what error I get when I scan the content. The error I get: "ERROR: CecLogMessage - Write: write failed !" I openen phpmyadmin and granted the kodi user all permissions db's.... nothing helps. How did you solve it?
if there's no sources.xml then you won't have a "films" and "TV" option in Modi and therefore cannot simply set content as you suggest. How about and explanation of what to put in the sources.xml file?
You don't need it. Just install phpMyAdmin and it will load all the dependencies it needs, including MariaDB and Web Services. You no longer need to enable web services in 6.0, it's on by defualt.
Hi I followed your instructions but after putting the advanced settings file in user folder and starting kodi and after setting content kodi does not start searching and getting information about the movie. In kodi log file I see that the iPhone addresses of laptop doesn't get access to my synology (I guess). What am I doing wrong? Please help
Great tutorial. I'm having a problem though. Everything is working and the mysql database was created with artwork etc. but when I stop a movie on one of my raspberry pis (running openelec) i cannot startup where I left off on my other raspberry pi (running open elec). They are both running the same version and i copied the advancedsettings and sources file from one of the rasberry pis (after i scanned for my content) to my other raspberry pi. Do you know why its not letting me use the continuity feature?
+pappabjoern It was working the whole time. In order to continue to watch something in one room where you left off in another room, you must stop the movie (not pause) in the room you are currently watching and then back out and go back into the library in the room that you want to continue from. Thanks for the tutorial
Great video, thanks! So this is working if I edited Meta Data on the NAS using the Video Station app? That would be so great. But I have a little "problem". Since I am running my Kodi on the FireTV I don't think I have access to the advancedsettings.xml file, to I? Does anyone know how to do it for the FireTV?
Thanks for a great video. I have a problem thou. It seems like my Arctic htpc with Openelec and XBMC 12.2 and my Raspberry Pi2 with Openelec and Kodi 15.2 makes two different databases. If i look inside myPHPadmin i find one KODI_Video75 and one KODI_Video93. I've set the to KODI_Video in the file. How come this is happening? Did i miss something? It it because i run different versions of XBMC/Kodi? Reckon that shouldn't matter.
probably spoke too soon. Read somewhere now that both units must run the same version of kodi. Gonna give it a shot and update my Arctic MC001 tonight and hopefully that solves the issue with two databases.
its says Synology. so anyone that knows synology will know it uses MAriaDB as a resplacemnt to MySQL adn is exacly the same. Synology doesnt even have an option to use native MYSQL.
Simple as that, got two raspberry pi media centres sharing an SQL database hosted on my NAS now :) I also have my Sickrage and Sab services running on my NAS now, so I'm nearly in a position to be able to sell my Mac Mini, I just don't need a full-on computer in the lounge any more :)
Great video man, very clear instructions, thanks a lot!
Note: MariaDB 10 uses port 3307 not 3306. Took me a while to figure this out. Hopefully it will help someone else.
This is true.. if I have some free time I will make some updated videos. The process is much easier now and I've started using Docker for everytng now and I'd love too help others do the same thing..
This solved my problems! Thanks Jesse Kramasz, and QuixVenture!
@@QuixVenture that would be nice :)
thank you 감사^^
Can anyone point me to an updated video that shows how to do this with newer synology's using docker?
I tried doing this and in principle it worked. That is to say, the database was created on the NAS and populated nicely. But the other client didn't read from it. It started its own database on the NAS. So effectively, I ended up with two Music and two Video databases... Even if I added a name tag in the advancedsettings.xml-file, that name would then be suffixed with the default MyVideos###/MyMusic###. I suppose this is because there is an inevitable version difference between my two clients. One is an RPi1 with OSMC and runs Kodi v18 RC2; the other is an Apple TV gen 4 on which I sideloaded the most recent Kodi build available for it, which is based on version 17.6. The official Kodi wiki clearly states that, for this to work properly, _all_ clients should run the same version of Kodi. The exact flavour (XBMC/OpenElec/OSMC) doesn't matter as much, as long as the version of Kodi upon which it is based is identical. So I suppose that is part of what is going on here. Anyhow, setting up a centralised database kind of defeats its purpose when this phenomenon keeps unfolding itself. OSMC seems not to want to parse the NAME tag properly, meaning that it still uses the default naming scheme in some way. The 'official' Kodi client on Apple TV (I say official because it's just Kodi with nothing else around it) does parse it. Which is a good thing, because in the default scheme, the number would be different from that of the OSMC client.
As I've said, there is presently no way to go beyond version 17.6 on the Apple TV. So I left the centralised database for what it was and reverted to the default local database for the time being. I might get lucky sometime and be able to run the same version of Kodi on both clients...
Great video, the only issue I had is that my database was not on port 3306 but on 3307. I found this by going to the variables tab in myPHPAdmin and scrolling down to 'port'
Thanks Mark very nice as always. :)
I don't have an option of "Web Services" & PhPmyadmin comes up with "The following packages are missing in the package server. Please contact the Synology support team for help. PHP7.4" and I already have MariaDB 10 installed and running. I do have an option of installing MariaDB 5 ... any suggestions as I'm running a clone of Synology??
Do I need to set content on all of my Kodi boxes?
Does it take longer time to start Kodi(/xbmc) the first time if you have a larger library than a couple of "movies" that you have? Because it takes a loong time to start Kodi. I haven't even been able to start it yet.
Any suggestions?
Hello Mark. if i have a windows-kodi and two raspberry with openelec. i have copied the same advancedsettings.xml in the 3 right folders and it seems work fine. so now if i see a film and i tag it as yet seen, in the other two kodi i have to see it as yet seen right?
I got everything running on the win 8 and Synology, I copied the two files over to the Mac and the database shows up. When I try to play a video on the Mac from the database, I get a message "This File is no longer available, would you like to delete it?" message. The file will play just fine on the Win 8, I have tried smb, and nfs with the same issues
Hi Mark,
Excellent guide! I have used this setup since about 4 months or so. I recently have had extremely slow response times in XBMC (13.2 Frodo). But it is the same version I installed MariaDB and PHPMyAdmin with. Have you experienced anything like this? And do you have any suggestions on what I could do to fix this?
Thank’s
Awesome guide, i follow this step by step but when i scan movie.
It will find all info but not thumbnails.
Thank you for this video. I followed it step by step, but the "set content" isn't staying. As soon as I set the content and tell it to refresh, Kodi does a 2 second scan and then stops. When I go back into "set content" it shows nothing. Did I miss something?
+kme06d I have the same problem did you solve it?
+kme06d I also have that same problem. When I set the content, Kodi ask If I want to scan the location. Choose yes, but nothing happening... How did you solve it?
I enabled debugging in kodi to see what error I get when I scan the content. The error I get:
"ERROR: CecLogMessage - Write: write failed !"
I openen phpmyadmin and granted the kodi user all permissions db's.... nothing helps. How did you solve it?
Roel Janssen I don't recall how I fixed it, I'm sorry!
if there's no sources.xml then you won't have a "films" and "TV" option in Modi and therefore cannot simply set content as you suggest. How about and explanation of what to put in the sources.xml file?
any chance you could update this video?
Yeah.. I've been planning to forever but have been distracted with real life door as while :)
thank you, very helpfull
How can I get the Web Services option in control panel on DSM 6.0 + ?
You don't need it. Just install phpMyAdmin and it will load all the dependencies it needs, including MariaDB and Web Services. You no longer need to enable web services in 6.0, it's on by defualt.
Thank you.
Hi I followed your instructions but after putting the advanced settings file in user folder and starting kodi and after setting content kodi does not start searching and getting information about the movie. In kodi log file I see that the iPhone addresses of laptop doesn't get access to my synology (I guess). What am I doing wrong? Please help
+Göksel Arslan i have the same problem, any way to solve it?
+fbrea hi I solved it by following the instructions again and making the xml file in notepad in Windows. I hope this helps you.
Great tutorial. I'm having a problem though. Everything is working and the mysql database was created with artwork etc. but when I stop a movie on one of my raspberry pis (running openelec) i cannot startup where I left off on my other raspberry pi (running open elec). They are both running the same version and i copied the advancedsettings and sources file from one of the rasberry pis (after i scanned for my content) to my other raspberry pi. Do you know why its not letting me use the continuity feature?
+Tim Sax Hi,
If you haven't solved it, have you this in the advancedsettings "true"?
+pappabjoern It was working the whole time. In order to continue to watch something in one room where you left off in another room, you must stop the movie (not pause) in the room you are currently watching and then back out and go back into the library in the room that you want to continue from. Thanks for the tutorial
How about the path substitution for thumbnails?
not used anymore
Great video, thanks! So this is working if I edited Meta Data on the NAS using the Video Station app? That would be so great.
But I have a little "problem". Since I am running my Kodi on the FireTV I don't think I have access to the advancedsettings.xml file, to I? Does anyone know how to do it for the FireTV?
Ok, ofc I could just use the adbfireTV tool to push the file... I forgot about that ^^
Thanks for a great video. I have a problem thou. It seems like my Arctic htpc with Openelec and XBMC 12.2 and my Raspberry Pi2 with Openelec and Kodi 15.2 makes two different databases. If i look inside myPHPadmin i find one KODI_Video75 and one KODI_Video93. I've set the to KODI_Video in the file.
How come this is happening? Did i miss something? It it because i run different versions of XBMC/Kodi? Reckon that shouldn't matter.
probably spoke too soon. Read somewhere now that both units must run the same version of kodi. Gonna give it a shot and update my Arctic MC001 tonight and hopefully that solves the issue with two databases.
Correction:I mean ip address of course (damned auto correction)
Your title is a lie. You did not show how to install MySQL. I already had MariaDB and wanted to see how to install MySQL.
its says Synology. so anyone that knows synology will know it uses MAriaDB as a resplacemnt to MySQL adn is exacly the same. Synology doesnt even have an option to use native MYSQL.