Problems using shared MySQL database

Rich rich at
Wed Nov 22 10:26:56 UTC 2006

Guðlaugur Jóhannesson wrote:
> I am trying to set up a shared MySQL database so I can have the same ratings 
> wether I listen on the desktop or the laptop.  It was working perfectly, I 
> shared the music library through NFS on my lan and through sshfs when on the 
> run.  Then all of a sudden (I have no recollection of what made this happen 
> since I do not use amarok daily and have been going through many upgrades and 
> changed laptops) it stopped working.  I let the desktop build the database 
> and then point the laptop to the very same database, using the same 
> authentication.  That used to give me a collection on both machines, but now 
> it only gives the collection on the desktop.  
> In trying to debug this, I let the laptop build the database yesterday and 
> found that it created a collection that did not interfere with the desktops 
> collection.  After looking at the database, I gather that the songs are 
> stored in the table uniqueid.  In that table there is a column named deviceid 
> that currently has two values in my case.  What is the purpose of this 
> column, and why are all my songs listed twice now?

this probably happens because of dynamic collection (starting from 1.4.2).

now your solutions could be either using same protocol (and server, and 
local mountpoint) for all machines, or disabling dynamic collection.

More information about the Amarok mailing list