2014-03-02, 19:34
So I moved my SQL server off of my Zyxel NAS, because I was having trouble connecting to the database sometimes. If I rebooted xbmc a few times, it would eventually be able to read it. I assumed it was because of some shotty Zyxel mysql software.
So I moved it to my NUC, which is running XBMCBUNTU.
I set it up correctly and have my my.conf file's bind address looking like this:
I have also tried just 0.0.0.0 and commenting out the line completely.
I cannot get XBMC running on the same machine to open the databse. The Debug log looks like this:
I also have a pi running openelecand my Windows machine can see it, and seems to work fine.
I did
so that is not the problem.
Here is a link to my full debug:
DEBUG
So I moved it to my NUC, which is running XBMCBUNTU.
I set it up correctly and have my my.conf file's bind address looking like this:
Quote:bind-address = 127.0.0.1
bind-address = 192.168.1.12
I have also tried just 0.0.0.0 and commenting out the line completely.
I cannot get XBMC running on the same machine to open the databse. The Debug log looks like this:
Quote:12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic11 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic10 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic9 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic8 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic7 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic6 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic5 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic4 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic3 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic2 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic1 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.1.12' (111))
12:24:29 T:3037849344 ERROR: Unable to create new database
I also have a pi running openelecand my Windows machine can see it, and seems to work fine.
I did
Quote:GRANT ALL ON *.* TO 'xbmc';
so that is not the problem.
Here is a link to my full debug:
DEBUG