Kodi Community Forum
MySQL in Mixed PC/Mac environment - 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: MySQL in Mixed PC/Mac environment (/showthread.php?tid=118898)



MySQL in Mixed PC/Mac environment - ZestyChicken - 2012-01-05

So my brilliant plans to use an unRAID server and a mixed environment of Macs, PCs and one Ubuntu PC has run into a stumbling block. Each of the different OSs have their own preferred network service (AFP, SMB, NFS). While this isn't a problem for unRAID - at all - it is a problem for sharing a single library on a MySQL database. Specifically, they can't share the same list of movies because the paths to the media is all different.

e.g.
smb://unRAID/My TV/Fringe/
vs
afp://192.168.1.77:548/My TV/Fringe/
vs
whatever NFS path it would be

It seems like my only option is to default everything back to Samba, but that just rubs me wrong. Like building a Ferrari and sticking a Chevy engine in it. I've had a lot of issues with Samba and Macs (though that may be due to Win7 and unRAID samba may be less finicky, not sure).

Anyway, just wondering if anyone else has similar issues.

What would seem to resolve this is if XBMC only stored the relative path rather than the absolute. In other words, build the path by concatenating the path from sources.xml [smb://unRAID/My TV/ or afp://192.168.1.77:548/My TV/] to the relative path stored in the database (/Fringe/).

Has anyone else dealt with this issue?


- darkscout - 2012-01-05

AFP, SMB & NFS are all built into XBMC, why does it matter which one you use?


- ZestyChicken - 2012-01-06

darkscout Wrote:AFP, SMB & NFS are all built into XBMC, why does it matter which one you use?

Well Windows can't use AFP or NFS to my knowledge. AFP is faster and more reliable than SMB in my experience. I can't use multiple with a shared database or I get multiple entries for the same movie (one for each path).


- Memphiz - 2012-01-06

nfs works on all plattforms...


- bossanova808 - 2012-01-06

use path subsitution to make the look the same to XBMC - I do this with my Openelec main clients and testing windows laptop so they all point at the same library.


- Philmatic - 2012-01-06

Memphiz Wrote:nfs works on all plattforms...
Oh, was libnfs ported to Windows? That would be a huge win!

EDIT: W I N!


- ZestyChicken - 2012-01-06

bossanova808 Wrote:use path subsitution to make the look the same to XBMC - I do this with my Openelec main clients and testing windows laptop so they all point at the same library.

Can you explain that to me? Me confused...


- ZestyChicken - 2012-01-06

Memphiz Wrote:nfs works on all plattforms...

Is that my best bet? If I'm using mostly Mac clients, is the speed comparable?


- darkscout - 2012-01-06

Philmatic Wrote:Oh, was libnfs ported to Windows? That would be a huge win!

EDIT: W I N!

Even if it wasn't, SMB should work on all platforms.


- ZestyChicken - 2012-01-06

darkscout Wrote:Even if it wasn't, SMB should work on all platforms.

True enough. I got it working now. It's a little slow but not terrible. I may try NFS at some point.