Posts: 4,146
Joined: Jan 2008
Reputation:
40
Double check your mysql installation and make sure "skip-networking" (or whatever its called) is disabled. Are you able to connect to the db from any other host?
Always read the
online manual (wiki),
FAQ (wiki) and search the forum before posting.
Do not PM or e-mail Team-Kodi members directly asking for support. Read/follow the
forum rules (wiki).
Please read the pages on
troubleshooting (wiki) and
bug reporting (wiki) before reporting issues.
Posts: 7
Joined: Jul 2011
Reputation:
0
I havent checked that, but it was working perfectly on ATV2 (same hardware)
I updated to a nightly, then it stopped working, then re-jailbroke etc and still not working.
and yes, I can connect from my laptop with xbmc installed fine.
Posts: 7
Joined: Jul 2011
Reputation:
0
just checked, skip_networking is set to "off"
Posts: 507
Joined: Sep 2008
Reputation:
1
When this happened to me, I had to drop my database and start fresh. After doing this, and using the nightly build along with 10.0.9, my ATV2 and Win7 machine running the nightly hosting MySQL worked again.
Posts: 7
Joined: Jul 2011
Reputation:
0
Hi,
thanks for that, however i'm not impressed that I would have to do that, the database is VERY large, and I already lost it once changing to the mysql format.
surely this is a bug that can get resolved?
Posts: 31,445
Joined: Jan 2011
2011-07-04, 01:40
(This post was last modified: 2011-07-04, 01:42 by Ned Scott.)
joshuaand Wrote:Hi,
thanks for that, however i'm not impressed that I would have to do that, the database is VERY large, and I already lost it once changing to the mysql format.
surely this is a bug that can get resolved?
Export your library using XBMC on the computer hosting the database. Start fresh in mysql then reimport. Plus, it's always a good idea to backup your database when using nightlies/pre-Eden builds.
Although I believe you only need to install a nightly XBMC on your host computer to get mysql working again.
Posts: 125
Joined: Mar 2011
Reputation:
0
I just tried setting up MySql for the first time. As soon as I uploaded the advancedsettings XML file and booted up XBMC from my AppleTV, I immediately noticed that the splash screen remained on screen 3-5 times as long as it normally does. When I finally got to the home screen, I saw a database messages that said "preparing" which remained on screen for several minutes while I could not navifate at all. Then it said compressing, still locking me up for several more minutes. Then that went away and I could navigate as normal.
When I sent into settings to import my database, it began the import and just locked up on that screen and never did anything. I force-reset the ATV after giving it an hour to do something, restarted XBMC and dealt with the delayed splash screen/startup/preparing/compressing messages again. I've sinced deleted the advancedsettings XML file.
Anyone have any ideas what the issue could be?
Posts: 7
Joined: Jul 2011
Reputation:
0
Ok so library is working again on ATV2 after ugprading main windows machine to latest nightly, exporting library, clearing mysql, re-importing.
this is however definately NOT the desired outcome, as I now have my main TV on an unstable nightly build.
downgrading to 10.1 on the windows machine thus renders this useless (cant access library)
I guess I will have to live with the nightly, hopefully the nightly isnt too bad.
Posts: 125
Joined: Mar 2011
Reputation:
0
Davilla:
I took a look at the log -- I won't bother pasting it because all it says is that it couldn't connect to the database, so something else is up.
I have the database installed to the same server that my smb share is set up, which I do have to enter a username and password to connect to. Do I need to additionally add login parameters to the advancedsettings.xml file in order to connect (so it would have the xbmb/xbmc user/pass for the mysql database and also somewhere the user/pass for the server?) If so (from a mysql n00b) how is that coded into the advanced settings?
If that's *not* the case, even though I followed the instructions exactly from the setup tutorial, any thoughts?
I'm running everything off of a WHS 2011 system, core i3, 4gb RAM, gigabit router, hard-wired, etc.
Many thanks,
SM
Posts: 125
Joined: Mar 2011
Reputation:
0
Gotcha, okay. :-) So I installed mysql from the Microsoft Web Platform Installer. I think it's MySql version 5.1. Is this what needs to be updated? I haven't been able to install MySql from the mysql.com website on the WHS 2011. I can't launch the Command Line Client, for whatever reason.
Or is this some other issue? (I'm running an XBMC nightly from several months ago on this particular ATV2 device, which I haven't updated because of the scraping issues with the latest official. My other ATV2 is jailbroken with the latest iOS and the latest official and can't even get beyond the splash screen.)
Thanks a lot for your help!
SM