• 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?

steven s

Well-known member
#1
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.
 

steven s

Well-known member
#3
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. ??
 

steven s

Well-known member
#5
Have you made yourself an administrator and added the necessary permissions?
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.
 

Brogan

XenForo moderator
Staff member
#6
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?
 

steven s

Well-known member
#7
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?
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
 

Brogan

XenForo moderator
Staff member
#8
In which case your permission set is quite limited.

You need to ask the super admin to change it.
 

steven s

Well-known member
#9
In which case your permission set is quite limited.

You need to ask the super admin to change it.
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
 

Brogan

XenForo moderator
Staff member
#10
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.
 

Luke F

Well-known member
#11
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
How can you have database access but not full admin permissions?
 

steven s

Well-known member
#12
How can you have database access but not full admin permissions?
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.