2014-03-26, 00:36
Okay so I spent a good part of all night last night trying to get my XBMC to connect to an external database (newly created) and setup the tables for my library. I followed the wiki several times and did probably 50 google searches trying to resolve my issue. I'm starting to think that XBMC will not connect to an external ip address and that it MUST be a LAN address.
Anyways, the sql server is GoDaddy (I run a website and thought it would be rather convenient to just make another database for XBMC). I created a blank database available for XBMC. Setup my advancedsettings.xml to include all of the information. IP address is included, user, pass etc and I get nothing but "access denied for user @'%" and then that message repeats in the log video61, video62 etc.
I've tried reinstalling which didn't help. So I created a local Linux mysql database on my NAS drive... tried connecting with that but get the same error. Gah I'm not sure what else to do but to make a local sql database (which is less than ideal).
I'm sure the ip address / user / pass are all correct because I can connect using the mysql client from the same computer manually.
Anyways, the sql server is GoDaddy (I run a website and thought it would be rather convenient to just make another database for XBMC). I created a blank database available for XBMC. Setup my advancedsettings.xml to include all of the information. IP address is included, user, pass etc and I get nothing but "access denied for user @'%" and then that message repeats in the log video61, video62 etc.
I've tried reinstalling which didn't help. So I created a local Linux mysql database on my NAS drive... tried connecting with that but get the same error. Gah I'm not sure what else to do but to make a local sql database (which is less than ideal).
I'm sure the ip address / user / pass are all correct because I can connect using the mysql client from the same computer manually.