Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
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.)
Posts: 31,445
Joined: Jan 2011
(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.
Posts: 1,603
Joined: Jul 2007
Reputation:
51
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.
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
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.)
Posts: 3
Joined: Mar 2013
Reputation:
0
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.
Posts: 160
Joined: May 2013
Reputation:
2
2015-02-25, 15:36
(This post was last modified: 2015-02-25, 15:39 by rlg6767.)
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
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
2015-02-26, 23:41
(This post was last modified: 2015-02-26, 23:41 by nickr.)
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.)
Posts: 1
Joined: Apr 2015
Reputation:
0
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?