Kodi Community Forum
[AppleTV2] MySQL database / library support? - 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: iOS & tvOS (https://forum.kodi.tv/forumdisplay.php?fid=137)
+---- Thread: [AppleTV2] MySQL database / library support? (/showthread.php?tid=91485)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

- freaksworth - 2011-03-06

Odon Wrote:I don't really know if it has been talked about, but i've found a way to use the same Video database for both AppleTV2 official release and Nigthly build (DB Version >42): mysql-proxy. It can be used to fake database response to a query.

Install mysql-proxy (see link above) (for debian, just: apt-get install mysql-proxy)

Create a lua script:
Code:
function read_query( packet )
   print(proxy.connection.client.src.address)
   if string.byte(packet) == proxy.COM_QUERY then
     local query = string.sub(packet, 2)
     if string.match(string.upper(query), '^%s*SELECT IDVERSION FROM VERSION')
     then
       proxy.response.type = proxy.MYSQLD_PACKET_OK
       proxy.response.resultset = {
         fields = {
                    {
                      type = proxy.MYSQL_TYPE_INT,
                      name = "idVersion",
                    },
                  },
         rows = { { 42 } }
       }
       return proxy.PROXY_SEND_RESULT
     else
       return proxy.PROXY_SEND_QUERY
     end
   end
end

and then launch mysql-proxy with this script, in my case:
Code:
/usr/bin/mysql-proxy --max-open-files 1024 --proxy-lua-script=/etc/mysql/XBMCatv42.lua --proxy-address=0.0.0.0:3307 --proxy-backend-addresses=127.0.0.1:3306

where:
- /etc/mysql/XBMCatv42.lua is the path to my script
- 127.0.0.1:3306 is the address of mysql server (here, same host for both mysql and mysql-proxy)
- 0.0.0.0:3307 configure mysql-proxy to wait for connection on port 3307
- --max-open-files 1024 is to avoid a critical error i had when launching mysql-proxy

(on debian, you can edit /etc/default/mysql-proxy to enable launch start and change option with previous ones)

Then in your ATV2 advancedsettings.xml change mysql address and port to mysql-proxy address / port only for video DB (or music DB won't work anymore) (eventually add <port>...</port> if missing).

To avoid potential side effect you can add a default value to the new field since DB version 42 (I think it can avoid problem when updating DB from ATV2)
Code:
ALTER TABLE `xbmc_video`.`settings` CHANGE COLUMN `VerticalShift` `VerticalShift` FLOAT NULL DEFAULT 0.0  ;

... thanks! that's really helpful. Nod

- TheRealDL - 2011-03-06

Your english is far better than mine mate.

MEthinks that your NFS connections are the issue you're having with the ATV.

You MUST create the MySQL DB with your datasources connected via SMB for the ATV to see the video files, otherwise the database populates with whatever path you have connected at the time. I had the same problem with the DB and the files on the same machine. I had to create SMB sources even though the files were local.

Try creating a test DB, create a temp advancedsettings.xml that points to your test db on one linux box, connect to your data via SMB on the test box, Import a few vids for testing, reconfig the ATV to point at the test DB. You should have everything!

Cheers!

mod24 Wrote:Hi all,

I have a very strange Problem regarding a centralized MYSQL-DB and path substitution on ATV2 and IPAD.

I've got two linux boxes running xbmc with a central mysql-db on a synology NAS. The Datasources for Video and Music are mounted as NFS on those boxes. Now I recently bought an ATV2, jailbreaked it and installed latest XBMC (Nightly Build, but also tried the release) on it. I want to use the Database here as well and used the pathsubstitution for getting my Thumbnails to work and to translate the Video-Sources from nfs to smb.
Now everything seems to work well, thumbnails get loaded and if I want to look tv-shows the substitution just works as i want it to work. The only thing I can't get to work for 2 weeks now are my movies. The movies are on the same source as the tv-shows just in a different subfolder. But if I want to watch ANY movie, I get a dialouge asking me, if I want to delete the Movie from the DB, since the file cannot be found. I cannot understand, since the same substitiuntion for the same source works well with the tv-shows.

I already enabled Debug-logging and I can see the smb-calls for the Screenshots (loading .tbn files), but I cannot even see a call for the movie. I just see that the delete-dialouge (yesno.xml, or so) get's loaded.

I am really stuck in this situation and I hope that anyone from you might help me out, since I really have no further idea. It would be easier for me to comprehend if nothing regarding the subsitution would work, but having 50% working and 50% not without any obvious reason is driving me insane.

I appreciate any feedback on this.

Kind Regards
Michael

P.s.: Excuse my bad english, i am obviously no native speaker


- freaksworth - 2011-03-06

Quote:You MUST create the MySQL DB with your datasources connected via SMB for the ATV to see the video files, otherwise the database populates with whatever path you have connected at the time. I had the same problem with the DB and the files on the same machine. I had to create SMB sources even though the files were local.
... I think that's what path substitution is actually made for. To translate local paths in DB to remote ones.

- TheRealDL - 2011-03-06

I thoroughly agree and I am hoping for NFS support on all XBMC clients very soon but I believe the iOS clients currently only support SMB.

freaksworth Wrote:... I think that's what path substitution is actually made for. To translate local paths in DB to remote ones.


- zosky - 2011-03-06

TheRealDL Wrote:I thoroughly agree and I am hoping for NFS support on all XBMC clients very soon but I believe the iOS clients currently only support SMB.

(thanks to the popularity of winBlows) SMB has been made to work on all platforms & can be built into xbmc ... so mySQL+SMB = a platform agnostic solution.

i have 3 xbmc boxes (all linux, all NFS ). i asked the same on IRC & was told NFS needs kernel extensions which can't be done on iOS.

the path substitution works, but there are a bunch of movies & tv shows that dont play in iOS because the path or file contains a windows special character, like (:,') Confused

- freaksworth - 2011-03-06

I (also) prefer to manage my shares on OS level via NFS, so there's no need for a builtin-client. It is more flexible to change a symlink in os, than altering strings from the db when you change your setup or use a remote db.
Of course that doesn't count for appletv... No

- Maetrik - 2011-03-07

zosky Wrote:the path substitution works, but there are a bunch of movies & tv shows that dont play in iOS because the path or file contains a windows special character, like (:,') Confused

well, i guess renaming files/folders to unix friendly names should be the smallest problem Wink

- mod24 - 2011-03-07

Hi,

sorry that I didn't deliver those infos right away when first posting.

Below my advancedsettings.xml:
Code:
<advancedsettings>
  
  <pathsubstitution>
    <substitute>
        <from>/datastore/video/</from>
        <to>smb://xxx:[email protected]/video/</to>
    </substitute>

    <substitute>
    <from>special://masterprofile/Thumbnails</from>
        <to>smb://xxx:[email protected]/data/userdata/xbmc/Thumbnails/</to>
    </substitute>
  </pathsubstitution>

<videodatabase>
        <type>mysql</type>
        <host>192.168.100.28</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xxx</pass>
        <name>xbmc_video</name>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>192.168.100.28</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xxx</pass>
        <name>xbmc_music</name>
    </musicdatabase>
</advancedsettings>

And below my Debug-log (the Problem appears at 8:51:17):
Code:
...
08:51:03 T:805208064 M:115408896   DEBUG: CGUIMediaWindow::GetDirectory ()
08:51:03 T:805208064 M:115408896   DEBUG:   ParentPath = []
08:51:03 T:804675584 M:115392512   DEBUG: thread start, auto delete: 0
08:51:03 T:804675584 M:115392512   DEBUG: Thread 804675584 terminating
08:51:05 T:805208064 M:114356224   DEBUG: CGUIMediaWindow::GetDirectory (videodb://1/)
08:51:05 T:805208064 M:114356224   DEBUG:   ParentPath = []
08:51:06 T:805208064 M:114360320   DEBUG: Saving fileitems [videodb://1/]
08:51:06 T:805208064 M:114364416   DEBUG:   -- items: 8, sort method: 0, ascending: false
08:51:06 T:804675584 M:114364416   DEBUG: thread start, auto delete: 0
08:51:06 T:804675584 M:113999872   DEBUG: Thread 804675584 terminating
08:51:08 T:805208064 M:113999872   DEBUG: CGUIMediaWindow::GetDirectory (videodb://1/2/)
08:51:08 T:805208064 M:114130944   DEBUG:   ParentPath = [videodb://1/]
08:51:08 T:146190336 M:114130944   DEBUG: GetSetsNav query: SELECT sets.idSet,sets.strSet,COUNT(1) AS c,count(files.playCount) FROM sets JOIN setlinkmovie ON sets.idSet=setlinkmovie.idSet JOIN movie ON setlinkmovie.idMovie=movie.idMovie JOIN files ON files.idFile=movie.idFile  GROUP BY sets.idSet HAVING c>1
08:51:08 T:146190336 M:114130944   DEBUG: GetMoviesByWhere query: select * from movieview WHERE movieview.idMovie NOT IN (SELECT idMovie FROM setlinkmovie s1 JOIN(SELECT idSet, COUNT(1) AS c FROM setlinkmovie GROUP BY idSet HAVING c>1) s2 ON s2.idSet=s1.idSet)
08:51:08 T:146190336 M:114130944   DEBUG: Time for actual SQL query = 73
08:51:09 T:805208064 M:114130944   DEBUG: ------ Window Init (DialogBusy.xml) ------
08:51:09 T:146190336 M:113385472   DEBUG: Time to retrieve movies from dataset = 1034
08:51:10 T:805208064 M:113385472   DEBUG: Saving fileitems [videodb://1/2/]
08:51:10 T:805208064 M:113262592   DEBUG:   -- items: 43, sort method: 25, ascending: true
08:51:10 T:804675584 M:113262592   DEBUG: thread start, auto delete: 0
08:51:10 T:804675584 M:113340416   DEBUG: OpenDir - Using authentication url smb://michael:xxx@192%2e168%2e100%2e28/video/Dokumentationen
08:51:10 T:805208064 M:113721344   DEBUG: ------ Window Deinit (DialogBusy.xml) ------
08:51:11 T:804675584 M:113348608   DEBUG: OpenDir - Using authentication url smb://michael:xxx@192%2e168%2e100%2e28/video/Filme
08:51:11 T:804675584 M:113348608   ERROR: GetDirectory - Error getting /datastore/video/Neue Releases/
08:51:12 T:804675584 M:113348608   ERROR: Previous line repeats 2 times.
08:51:12 T:804675584 M:113348608   DEBUG: Thread 804675584 terminating
08:51:17 T:145657856 M:113635328   DEBUG: CFileSMB::Open - opened data/userdata/xbmc/Thumbnails/Video/Fanart/5e56fcc5.tbn, fd=10000
08:51:17 T:805208064 M:113635328    INFO: Loading skin file: DialogYesNo.xml
08:51:17 T:805208064 M:113635328   DEBUG: ------ Window Init (DialogYesNo.xml) ------
08:51:17 T:146190336 M:113184768   DEBUG: CFileSMB::Open - opened data/userdata/xbmc/Thumbnails/Video/5/5e56fcc5.tbn, fd=10001
08:51:17 T:145657856 M:113143808   DEBUG: CFileSMB::Close closing fd 10000
08:51:17 T:146190336 M:113143808   DEBUG: CFileSMB::Close closing fd 10001
08:51:17 T:146190336 M:113094656   DEBUG: DoWork - took 353 ms to load special://masterprofile/Thumbnails/Video/5/5e56fcc5.tbn
08:51:17 T:145657856 M:119984128   DEBUG: DoWork - took 660 ms to load special://masterprofile/Thumbnails/Video/Fanart/5e56fcc5.tbn
08:51:22 T:805208064 M:112410624   DEBUG: ------ Window Deinit (DialogYesNo.xml) ------
08:51:28 T:805208064 M:112742400    INFO: CheckIdle - Closing session to http://feeds.feedburner.com (easy=0x81bd000, multi=0x83e44c0)
08:51:30 T:805208064 M:112861184    INFO: CheckIdle - Closing session to http://xoap.weather.com (easy=0x8124000, multi=0x1df7390)
08:51:47 T:146190336 M:112857088   DEBUG: Thread 146190336 terminating (autodelete)
08:51:47 T:145657856 M:112861184   DEBUG: Thread 145657856 terminating (autodelete)
08:52:00 T:805208064 M:112836608   DEBUG: SECTION:UnloadDll(libcurl.4.dylib)
08:52:00 T:805208064 M:112832512   DEBUG: Unloading: libcurl.4.dylib

Thank you all very much for your help. I really appreciate it!

Kind Regards
Michael

- vajonam - 2011-03-07

mod24 Wrote:Hi,

sorry that I didn't deliver those infos right away when first posting.

Below my advancedsettings.xml:
Code:
<advancedsettings>
  
  <pathsubstitution>
    <substitute>
        <from>/datastore/video/</from>
        <to>smb://xxx:[email protected]/video/</to>
    </substitute>

    <substitute>
    <from>special://masterprofile/Thumbnails</from>
        <to>smb://xxx:[email protected]/data/userdata/xbmc/Thumbnails/</to>
    </substitute>
  </pathsubstitution>

<videodatabase>
        <type>mysql</type>
        <host>192.168.100.28</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xxx</pass>
        <name>xbmc_video</name>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>192.168.100.28</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xxx</pass>
        <name>xbmc_music</name>
    </musicdatabase>
</advancedsettings>

And below my Debug-log (the Problem appears at 8:51:17):
Code:
...
08:51:03 T:805208064 M:115408896   DEBUG: CGUIMediaWindow::GetDirectory ()
08:51:03 T:805208064 M:115408896   DEBUG:   ParentPath = []
08:51:03 T:804675584 M:115392512   DEBUG: thread start, auto delete: 0
08:51:03 T:804675584 M:115392512   DEBUG: Thread 804675584 terminating
08:51:05 T:805208064 M:114356224   DEBUG: CGUIMediaWindow::GetDirectory (videodb://1/)
08:51:05 T:805208064 M:114356224   DEBUG:   ParentPath = []
08:51:06 T:805208064 M:114360320   DEBUG: Saving fileitems [videodb://1/]
08:51:06 T:805208064 M:114364416   DEBUG:   -- items: 8, sort method: 0, ascending: false
08:51:06 T:804675584 M:114364416   DEBUG: thread start, auto delete: 0
08:51:06 T:804675584 M:113999872   DEBUG: Thread 804675584 terminating
08:51:08 T:805208064 M:113999872   DEBUG: CGUIMediaWindow::GetDirectory (videodb://1/2/)
08:51:08 T:805208064 M:114130944   DEBUG:   ParentPath = [videodb://1/]
08:51:08 T:146190336 M:114130944   DEBUG: GetSetsNav query: SELECT sets.idSet,sets.strSet,COUNT(1) AS c,count(files.playCount) FROM sets JOIN setlinkmovie ON sets.idSet=setlinkmovie.idSet JOIN movie ON setlinkmovie.idMovie=movie.idMovie JOIN files ON files.idFile=movie.idFile  GROUP BY sets.idSet HAVING c>1
08:51:08 T:146190336 M:114130944   DEBUG: GetMoviesByWhere query: select * from movieview WHERE movieview.idMovie NOT IN (SELECT idMovie FROM setlinkmovie s1 JOIN(SELECT idSet, COUNT(1) AS c FROM setlinkmovie GROUP BY idSet HAVING c>1) s2 ON s2.idSet=s1.idSet)
08:51:08 T:146190336 M:114130944   DEBUG: Time for actual SQL query = 73
08:51:09 T:805208064 M:114130944   DEBUG: ------ Window Init (DialogBusy.xml) ------
08:51:09 T:146190336 M:113385472   DEBUG: Time to retrieve movies from dataset = 1034
08:51:10 T:805208064 M:113385472   DEBUG: Saving fileitems [videodb://1/2/]
08:51:10 T:805208064 M:113262592   DEBUG:   -- items: 43, sort method: 25, ascending: true
08:51:10 T:804675584 M:113262592   DEBUG: thread start, auto delete: 0
08:51:10 T:804675584 M:113340416   DEBUG: OpenDir - Using authentication url smb://michael:xxx@192%2e168%2e100%2e28/video/Dokumentationen
08:51:10 T:805208064 M:113721344   DEBUG: ------ Window Deinit (DialogBusy.xml) ------
08:51:11 T:804675584 M:113348608   DEBUG: OpenDir - Using authentication url smb://michael:xxx@192%2e168%2e100%2e28/video/Filme
08:51:11 T:804675584 M:113348608   ERROR: GetDirectory - Error getting /datastore/video/Neue Releases/
08:51:12 T:804675584 M:113348608   ERROR: Previous line repeats 2 times.
08:51:12 T:804675584 M:113348608   DEBUG: Thread 804675584 terminating
08:51:17 T:145657856 M:113635328   DEBUG: CFileSMB::Open - opened data/userdata/xbmc/Thumbnails/Video/Fanart/5e56fcc5.tbn, fd=10000
08:51:17 T:805208064 M:113635328    INFO: Loading skin file: DialogYesNo.xml
08:51:17 T:805208064 M:113635328   DEBUG: ------ Window Init (DialogYesNo.xml) ------
08:51:17 T:146190336 M:113184768   DEBUG: CFileSMB::Open - opened data/userdata/xbmc/Thumbnails/Video/5/5e56fcc5.tbn, fd=10001
08:51:17 T:145657856 M:113143808   DEBUG: CFileSMB::Close closing fd 10000
08:51:17 T:146190336 M:113143808   DEBUG: CFileSMB::Close closing fd 10001
08:51:17 T:146190336 M:113094656   DEBUG: DoWork - took 353 ms to load special://masterprofile/Thumbnails/Video/5/5e56fcc5.tbn
08:51:17 T:145657856 M:119984128   DEBUG: DoWork - took 660 ms to load special://masterprofile/Thumbnails/Video/Fanart/5e56fcc5.tbn
08:51:22 T:805208064 M:112410624   DEBUG: ------ Window Deinit (DialogYesNo.xml) ------
08:51:28 T:805208064 M:112742400    INFO: CheckIdle - Closing session to http://feeds.feedburner.com (easy=0x81bd000, multi=0x83e44c0)
08:51:30 T:805208064 M:112861184    INFO: CheckIdle - Closing session to http://xoap.weather.com (easy=0x8124000, multi=0x1df7390)
08:51:47 T:146190336 M:112857088   DEBUG: Thread 146190336 terminating (autodelete)
08:51:47 T:145657856 M:112861184   DEBUG: Thread 145657856 terminating (autodelete)
08:52:00 T:805208064 M:112836608   DEBUG: SECTION:UnloadDll(libcurl.4.dylib)
08:52:00 T:805208064 M:112832512   DEBUG: Unloading: libcurl.4.dylib

Thank you all very much for your help. I really appreciate it!

Kind Regards
Michael

I had the same issues, my problem was that my sources and paths were off by a "slash" so ensure the path you have specified in your sources is exactly the same.

also set your loglevel to 3 and see if that shows any info.

- haffi - 2011-03-07

Hi all

I just tried the substition option in the advancedsettings.xml for ATV2 since I have two of them , and it seams to work fine for thumbnails , both reading them and creating,

However I then went to my Linux Ubuntu box and tried useing the same settings but that box does not want to read these thumbs.

I checked the logs and got this error.

Unsupported protocol(stack) in stack://smb://

for every thumbnails it seams to trie to access.

so its seams that smb protocol is not supported in that version ubuntu newest from apt.

Can any one confirm this ?

- hernandito - 2011-03-07

haffi Wrote:Hi all

I just tried the substition option in the advancedsettings.xml for ATV2 since I have two of them , and it seams to work fine for thumbnails , both reading them and creating,

However I then went to my Linux Ubuntu box and tried useing the same settings but that box does not want to read these thumbs.

I checked the logs and got this error.

Unsupported protocol(stack) in stack://smb://

for every thumbnails it seams to trie to access.

so its seams that smb protocol is not supported in that version ubuntu newest from apt.

Can any one confirm this ?

In Ubuntu, the "substitute thing does not work. For this to work, you need to first auto-mount your smb share at boot time and then create a symlink from the local XBMC Thubnails to your shared Thumbnails... read my post here:

http://lime-technology.com/forum/index.php?topic=11473.0

Look at Step 3 under XBMC Live... same procedure applies for Ubuntu.

- vicbitter - 2011-03-08

mod24 Wrote:Hi,

sorry that I didn't deliver those infos right away when first posting.

Below my advancedsettings.xml:
Code:
<advancedsettings>
  
  <pathsubstitution>
    <substitute>
        <from>/datastore/video/</from>
        <to>smb://xxx:[email protected]/video/</to>
    </substitute>

    <substitute>
    <from>special://masterprofile/Thumbnails</from>
        <to>smb://xxx:[email protected]/data/userdata/xbmc/Thumbnails/</to>
    </substitute>
  </pathsubstitution>

<videodatabase>
        <type>mysql</type>
        <host>192.168.100.28</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xxx</pass>
        <name>xbmc_video</name>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>192.168.100.28</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xxx</pass>
        <name>xbmc_music</name>
    </musicdatabase>
</advancedsettings>

And below my Debug-log (the Problem appears at 8:51:17):
Code:
...
08:51:03 T:805208064 M:115408896   DEBUG: CGUIMediaWindow::GetDirectory ()
08:51:03 T:805208064 M:115408896   DEBUG:   ParentPath = []
08:51:03 T:804675584 M:115392512   DEBUG: thread start, auto delete: 0
08:51:03 T:804675584 M:115392512   DEBUG: Thread 804675584 terminating
08:51:05 T:805208064 M:114356224   DEBUG: CGUIMediaWindow::GetDirectory (videodb://1/)
08:51:05 T:805208064 M:114356224   DEBUG:   ParentPath = []
08:51:06 T:805208064 M:114360320   DEBUG: Saving fileitems [videodb://1/]
08:51:06 T:805208064 M:114364416   DEBUG:   -- items: 8, sort method: 0, ascending: false
08:51:06 T:804675584 M:114364416   DEBUG: thread start, auto delete: 0
08:51:06 T:804675584 M:113999872   DEBUG: Thread 804675584 terminating
08:51:08 T:805208064 M:113999872   DEBUG: CGUIMediaWindow::GetDirectory (videodb://1/2/)
08:51:08 T:805208064 M:114130944   DEBUG:   ParentPath = [videodb://1/]
08:51:08 T:146190336 M:114130944   DEBUG: GetSetsNav query: SELECT sets.idSet,sets.strSet,COUNT(1) AS c,count(files.playCount) FROM sets JOIN setlinkmovie ON sets.idSet=setlinkmovie.idSet JOIN movie ON setlinkmovie.idMovie=movie.idMovie JOIN files ON files.idFile=movie.idFile  GROUP BY sets.idSet HAVING c>1
08:51:08 T:146190336 M:114130944   DEBUG: GetMoviesByWhere query: select * from movieview WHERE movieview.idMovie NOT IN (SELECT idMovie FROM setlinkmovie s1 JOIN(SELECT idSet, COUNT(1) AS c FROM setlinkmovie GROUP BY idSet HAVING c>1) s2 ON s2.idSet=s1.idSet)
08:51:08 T:146190336 M:114130944   DEBUG: Time for actual SQL query = 73
08:51:09 T:805208064 M:114130944   DEBUG: ------ Window Init (DialogBusy.xml) ------
08:51:09 T:146190336 M:113385472   DEBUG: Time to retrieve movies from dataset = 1034
08:51:10 T:805208064 M:113385472   DEBUG: Saving fileitems [videodb://1/2/]
08:51:10 T:805208064 M:113262592   DEBUG:   -- items: 43, sort method: 25, ascending: true
08:51:10 T:804675584 M:113262592   DEBUG: thread start, auto delete: 0
08:51:10 T:804675584 M:113340416   DEBUG: OpenDir - Using authentication url smb://michael:xxx@192%2e168%2e100%2e28/video/Dokumentationen
08:51:10 T:805208064 M:113721344   DEBUG: ------ Window Deinit (DialogBusy.xml) ------
08:51:11 T:804675584 M:113348608   DEBUG: OpenDir - Using authentication url smb://michael:xxx@192%2e168%2e100%2e28/video/Filme
08:51:11 T:804675584 M:113348608   ERROR: GetDirectory - Error getting /datastore/video/Neue Releases/
08:51:12 T:804675584 M:113348608   ERROR: Previous line repeats 2 times.
08:51:12 T:804675584 M:113348608   DEBUG: Thread 804675584 terminating
08:51:17 T:145657856 M:113635328   DEBUG: CFileSMB::Open - opened data/userdata/xbmc/Thumbnails/Video/Fanart/5e56fcc5.tbn, fd=10000
08:51:17 T:805208064 M:113635328    INFO: Loading skin file: DialogYesNo.xml
08:51:17 T:805208064 M:113635328   DEBUG: ------ Window Init (DialogYesNo.xml) ------
08:51:17 T:146190336 M:113184768   DEBUG: CFileSMB::Open - opened data/userdata/xbmc/Thumbnails/Video/5/5e56fcc5.tbn, fd=10001
08:51:17 T:145657856 M:113143808   DEBUG: CFileSMB::Close closing fd 10000
08:51:17 T:146190336 M:113143808   DEBUG: CFileSMB::Close closing fd 10001
08:51:17 T:146190336 M:113094656   DEBUG: DoWork - took 353 ms to load special://masterprofile/Thumbnails/Video/5/5e56fcc5.tbn
08:51:17 T:145657856 M:119984128   DEBUG: DoWork - took 660 ms to load special://masterprofile/Thumbnails/Video/Fanart/5e56fcc5.tbn
08:51:22 T:805208064 M:112410624   DEBUG: ------ Window Deinit (DialogYesNo.xml) ------
08:51:28 T:805208064 M:112742400    INFO: CheckIdle - Closing session to http://feeds.feedburner.com (easy=0x81bd000, multi=0x83e44c0)
08:51:30 T:805208064 M:112861184    INFO: CheckIdle - Closing session to http://xoap.weather.com (easy=0x8124000, multi=0x1df7390)
08:51:47 T:146190336 M:112857088   DEBUG: Thread 146190336 terminating (autodelete)
08:51:47 T:145657856 M:112861184   DEBUG: Thread 145657856 terminating (autodelete)
08:52:00 T:805208064 M:112836608   DEBUG: SECTION:UnloadDll(libcurl.4.dylib)
08:52:00 T:805208064 M:112832512   DEBUG: Unloading: libcurl.4.dylib

Thank you all very much for your help. I really appreciate it!

Kind Regards
Michael

Looking at the log, it appears that XBMC can't find a directory (08:51:11 ERROR: GetDirectory - Error getting /datastore/video/Neue Releases/) so it looks like there is a problem with your path substitution.

Are you able to check where Neue Releases is in your smb share? That way you can double check that the path substitution is correct.

- mod24 - 2011-03-08

Hi,

thanks for your feedback. I just checked via smb client in XBMC (via filelist, not database) and "Neue Releases" is there. I just renamed it to "neue.releases", since I thought there might be a problem with the space and changed the entry in the db accordingly. Now this error (GetDirectory) doesn't appear any longer, but I still can't watch any movies. TV Shows still work great.

Regards
Michael

- lukenukem - 2011-03-10

Just in case anybody is having the same problem and hasn't figured out how to fix it. XBMC was terribly slow after I set it to connect to a remote MySQL database. Navigating through menus that contained information from the database took between 5 to 10 seconds, and I had the same problem when starting or stopping a video.

Adding skip-name-resolve to the MySQL settings in my.ini solved the problem. I wasn't aware that that fix could also work when your configuration actually works but is just slow. But it does. Smile

- rflores2323 - 2011-03-10

man this seems really complicated. I am going to be getting another atv2 tomorrow for my bday (bedroom setup) and wanted to get this working with my revo, atv2 living room, and atv2 bedroom. Is there a full how to on doing this as I see bits an pcs of information. I did see the lifehacker tutorial but its does not mention the problem with thumbnails or the skip-name-resolve to the MySQL settings in my.ini