Hi all,
First time post.
My current setup is as follows. Main PC acts as a server of sort, with the drive shared via Samba, running Linux Mint KDE. My RPi is setup OpenElec, latest version.
On my PC Sabnzbdplus does the downloading, and Sick Beard manages what gets downloaded and where to move it too. I also have Mediaelch installed, just to help clean up some of my older movies and series.
Now, my question. Is it possible to have my PC setup up in such a way that it creates a library database, and my RPi can read it from there?
The reason why I would like to do that is that having the RPi update the library every time it starts up is super annoying, and essentially renders the RPi useless for a couple of minutes.
I'm aware that you can setup XBMC to access a remote library, but how would I go about creating said library automatically? I know I can install XBMC on my PC, but it only scans the drives when you start it, so not really automatic.
Is there any software out there that can do what I want, or is there some way of configuring XBMC so that it periodically scans.
Oh, I know about PLEX. Had it running for awhile, but I found it dog slow on the RPi.
MySQL (wiki) + XBMC/Kodi + one of the auto library update add-ons.
Thanks Ned. Will try it later today.
I was really hoping to not have to go the MySQL route. Bit scared that I mess up and hose my installation.
OK, I've spent the better part of the morning trying to get this to work.
I've followed everything to the letter, but no joy.
My Pi just shows the normal Videos/Files list, but nothing for Movies or TV Shows.
Am I missing something?
OK, I've now gone in circles with this for a full day. No joy.
As can be seen from the log below, xbmc seems to be having trouble opening or create a database. I've checked and double checked all settings, but still nothing. Anybody else ran into this, and how can I get it fixed.
Quote:08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic46 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic46')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic45 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic45')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic44 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic44')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic43 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic43')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic42 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic42')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic41 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic41')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic40 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic40')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic39 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic39')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic38 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic38')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic37 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic37')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic36 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic36')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic35 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic35')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic34 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic34')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic33 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic33')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic32 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic32')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic31 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic31')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic30 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic30')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic29 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic29')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic28 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic28')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic27 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic27')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic26 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic26')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic25 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic25')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic24 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic24')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic23 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic23')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic22 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic22')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic21 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic21')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic20 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic20')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic19 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic19')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic18 [1044](Access denied for user 'xbmc'@'%' to database 'MyMusic18')
08:29:57 T:139719065204672 ERROR: SQL: Can't create new database: 'MyMusic46' (1044)
08:29:57 T:139719065204672 ERROR: Unable to open database: MyMusic46 (0)
08:29:57 T:139719065204672 ERROR: Unable to create new database
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos78 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos78')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos77 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos77')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos76 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos76')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos75 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos75')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos74 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos74')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos73 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos73')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos72 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos72')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos71 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos71')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos70 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos70')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos69 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos69')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos68 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos68')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos67 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos67')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos66 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos66')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos65 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos65')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos64 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos64')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos63 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos63')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos62 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos62')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos61 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos61')
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos60 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos60')
08:29:57 T:139719065204672 ERROR: SQL: Can't create new database: 'MyVideos78' (1044)
08:29:57 T:139719065204672 ERROR: Unable to open database: MyVideos78 (0)
08:29:57 T:139719065204672 ERROR: Unable to create new database
OK, it's fixed. I simply had to comment out the bind address in the my.cnf file. Now everything seems to work.