Problems using shared MySQL database

[Rich]

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).
http://amarok.kde.org/wiki/Dynamic_Collection

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