problem with music library when using SQL
#1
I have just installed as the wiki the SQL on my main maching and then synced the library on 2 other machines. All great on TV and Movies however whether I import or rescan my music library remains empty. If I remove the Advancedsettings on the host machine and rescan it works fine.

on a seperate note is there any way to scan just the movie posters on the remote machines as syncing the thumbnails proved to slow the interface down somewhat.

thanks
Reply
#2
after trawling through a few posts I think I may have found the problem with the music library:

It looks like the wiki is wrong as when I follow the detail from the following:

http://forum.xbmc.org/showthread.php?tid...ry&page=26

namely using the following text in advancedsettings :

for video database…
<videodatabase>
<type>mysql</type>
<host>192.168.0.10</host>
<name>xbmc_video</name>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

for music database…
<musicdatabase>
<type>mysql</type>
<host>192.168.0.10</host>
<name>xbmc_music</name>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>

it seems to work!

just the movie posters now?
Reply
#3
tytherman Wrote:after trawling through a few posts I think I may have found the problem with the music library:

It looks like the wiki is wrong as when I follow the detail from the following:

http://forum.xbmc.org/showthread.php?tid...ry&page=26

namely using the following text in advancedsettings :

for video database…
<videodatabase>
<type>mysql</type>
<host>192.168.0.10</host>
<name>xbmc_video</name>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

for music database…
<musicdatabase>
<type>mysql</type>
<host>192.168.0.10</host>
<name>xbmc_music</name>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>

it seems to work!

just the movie posters now?

I don't think the wiki is wrong, there are just two different examples. The first is connecting the video database to a mysql server, the second is connecting the music database to an sqlite file. Both examples are interchangable. As you've discovered, if using mysql for both database just duplicate the format but change the database name and the <videodatabase> tag to <musicdatabase>. The wiki is meant more as an example of the 2 different ways to do it.

This page on the wiki is a more detailed guide on how to sync data across XBMC instances. It includes sections on the thumbnails and fanart too.

http://wiki.xbmc.org/index.php?title=HOW..._libraries

update: I did edit the wiki page to explain the examples a little better to avoid this issue in the future.
Reply

Logout Mark Read Team Forum Stats Members Help
problem with music library when using SQL0