Get your own customer support community
 

Multiple users, one library

Ok. The iPhone app is awesome, and kudos on switching the details display back to the right-hand position. I'm really happy about both.

What I could use now is some help in setting it up so that my wife and I can both read and write to the same library database from our separate computers. I don't want to just be able to publish the database and have her be able to see it, I want her to also be able to add books from her computer.

I understand that we could screw things up if we both go into the database at the same time. Let us worry about that. Just please tell me how I need to set up the links. Thanks!

(I hope this will be an official enhancement in future releases now that the more critical iPhone project is done. I doubt I'm the only person who wants multiple full users on a shared database.)

PS -- Yes, I'll buy a second copy of the software. This isn't about saving money, it's about having a shared library database. I'm delighted to support you guys. But please help me out on this one.
Inappropriate?
3 people have this question

  • Stu Wilson
    Inappropriate?
    c) you don't need to buy a second license, they allow you to run on a few machines with the one licence, cool huh?

    so how do I do this thing, well its complicated and it's not... first thing I would do is make a backup of any existing libraries on your accounts.

    you then need to decide where you are going to put the shared library, personally I'd advocate /Users/Shared, but it's entirely up to you, but wherever you put it, you will need to make sure that everyone has read/write permissions to the files, but more on that later.

    so lets try this, you will need to use terminal.app to get this working so if you are not very technical, then please be aware that everything you will type will be case sensitive and that the orientation of any slashes \ or / will be very important:
    1) choose one of your libraries to be the master library, this will be moved to the shared location to become your new shared library. We will actually be moving the whole folder not just the library in the folder.

    in terminal.app, type the following followed by enter

    pwd

    this should return a path such as mine
    /Users/stuwilson

    cd "Library/Application Support"
    pwd

    this should return the path as (obv not stuwilson unless spookily you are also called stuwilson) :p
    /Users/stuwilson/Library/Application Support

    ok we are good to go:

    cp "Delicious Library 2" /Users/Shared
    cd /Users/Shared
    sudo chown -R root:wheel "Delicious Library 2"
    sudo chmod -R 777 "Delicious Library 2"

    this has copied your library to the /Users/Shared folder, changed the owner and then added read/write permissions so that everyone on your machine can access it.

    ok here the last bit, making the symbolic link so that it hangs together:
    for each user that needs access to the shared library, login to that user, and open terminal.app

    *******************************************
    PLEASE NOTE, this will DESTROY any existing Library for that user, so if you have data EXPORT IT FIRST, then close Delicious Library, or it wont work
    *******************************************
    type the following very carefully (this is all on one line):

    ln -sF "/Users/Shared/Delicious Library 2/Delicious Library Items.deliciouslibrary2" "Library/Application Support/Delicious Library 2/Delicious Library Items.deliciouslibrary2"

    And that's it, however you may want to check thats it's worked first...

    type the following:

    file "Library/Application Support/Delicious Library 2/Delicious Library Items.deliciouslibrary2"

    will return
    Delicious Library Items.deliciouslibrary2: SQLite 3.x database

    but if it returns

    ...broken symbolic link to Delicious Library 2/Delicious Library Items.deliciouslibrary2

    then its all gone pear-shaped.

    DISCLAIMER: If you lose your data with this, neither myself nor any person living or dead except you are at fault, srsly, this isn't hard to do but can be prone to errors for Unix n00bs.

    make backups before you do any of this, if you don't and it goes pear-shaped, well sorry.

    Restoring any backups is simply a matter of copying the original folders back to the Library/Application Support folder.
     
    happy I’m tired after all that
  • jmsaul
    Inappropriate?
    Wow. Thank you! I actually can follow that, I'm comfortable with the Unix command line.

    Will that work if it's two different, networked, computers? That is, I have the LIbrary file on mine and my wife is accessing it from hers?
     
    happy I’m thankful
  • Stu Wilson
    Inappropriate?
    I see no reason why it wont work, however there would be issues if the machine with the Library wasn't on obv.

    personally, i'd use automount, there's a nice page here describing it:
    http://sial.org/howto/osx/automount/

    the main caveats to that are the UID and GID must match on the two machine, but generally, root and wheel are the same, but I'd check first.
     
    happy I’m confident
User_default_medium