Kodi Community Forum

Full Version: MySQL Issues
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello all,

I was the last two days trying to share my library through MySQL and am having some issues, I've been reading the guides but haven't had any luck. Hoping someone here can help me.

I have two PC running Kodi V14 both have Windows 7. My main PC has three hard drives attached where my movies and tv shows are stored. Everything is working on this PC. When I show the databases in the SQL all my tv shows and movies are showing up.

Now the issue is on the second PC. All the movies and tv shows are showing up, as well as fanart. The watched status also syncs. But I am not getting cover art, season art or episode art.

Also, when I try to play a movie or tv show on the second PC I get the message "The file is no longer available".

The advanced settings file from PC #1 is here

The advanced settings file from PC #2 is here

The Debug File from PC #1 is here

The Debug File from PC #2 is here
did you also add the sources.xml + passwords.xml to the second PC ?
else xbmc doesn't know where the files are located.
Ok I never included sources or password.

Here is the new sources.xml


I don't have any passwords on my network, so I don't think I need the password.xml?
I've added the souces.xml and mediasource.xml and tried changing them around a bit but still no luck, still the same issues.

Here is my new advanced settings:

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>10.0.0.16</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>10.0.0.16</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails/</from>
<to>smb://10.0.0.16/Thumbnails/</to>
</substitute>
<substitute>
<from>special://profile/sources.xml</from>
<to>SMB://10.0.0.16/kodi/userdata/sources.xml</to>
</substitute>
<substitute>
<from>special://profile/mediasources.xml</from>
<to>SMB://10.0.0.16/kodi/userdata/mediasources.xml</to>
</substitute>
<substitute>
<from>special://profile/passwords.xml</from>
<to>sMB://10.0.0.16/kodi/userdata/passwords.xml</to>
</substitute>
</pathsubstitution>
</advancedsettings>
Well my sources doesn't look like that,
My main pc sources has the path to where the files are stored.
Movies series music etc.
Up don't see that in yours
have you shared the thumbnails folder separately if not you might need to add the full path.
I don't use subs anymore see if you can access that folder from your 2nd PC.
as you can see in my sources.xml
it has the paths where the video's are located.

Code:
<sources>
    <programs>
        <default pathversion="1"></default>
    </programs>
    <video>
        <default pathversion="1"></default>
        <source>
            <name>Videos</name>
            <path pathversion="1">/storage/videos/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>Movies</name>
            <path pathversion="1">smb://192.168.2.200/Movies/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>TV</name>
            <path pathversion="1">smb://192.168.2.200/TV/</path>
            <allowsharing>true</allowsharing>
        </source>
    </video>
    <music>
        <default pathversion="1"></default>
        <source>
            <name>Music</name>
            <path pathversion="1">/storage/music/</path>
            <allowsharing>true</allowsharing>
        </source>
    </music>
    <pictures>
        <default pathversion="1"></default>
        <source>
            <name>Pictures</name>
            <path pathversion="1">/storage/pictures/</path>
            <allowsharing>true</allowsharing>
        </source>
    </pictures>
    <files>
        <default pathversion="1"></default>
    </files>
</sources>
don't share your thumbnails folder, each client should populate its own cache.