SQL Duplicates after using FSTAB paths

Help and Support Vero 4K / Vero 4K +
1

First of all thank you for this wonderful device and continuous support!

Logs here.
I use a remote database.
After switching to fstab on my Vero I dropped databases.
Rescanned and populated database.
But because my PC is connecting to (nfs://192.168.1.135/volume1/video/movies/Django (2012)/)
and my Vero is connecting to (/mnt/Server_Movies/Django (2012)/)
I end up with duplicates.
Either machine can’t play from the other source. Which is logical.

Not sure if this question belongs over here, but who knows the answer is obvious enough.

Would love a pointer in the correct direction.

My advanced settings ;

<advancedsettings>
     <videodatabase>
       <type>mysql</type>
       <host>192.168.1.135</host>
       <port>3306</port>
       <user>osmc</user>
       <pass>osmc</pass>
       <name>adults_video</name>
    </videodatabase>
    <musicdatabase>
       <type>mysql</type>
       <host>192.168.1.135</host>
       <port>3306</port>
       <user>osmc</user>
       <pass>osmc</pass>
       <name>adults_music</name>
    </musicdatabase>
</advancedsettings>

Sources on PC

<sources>
    <programs>
        <default pathversion="1"></default>
    </programs>
    <video>
        <default pathversion="1"></default>
        <source>
            <name>movies</name>
            <path pathversion="1">nfs://192.168.1.135/volume1/video/movies/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>tv</name>
            <path pathversion="1">nfs://192.168.1.135/volume1/video/tv/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>music_video</name>
            <path pathversion="1">nfs://192.168.1.135/volume1/music_video/</path>
            <allowsharing>true</allowsharing>
        </source>
    </video>
    <music>
        <default pathversion="1"></default>
        <source>
            <name>music</name>
            <path pathversion="1">nfs://192.168.1.135/volume1/music/</path>
            <allowsharing>true</allowsharing>
        </source>
    </music>
    <pictures>
        <default pathversion="1"></default>
        <source>
            <name>photo</name>
            <path pathversion="1">nfs://192.168.1.135/volume1/photo/</path>
            <allowsharing>true</allowsharing>
        </source>
    </pictures>
    <files>
        <default pathversion="1"></default>
    </files>
</sources>

Sources on Vero

<sources>
    <programs>
        <default pathversion="1"></default>
    </programs>
    <video>
        <default pathversion="1"></default>
        <source>
            <name>Server_Movies</name>
            <path pathversion="1">/mnt/Server_Movies/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>Server_tv</name>
            <path pathversion="1">/mnt/Server_tv/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>Server_Music_video</name>
            <path pathversion="1">/mnt/Server_Music_video/</path>
            <allowsharing>true</allowsharing>
        </source>
    </video>
    <music>
        <default pathversion="1"></default>
        <source>
            <name>Server_Music</name>
            <path pathversion="1">/mnt/Server_Music/</path>
            <allowsharing>true</allowsharing>
        </source>
    </music>
    <pictures>
        <default pathversion="1"></default>
        <source>
            <name>Server_Photo</name>
            <path pathversion="1">/mnt/Server_Photo/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>debackup</name>
            <path pathversion="1">smb://192.168.1.135/debackup/</path>
            <allowsharing>true</allowsharing>
        </source>
    </pictures>
    <files>
        <default pathversion="1"></default>
        <source>
            <name>animatedgifs</name>
            <path pathversion="1">/home/osmc/.kodi/userdata/profiles/Adults/addon_data/script.module.metadatautils/animatedgifs/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>Server_Movies</name>
            <path pathversion="1">/mnt/Server_Movies/</path>
            <allowsharing>true</allowsharing>
        </source>
    </files>
</sources>

And advanced settings on Vero

    <advancedsettings>
     <videodatabase>
       <type>mysql</type>
       <host>192.168.1.135</host>
       <port>3306</port>
       <user>osmc</user>
       <pass>osmc</pass>
       <name>adults_video</name>
    </videodatabase>
    <musicdatabase>
       <type>mysql</type>
       <host>192.168.1.135</host>
       <port>3306</port>
       <user>osmc</user>
       <pass>osmc</pass>
       <name>adults_music</name>
    </musicdatabase>

	<cache>
	<buffermode>1</buffermode>
	<memorysize>256000000</memorysize>
	<readfactor>5</readfactor>
	</cache>
</advancedsettings>
2

Okay. Editing to make things readable didn’t get me far lol :rofl:

3

I’ve edited your post for clarity. Recommend in future you highlight the relevant block of code and use the </> (preformatted text) button.

1 Like
4

The key is to have the same paths on both machines. This can be done with path substitution.

Pick one machine to do all the scanning. Then, add a path substitution on the other machine to match the path that is used to do the scan. The path substitution only has to contain the part of the path that isn’t duplicated.

Clear out the database again, and scan from the chosen machine, and the other machine should be able to access the videos.

1 Like
5

Thanks a gazillion! It worked!
Funny thing is I looked at substituting paths earlier on, but was doing it the wrong way around.
Never got it to work.

See? Sometimes the most obvious answers can be right in front of one :wink:

Thanks again.