iPad and MySQL
#1
SOLVED: iPad doesn't seem to be connecting to MySQL

---------------------------------------------------------------------------------


Hey folks,

Well... learning curve time again. I upgraded my win7 based XBMC systems to work with a MySQL centralized DB.

That part works great. One computer (my Win7 NAS) runs MySQL, one Win7 XBMC (main in living room) is where I configure my profiles, all other XBMC boxes just connect as if magic.


So: Time to upgrade the iPad Gen1 to run with MySQL ...


I had previously successfully run XBMC on this iPad. Cydia, and network connectivity is solid.

To ensure that I start clean, I uninstalled XBMC form iPad/Cydia and then used i-Funbox to delete the contents of /private/var/mobile/Library/Preferences/XBMC.

Rebooted and checked again to ensure that what I deleted was gone. (it was)

Reboot, and reloaded XBMC Eden 11 from Cydia.

Connected with i-FunBox and copied over my advancesettings.xml file to /private/var/mobile/Library/Preferences/XBMC/userdata



Now, at this point, I expected that once I started XBMC on my iPad, it would show MOVIE and TV SHOWS icon boxes just like on the Win7 XBMX installs, but nothing turned up.

(I even checked the skin settings to ensure that MOVIES and TV SHOWS was not turned off... they weren't,. as they were gray'ed out.)


... bummer.


SO: What special piece of iPad specific magic did I miss?



Of course, here is my advancedsettings.xml file:

Code:
<advancedsettings>


<!-- This should force smaller picture size -->

    <useddsfanart>true</useddsfanart>


<!-- This defines where the shared thumbnails source is located -->

    <pathsubstitution>

        <substitute>
            <from>special://masterprofile/Thumbnails/Music/</from>
            <to>smb://zebraitis:1@ZebraitisServ2/xbmc_thumb_cache/Music/</to>
        </substitute>

    </pathsubstitution>

  
<!-- This creates my main databases in MY SQL -->

    <videodatabase>
              <type>mysql</type>
               <host>192.168.15.14</host>
               <port>3306</port>
               <user>xbmc</user>
               <pass>xbmc</pass>
               <name>myvideos</name>
    </videodatabase>

    <musicdatabase>
            <type>mysql</type>
            <host>192.168.15.14</host>
            <port>3306</port>
            <user>xbmc</user>
            <pass>xbmc</pass>
               <name>mymusic</name>
        </musicdatabase>


<!-- 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>

<!-- Faster?  -->

       <gui>    
                <algorithmdirtyregions>1</algorithmdirtyregions>
                <nofliptimeout>1000</nofliptimeout>
       </gui>

</advancedsettings>


And... My XBMC.log file: http://pastebin.com/TyLSz2yb



I would appreciate some guidance on this.

Thanks!

Vincent

Reply
#2
Looks like I am gonna be the guy that responds to his own post...


To have MOVIES and TV SHOWS turn up on my iPad, I had to upgrade Eden 11.00 to a recent nightly build. (It appears that this has to do with the version of DB that is now being used.)


I used the SSH TERMINAL in i-FunBox and copied over the nightly, following the instructions available at: http://wiki.xbmc.org/index.php?title=HOW...iPod_touch


PARTIAL SUCCESS: Now, MOVIES and TV SHOWS are present on my screen, and there is content in both.


HOWEVER...

* the name and description shows up in MOVIES and TV SHOWS, but no thumbnails.

* If I select an items, XBMC says "no longer in the library."

* If I change views, there seems to be some flickering where the home and config icon are at... but still no thumbs.


Am asking too much from my iPad? (ie: my unwatched selection is 700+)

Is there an error in my advancedsettings,xml?


Thoughts?
Reply
#3
it has nothing to do with your ipad but with recent changes in the thumbnail handling - search the forum there are already multiple threads about it (its not specific to ios/ipad). Beside that ddsfanart is slower on ios then on other platforms - its contra productive to have it activated.

Same for your dirty region setting - look at the wiki what is best for ios (iirc it was mode 3).
AppleTV4/iPhone/iPod/iPad: HowTo find debug logs and everything else which the devs like so much: click here
HowTo setup NFS for Kodi: NFS (wiki)
HowTo configure avahi (zeroconf): Avahi_Zeroconf (wiki)
READ THE IOS FAQ!: iOS FAQ (wiki)
Reply
#4
(2012-06-08, 21:03)Memphiz Wrote: it has nothing to do with your ipad but with recent changes in the thumbnail handling - search the forum there are already multiple threads about it (its not specific to ios/ipad). Beside that ddsfanart is slower on ios then on other platforms - its contra productive to have it activated.

Same for your dirty region setting - look at the wiki what is best for ios (iirc it was mode 3).


Thanks for the reply.

Based on your suggestions, I changed my advancedsetting.xml to

Code:
<advancedsettings>

<!-- This defines where the shared thumbnails source is located -->

    <pathsubstitution>

        <substitute>
            <from>special://masterprofile/Thumbnails/Music/</from>
            <to>smb://zebraitis:1@ZebraitisServ2/xbmc_thumb_cache/Music/</to>
        </substitute>

    </pathsubstitution>

  
<!-- This accesses my DB's in MySQL -->

    <videodatabase>
              <type>mysql</type>
               <host>192.168.15.14</host>
               <port>3306</port>
               <user>xbmc</user>
               <pass>xbmc</pass>
               <name>myvideos</name>
    </videodatabase>

    <musicdatabase>
            <type>mysql</type>
            <host>192.168.15.14</host>
            <port>3306</port>
            <user>xbmc</user>
            <pass>xbmc</pass>
               <name>mymusic</name>
        </musicdatabase>


<!-- 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>



HOWEVER... that still leaves me with a very pesky "This file is no longer available. Would you like to remove it from the library?" message when I select a movie or TV show to play.



Hey... * FACEPALMSLAP * ... D'oh ...


Since I haven't defined my sources on my iPad (as all I am doing is pointing it at the MySQL DB), then I haven't entered my NAS server username and password !

So: I set up a fake source, just so I could enter the username and password, and have XBMC remember it...

** B A M **

Thumbnails are there, and the movies play !


(This wasn't an issue in my Win7 installs, as I did not do a full uninstall... as a result, the username and password was still reserved by XBMC.)


Mark this thread: SOLVED !!!
Reply

Logout Mark Read Team Forum Stats Members Help
iPad and MySQL0