2012-03-11, 01:39
I have been sharing my music and movies from a Netgear ReadyNAS Linux-based server successfully for the last year. I decided I wanted to move the thumbnails to the server, along with music and video libraries, to a mysql database on this server. The thumbnails were a piece of cake with nfs, the libraries are a pain.
I first configured a local mysql server on my Ubuntu Eden RC2 box. I scraped the movies and music to the local mysql and all was well for 5 days. I thought I had the remote mysql server configured, but I can't get it to work. I have searched here and across the web. I have read everything I can find that seems related. All I can find is references to CREATE & GRANT for the appropriate user.
I won't post the xbmc or mysql logs here, just a couple of snipets, since there are already many examples. It starts with:
The database name counts down to zero, then xbmc tries and fails to create MyVideos60.
My Eden box is 192.168.1.26 and the NAS server is 192.168.1.200.
This is what I did via ssh and mysql client, at the nas server:
When that didn't work, I tried this:
XBMC still can't create the remote mysql database. Can somebody please tell me what I am doing wrong?
The local database was a breeze compared to this one.
I first configured a local mysql server on my Ubuntu Eden RC2 box. I scraped the movies and music to the local mysql and all was well for 5 days. I thought I had the remote mysql server configured, but I can't get it to work. I have searched here and across the web. I have read everything I can find that seems related. All I can find is references to CREATE & GRANT for the appropriate user.
I won't post the xbmc or mysql logs here, just a couple of snipets, since there are already many examples. It starts with:
Code:
ERROR: Unable to open database: MyVideos60 [1044](Access denied for user 'xbmc'@'192.168.1.26
Code:
ERROR: SQL: Can't create new database: 'MyVideos60' (1044)
My Eden box is 192.168.1.26 and the NAS server is 192.168.1.200.
This is what I did via ssh and mysql client, at the nas server:
Code:
CREATE USER 'xbmc'@'192.168.1.26/255.255.255.0' IDENTIFIED BY 'xbmc';
GRANT ALL on *.* TO 'xbmc'@'192.168.1.26/255.255.255.0';
Code:
CREATE USER 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT ALL on *.* TO 'xbmc'@'%';
XBMC still can't create the remote mysql database. Can somebody please tell me what I am doing wrong?
The local database was a breeze compared to this one.