2013-09-03, 00:12
(I didn't put this on the Linux subforum because it deals with multiple different systems on a network. I also found one or two previous threads discussing similar issues, but without any fix for my problem.)
I have a Linux computer I'm using as a media server for several XBMC clients (using NFS shares). I had previously set up MySQL to use a shared library, and everything was working fine. However, I recently had to replace the boot drive on the server, and took the opportunity to clean up the system with a clean install of everything. Before doing so, I was able to export the library (with the separate files option) so that I would be able to import it after replacing the drive.
However, after installing MySQL (following the guide on the wiki, just as I had done previously), my clients -- in particular my Ouya, which is my main client -- can't update the library. I installed XBMC on the server and was able to have it create the tables and import the library, after which the clients were able to access the library but still not update it. But because I don't want to have to run XBMC on the server every time I want to update the library and also to reduce the chance of incompatible versions causing problems with the database, I have since dropped the databases.
I have checked the priviledges for the xbmc user ("GRANT ALL ON *.* TO 'xbmc';"), and have made sure the database is available on the network. I've checked to make sure the advanced_settings.xml file contains the correct address for the server and correct username and password for the database. And I can access the database with the xbmc user remotely using a MySQL client on my laptop. But I still can't get my XBMC clients to update the database.
Help, please!
I have a Linux computer I'm using as a media server for several XBMC clients (using NFS shares). I had previously set up MySQL to use a shared library, and everything was working fine. However, I recently had to replace the boot drive on the server, and took the opportunity to clean up the system with a clean install of everything. Before doing so, I was able to export the library (with the separate files option) so that I would be able to import it after replacing the drive.
However, after installing MySQL (following the guide on the wiki, just as I had done previously), my clients -- in particular my Ouya, which is my main client -- can't update the library. I installed XBMC on the server and was able to have it create the tables and import the library, after which the clients were able to access the library but still not update it. But because I don't want to have to run XBMC on the server every time I want to update the library and also to reduce the chance of incompatible versions causing problems with the database, I have since dropped the databases.
I have checked the priviledges for the xbmc user ("GRANT ALL ON *.* TO 'xbmc';"), and have made sure the database is available on the network. I've checked to make sure the advanced_settings.xml file contains the correct address for the server and correct username and password for the database. And I can access the database with the xbmc user remotely using a MySQL client on my laptop. But I still can't get my XBMC clients to update the database.
Help, please!