(2012-05-13, 12:02)jmarshall Wrote: The actual images aren't stored in the mysql database, however the links are. (See the art table). Thus, all clients know exactly where to get art, so can store a nice, fast local cache.
Yessssss... Interesting...
OK Jonathan,
Thanks very much for the reply. And a quick thanks for all the efforts over the years.
For me, this thread is important, as my boggle was thumbnails. And you (XBMC Team) may have changed this to be easier.
I have read the wiki, I scanned the forums, my google-foo is strong. In short, I believe that I have resolved my challanges, but I still have a question:
QUESTION: In the thread above, you say that thumbs are being kept in the database... But then you say that it's not really thumbs, but it's links...
Can you explain what you mean by that?
Does it actually contain a thumbnail... or does it just link to my thumb "somewhere else".
I ask, as I have taken great steps to get this to work, overcoming several "special" win7 related challanges (as listed below) and one self-inflicted one as well.
I want to be sure that the thumbs will be in the "right" place when I have other local XBMC installs point to it. (I have 4 XBMC boxes... so shared database & thumbs is important... to me.)
Bottom line (literally, down at #52 below) I saw that there were no thumbs being stored where I expected them to be.
(...and what about the actor thumbs that still seem to be local?)
=======================================
For those curious of what I saw in Win7 with MySQL, please read on, and apologies in advance for the length of the post.
- - -
1) Build a 40TB server for home storage (win7 Ult 32-bit).
2) load MySQL 5.5 on home server.
(tip: Reinstall fails unless you remove hidden MySQL subdirectories)
(MySQL related Bug: skip-name-resolve tweak for C:\Program Files\MySQL\MySQL Server 5.5\my.ini fails in win7. Causes MySQL to fail - Command client will not open. Some problem with "localhost" being named rather than IP Address in MySQL setup.)
3) Create firewall TCP and UDP inbound and outbound port 3306 on MySQL machine
4) Load 13-May build for Win32
5) Import Partial AdvancedSettings.xml (to address "watched" status on reimport)
-----------------------------------
<advancedsettings>
<!-- This should force smaller picture size -->
<useddsfanart>true</useddsfanart>
<!-- This ensures that a movie is not marked as watched until 90% of film has been played -->
<video>
<playcountminimumpercent>90</playcountminimumpercent>
</video>
<!-- This increases the number of recently added and also imports watched state -->
<videolibrary>
<recentlyaddeditems>100</recentlyaddeditems>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
<!-- This creates an unlimited buffer for internet based streaming -->
<network>
<cachemembuffersize>0</cachemembuffersize>
</network>
</advancedsettings>
--------------------------------------------
6) Scan films and TV
(Added seven SMB shared directories, 2300+ films, 90 tv series. Skipped music import / export as it is not yet done per this thread. Also note: TV Watched Status did not import, and it also did not take preference for local artwork)
7) Export Films and TV to file.
(Note: Films exported, but TV Series did not export... drag. Nor did it capure watched status of the TV Series)
8) Exit XBMC
9) Unplug the ethernet cable from the XBMC Win7 NIC
10) restart XBMC, run a "clean" to get rid of my existing database content.
11) Exit XBMC, plug ethernet cable back in.
12) Apply additional AdvancedSettings.xml section, defining path substitution, creating MySQL DB's, and defining the location of the MySQL location:
--------------------------------------------
<!-- This defines where the shared thumbnails source is located -->
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails/Video/</from>
<to>smb://ZebraitisServ2/xbmc_thumb_cache/Video/</to>
</substitute>
<substitute>
<from>special://masterprofile/Thumbnails/Music/</from>
<to>smb://ZebraitisServ2/xbmc_thumb_cache/Music/</to>
</substitute>
</pathsubstitution>
<!-- This creates my main databases in MY SQL -->
<videodatabase>
<type>mysql</type>
<host>192.168.015.014</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.015.014</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
--------------------------------------------
13) reboot... just to be sure (don't yet start XBMC)
14) Since my substitution only addresses "Video" and "music", leave the thumbnails subdirectory in AppData/roaming/xbmc/userdata , but delete both the Video and Music subdirectory withing the Thumbnails subdirectory.
15) Create both those subdirectories in ZebraitisServ2/xbmc_thumb_cache/
16) verify I have network access to those two new subdirectories by checking from the XBMC machine (via "paste" of address into Int Exp)
!!! SURPRISE !!! I did not !!!
There is a "persistance of credentials feature / bug" in Win7 that makes access to a network drive wonky.
If you are so challanged, you can find the answer at
http://www.w7forums.com/windows-7-does-n...621p2.html in a post by Redhotorange.
17) Restart XBMC
18) Watch XBMC just hang at the splash screen...
19) Check to see if DB's are created in MySQL... they are not.
20) Kill the splash screen [ctrl-alt-del]
21) Add username and password to <pathsubstitution> line in advancedsettings.xml
22) again remove videos and music from thumbnails
23) restart xbmc
24) Watch XBMC just hang at the splash screen...
25) Check to see if DB's are created in MySQL... they are not.
26) Kill the splash screen [ctrl-alt-del]
27) However, THIS TIME there is information in the shared drive "videos" and "music" directory. (newly created subdirectories)
28) Let it run AGAIN, this time being VERY patient...
29) got past the splash screen... wallpaper displayed.. finally a menu.
This time the subdirectories were created again, but no databases created in MySQL.
--- NOTE: AT THIS POINT, I HAVE RESOLVED THE THUMBNAILS SUBSTITUTION RELOCATION ISSUE, DUE TO WIN7 PERMISSIONS ---
(oddly, I resolved an issue that may no longer matter in the new DB Schema... but a win is a win)
30) look VERY CAREFULLY at advancedsettings.xml
31) could a "zero" ( "0" ) in the IP Address be a problem? Let's find out...
Change 192.168.015.014 to 192.168.15.14
32) restart XBMC
33) XBMC starts almost immediately. Definate improvement!!!
SO: DON"T PUT "0" in the IP Address as a leading character.
34) However, there is no "video" or "Music" DB in mySQL. Maybe I need to add content?
35) "Import video library" information from saved single file..... there is a long pause...
36) system seems locked up. XBMC not responding pop-up box... (and still no created DB)
37) Wild Guess: Maybe the firewall needs to be inbound only on port 3306... Make that change to remove the outbound port rule on the MySQL server host firewall
38) restart XBMC
39) nope... still no databases created.
40) Start up debugging to create an XBMC.log, try to import video library... review teh log file...
41) saw a lot of "access denied for user" messages.
42) changed the password in advancedsettings.xml to reflect the password that I used when I created the mySQL install.
43) restart XBMC
44) this time, import directly from my shared drives... (stopped after 10 films). this seemed to work for the thumbnails, BUT... (review the debug log) ... when I check the debug log, again, the DB's have "access denied for user" messages and the database has defaulted back to SQLlite.
But the blocking seems to be happening at XBMC_MAIN (my xbmc win7 box)
45) Just for grins, since I was able to resolve my thumbs issue using the server name, I replaced the IP Address with a server name, and changed the password back to XBMC.
(of course, "clean" the videos again, reboot, etc.)
46) run xbmc
47) check the log...
OH SNAP !!!!
It just dawned on me that I forgot to include this in the MySQL setup:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
GRANT ALL ON *.* TO 'xbmc';
Add those two commands at the MySQL command line client...
Change the server name back to an IP Address... make sure that it is teh default password (xbmc)
48) Start XBMC... check MySQL... YES !!! the DB's have been created!
49) Import the video library..... and ... nothing. Locked up again.
50) OK... if Import doesn't work, then how about just a scan from the shared drives. Scan in a couple of films... Check the log file...
LOOK LIKE MYSQL COMMANDS ARE HAPP'NIN' !!! WHOO HOO !!!
51) Let's see if the size of teh DB grows as I continue to scan...
SELECT COUNT(*) from myvideos64.movie;
Yes! The database continues to gow.
...and easy-peasy, in just 7 hours! (Not including building the 40TB server)
52) Wait a minute... there are no files in my shared "videos" subdirectory. Nor is there anything in my local "video" subdirectory...
WHAT MAGIC IS THIS?
WHERE ARE THE THUMBNAILS?
I see loads of actor thumbs in the local thumbnails subdirectory.
Should I have substituted the entire thumbnails sub?
Or... is it using "something else"?