Kodi Community Forum
2 XBMC PCs and 1 Database on the shared NAS - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Windows (https://forum.kodi.tv/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)



- hermy65 - 2010-05-02

can i use sql server express rather than mysql?


- RockDawg - 2010-05-02

charrua Wrote:I see. Try this:
Code:
mount -t cifs //[url=http://192.168.1.20/disk7/xbmc_thumbs/Thumbnails]192.168.1.20/disk7/xbmc_thumbs/Thumbnails[/url]  Thumbnails -o dir_mode=0777

I tried that and get the exact same thing. I've tried this on two different XBMC boxes and I've tried hosting the Thumbs on both a Linux server and a Windows machine. All act identically. Here is a section of an XBMC log where I tried to "Get Thumb" from inside 'Movie Info' with no luck:

Code:
15:25:11 T:61414256 M:1419407360   DEBUG: thread start, auto delete: 0
15:25:11 T:3078985616 M:1419407360   DEBUG: Alloc resources: 0.13ms (0.01 ms skin load)
15:25:11 T:61414256 M:1419407360   DEBUG: Thread 61414256 terminating
15:25:13 T:3078985616 M:1416462336   DEBUG: LIRC: Update - NEW at 71062135:000000037ff07bdd 00 OK mceusb (OK)
15:25:13 T:3078985616 M:1416462336   DEBUG: OnKey: 11 pressed, action is Select
15:25:13 T:3078985616 M:1416462336   DEBUG: ------ Window Deinit (FileBrowser.xml) ------
15:25:13 T:3078985616 M:1419382784   ERROR: Create - Error creating /home/kevin/.xbmc/userdata/Thumbnails/Video/
15:25:13 T:3078985616 M:1419382784   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/
15:25:13 T:3078985616 M:1419382784 WARNING: CreateDirectory, cant create dir </home/kevin/.xbmc/userdata/Thumbnails/Video/5/>. trying lower case.
15:25:13 T:3078985616 M:1419382784   ERROR: Create - Error creating /home/kevin/.xbmc/userdata/Thumbnails/Video/5/
15:25:13 T:3078985616 M:1419382784   ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/5/
15:25:13 T:3078985616 M:1419382784   DEBUG: CDatabase: Connecting to database xbmc_video at 192.168.1.20:3306
15:25:16 T:71904112 M:1419382784   DEBUG: Thread 71904112 terminating (autodelete)
15:25:23 T:3078985616 M:1419399168    INFO:   msg: PICTURE::LoadImage: Unable to open image: special://masterprofile/Thumbnails/Video/5/50684ec7.tbn Error: (2)
15:25:23 T:3078985616 M:1419399168   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/Video/5/50684ec7.tbn
15:25:23 T:3078985616 M:1419399168    INFO:   msg: PICTURE::LoadImage: Unable to open image: special://masterprofile/Thumbnails/Video/5/50684ec7.tbn Error: (2)
15:25:23 T:3078985616 M:1419399168   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/Video/5/50684ec7.tbn
15:25:27 T:105646960 M:1419399168   DEBUG: Thread 105646960 terminating (autodelete)
15:25:53 T:3078985616 M:1419288576   DEBUG: SECTION:UnloadDelayed(DLL: special://xbmc/system/ImageLib-i486-linux.so)
15:25:53 T:3078985616 M:1419288576   DEBUG: Unloading: ImageLib-i486-linux.so

But after that I can go into that same Thumbnails folder via a FTP client and copy or create a file/folder and it works. It will appear in the Thumbnail folder on my server. It all seems to work with my manual tests. It just seems whatever XBMC does to write the thumb is the only part that's not working.


Wow.... - johnny_swindle - 2010-05-03

All I can say is "Wow...." Shocked

This is a complicated discussion.

I am going to go out on a limb and suggest that someone compile all this into a helpful guide.

Now, I probably will get flamed or lambasted for suggesting this, told to go read the manual, do a Google search, but for all of the novice XBMC users it would be invaluable and aid in our education process.

Now, I must withdraw to put on my fire proof clothing and my Kevlar vest and helmet.

Johnny


- lestat1977uk - 2010-05-03

HERMY I also asked this question, not had a response.


- hermy65 - 2010-05-03

hopefully somebody will be able to answer it soon. I currently have sql server express actively running on my server for some other stuff and i would rather just load xbmc into that rather then having to set up mysql as well.


- charrua - 2010-05-03

hermy65 Wrote:hopefully somebody will be able to answer it soon. I currently have sql server express actively running on my server for some other stuff and i would rather just load xbmc into that rather then having to set up mysql as well.
The wiki can answer:
http://wiki.xbmc.org/index.php?title=Advancedsettings.xml#.3Cmusicdatabase.3E.2F.3Cvideodatabase.3E
Quote:...
type Can be either "sqlite3" or "mysql" (default: sqlite3)
...
I think it is clear enough.
So unless that part of the wiki is out of date, I'd say only MySQL is supported.


- wstewart - 2010-05-03

This is awesome that we now have mysql capability. Would like to try this out and I have a few questions before I do.

I have the mysql database running on a server separate from the xbmc frontends, thus the database will be accessed over the network. I know that I have to set /etc/mysql/my.cnf to permit remote connection, aside from that looking for guidance on what is needed, what xbmc will take care of automatically and what I have to do.

Will XBMC automatically create the videodatabase database and assign the appropriate permissions to allow remote access? It is not clear to me that a xbmc remote connection would be able to create a new database in an empty one and be able to set permissions.

How does the local image caching work with a remote database? If the scraping was done on frontend1 and then frontend2 accessing the database, will it automatically do the local image caching without scrapping? I have nfo, images, etc co-located with my video files.


- RockDawg - 2010-05-03

Code:
special://masterprofile/Thumbnails/Video/

Anybody know what this is? I wonder if it's affecting my problems with shared thumbs?


- RockDawg - 2010-05-03

wstewart Wrote:This is awesome that we now have mysql capability. Would like to try this out and I have a few questions before I do.

I have the mysql database running on a server separate from the xbmc frontends, thus the database will be accessed over the network. I know that I have to set /etc/mysql/my.cnf to permit remote connection, aside from that looking for guidance on what is needed, what xbmc will take care of automatically and what I have to do.

Will XBMC automatically create the videodatabase database and assign the appropriate permissions to allow remote access? It is not clear to me that a xbmc remote connection would be able to create a new database in an empty one and be able to set permissions.

How does the local image caching work with a remote database? If the scraping was done on frontend1 and then frontend2 accessing the database, will it automatically do the local image caching without scrapping? I have nfo, images, etc co-located with my video files.

You have to manually create the db, user, password and assign the privileges. Instructions are here: Link

Local image cahing is still a problem. In you scenario frontend2 would not show any images. Some people seem to be having luck with creating a symbolic link between the Thumbnail folder on each XBMC box and on on a server, but I haven't; been able to get it to work myself.


- charrua - 2010-05-04

RockDawg Wrote:I tried that and get the exact same thing. I've tried this on two different XBMC boxes and I've tried hosting the Thumbs on both a Linux server and a Windows machine. All act identically. Here is a section of an XBMC log where I tried to "Get Thumb" from inside 'Movie Info' with no luck.
But after that I can go into that same Thumbnails folder via a FTP client and copy or create a file/folder and it works. It will appear in the Thumbnail folder on my server. It all seems to work with my manual tests. It just seems whatever XBMC does to write the thumb is the only part that's not working.
If you can write to the mounted path from FTP and not from XBMC, the issue is probably related to the linux permissions over the user you run XBMC with.
Here you can find a more detailed guide on setting up a network shared folder for Thumbnails: http://forum.xbmc.org/showthread.php?tid=63218


- Aslan2120 - 2010-05-04

I have been following this thread with great interest. It is a great setup and since I got it working yesterday it has been great. I have had 2 interesting things to add to the discussion.

The first interesting thing is in regards to the thumbs and fan art. I have 2 apple tvs and one windows 7 machine. All the media files are stored on a NAS and the database is on the windows 7 machine. When I update the library from the windows machine the thumbs and movie information is shoeing up on both apple tvs. I never created the sym link or anything, it just worked! I am not sure why but it did.

I posted the second issue already in another thread but in case anyone has any thoughts here I will repost here. Tonight "The Big Bang Theory" and "24" would not show up in the library. Ember scrapped them and this only happened to the new episodes from today. The old episodes that were existing before the move to mysql were added fine. Also "Castle" and "Chuck" were added fine. Any thoughts?


- Aslan2120 - 2010-05-04

Nevermind on the issue with the episodes. Not sure why but they seem to be added now.


- Cheeshead - 2010-05-05

Should the video database be clear after adding the settings to the advancedsettings.xml? Is there a way to tell inside XBMC or MySql that the database is being used? I don't notice any difference before/after.

Any help would be appreciated....thanks


- RockDawg - 2010-05-05

Did you rename the old database? If not, XBMC may continue to use it. Also, make sure you export your old db first. After setting up the new db, mine was empty and I had to import the old db from the file that was created when I exported the old one.


- Cheeshead - 2010-05-05

no i didn't rename old one....i cleared it out and rescraped all the info...I don't have a lot on my test box so it doesn't take long. i just don't see on the Mysql control panel that a xbmc db was created and the watched flags aren't synced.