Advocate Wrote:For the moment I'm giving up on the whole path substitution/remote thumbnails thing. Having to do one thing for the ATV2 and something completely different for the other machines on the network is frankly a bit ridiculous.

We need to get to the stage where all artwork is stored in the MySQL database, including banners, posters, cleararts, logos etc. This would also make skinning that much easier as all the different kinds of artwork would just need to be called by their correct name (eg listitem.banner listitem.poster etc)

For now I'll scrape on the Mac Pro and periodically copy the thumbnails directory from there to the other machines.

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

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  ;

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

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.

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

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.