1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Setting user admin permissions via mysql tables?

Discussion in 'XenForo Questions and Support' started by steven s, Aug 6, 2011.

  1. steven s

    steven s Well-Known Member

    We are working with a company to develop our new forum.
    Currently I have mod rights in our test forum.
    I imported my vB forum to the database server and now want to test the import.

    Is there way for me to set my permissions so I have admin access to run the import?
    I have access to the database and root passwords.
    I don't want to wait until Monday for my access.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. steven s

    steven s Well-Known Member

    Thanks.
    According to the other thread, everything is set correctly. Also cleared cache and cookies to be on the safe side. I still appear as moderator.
    Added myself as superadmin.

    Can't see usernames or the import under tools. ??
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Have you made yourself an administrator and added the necessary permissions?
     
  5. steven s

    steven s Well-Known Member

    The current admin says he made me an admin.
    I added myself as a superadmin in the config file.

    user.is_admin = 1 as it should.
    I'm listed in the xf_admin.user_id

    I cleared cache and cookies. Logged back in.
    Usergroup says moderator as it did before.
    There may be permissions I don't see.
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Do you appear in the list when you click on Users -> Administrators?

    If so, are you able to see what your permissions are by clicking on your name?
     
  7. steven s

    steven s Well-Known Member

    That's the thing. I don't see anything that I would expect expect that and the couple of tables I checked look correct.

    screen.png
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    In which case your permission set is quite limited.

    You need to ask the super admin to change it.
     
  9. steven s

    steven s Well-Known Member

    Can I do that through the tables?

    my xf_admin.extra_user_group_ids = 332c342c35
    User 1 is = 33

    xf_user.secondary_group_ids = 332c342c35
    User 1 = 332c34

    xf_user.permission_combination_id = 10
    User 1 = 7
     
  10. Brogan

    Brogan XenForo Moderator Staff Member

    I'm not sure how to do it directly on the DB as the permission_cache field is a long string of digits relating to the actual permission set.
     
  11. Luke F

    Luke F Well-Known Member

    How can you have database access but not full admin permissions?
     
  12. steven s

    steven s Well-Known Member

    Because we have a web development company creating a single sign on with another database and they are incorporating our site design in the footer and header of xenforo.
    I now have the admin's login and password. The problem with my permissions might have something to do with the single sign on.
     

Share This Page