Re: [campsite-support] Importing Users from another database
  • Vote Up0Vote Down importimport
    Posts: 0Member
    Hi,

    What encryption algorithm did you use to create the account ? Should be SHA1.


    On Wed, Apr 21, 2010 at 11:08 AM, wrote:
    > Author: Terix
    > Link:
  • 3 Comments sorted by
  • Vote Up0Vote Down importimport
    Posts: 0Member
    I've created the account using a local installation of campsite, and the hash of other already existing accounts match together, so i can suppose it's the same encryption algorithm.
  • Vote Up0Vote Down importimport
    Posts: 0Member
    Terix,

    Hash is ok. Fine. Now... you have to update some other tables... but
    as you are doing db changes by hand you have to be careful. You need
    to:

    1- Create the enty in liveuser_users for the new user (you already did it)

    2- Create a new entry for the user in the permission users table:
    liveuser_perm_users
    Some like this:
    INSERT INTO liveuser_perm_users VALUES (3, 3, 'DB', 1);

    Where first value is a sequence, second one is the user id from
    liveuser_users table, third and forth remain like above.

    3- Create an entry in liveuser_groupusers table. There you relate
    user to group (user type). Like this:
    INSERT INTO liveuser_groupusers VALUES (3, 1);

    Where first parameter is perm_user_id from liveuser_perm_users table
    and second parameter is group_id from liveuser_groups table.

    4. Now, as liveuser tables uses sequence tables, you must updated by
    hand, otherwise you will be in trouble when creating new accounts.
    Those tables are:

    liveuser_users_auth_user_id_seq and liveuser_perm_users_perm_user_id_seq

    5- Now is time to log into admin interface as admin user and
    "Synchronize Campsite and Phorum users"

    That is it, now your new user is a valid one and it can log into the system.

    As you can see is kind of messy, so we highly recommend you to fix the
    accounting management via admin UI.
    I am wondering what's wrong with that, what kind of error message you
    get when creating/editing an account?

    Please take a look at the sequence tables and set proper values there.
    Then try again creating an account.

    Hope this helps.


    On Wed, Apr 21, 2010 at 11:45 AM, wrote:
    > Author: Terix
    > Link:
    Vote Up0Vote Down importimport
    Posts: 0Member
    Hi holman,

    thank you a lot for your guide. I was able to make a new acocunt by hand as succesfully login with it. during the procedure i found that the user sequence was wrong (it was 20, when it had to be 6), then i've set it to 7 when i made the new account. Unfortunately, campsite is still blocking me from adding new users. the message that i get is "The user account could not be created." with no more details, and i'm going nuts to find what is going wrong. The weird thing is that the database works fine if i put it on another campsite installation (the one on my development server), so i doubt that it's a DB issue (but who ever knows). There is any way to get a more explicit error message? How can i pinpoint what is going wrong?
Add a Comment