[z9182]

Hello all ,

I've been trying for days, but I can not get it to work.

Start data:
- XBMC FRODO 12 on Windows 8 HTPC
- Synology DS1812+ with DSM 4.0 as central file server for movies, music and pics
- Cabled LAN network

What works
The HTPC with Frodo on it can read and play the movies on the Synology fine (via SMB).

What doesn't work
As I have two HTPC's, I want the XBMC Library stored centrally on the Synology. This I can not get to work

What did I do
At first, I followed this tutorial (mentioned in the XBMC Wiki): http://www.robvanhamersveld.nl/2013/02/0...other-nas/

That didn't work. There is no data sent to the SQL-database, as I can see in the MyPhp-GUI (status).

Then I discovered a new tutorial, also mentioned in the Wiki (from this, I learned the first tuto is incomplete, it is missing the GRANT ALL instruction in SQL while creating a user), and it doesn't mention the 'substitute'-topic in advancedsettings.xml). This tutorial is the second one: http://quixventure.com/2011/12/configure...-for-xbmc/

So I decided, and I probably did something stupid here, to delete the stuff from the first tutorial in SQL: I deleted both the user ('xbmc') and the two databases (video and music).

I followed the second tutorial, but again, there is no data sent to SQL, and the two databases are not recreated which, if I understand it correctly, is what needs to be done when XBMC goes to the Synology the first time.

So I deinstalled PhPMyAdmin on the Synology, and reinstalled it. Still, no databases are created by XBMC and no data is sent to the SQL-database when XBMC is scraping the video directory.

I have been puzzling with this for days now, but I am lost

Would anybody know how to tackle this? At one way or the other, I need to get back to the start position (situation zero) with the SQL-databases (I think), because XBMC refuses to create them.

Any help would be most highly appreciated, thank you in advance extremely very much

Finally, these are my *.xml files:

Sources.xml:

Code:

<sources>
    <programs>
        <default pathversion="1"></default>
    </programs>
    <video>
        <default pathversion="1"></default>
        <source>
            <name>Movies</name>
            <path pathversion="1">smb://DISKSTATION/media/vids/Movie/</path>
        </source>
        <source>
            <name>Series</name>
            <path pathversion="1">smb://DISKSTATION/media/vids/Series/</path>
        </source>
    <source>
            <name>Cartoons</name>
            <path pathversion="1">smb://DISKSTATION/media/vids/Cartoons/</path>
        </source>
    <source>
            <name>Documentaire</name>
            <path pathversion="1">smb://DISKSTATION/media/vids/Documentaire/</path>
        </source>
    <source>
            <name>Clips</name>
            <path pathversion="1">smb://DISKSTATION/media/vids/Clips/</path>
        </source>
    <source>
            <name>Homevids</name>
            <path pathversion="1">smb://DISKSTATION/media/vids/HomeVids/</path>
        </source>
    </video>
</sources>

Advancedsettings.xml:

Code:

<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>192.1928.1.92</host>
        <port>33092</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    <name>xbmc_video</name>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>192.1928.1.92</host>
        <port>33092</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    <name>xbmc_music</name>
    </musicdatabase>
    <pathsubstitution>
     <substitute>
      <from>special://masterprofile/Thumbnails/</from>
      <to>smb://DISKSTATION/xbmc_thumbs/</to>
     </substitute>
</advancedsettings>

The xbmc.log I have posted here:

http://pastebin.com/PcLY6aCz

Very much thank you for any help :-)

[DigitalAnvil]

Your problem is probably your IP address here:
<host>192.1928.1.92</host>

That's not a valid IP address

(BTW 2 of my machines have win8, 2 have win7 and the rest are winxp....all on frodo and connecting to my synology boxes.... so it definately does work)

[jmedemar]

Also double check the port. Standard port is 3306. You could also delete the <name> lines, they are not required. See the advancedsettings.xml shown on the wiki.

http://tinyurl.com/832odes

[rocketpants]

you don't need to include the <substitute> section for Frodo (v12.0). The second tutorial you linked is based on Eden and things have changed since Frodo was released. The wiki has good instructions for getting mySQL to work (apart from setting up mySQL on the NAS).

[scott967]

Your log says it all:

Code:

16:48:07 T:2312   ERROR: Error loading special://profile/advancedsettings.xml, Line 23
                                            Error reading end tag.

