MySQL-problems [2003] and (101)

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
nils_larson Offline
Junior Member
Posts: 6
Joined: Aug 2012
Reputation: 0
Post: #1
Hello (my first post)

I'm trying to sync my library from my Netgear ReadyNAS MySQL-server to my pc (Windows) and Raspberry Pi with OpenELEC. (I do hope OpenELEC is sort of "supported" in this forum).
I got it all up and running between the NAS and my windows PC, I can fill and get my library from the MySQL-server.

On the raspberry i only got this error:
Code:
ERROR: Unable to open database: MyVideos60 [2003](Can't connect to MySQL server on '192.168.1.214' (101))
The advancedsettings.xml (as shown in the below pastebin) is the same on both machines, so i can't understand what the problem might be?

Full debug log on the raspberry openElec:

http://pastebin.com/JSHMpahJ

I have tried to find an answer from people with similar problems but for all of them it seems to be a go/no go on all devices, where I instead only have problem with one device.
find quote
Ned Scott Offline
Team-Kodi Wiki Guy
Posts: 21,900
Joined: Jan 2011
Reputation: 289
Location: Arizona, USA
Post: #2
I'm guessing the problem here is you're using XBMC v11 on the Windows desktop, and the OpenELEC build, being based on pre-v12 code, is trying to update the database and doesn't have access. Even if it did, the two machines won't sync because they're not using the same code. You'd need to update the Windows desktop to a nightly build that is close to what the OpenELEC build is using.

But that's just a guess. Is this setup working fine on the Windows PC? No errors and the library loads fine?

You can make easy links to the XBMC wiki using double brackets around common XBMC words: [[debug log]] = debug log, [[Video library]] = Video library, [[SMB]] = SMB , [[userdata]] = userdata, etc
find quote
nils_larson Offline
Junior Member
Posts: 6
Joined: Aug 2012
Reputation: 0
Post: #3
ok, will test to update windows PC.

Yes the PC is loading the library fine, no errors.

Debug log from windows PC:
http://pastebin.com/HRbu7kpY
find quote
Ned Scott Offline
Team-Kodi Wiki Guy
Posts: 21,900
Joined: Jan 2011
Reputation: 289
Location: Arizona, USA
Post: #4
Ah, I think I see the problem here. The user/password on the PC's advancedsettings.xml file is "xbmc" while the user on the R-Pi is "xbmcelec"

They both need to be "xbmc". That, and updating the PC to a nightly build, should fix the issue.

You can make easy links to the XBMC wiki using double brackets around common XBMC words: [[debug log]] = debug log, [[Video library]] = Video library, [[SMB]] = SMB , [[userdata]] = userdata, etc
find quote
nils_larson Offline
Junior Member
Posts: 6
Joined: Aug 2012
Reputation: 0
Post: #5
I got both users (did some testing on my own) but have change so both are correct now..

Your suggestion is to find the exactly matching nightly build on my pc?

When I use the latest build on PC it works great, but still not working on RPi:

Latest RPi-debug:

http://pastebin.com/AEHU6pYC
find quote
Ned Scott Offline
Team-Kodi Wiki Guy
Posts: 21,900
Joined: Jan 2011
Reputation: 289
Location: Arizona, USA
Post: #6
That last pastebin link doesn't seem to work?

You can make easy links to the XBMC wiki using double brackets around common XBMC words: [[debug log]] = debug log, [[Video library]] = Video library, [[SMB]] = SMB , [[userdata]] = userdata, etc
find quote
nils_larson Offline
Junior Member
Posts: 6
Joined: Aug 2012
Reputation: 0
Post: #7
Here is another try:

http://pastebin.com/ACZ5M32X
find quote
nils_larson Offline
Junior Member
Posts: 6
Joined: Aug 2012
Reputation: 0
Post: #8
btw: PC is working with db named MyVideos68 and MyMusic27 now, and it doesn't seems like the RPi look for those, therefor my question; am I supposed to try another nightly build on the PC?
find quote
nils_larson Offline
Junior Member
Posts: 6
Joined: Aug 2012
Reputation: 0
Post: #9
I changed to Raspbmc and now everything is working fine now (edit: sort of not). Seems to be something with OpenELEC/my settings in OpenELEC.

Thank you for your help though Ned!

EDIT: Actually it seems like it's a Wifi-thing, like xbmc tries to connect to MySQL before the wifi is up, and therefore results in a bad connection.
Any idea how to "fix" this or do I allways have to run on wired network to be able to load the library?
(This post was last modified: 2012-08-12 20:28 by nils_larson.)
find quote