[duncang92]

I've googled and read and googled and read some more but I still can't get this to work:

Kitchen pc stores all music, tv, movies etc. and runs Ubuntu 13.10. All shares are via nfs.

I installed mysql-server on the kitchen pc and followed this link which is damned close to the wiki which I found after .... added xbmc user in mysql and created xbmc_video and xbmc_music databases and granted xbmc ALL.

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
CREATE database xbmc_video;
CREATE database xbmc_music;
GRANT ALL ON *.* TO 'xbmc';

And restarted mysql

Note that I have tried my.cnf set with bind_address as 192.168.1.3 (kitchen pc) and 127.0.0.1 and commented out and all gives the same result.

I updated advancedsettings.xml on each of my machines and when I go to TV or Movies link and try "Set content" I can run through the gui and yet it doesn't "take" ie if I select the link then I have the "set content" option again but it hasn't been set to TV or Movies .......

<videodatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

And restarted each machine.

I reset advancedsettings.xml back to what it was prior and I still can't set the content which seems rather bizarre as now I should be using local libraries and not via mysql to the kitchen pc.

Where the fur do I start looking?


I don't want to dump a ton of stuff here but am quite happy to take pointers on where to look.

Cheers, Duncan