• 1
  • 25
  • 26
  • 27(current)
  • 28
  • 29
MySQL Database: Multiple XBMC HTPC's with 1 Shared Library
(2015-02-20, 23:46)Tight_wad Wrote: How to search, it's easy Click the link, you will have your video

Both old videos with pretty horrible guidance. I'll figure it out on my own. Smartass.
Reply
(2015-02-20, 20:07)nickr Wrote:
(2015-02-20, 15:47)RamboUnchained Wrote: 5 years and not a single person has done a tutorial actually worth watching...I dont get it. There are Kodi/XBMC tuts out there that explain how to do things a monkey could learn to do, but there's no solid tut for this. I'm used to working with hardware and software that TELLS me if I've done something right or wrong. Following text tutorials has lead me nowhere.

And when you ask for help, people assume you're on Linux...Please...Someone take 15min of your time and make a true step by step guide to this for Windows as well. Linux tuts are of no use to me since the commands seem to be completely different. A 15min video stickied on the forums would save a lot of people a lot of time.
Is the process not fully described, for windows, here? http://kodi.wiki/view/MySQL/Setting_up_M...ab=Windows

It's vague for someone that's never done anything mysql related. All command lines since ever offer feedback when you type a command and it is accepted or not. With Mysql, you can type anything and as long as you don't put any weird symbols, there's no surefire way of knowing of what you entered was correct or not.
Reply
Copy & paste is good for eliminating error. How is a video going to help your typing skills?
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Reply
(2015-02-21, 21:26)nickr Wrote: Copy & paste is good for eliminating error. How is a video going to help your typing skills?

