[pledgeX]

I've got a Synology NAS on which I have a MariaDB setup in order to store my Kodi library which is shared amongst a few Fire TV devices around the house. This has been working flawlessly for years now.

My ISP changed today, which involved getting a new router (Sky Q hub). The first problem was that I had had to change the static IP address assigned to my Synology NAS (from 192.168.1.100 to 192.168.0.100). After doing that, I realised I had to edit my sources.xml and advancedsettings.xml to point to the new IP address. I've attached what these files look like at the end of this post.

After clearing cache/data on the Kodi application on the FireTV stick, I fired up Kodi, copied the two xml files into the userdata folder, restarted Kodi, and huzzah, all my media is visible! It's retrieved all movies/tv shows, artwork, elapsed time, the lot. Everything looks great.  HOWEVER, when I click on something to watch it, the system just hangs on the spinner icon until I force quit. 

Strangely, if I choose to watch something through the Videos > Files section in Kodi, it plays fine, so Kodi can access the media file itself, it just doesn't seem to like it when I play it via the Movies/TV Show section. I'm guessing it's trying (and failing) to read/write something to MariaDB when I try and play it through the media sections, but I don't know what it could be. Any ideas?

The only thing that has changed in my setup is the new router, and as a result the static IP address of the NAS box. Could it be port forwarding related? The NAS is wired to router so is on the same LAN.  I'm not sure if this requires ports to be opened, but I tried just in case but still no luck. I'm not that savvy with networking so I may have done something wrong on this step. Screenshot of the rules below.

Thanks for any help.

AdvancedSettings.xml:

xml:
<advancedsettings>

<videodatabase>

<type>mysql</type>

<host>192.168.0.100</host>

<port>3307</port>

<user>kodi</user>

<pass>mypassword</pass>

</videodatabase>



<musicdatabase>

<type>mysql</type>

<host>192.168.0.100</host>

<port>3307</port>

<user>kodi</user>

<pass>mypassword</pass>

</musicdatabase>

</advancedsettings>

Sources.xml:

xml:
<sources>

    <programs>

        <default pathversion="1"></default>

    </programs>

    <video>

        <default pathversion="1"></default>

        <source>

            <name>TV Series</name>

            <path pathversion="1">nfs://192.168.0.100/volume1/DiskStation/My Videos/TV Series/</path>

            <allowsharing>true</allowsharing>

        </source>

        <source>

            <name>Movies</name>

            <path pathversion="1">nfs://192.168.0.100/volume1/DiskStation/My Videos/Movies/</path>

            <allowsharing>true</allowsharing>

        </source>

    </video>

    <music>

        <default pathversion="1"></default>

        <source>

            <name>My Music</name>

            <path pathversion="1">nfs://192.168.0.100/volume1/DiskStation/My Music/</path>

            <allowsharing>true</allowsharing>

        </source>

    </music>

    <pictures>

        <default pathversion="1"></default>

    </pictures>

    <files>

        <default pathversion="1"></default>

        <source>

            <name>DiskStation</name>

            <path pathversion="1">nfs://192.168.0.100/volume1/DiskStation/</path>

            <allowsharing>true</allowsharing>

        </source>

    </files>

</sources>

[ponkotsu]

The media paths stored in your MariaDB tables are still pointing to 192.168.1.100. You can either edit them directly in the tables to replace 192.168.1.100 with 192.168.0.100, or you can do something with path substitution. Unforutnately, I don't have access to my database right now so I can't specify which tables/columns. And I've never done path substitution, just echoing what I've heard suggested before. I'm sure it's in the wiki though.

[scott967]

Please take a look at this:  HOW-TO:Update_Paths_In_MySQL (wiki)

scott s.
.

[black_eagle]

Either that or alter the base address of the router to be 192.168.1.x instead of 0.x Dunno where that might be on the SkyQ hub but you can most likely change it under LAN IP Setup, judging from your screenshot. It'll just make everything as it was before (if you change your NAS back too!).  That's what I would do anyway.

[pledgeX]

Either that or alter the base address of the router to be 192.168.1.x instead of 0.x Dunno where that might be on the SkyQ hub but you can most likely change it under LAN IP Setup, judging from your screenshot. It'll just make everything as it was before (if you change your NAS back too!).  That's what I would do anyway.

Yes! This worked a treat. Didn't realise you could do that. Thank you very much