HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker

  Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Closed
« Next Oldest | Next Newest»
EdgarWallace Offline
Junior Member
 Posts: 9
Joined: Nov 2010
Reputation: 0
2011-12-20 17:11 Post: #301
Finchy,

I have the following XBMC installations:
  • 2x on a Mac: (XBMC 11.0-PRE GIT:20111213
  • 1x on Windows 7: (XBMC 11.0 PRE-11.0 Git:20111210)
  • 1x on yaVDR 0.4, Ubuntu 11.04: (XBMC 2:11.0-pvr+pipelka-eden~git20111022)
The database resides on an unRAID Server V5b14 (mySQL 5.0.67-i486) as well as all video files (I don't use any music with XBMC).
Only one of the Mac's is doing the scraping. The one thing I was struggling first was the movie path in row c22 but since I'm using smb for all XBMC machines every instance understands where the files are (e.g. smb://TOWER/Kino/Mad Money (2008).mkv).

Here is the description how I centralized my library as well as the thumbnails: LINK
It works very well with both of the Mac's (nfs, symlink etc). On the Windows machine I' using pathsubstitution in the respective advancedsettings file:
Code:
<pathsubstitution>
  <substitute>    
   <from>special://masterprofile/Thumbnails/</from>
   <to>smb://TOWER/Kino/Thumbnails</to>  
  </substitute>
</pathsubstitution>

All machine are using the library according to the above guide (...which is based on other guides you can find on several web pages) - except the yaVDR XBMC. I'm using the same advancesettings but yaVDR doesn't seem to use the database (however there is no local database either).

Right now I do have 3 databases on my server: xbmc_video, xbmc_video58, MyVideos56. Here are the settings - at least the thumbnails sharing is working (the part between the videodatabase is the same on every machine):

Code:
<advancedsettings>
   <videodatabase>
        <type>mysql</type>
        <host>192.168.178.28</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>xbmc_video</name>
    </videodatabase>
    <lcd>
        <scrolldelay>5</scrolldelay>
        <spectrumanalyzer>false</spectrumanalyzer>
        <progressbar1>none</progressbar1>
        <progressbar2>progress</progressbar2>
        <progressbar3>none</progressbar3>
        <progressbar4>menu</progressbar4>
    </lcd>
    <pathsubstitution>
      <substitute>
        <from>special://masterprofile/Thumbnails/</from>
        <to>smb://TOWER/Kino/Thumbnails</to>
      </substitute>
    </pathsubstitution>                  
</advancedsettings>

If yaVDR would also use the database I would be a happy camper. I might just be the older build? Can anyone confirm?

Maybe the rest of the information is helpful in your case?
find
Klyde Offline
Junior Member
 Posts: 16
Joined: Nov 2011
Reputation: 0
2012-01-04 04:18 Post: #302
Thought I would give this another go, uninstalled sql, removed all registry entrys. Reinstalled using Latest MySQL Community Server 5.5.19, and the XBMC 11.0 Eden: Beta, Computer Running Windows 7 Ultimate.

Once its all setup, when I try to scan items into the library it will only allow me to scan 1 episode of the first tv show then stops.

Here is My Debug Log
*You may notice it connects with the root login, was just testing that to make sure it wasn't a permission issue with the xbmc user

I've also tried setting this up (installing mysql pointing the advancedsettings.xml to laptop etc.) temporarily on my laptop instead of on the mediaserver and experience the same issue.
Tried Following this Guide

I notice when I log into mysql and "show databases;" there is an xbmc_video58 which I've also tried changing the name to, but no luck.

*edit: Latest Debug log with hopefully a more helpful error

Any suggestions would be greatly appreciated.
(This post was last modified: 2012-01-04 04:24 by Klyde.)
find
silencery Offline
Junior Member
 Posts: 24
Joined: Jan 2011
Reputation: 0
2012-01-04 06:49 Post: #303
Klyde Wrote:Thought I would give this another go, uninstalled sql, removed all registry entrys. Reinstalled using Latest MySQL Community Server 5.5.19, and the XBMC 11.0 Eden: Beta, Computer Running Windows 7 Ultimate.

Once its all setup, when I try to scan items into the library it will only allow me to scan 1 episode of the first tv show then stops.

Here is My Debug Log
*You may notice it connects with the root login, was just testing that to make sure it wasn't a permission issue with the xbmc user

I've also tried setting this up (installing mysql pointing the advancedsettings.xml to laptop etc.) temporarily on my laptop instead of on the mediaserver and experience the same issue.
Tried Following this Guide

I notice when I log into mysql and "show databases;" there is an xbmc_video58 which I've also tried changing the name to, but no luck.

*edit: Latest Debug log with hopefully a more helpful error

Any suggestions would be greatly appreciated.

Looks like something's not right with your original library setup.

Your setup is having trouble inserting records into the table. MySQL error 1062 usually indicates duplicate values on a column designed to be unique. In this case, my guess would be the 'strpath' column since your log is showing the following repeats and the strpath column is set as unique:

insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\24\\','','');
insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\24\\','','');

The first step would be to see if you can insert anything into the table at all. To do so, just fire up the mysql console (login with the same credentials used in advancedsettings.xml) and run the following:
    Code:
    use database xbmc_video58;
    insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\24\\','','');

    If it doesn't work, that means you may be running into some permission errors on your database (your last debug log says you logged in with xbmc)[ah, nevermind, saw your entry with the root login attempt].

    If that works with no errors, that means your database setup is ok and something isn't right with your library. In that case, I would suggest checking your source settings in the library setup, or checking if the export included duplicates for some reason.

    If it does work, you'll probably also want to run the following to remove the row of fake data you put in for testing:
    Code:
    DELETE FROM path ORDER BY idPath DESC LIMIT 1;
    (This post was last modified: 2012-01-04 06:51 by silencery.)
    find
    jwdv22 Offline
    Member
     Posts: 71
    Joined: Mar 2009
    Reputation: 0
    Location: Phoenixville, PA
    2012-01-04 16:35 Post: #304
    silencery, it looks like the problem is actually before that. It says the tables do not exist. Anyway since Eden the first thing I check is whether the as.xml has the db name listed. if so, delete it. then post your log.
    <advancedsettings>
    <videodatabase>
    <type>mysql</type>
    <host>172.16.1.202</host>
    <port>3306</port>
    <user>root</user>
    <pass>password</pass>
    <name>xbmc_video</name>
    </videodatabase>
    </advancedsettings>
    find
    jwdv22 Offline
    Member
     Posts: 71
    Joined: Mar 2009
    Reputation: 0
    Location: Phoenixville, PA
    2012-01-04 17:23 Post: #305
    I have mySQL db on Win7 but shared between Win7, atv2, and openelec(generic) xbmc installs. I recommed using the UNC path instead of mapped drives if possible. So instead of your sources being your Y:\ drive just change them to be smb shares like \\mediaserver\tvshows\ and \\mediaserver\movies
    I have had friends who have had the sharing act really funny until they switched to this smb method.
    find
    EMETIB Offline
    Junior Member
     Posts: 25
    Joined: Nov 2006
    Reputation: 0
    2012-01-10 00:10 Post: #306
    This sounds AWESOME!!!

    Always wanted a feature like this, didn't even notice it's been worked on for so long.

    But before I try it out, I mainly use XBMC across my original XBOX and also iPad/iPhone, with new downloads on my Windoes 7 desktop and archived files stored on my LG NAS. Will it work across these devices too?

    Thanks!
    find
    {{INX}} Offline
    Member
     Posts: 96
    Joined: Jan 2011
    Reputation: 0
    2012-01-10 15:50 Post: #307
    I have all this setup with no problems, including the shared thumbnails but one problem is with the profile pics. Every machine when synchronised won't show up the login profile pictures unless I setup them up manually on each machine.
    Is there a work around for this?

    I also have the same issue with custom menu's on Aeon MQ3 skin. When I set them up with custom backgrounds and then synchronise the folder to another machine it won't show the backdrops.
    [Image: all-fanart.jpg]
    find
    {{INX}} Offline
    Member
     Posts: 96
    Joined: Jan 2011
    Reputation: 0
    2012-01-10 20:49 Post: #308
    OK now things are going a little strange.
    My server is just a Windows 7 64bit build with a copy of XBMC installed for me to try any changes etc. before playing with the main HTPC.
    I have 3 profiles which all work fine on the server but as soon as I copy the userdata folder to the main HTPC, the main profile works with no problems, my daughters profile works fine, but my sons profile just hangs on the login screen.

    Please see below for log.


    18:33:17 T:2076 NOTICE: -----------------------------------------------------------------------
    18:33:17 T:2076 NOTICE: Starting XBMC, Platform: Windows 7, 64-bit (WoW) Service Pack 1 build 7601. Built on Dec 23 2011 (Git:20111222-22ad8e4, compiler 1600)
    18:33:17 T:2076 NOTICE: AMD A6-3650 APU with Radeon™ HD Graphics
    18:33:17 T:2076 NOTICE: Desktop Resolution: 1920x1080 32Bit at 60Hz
    18:33:17 T:2076 NOTICE: Running with administrator rights
    18:33:17 T:2076 NOTICE: Aero is enabled
    18:33:17 T:2076 NOTICE: special://xbmc/ is mapped to: C:\Program Files (x86)\XBMC
    18:33:17 T:2076 NOTICE: special://xbmcbin/ is mapped to: C:\Program Files (x86)\XBMC
    18:33:17 T:2076 NOTICE: special://masterprofile/ is mapped to: C:\Users\Main\AppData\Roaming\XBMC\userdata
    18:33:17 T:2076 NOTICE: special://home/ is mapped to: C:\Users\Main\AppData\Roaming\XBMC\
    18:33:17 T:2076 NOTICE: special://temp/ is mapped to: C:\Users\Main\AppData\Roaming\XBMC\cache
    18:33:17 T:2076 NOTICE: The executable running is: C:\Program Files (x86)\XBMC\XBMC.exe
    18:33:17 T:2076 NOTICE: Log File is located: C:\Users\Main\AppData\Roaming\XBMC\xbmc.log
    18:33:17 T:2076 NOTICE: ------------------------------------------------

    18:34:02 T:2076 NOTICE: special://profile/ is mapped to: special://masterprofile/profiles/Jake/
    18:34:02 T:2076 NOTICE: loading special://profile/guisettings.xml
    18:34:02 T:2076 NOTICE: Getting hardware information now...
    18:34:02 T:2076 NOTICE: Checking resolution 12
    18:34:02 T:2076 NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
    18:34:02 T:2076 NOTICE: Loaded playercorefactory configuration
    18:34:02 T:2076 NOTICE: Loading player core factory settings from special://profile/playercorefactory.xml.
    18:34:02 T:2076 NOTICE: Loaded playercorefactory configuration
    18:34:02 T:2076 NOTICE: No settings file to load to load (special://xbmc/system/advancedsettings.xml)
    18:34:02 T:2076 NOTICE: Loaded settings file from special://profile/advancedsettings.xml
    18:34:02 T:2076 NOTICE: Contents of special://profile/advancedsettings.xml are...
    <advancedsettings>
    <videodatabase>
    <type>mysql</type>
    <host>192.168.0.104</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    <name>xbmc_video_eden_jake</name>
    </videodatabase>
    <musicdatabase>
    <type>mysql</type>
    <host>192.168.0.104</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    <name>xbmc_music_eden_jake</name>
    </musicdatabase>
    <pathsubstitution>
    <substitute>
    <from>special://masterprofile/Thumbnails/</from>
    <to>smb://Home-Server/Software/Applications/HTPC/XBMC/_Shared/thumbnails</to>
    </substitute>
    </pathsubstitution>
    </advancedsettings>
    18:34:02 T:2076 WARNING: VIDEO database configuration is experimental.
    18:34:02 T:2076 NOTICE: Getting hardware information now...
    18:34:02 T:2076 NOTICE: Checking resolution 12
    18:34:02 T:2076 NOTICE: Default DVD Player: dvdplayer
    18:34:02 T:2076 NOTICE: Default Video Player: dvdplayer
    18:34:02 T:2076 NOTICE: Default Audio Player: paplayer
    18:34:02 T:2076 NOTICE: Disabled debug logging due to GUI setting. Level 0.
    18:34:02 T:2076 NOTICE: Log level changed to 0
    18:34:02 T:2076 NOTICE: Loading media sources from special://masterprofile/profiles/Jake/sources.xml
    18:34:06 T:2076 ERROR: unmatched parentheses in substring(Container(510).ListItem.Property(RunningTime),min
    18:34:06 T:2076 WARNING: Skin has invalid include: selectedcolor
    18:34:06 T:2076 WARNING: Previous line repeats 3 times.
    18:34:06 T:2076 NOTICE: Webserver: Starting...
    18:34:06 T:2076 NOTICE: WebServer: Started the webserver
    18:34:06 T:2076 NOTICE: starting upnp renderer
    18:34:06 T:2076 NOTICE: ES: Starting event server
    18:34:06 T:3076 NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777
    18:34:06 T:3076 NOTICE: UDP: Listening on port 9777
    18:34:06 T:1088 NOTICE: -->Python Interpreter Initialized<--
    18:34:06 T:1428 NOTICE: -->Python Interpreter Initialized<--
    18:34:06 T:2076 NOTICE: CApplication::UpdateLibraries - Starting video library startup scan
    18:34:06 T:1088 NOTICE: StorageServer Module loaded RUN
    18:34:06 T:1088 NOTICE: StorageClient-0.8 Starting server
    18:34:06 T:1088 ERROR: Error Type: <class 'socket.error'>
    18:34:06 T:1088 ERROR: Error Contents: (10048, 'Only one usage of each socket address (protocol/network address/port) is normally permitted')
    18:34:06 T:1088 ERROR: Traceback (most recent call last):
    File "C:\Users\Main\AppData\Roaming\XBMC\addons\script.common.plugin.cache\default.py", line 40, in <module>
    run()
    File "C:\Users\Main\AppData\Roaming\XBMC\addons\script.common.plugin.cache\default.py", line 33, in run
    s.run()
    File "C:\Users\Main\AppData\Roaming\XBMC\addons\script.common.plugin.cache\lib\Storage​Server.py", line 106, in run
    sock.bind(self.socket)
    File "<string>", line 1, in bind
    error: (10048, 'Only one usage of each socket address (protocol/network address/port) is normally permitted')
    18:34:06 T:2076 NOTICE: CApplication::UpdateLibraries - Starting music library startup scan
    18:34:06 T:3084 NOTICE: VideoInfoScanner: Starting scan ..
    18:34:50 T:3084 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:43

    Does anyone have any ideas why this is happening?
    [Image: all-fanart.jpg]
    find
    Klyde Offline
    Junior Member
     Posts: 16
    Joined: Nov 2011
    Reputation: 0
    2012-01-11 00:44 Post: #309
    thanks for the suggestions:

    silencery Wrote:Looks like something's not right with your original library setup.

    Your setup is having trouble inserting records into the table. MySQL error 1062 usually indicates duplicate values on a column designed to be unique. In this case, my guess would be the 'strpath' column since your log is showing the following repeats and the strpath column is set as unique:

    insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\24\\','','');
    insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\24\\','','');

    The first step would be to see if you can insert anything into the table at all. To do so, just fire up the mysql console (login with the same credentials used in advancedsettings.xml) and run the following:
      Code:
      use database xbmc_video58;
      insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\24\\','','');

      If it doesn't work, that means you may be running into some permission errors on your database (your last debug log says you logged in with xbmc)[ah, nevermind, saw your entry with the root login attempt].

      Attempted that code in the command line and get an error back saying:
      ERROR 1054 (42S22): Unknown column `Y:\\24\\` in `field list`


      jwdv22 Wrote:silencery, it looks like the problem is actually before that. It says the tables do not exist. Anyway since Eden the first thing I check is whether the as.xml has the db name listed. if so, delete it. then post your log.
      <advancedsettings>
      <videodatabase>
      <type>mysql</type>
      <host>172.16.1.202</host>
      <port>3306</port>
      <user>root</user>
      <pass>password</pass>
      <name>xbmc_video</name>
      </videodatabase>
      </advancedsettings>
      okay I've removed that still no luck. here's my latest debug log:http://pastebin.com/eCuBTmZh
      find
      hjid Offline
      Junior Member
       Posts: 2
      Joined: Jan 2012
      Reputation: 0
      2012-01-11 21:58 Post: #310
      I have two XBMC Dharma clients on Win 7 computers and a shared MySQL database. In the first client I define sources and import all information to the database (thumbnails/fanart is not shared).

      All movies in the database are automatically visible in the second client but no thumbnails/fanart is presented. Is it possible to make XBMC automatically get the missing thumbnails/fanart in the second client?

      Also, no sources are defined for the second client. Do I need to update the sources manually or should that information be transferred from the database?

      Thanks!
      find
      Thread Closed
      Contact Us | XBMC Home | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication