Kodi Community Forum
Library not appearing after router went belly up - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Mac OS X (https://forum.kodi.tv/forumdisplay.php?fid=56)
+---- Thread: Library not appearing after router went belly up (/showthread.php?tid=192476)



Library not appearing after router went belly up - Yardley - 2014-04-17

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


RE: Library not appearing after router went belly up - robweber - 2014-04-17

There are numerous authentication failures for user [email protected] . 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.


RE: Library not appearing after router went belly up - Yardley - 2014-04-17

(2014-04-17, 04:37)robweber Wrote: There are numerous authentication failures for user [email protected] . 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.


RE: Library not appearing after router went belly up - Yardley - 2014-04-17

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