Home Forum User Contribution Guides, Tips and Tricks [GUIDE] How-to build your own external XBMC library and use it for multiple boxes
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account

TOPIC: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 2 months ago #121

  • klojum
  • klojum's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 65
  • Thank you received: 3
  • Karma: 0
The 0.153 seconds of retrieval of data is of course just text data. Retrieving the jpg thumbs will take some more time since the total amount of data is much more of course, compared to the database contents. The rest of the processing time is down to XBMC/OE and the HTPC machine(s) involved.

I myself have no intrest in actor thumbs, so I don't use or download them in any way. Not using them will also not slow things further down.
Intel Core i3 3225 (4GB) - OpenELEC Eden 64bit
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 1 month ago #122

  • Tight_wad
  • Tight_wad's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 14
  • Karma: 0
According to this Thread by JMarshall over at XBMC, there will be some sort of fix for this slow behavior. Guess I can stop looking for issue with my setup, and wait for Final Eden and this fix to then be added.
3 Zotac zbox HD-id11 w/ 30g SSD
Last Edit: 1 year 1 month ago by Tight_wad.
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 1 month ago #123

  • klojum
  • klojum's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 65
  • Thank you received: 3
  • Karma: 0
If I read JMarshall's reply correctly, then the fix will be impletented AFTER the Eden release... For the next version after Eden?
This is fixed (for videos at least) in my video_thumbs_to_cache branch that will be merged in after Eden.
Intel Core i3 3225 (4GB) - OpenELEC Eden 64bit
Last Edit: 1 year 1 month ago by klojum.
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 1 month ago #124

  • Tight_wad
  • Tight_wad's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 14
  • Karma: 0
Sorting through different post by jmarshall, it could be as soon as within a month or two after Eden makes final. And Eden has apparently gone final for Linux users as of last night. Not announced yet, but a link is on the thread about Eden rc 2 here
3 Zotac zbox HD-id11 w/ 30g SSD
Last Edit: 1 year 1 month ago by Tight_wad.
The administrator has disabled public write access.

[GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 3 weeks ago #125

  • MaxCore
  • MaxCore's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
DavidA wrote:
I have 1.0.2 of OpenELEC on a couple of Zbox PCs. Broadly working fine.

I've used a MySQL database to keep the libraries in sync, and symbolic links to a Synology NAS drive to keep the thumbnails in one place.

I have an issue that when the box wakes from sleep mode, it takes a while for it to find the library. Maybe 30 seconds. Perhaps it's struggling to get access to the NAS as it wakes. Regardless, the result is that it shows an empty library.

Can anyone think of any way of having the library show up more quickly? I could leave the box always on, but that would be a waste of power.

Thanks in advance.


I have the same problem , anyone have find the solution ?


---
I am here: tapatalk.com/map.php?fkeyrm
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 3 weeks ago #126

apologies for the basic question but i have just setup a mysql database on my server and imported my library to one of my xbmc machines,

my question is what should i do with my other xbmc machines to ensure they connect? do i just change the advancedsettings.xml to point to the mysql database or import the library as well?
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 3 weeks ago #127

  • klojum
  • klojum's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 65
  • Thank you received: 3
  • Karma: 0
All HTPCs that are on your network should connect in the same way, via the settings in the advancedsettings.xml file. There are exceptions (such as read-only situations with a children's htpc), but basically every OE machine connects as user 'xbmc' to the database. No need to re-import the library, because everything is already in the database. That's the big idea, one database for all. B)

See also our Wiki page for setting up a MySQL database with XBMC/OpenELEC.
Intel Core i3 3225 (4GB) - OpenELEC Eden 64bit
Last Edit: 1 year 3 weeks ago by klojum.
The administrator has disabled public write access.
The following user(s) said Thank You: pheonixsingh

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 3 weeks ago #128

thanks for the info,

ive managed to sucessfully create a mysql database with one of my machines however i cannot get another xbmc client to connect, ive put the advancedsettings.xml in the right place, xbmc boots up but theres nothing in the library, not sure whats wrong
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 2 weeks ago #129

  • klojum
  • klojum's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 65
  • Thank you received: 3
  • Karma: 0
"One of my machines" as in a standalone Windows/Linux PC, with also an instance of XBMC running, which is working (locally)? The default installed MySQL behavior is that no access from outside is allowed. It's a safety feature.

So perhaps you need to make sure that the table 'user' of the database 'mysql' is giving access to any user/domain, not just locally, by using % as a hostname, and not the default 'localhost' or '127.0.0.1'.
Intel Core i3 3225 (4GB) - OpenELEC Eden 64bit
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 2 weeks ago #130

klojum wrote:
"One of my machines" as in a standalone Windows/Linux PC, with also an instance of XBMC running, which is working (locally)? The default installed MySQL behavior is that no access from outside is allowed. It's a safety feature.

So perhaps you need to make sure that the table 'user' of the database 'mysql' is giving access to any user/domain, not just locally, by using % as a hostname, and not the default 'localhost' or '127.0.0.1'.

I have checked the hostname on the database and it is indeed a %.

a copy of my advanced settings,xml is below
<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>192.168.1.10</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </videodatabase> 

    <musicdatabase>
        <type>mysql</type>
        <host>192.168.1.10</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>  
    </musicdatabase>
</advancedsettings>
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 1 year 2 weeks ago #131

  • klojum
  • klojum's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 65
  • Thank you received: 3
  • Karma: 0
Is a firewall preventing access from 'strange' ports, such as port 3306 (mysql) ?
Intel Core i3 3225 (4GB) - OpenELEC Eden 64bit
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 11 months 3 weeks ago #132

I managed to move the db from my Ultra2 to my Synology NAS. I Also moved the thumbnails to a shared folder on the NAS. When I boot the xtreamer and the main menu opens I don't see the backgrounds and thumbs. Once I move to another menu and go back all the images are there. I use Aeon MQ3 on a Xtreamer Ultra2 PVR build 1.95.4.

Any ideas on how to get every image showning at startup?
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 11 months 3 weeks ago #133

  • klojum
  • klojum's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 65
  • Thank you received: 3
  • Karma: 0
I still use a link to an OpenELEC folder, placed in a AUTOSTART.SH file (in the .config folder):
mkdir -p "/storage/thumbnails"
mount -t nfs 192.168.1.148:/volume1/xbmc/thumbnails /storage/thumbnails -o timeo=600,nolock

... along with a path reference in advancedsettings.xml:
<pathsubstitution>
  <substitute>
    <from>special://masterprofile/Thumbnails/</from>
      <to>nfs://192.168.1.148/volume1/xbmc/thumbnails/</to>
  </substitute>
</pathsubstitution>
Intel Core i3 3225 (4GB) - OpenELEC Eden 64bit
Last Edit: 11 months 3 weeks ago by klojum.
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 10 months 2 weeks ago #134

  • CrashnBrn
  • CrashnBrn's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 38
  • Thank you received: 1
  • Karma: 0
Can I still use this guide if I'm running Frodo on all of my boxes? I read that Frodo uses a different database so I wasn't sure.

Thanks.
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 10 months 2 weeks ago #135

  • lrusak
  • lrusak's Avatar
  • OFFLINE
  • Administrator
  • Posts: 2007
  • Thank you received: 260
  • Karma: 262
I'm sure it would be fine for the most part, but I would follow the guide in the wiki

wiki.openelec.tv/index.php?title=Configure_MySQL_database

also, the change in db only means that you cannot use older databases with the new system. You'll have to export your library, setup the new system, then import it for the new db to work properly
<-- Hit me with some karma if I've helped you out :)
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 10 months 2 weeks ago #136

  • CrashnBrn
  • CrashnBrn's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 38
  • Thank you received: 1
  • Karma: 0
lrusak wrote:
I'm sure it would be fine for the most part, but I would follow the guide in the wiki

wiki.openelec.tv/index.php?title=Configure_MySQL_database

also, the change in db only means that you cannot use older databases with the new system. You'll have to export your library, setup the new system, then import it for the new db to work properly

Thanks for the super quick reply!
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 10 months 2 weeks ago #137

  • klojum
  • klojum's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 65
  • Thank you received: 3
  • Karma: 0
lrusak wrote:
also, the change in db only means that you cannot use older databases with the new system. You'll have to export your library, setup the new system, then import it for the new db to work properly
Basically, one or more new database are created by OE/XBMC and the contents from the older database(s) is imported, keeping the old database intact.

I'm still using OE beta4 here, because there have been recent database layout changes in the newer XBMC releases (video63 or 64 now), but I wanna keep things steady here for now.

Also, Frodo is still very 'beta', so if you want to keep things running with the latest database, make sure you upgrade all your htpc machines to the same version.
Intel Core i3 3225 (4GB) - OpenELEC Eden 64bit
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 9 months 3 days ago #138

  • shm
  • shm's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 90
  • Thank you received: 1
  • Karma: 0
Great initiative, but you need to update this how to, alot of things are missing/changed since a year ago. For example there is no advancedsettings.xml anymore, you have to create it yourself. Please update it!
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 9 months 2 days ago #139

  • klojum
  • klojum's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 65
  • Thank you received: 3
  • Karma: 0
shm wrote:
Great initiative, but you need to update this how to, alot of things are missing/changed since a year ago. For example there is no advancedsettings.xml anymore, you have to create it yourself. Please update it!
Which "Howto" is that, exactly? By the way, every info/howto is now put into OpenELEC's Wikipages.
AFAIK, advancedsettings.xml is still very much in use, in XBMC Eden anyway. Perhaps you are confused with the much older netmount.conf settings file.
Intel Core i3 3225 (4GB) - OpenELEC Eden 64bit
The administrator has disabled public write access.

Re: [GUIDE] How-to build your own external XBMC library and use it for multiple boxes 9 months 21 hours ago #140

  • shm
  • shm's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 90
  • Thank you received: 1
  • Karma: 0
klojum wrote:
shm wrote:
Great initiative, but you need to update this how to, alot of things are missing/changed since a year ago. For example there is no advancedsettings.xml anymore, you have to create it yourself. Please update it!
Which "Howto" is that, exactly? By the way, every info/howto is now put into OpenELEC's Wikipages.
AFAIK, advancedsettings.xml is still very much in use, in XBMC Eden anyway. Perhaps you are confused with the much older netmount.conf settings file.

yes sorry, ive run into a problem though:

i browsed to Thumbnail on the elec box and copied the whole dir to my server thumnails dir ive made, rebooted and everything looked like before witch was the intention. Then i added a movie to the db and rebooted but it didnt download the fanart/thumbnails for the new movie and i cant do it manually in the library either, when i try to it wont load any fanart/thumbs to download. Any ides?

my advancedsettings.xml looks like this pastebin.com/NT8hN4R7
Last Edit: 9 months 21 hours ago by shm.
The administrator has disabled public write access.
Moderators: MikeBuzz, ericab, turbomettwurst, lrusak

Our Sponsors & Partners

arctic_logo