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) |
- sladinki007 - 2010-07-11 sladinki007 Wrote:mmm. i made the jumo to a svn Update ... Installed mysql 5 and problems solved populating database now - muggsy - 2010-07-13 thanks for the info guys.... Using my Readynas's mysql and multiply DBs. Using this to sync my mac my linux HTPC and my trusty old xbox. Bit of a struggle getting the thumbnails synced up, but rsync is your friend and a data source share setup on my NAS seems to work OK... looking forward to seeing thumbs etc added to the DB... - sladinki007 - 2010-07-13 one more bug the scrape script should escape ' 16:17:51 T:3560 M:1490001920 ERROR: SQL: Undefined MySQL error: Code (1062) Query: insert into actorlinkmovie (idActor, idMovie, strRole) values(10709,972,'Bruce''s Soundman') 16:21:58 T:5856 M:1528987648 ERROR: SQL: Undefined MySQL error: Code (1064) Query: update episode set c00='Examination Day',c01='When a foreign student dies in the middle of an exam, Homicide delves into a world where speaking up can cost someone their life. Greedy universities milking the international cash cow. Opportunistic businessmen exploiting the hopes and dreams of young students. Rumours spreading like wildfire across campus. Competition for a shot at an Undercover training course creates tension within the team, particularly for Simon who wasn\''t nominated. And a feisty Federal Cop flying solo connects with Duncan, much to the intrigue of the rest of the team.',c02='',c03='7.000000',c04='Mia Tolhurst',c05='2008-09-22',c06='<thumb>http://thetvdb.com/banners/episodes/80480/388502.jpg</thumb>',c07='',c08=NULL,c09='',c10='Kevin Carlin',c11='',c12='2',c13='10',c14='',c15='-1',c16='-1',c17='-1'where idEpisode=13462 greetings Slad - jmarshall - 2010-07-14 That should already be fixed in SVN. - bmillham - 2010-07-14 indy5 Wrote:I know this has been discussed to death, but I am still not fully understanding how the poster cache works for movies. I have the same problem. I've started 2 different threads looking for help with this, but never get any response. If I look at the movie info, the thumb is there. When I go back to the movie list, the thumb only shows up after looking at the movie info... - sladinki007 - 2010-07-14 i am in the process of importing 3600+ movies and about 300 different tv seasons... uploading the tv seasons through normal mode movies through library mode central thumbs folder on the computer which is collecting the tv series and mysql also running now on that same computer as the nas box was too slow to handle abuse well can't see what you are describing ... have fanart showing up from all movies and seperate thumbs ... only thing what happens on some tv series is that if there is no thumb that it shows the distorted banner in the thumbs place .... didn't see it do that yet with movies ... but before i started importing everything again i delete my whole thumbs folder as with all messing around it had rown already to 4 gb so to be sure there was no doubles i just deleted and now importing everything all over again... already set my mysql to take a daily backup of the tables - sladinki007 - 2010-07-14 jmarshall Wrote:That should already be fixed in SVN. will upgrade to latest build today and see if it is solved ... for the moment running R31463 was scared to run in trouble when i installed a too new build but seems things are pretty stable in these builds so will jump to newest soon - indy5 - 2010-07-14 sladinki007 Wrote:central thumbs folder on the computer which is collecting the tv series and mysql also running now on that same computer as the nas box was too slow to handle abuse well This is probably the issue that I am seeing. I do not have a centralized thumb folder. After reading through this thread a few times, I am starting to understand that if you do not have a central place to store the thumbnails, then each xbmc installation will cache its own thumbs. What I have been having trouble finding here however is what parameter needs to be set in xbmc to map the thumbs to a different location. I do not want to remap the entire profile, but just the thumbs. Is this possible, and if so, where is it set? Thanks - sladinki007 - 2010-07-14 indy5 Wrote:This is probably the issue that I am seeing. I do not have a centralized thumb folder. After reading through this thread a few times, I am starting to understand that if you do not have a central place to store the thumbnails, then each xbmc installation will cache its own thumbs. HI, it is explained in this thread but for linux for windows symlinks will do the trick see this site for some info Quote:http://www.windows7home.net/how-to-create-symbolic-link-in-windows-7/ works for XP and vista too just copy all thumbs to your fastest computer when that is done ... remove thumbnails folder from the second computer Share your thumbnails folder with write permissions on the fastest computer and add a symlink on the second computer since we are linking a folder here is the command mklink /D "place where the folder has to be" "place where the folder really is" depending on the permissions you set on the shared thumbnails folder can it be written too and read from We are hoping the release crew will add the thumbs to the mysql database in time ... but that could be a problem for some people as your mysql will grow quickly hope this helps Greetz Slad - sladinki007 - 2010-07-14 sladinki007 Wrote:will upgrade to latest build today and see if it is solved ... for the moment running R31463 Newest Build xbmc-r31755-trunk.exe on the website does solve the mysql error Thanks for that Greetz Slad - MrDVD - 2010-07-14 Hallo, anyone have maybe an helping hint for me ? I have 3 XBMC under Linux with an central mysql db and all works great. Now i have installed an new XBMC under W7 and this works also great BUT when i add to the advancedsettings.xml the data for the mysql db its sooooooooooo slow. Its the same when i use my already old mysql db but also when i create a new one for this pc. Any hints ? - harryzimm - 2010-07-14 Hi, I suffer the same problem when using different OS'. When i have a windows mysql DB my linux htpc's are slow as hell but my windows pc is normal. When i have a linux mysql DB my linux htpc's are normal but windows htpc is slow as hell. I couldn't figure out what the problem was so i just stuck with linux. Obviosly there is a problem connecting to a mysql DB that is not on the native operating system. Any info on this is also appreciated. cheers - bmillham - 2010-07-14 MrDVD Wrote:Hallo, anyone have maybe an helping hint for me ? Try adding Code: skip-name-resolve to the my.conf (or my.ini ) on the system that the mysql server is installed, and restart the mysql server. I don't know why it would work OK on your linux systems, but I had the same problem, and the above fix worked for me. - MrDVD - 2010-07-14 bmillham Wrote:Try adding THX this did the trick You tested also the other way ? (add the Windows names to the linux hosts file) - bmillham - 2010-07-14 Glad it worked for you! My mysql server is on a windows system, but I never tried adding the clients to the local hosts. I don't want to have to maintain that it a new clients is added, so for me it was easier to just turn off the reverse DNS lookup. |