MySQL-problems  and (101) - Printable Version
+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (/forumdisplay.php?fid=33)
+--- Forum: General Support (/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (/forumdisplay.php?fid=228)
+---- Thread: MySQL-problems  and (101) (/showthread.php?tid=138134)
MySQL-problems  and (101) - nils_larson - 2012-08-12 10:38
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:
Full debug log on the raspberry openElec:
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.
RE: MySQL-problems  and (101) - Ned Scott - 2012-08-12 11:26
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 (wiki) 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?
RE: MySQL-problems  and (101) - nils_larson - 2012-08-12 11:42
ok, will test to update windows PC.
Yes the PC is loading the library fine, no errors.
Debug log from windows PC:
RE: MySQL-problems  and (101) - Ned Scott - 2012-08-12 11:44
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.
RE: MySQL-problems  and (101) - nils_larson - 2012-08-12 12:09
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:
RE: MySQL-problems  and (101) - Ned Scott - 2012-08-12 14:03
That last pastebin link doesn't seem to work?
RE: MySQL-problems  and (101) - nils_larson - 2012-08-12 14:24
Here is another try:
RE: MySQL-problems  and (101) - nils_larson - 2012-08-12 14:35
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?
RE: MySQL-problems  and (101) - nils_larson - 2012-08-12 20:12
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?