2012-10-13, 02:31
Hi,
I've been using XBMC across a few computers for a while now, and only found out the other day about the MySQL syncing features, so I've been trying to set this up using the guides on the wiki and howtogeek. Mostly, this has gone okay - one computer, an HP microserver on Windows 7 runs the MySQL server as well as hosting the media files and acting as an HTPC and this uses the MySQL just fine, and has done the initial scrape and set the tables up and everything. I've checked in the MySQL command line and this shows that the right database exists and has the right number of movies and TV shows in it.
Using the same advancedsettings.xml, I've tried to have the same library sync across 3 other computers - a MacBook (OS X), an old HTPC (Windows 7) in a bedroom and the PC I'm typing this on now (also Windows 7). The MacBook and upstairs HTPC work perfectly, the libraries, watched status, and videos resuming across different computers etc all worked with no extra setup other than the advancedsettings.xml file. The PC I'm typing this on, though, won't connect to the MySQL server. All that happens is I open XBMC, it hangs on the splash screen, and I have to ctrl+alt+del out of it (it works fine with advancedsettings.xml moved away again).
Reading the debug log, there's one error that jumps out at me:
The rest of the debug log: http://pastebin.com/xj8AqgCB
If I keep it running rather than quitting out, it keeps running down MyVideos60, 59, 58, etc to 1 then starts over.
This is my advancedsettings.xml:
A few things I've tried:
I've made sure the ports are open on the machine running MySQL and confirmed this is all working properly using canyouseeme.org
All the versions of XBMC are the same (aside from the OS X version, but they're all the most current stable versions on the downloads page as of today)
A ridiculous number of reinstalls with slightly different settings
Checked the permissions for the xbmc user in the MySQL command line which are fine
Now I've typed all this and spent days trying to fix it on my own and with the help of Google, I'm sure there is going to be a really obvious solution that I've managed to miss, but I think this is everything that could be vaguely useful.
Any ideas?
EDIT: Oh, I forgot to mention, on the PC that the XBMC-MySQL combo isn't working on, I've installed HeidiSQL which can connect to the MySQL database fine using the XBMC credentials, but XBMC still doesn't work with it, which is weird.
I've been using XBMC across a few computers for a while now, and only found out the other day about the MySQL syncing features, so I've been trying to set this up using the guides on the wiki and howtogeek. Mostly, this has gone okay - one computer, an HP microserver on Windows 7 runs the MySQL server as well as hosting the media files and acting as an HTPC and this uses the MySQL just fine, and has done the initial scrape and set the tables up and everything. I've checked in the MySQL command line and this shows that the right database exists and has the right number of movies and TV shows in it.
Using the same advancedsettings.xml, I've tried to have the same library sync across 3 other computers - a MacBook (OS X), an old HTPC (Windows 7) in a bedroom and the PC I'm typing this on now (also Windows 7). The MacBook and upstairs HTPC work perfectly, the libraries, watched status, and videos resuming across different computers etc all worked with no extra setup other than the advancedsettings.xml file. The PC I'm typing this on, though, won't connect to the MySQL server. All that happens is I open XBMC, it hangs on the splash screen, and I have to ctrl+alt+del out of it (it works fine with advancedsettings.xml moved away again).
Reading the debug log, there's one error that jumps out at me:
Code:
21:53:52 T:3488 ERROR: Unable to open database: MyVideos60 [2003](Can't connect to MySQL server on '192.168.0.120' (10060))
The rest of the debug log: http://pastebin.com/xj8AqgCB
If I keep it running rather than quitting out, it keeps running down MyVideos60, 59, 58, etc to 1 then starts over.
This is my advancedsettings.xml:
Code:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.120</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
</advancedsettings>
A few things I've tried:
I've made sure the ports are open on the machine running MySQL and confirmed this is all working properly using canyouseeme.org
All the versions of XBMC are the same (aside from the OS X version, but they're all the most current stable versions on the downloads page as of today)
A ridiculous number of reinstalls with slightly different settings
Checked the permissions for the xbmc user in the MySQL command line which are fine
Now I've typed all this and spent days trying to fix it on my own and with the help of Google, I'm sure there is going to be a really obvious solution that I've managed to miss, but I think this is everything that could be vaguely useful.
Any ideas?
EDIT: Oh, I forgot to mention, on the PC that the XBMC-MySQL combo isn't working on, I've installed HeidiSQL which can connect to the MySQL database fine using the XBMC credentials, but XBMC still doesn't work with it, which is weird.