It wouldn't, but I ended up figuring out most of it on my on in the end anyway. The difference b/w a ' and a ` are miniscule and as I previously stated, I tried every possible combination before I just copied and pasted. My typing skills had nothing to do with the fact that what I typed and what I copied and pasted "looked" exactly the same in notepad, but only the copied text was accepted by the command line. It's not like I was mistaking a & for a % or something weird like that.
Reply
(2015-02-20, 15:47)RamboUnchained Wrote: I'm used to working with hardware and software that TELLS me if I've done something right or wrong. Following text tutorials has lead me nowhere.

I'll tell you what you did wrong: you ignored all the warnings that this was experimental and above your head, and you then expected someone else to solve your problems for nothing.

It takes a hell of a lot longer than 15 minutes to make an easy to understand video to set this stuff up. It's a lot easier to just complain about other people not doing it for you.
Reply
I gotta be honest, I know nothing about MySQL, databases or anything of the like and I successfully set it up on a Windows based server/HTPC setup. The worst issue I ran into was needing to convert my file entries from locations like d:\media\television series\ to smb://server/blah/blah but that was a fairly straight forward word replace of the XML file on the exported database.
Reply
notepad?

Now we know you're mad LOL!
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Reply
This may be an issue that has already been discussed, but I am at my wits end so I am coming to all you smarter people in hopes that I can get some guidance. So here's the issue....

I have a Synology Diskstation with my entire video/music library. Its running MySQL and houses the main DB for all the Kodi clients. When I setup my first client, it was a mini PC running Windows 7 that populated the first database scraping all the movies/music. I had a share on that computer labeled z:\ that had all the content. Its been tracking all the WATCHED items.

I just got a new Raspberry Pi 2 and have it setup with all the correct data, created the advancedsettings.xml as it should be and the first time I booted into Kodi on the Pi it showed my entire library as it was on the first computer, but obviously using all the paths from the windows machine which the Pi didn't like and it couldn't get to any of the files. So I found the <pathsubstitution> section and figured that would do it, and I thought I had it right, but it didn't do anything. Here's what my file looks like on the Pi:

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.100</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.100</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
<pathsubstitution>
<substitute>
<from>Z:\Music\</from>
<to>SMB://192.168.1.100/Music/</to>
<from>Z:\Movies\</from>
<to>SMB://192.168.1.100/Movies/</to>
<from>Z:\TV Shows\</from>
<to>SMB://192.168.1.100/TV Shows/</to>
</substitute>
</pathsubstitution>
</advancedsettings>

The only way it works is to remove all the sources and readd them browsing through the SMB source I have setup, then all the files show up, but won't show me any of the WATCHED data. If I had known this would be an issue mixing Windows/Linux machines with the Kodi DB I would have done things differently. Any idea what direction I should go with this? I am stumped.
Reply
I run pretty much the same setup as you. Win 7 and Xbmc Linux connecting to MySQL on synology.

This does sound weird. Are you running the same version of kodi on all devices?
I also had to include username and password in the substituted path within the advanced settings.xml on the Linux based devices so that they could access smb shares properly.

I.e. Smb://user:pass@nasIP

Also, it may be that the pi re-scanned the files to the db? Using the smb:// path. So it may have created separate entries for these which wouldn't have a watched status in the db.

I only allow my master htpc to scan. All others just read the db.
Kodi 16.1 on main HTPC Win 7 64-bit, 8 GB RAM, Quad Core 2.4 Ghz
3 x Pi2 running Kodi 16.1 (OSMC)
TVHeadend PVR server providing Freeview HD and Freesat HD
Reply
If you are wanting to do pathsubstitution with the source then the wiki shows that it should be like this.

Code:
<substitute>
    <from>special://profile/sources.xml</from>
    <to>PROTOCOL://YOUR_NETWORK_SHARE/kodi/userdata/sources.xml</to>
  </substitute>
Reply
(2015-02-25, 15:36)rlg6767 Wrote: I run pretty much the same setup as you. Win 7 and Xbmc Linux connecting to MySQL on synology.

This does sound weird. Are you running the same version of kodi on all devices?
I also had to include username and password in the substituted path within the advanced settings.xml on the Linux based devices so that they could access smb shares properly.

I.e. Smb://user:pass@nasIP

Also, it may be that the pi re-scanned the files to the db? Using the smb:// path. So it may have created separate entries for these which wouldn't have a watched status in the db.

I only allow my master htpc to scan. All others just read the db.

Yes that's where I think some of the issue stems. My Win7 PC created the first DB with the Z:\ pathing, and then the pi connected up to the MySQL DB (without scanning the first time) and saw everything but all had the Z:\path which made Kodi think that everything was unreachable. When I removed the sources and rescanned from an smb://192.x source it created brand new database tables obviously without the watched data. So I'm not sure if there is any way to just import the watched data to the DB that the Pi is using (I plan on putting Pi's for all the rest of my devices, no more windows boxes).
Reply
(2015-02-26, 03:04)aitrus00 Wrote: So I'm not sure if there is any way to just import the watched data to the DB that the Pi is using (I plan on putting Pi's for all the rest of my devices, no more windows boxes).

It might just be easier to start from scratch with unc paths and manually whizz through all your movies/tv shows and mark them as watched (unless you have a large library). There will probably be a technical way but it's beyond me.
Kodi 16.1 on main HTPC Win 7 64-bit, 8 GB RAM, Quad Core 2.4 Ghz
3 x Pi2 running Kodi 16.1 (OSMC)
TVHeadend PVR server providing Freeview HD and Freesat HD
Reply
Export your existing library as an xml file.

Use a text editor or sed to change the paths from Z:\whatever to SMB://whateverelse

Import the amended xml file.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Reply
I ran into a similar problem where the 1st Kodi install with the SQL setup worked fine.
I'm using 1 database...with 2 Kodi units.
The 2nd one ran into issues as it identified the database that was scraped by the 1st Kodi machine--but couldn't play the files.
I do get errors that state "couldnt connect to the server".

The 1st machine plays it just fine however.

I've check the xml file and the file was copied to the 2nd Kodi unit.
I've checked the path in the database---which was setup using SMB shares to begin with instead of a local drive(the SMB share points to a QNAP NAS)....and the database entries show the smb share in the path as well.
They are both using the same scrapers.
They both are the same version of OpenElec--5.0.8.

I was wondering if I missed a step?
On the 2nd machine, am i supposed to setup the path to the SMB share again? I didn't do this thinking the xml file should have mentioned the path and hence there wasn't a need to do this again.

Any ideas?
Reply
Debug log (wiki) of playback failure.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Reply
  • 1
  • 25
  • 26
  • 27(current)
  • 28
  • 29

Logout Mark Read Team Forum Stats Members Help
MySQL Database: Multiple XBMC HTPC's with 1 Shared Library1