2012-06-08, 20:11
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:
And... My XBMC.log file: http://pastebin.com/TyLSz2yb
I would appreciate some guidance on this.
Thanks!
Vincent
---------------------------------------------------------------------------------
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