MySQL Cross Platform Path Problems
#1
Hi,
I have been messing with XBMC for a few weeks now, got everything setup how
I liked it, then I decided to change it to mysql so I can add more nodes on the network.

mysql is on my server (linux) with my media shared via NFS and Samba
node1 is linux and everything is working fine, mount points are /tv and /movies over NFS on server

now I want to add a Windows machine, using Samba I can read my media, but I cannot find a way to ever have it work with the current populated database (can read the database itself fine) because the path will never match what is already there (linux path /tv/show/season/ep.avi) as windows will always be either a drive letter or smb://hostname/ etc..

Maybe I have missed some way of setting the sources up *shrugs*

Has anyone else come across this problem and maybe a solution?
If it come to it I could dual boot to linux then just use NFS again, but would rather not.

Thanks for any help Smile
Reply
#2
You need the paths to be the same on all platforms. I suspect the only way you're going to achieve this is to use SMB on your Linux installations.

JR
Reply
#3
hm, i think i will run into the same problem Laugh

i don't know if this works, but i found this option in the advancedsettings.xml:

<pathsubstitution>
<substitute>
<from>G:\dvds\</from>
<to>smb://somecomputer/g-share/dvds/</to>
</substitute>
</pathsubstitution>

So my suggestion is to try something like:

<pathsubstitution>
<substitute>
<from>/home/xbmc/Movies</from> <--Your NFS mount point
<to>smb://192.xxx.xxx.xxx/Movies</to>
</substitute>
</pathsubstitution>

for each share. i'll try it tonight and let you know whether it will work...
Reply
#4
well thats interesting, gunna give it a try now, see what happens Smile

doesn't look like it has any effect in the main library, only in playlists Sad
Reply
#5
it will only work on trunk, its not in Dharma
Reply
#6
amet Wrote:it will only work on trunk, its not in Dharma

I compiled the latest git PRE-11 and it has no effect, here is my advancedsettings.xml am i missing something?

Code:
<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>192.168.0.100</host>
        <port>3306</port>
        <user>xxxxxxxxxx</user>
        <pass>xxxxxxxxxx</pass>
        <name>xbmc_video</name>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>192.168.0.100</host>
        <port>3306</port>
        <user>xxxxxxxx</user>
        <pass>xxxxxxxx</pass>
        <name>xbmc_music</name>
    </musicdatabase>
<pathsubstitution>
<substitute>
<from>/tv</from>
<to>smb://192.168.0.100/tv</to>
</substitute>
</pathsubstitution>
</advancedsettings>
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL Cross Platform Path Problems0