I currently run 3 installations of Kodi 14.x on 3 different devices (Windows 7, Android and Raspberry Pi).
All of them are configured to use a remote mysql-database. Just installed OSMC Alpha 4 on my new Raspberry Pi 2, but I can’t connect to the mysql-database.
Changed from dhcp to static ip (same as my old Raspberry), works now. Still no idea why it doesn’t work with the dhcp assigned ip, firewall on my server is configured to accept connections to port 3306 from local network (192.168.1.0/24) and mysql user xbmc is accepted from ‘%’.
I have the same issue here - multiple Kodi 14.1 instances (Raspbmc, Windows, Ubuntu) can all connect to the MySQL library database, but the OSMC Alpha 4 on a Raspberry Pi 2 cannot - it logs the same error message as OP. Changing from DHCP to static IP works for some reason…
MySQL working with other Kodi installs: Yup
MySQL database created by OSMC: (MyVideos90, a bit old now but) Yup
Wired and Fixed IP address work done: Yup
OSMC refusing to do anything else to the database: Yup
Well, the last bit is a ‘bit’ of a lie, it has added a file that I manually browsed to from the file list but still, this isn’t really the experience I would have hoped for
Exactly what experience were you hoping for from Alpha software? It seems everyone else here has mysql working, I know I haven’t had any problems.
If you are seeking assistance, wouldn’t it make more sense to explain exactly what you are doing and what result you are seeing instead of posting some cryptic, sarcasm? Maybe include some debug logs?
I know this is a “ancient” thread (This was the thread that Google pointed to) - but I just wanted to give my $0.2. (And thank DerDaumen for saving me for a lot of more googling for a solution)
I Just changed my router, but duplicated every “setting” from my previous setup, with internal DNS, same DHCP scope etc. But after that, OSMC was unable to use my external MySQL database (Both on hostname or IP)
Reinstalling OSMC had no effect - but setting static IP for my ethernet connection worked right away!
So my conclusion is that there is some option that is set via DHCP that renders external MySQL unusable on OSMC+RaspberryPI - on some routers…