So before you get any further, you need to check your advancedsettings.xml, which I can see:

Code:

<pathsubstitution>
     <substitute>
      <from>special://masterprofile/Thumbnails/</from>
      <to>smb://DISKSTATION/xbmc_thumbs/</to>
     </substitute>

You pathsubstitution element is not closed with a

Code:

</pathsubstitution>

But I think you need to fix your IP address and port as advised above. Did you create the xbmc user in phpMyAdmin with xbmc password and permissions set?

scott s.
.

[z9182]

Your problem is probably your IP address here:
<host>192.1928.1.92</host>

That's not a valid IP address

(BTW 2 of my machines have win8, 2 have win7 and the rest are winxp....all on frodo and connecting to my synology boxes.... so it definately does work)

Thanks very much for answerring

The '1928' is a typo on my part, it is not like that in the config file, in there it does say '192.168.1.92'.

---

Also double check the port. Standard port is 3306. You could also delete the <name> lines, they are not required. See the advancedsettings.xml shown on the wiki.

http://tinyurl.com/832odes

Thanks very much

In advancedsettings I use the standard port. I assume the Synology allows this (but I really don't know how to check if it doesn't). I used the wiki to try and set it all up, but because of probably a part of my brain refusing to function, I did not find the wiki to be completely clear

---

you don't need to include the <substitute> section for Frodo (v12.0). The second tutorial you linked is based on Eden and things have changed since Frodo was released. The wiki has good instructions for getting mySQL to work (apart from setting up mySQL on the NAS).

Thanks for your reply

I used the wiki, which referred me to the articles I posted.

My situation is MySQL on the Synology, not on a different server, so that is what I am aiming at getting to work

---

Your log says it all:

Code:

16:48:07 T:2312   ERROR: Error loading special://profile/advancedsettings.xml, Line 23
                                            Error reading end tag.

So before you get any further, you need to check your advancedsettings.xml, which I can see:

Code:

<pathsubstitution>
     <substitute>
      <from>special://masterprofile/Thumbnails/</from>
      <to>smb://DISKSTATION/xbmc_thumbs/</to>
     </substitute>

You pathsubstitution element is not closed with a

Code:

</pathsubstitution>

But I think you need to fix your IP address and port as advised above. Did you create the xbmc user in phpMyAdmin with xbmc password and permissions set?

scott s.
.

Thanks very much for your reply, Scott

I have my IP-adres fixed in the LAN (static IP), and I did create the xbmc-user in phpMyAdmin. I will change the config file for the substition right now

[z9182]

Your log says it all:

Code:

16:48:07 T:2312   ERROR: Error loading special://profile/advancedsettings.xml, Line 23
                                            Error reading end tag.

So before you get any further, you need to check your advancedsettings.xml, which I can see:

Code:

<pathsubstitution>
     <substitute>
      <from>special://masterprofile/Thumbnails/</from>
      <to>smb://DISKSTATION/xbmc_thumbs/</to>
     </substitute>

You pathsubstitution element is not closed with a

Code:

</pathsubstitution>

Nope I did change the pathsubstitution, but I still don't see any traffic on the MySQL-server. I've enabled debugging-logging, and I will post back tomorrow when it is done doing its thing

Thanks again to all extremely very much for assisting me in this matter; it *is* highly appreciated

[z9182]

I've got part of it working

I appears it was a combination of the missing / at the end of a line in advancedsettings.xml and:

<from>special://profile/Thumbnails/Video/ instead of MasterProfile.

So thanks for the suggestions all

So now I do have a nice SQL-database on the Syno, yet there are hardly any pics on the Syno in the thumbs-folder now.

Well, there are a couple, they are covers, but there are over 900 movies on the Syno that XBMC has indexed before (while it was still running on the separate HTPC's, so before I told it do 'it's stuff' ( :mrgreen: ) on the Syno), and only 162 covers. So my mission has not yet ended, it seems.

Thanks again

[impact39]

It looks like it wasn't the OP's issue in this case, but those setting up a centralized database on a Synology NAS should note MariaDB (open source MySQL app for Synology NAS) uses port 3307, not 3306 as indicated by many of the guides/instructions.

You need to adjust the advancedsettings.xml file to point to port 3307.