unable to use mysql db with latest nighlies
#1
I am using APPLE TV2
4.3(2557)
xbmc 10.0-9 with currently the nightly xbmc-20111126-eac52fe-master-atv2.deb
I have also tried the latest one just compiled. i had just recently upgraded to 4.3 using the seasonpass jailbreak. I then followed the steps to install the cydia release of xbmc and then installed the latest nightly. without upgrading to the nightly i am able to load XBMC and I can see it building my database in mysql. however after upgrading to the latest nightly it crashes back to the apple tv screen.
xbmc.log http://pastebin.com/SE00nQ5F
advancedsettings.xml http://pastebin.com/zmm9ZdXx
syslog http://pastebin.ubuntu.com/757111/
if I remove the advnacedsettings.xml after it fails to boot then it comes up just fine and uses the local db.
Reply
#2
The settings in your log are different than the advanced settings you posted.

Your advancedsettings you posted have the video db name as 'xbmc_video' while the log says you have it as 'xbmc_video57'.

So what do you actually have in your advanced settings?

It should be 'xbmc_video'.

Check out the wiki for more.
Reply
#3
This is my advancedsettings.xml. and that is what is on my apple tv in the prefrences directory
<advancedsettings>

<videodatabase>
<type>mysql</type>
<host>192.168.1.150</host>
<port>3306</port>
<user>xbmcadmin</user>
<pass>xbmcadmin</pass>
<name>xbmc_video</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.1.150</host>
<port>3306</port>
<user>xbmcadmin</user>
<pass>xbmcadmin</pass>
<name>xbmc_music</name>
</musicdatabase>
<videoscanner>
<ignoreerrors>true</ignoreerrors> <!-- Set to true to silently ignore errors while scanning videos -->
</videoscanner>
</advancedsettings>
Reply
#4
I would delete the schemas you have in mysql and then try to restart XBMC. If that does not work post the new logs again.
Reply
#5
deleting the databases has resolved my issue. thanks for the assisstance
Reply
#6
jschoen Wrote:I would delete the schemas you have in mysql and then try to restart XBMC. If that does not work post the new logs again.

beside that keep in mind that the db names have changed ... when putting xbmc_video in the as.xml xbmc will create the db with the name xbmc_video57 ... where 57 is the version of the used db structure ... so everything was fine here ...
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
#7
The part I was referring to original was this section from the log:

Code:
08:51:16 T:118562816  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.150</host>
                                                <port>3306</port>
                                                <user>xbmcadmin</user>
                                                <pass>xbmcadmin</pass>
                                                <name>xbmc_video57</name>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.150</host>
                                                <port>3306</port>
                                                <user>xbmcadmin</user>
                                                <pass>xbmcadmin</pass>
                                                <name>xbmc_music</name>
                                              </musicdatabase>
                                              <videoscanner>
                                                <ignoreerrors>true</ignoreerrors>
                                                <!-- Set to true to silently ignore errors while scanning videos -->
                                              </videoscanner>
                                            </advancedsettings>

From that it looks like he had '<name>xbmc_video57</name>' for the video db name at some point in the advancedsettings.xml.
Reply
#8
ahh gotya ... i only looked on the settings on his post which looked fine...
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

Logout Mark Read Team Forum Stats Members Help
unable to use mysql db with latest nighlies0