2012-04-07, 19:00
Hi.
I'm trying to set up several instances of XBMC to use a shared library like this:
http://lifehacker.com/5634515/how-to-syn...-the-house
Unfortunately I'm unable to get it to work. It seems xbmc cannot connect to the mysql database. As far as I can tell I have everything set up correctly though there is obviously something I've missed.
Here is my setup:
Server:
OS: Windows Server 2008 r2
This contains all media as well as the MySQL server instance
Client1:
OS: Ubuntu 10.10 x32
Can connect to the mysql database using the terminal client and the xbmc user name and password I specified. I'm also able to create and modify tables using the xbmc user.
Client2:
OS: Windows 7 x64
Can connect using SQLWave client on the correct port using the correct user name and password. I'm also able to modify the databases from here.
The log on both machines has got a ton of entries like this:
18:40:23 T:5848 ERROR: Unable to open database: xbmc_video# [2003](Can't connect to MySQL server on '192.168.0.112' (10055))
where # is a number.
They both also contain an entry like this (both for video and music):
18:40:23 T:5848 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.0.112' (10055))
What am I missing?
I'm trying to set up several instances of XBMC to use a shared library like this:
http://lifehacker.com/5634515/how-to-syn...-the-house
Unfortunately I'm unable to get it to work. It seems xbmc cannot connect to the mysql database. As far as I can tell I have everything set up correctly though there is obviously something I've missed.
Here is my setup:
Server:
OS: Windows Server 2008 r2
This contains all media as well as the MySQL server instance
Client1:
OS: Ubuntu 10.10 x32
Can connect to the mysql database using the terminal client and the xbmc user name and password I specified. I'm also able to create and modify tables using the xbmc user.
Client2:
OS: Windows 7 x64
Can connect using SQLWave client on the correct port using the correct user name and password. I'm also able to modify the databases from here.
The log on both machines has got a ton of entries like this:
18:40:23 T:5848 ERROR: Unable to open database: xbmc_video# [2003](Can't connect to MySQL server on '192.168.0.112' (10055))
where # is a number.
They both also contain an entry like this (both for video and music):
18:40:23 T:5848 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.0.112' (10055))
What am I missing?