Library not appearing after router went belly up

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
Yardley Offline
Junior Member
Posts: 10
Joined: Nov 2011
Reputation: 0
Post: #1
Hi all, I have a Mac Mini running MySQL and hosting my files via an NFS share. All was working fine until my internet router died. I couldn't remember what the IP address of the Mac Mini was so I opened the advancedsettings.xml file on one of my clients and retrieved the address from there, assigned it to the Mac Mini and everything seemed to work or so I though. I can't remember if I tried XBMC no the Mini right after this or if I was just using it on my clients but I went to use it a few days ago on the Mini and my library isn't loading. This is only happening on the Mini which is where the MySQL server is running as well as the NFS share. (other clients run fine) On the Mini I can access the files if I go to videos --> files but there is no "library" option under videos and when I set content it doesn't save and still displays set content.

I uninstalled and reinstalled XBMC and it still doesn't work, again only the Mini isn't working the other clients are fine. I'm I missing something here? I haven't changed anything since my router crashed, all of the advancedsettings.xml settings are the same on all machines and I know the Mini is looking at it because if I change the IP on the advancedsettings.xml file to an invalid one XBMC won't load. When I give it the correct IP address of the server (or itself) it loads but doesn't scan for new content and doesn't display my library properly.

Any ideas? Below is the XBMC log.

http://pastebin.com/b9h1DLWT
find quote
robweber Offline
Posting Freak
Posts: 885
Joined: Sep 2009
Reputation: 27
Post: #2
There are numerous authentication failures for user xbmc@macmini.home . it appears there is a mysql permissions problem. If the db is on the same computer as you are running xbmc use "localhost" as the hostname or set the right permissions based on machine name.
find quote
Yardley Offline
Junior Member
Posts: 10
Joined: Nov 2011
Reputation: 0
Post: #3
(2014-04-17 04:37)robweber Wrote:  There are numerous authentication failures for user xbmc@macmini.home . it appears there is a mysql permissions problem. If the db is on the same computer as you are running xbmc use "localhost" as the hostname or set the right permissions based on machine name.

Thanks for the reply. That's what I was thinking but I wasn't sure. How can I set the right permissions?

The weird thing is that everything was working fine before and I haven't made any changes at all.
(This post was last modified: 2014-04-17 05:03 by Yardley.)
find quote
Yardley Offline
Junior Member
Posts: 10
Joined: Nov 2011
Reputation: 0
Post: #4
Ok I got it! I had to do CREATE USER 'xbmc'@'macmini.home' IDENTIFIED BY 'xbmc'; followed by GRANT ALL ON *.* TO 'xbmc'@'macmini.home';

Thanks
find quote