1
happynewyear
How to reset permissions

Just reset password ... thx for the help
Now I need to reset permissions to admin because I accidently deleted them.

2
happynewyear
Re: How to reset permissions

Hello XOOPS Support!

Having a problem on one of two XOOPS sites. A few weeks ago, someone uploaded porn on one site, so when i changed permissions in groups i accidently deleted my admin permissions. Instead of reinstalling a whole new site, is there a way to go in through php myadmin or sql or some way to restore admin/webmaster permissions? Thank you in advance for your help.

3
trabis
Re: How to reset permissions
  • 2009/1/9 21:06

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Try going to phpMyadmin and dump this lines into database
INSERT INTO `yourprefix_group_permission` (`gperm_id`, `gperm_groupid`, `gperm_itemid`, `gperm_modid`, `gperm_name`) VALUES
(1111'module_admin'),
(
2111'module_read'),
(
5111'system_admin'),
(
6121'system_admin'),
(
7131'system_admin'),
(
8141'system_admin'),
(
9151'system_admin'),
(
10161'system_admin'),
(
11171'system_admin'),
(
12181'system_admin'),
(
13191'system_admin'),
(
141101'system_admin'),
(
151111'system_admin'),
(
161121'system_admin'),
(
171131'system_admin'),
(
181141'system_admin'),
(
191151'system_admin');


Don't forget to change 'yourprefix' to the correct prefix.
This are the default values for a XOOPS 2.3 installation so, if they were deleted, you will be able to insert them again.

Perhaps is better if you have a look first to see what values were deleted, and the insert the missing ones.

4
happynewyear
Re: How to reset permissions

hi. thank you. just looked all through php myadmin & could not find anything that said 'permissions' ... even with the cute little SEARCH magnifying glass. AND that was on the working site.

any idea WHERE to find group permissions? thank you. ciao

5
ghia
Re: How to reset permissions
  • 2009/1/10 9:05

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


The group_permission is a table in the database used by XOOPS. The tables have a name with a prefix, so they look as xxxxx_group_permission, where xxxxx can be anything form XOOPS to y5677.

6
happynewyear
Re: How to reset permissions

thank you for your replies. still can't find group_permissions in php myadmin
and i've looked in most logical places including:
groups
groups blocks
groups modules
groups users

as well as 'users,' which is the list of reg users info

i wish i could find the main INDEX folder & just hand code it back in
at least the password problem was easy to fix ... hopefully someone in SUPPORT will know how to help fix this ... thank you to all

7
happynewyear
Re: How to reset permissions

PS -- Should I just dump the above lines 'code' into groupid? What's the worst thing that could happen?

8
ghia
Re: How to reset permissions
  • 2009/1/11 14:27

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


I'm not sure if we are on the same wavelength.
So, for clarity: phpMyAdmin is a program to explore the MySQL database on your server.
group_permission is the (partial) name of a table in your database. Two other tables have also group in their name:
groups and groups_users_link.

9
happynewyear
Re: How to reset permissions

sorry. i'm an uber newbie with only one web design class to boast. i'll keep looking for group_permissions in the database. i can see where the problem is when i look at VIEW & VIEW SOURCE [because both sites are the almost the same], but can't seem to locate the main index file(s) -- where i was taught everything is written. merci

10
ghia
Re: How to reset permissions
  • 2009/1/12 9:24

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Quote:
i'll keep looking for group_permissions in the database. i can see where the problem is when i look at VIEW & VIEW SOURCE
I don't know what you are doing or what kind of admin panel you have for your site (I guess it is not cPanel), but it seems to me that that 'VIEW & VIEW SOURCE' is a kind of file manager (or is this via FTP?), to be used to inspect the directories of your site and to look (and edit(?)) at the source of your html and php files.
This is not the way for looking into the database!
Therefore you need an MySQL database explorer program as eg phpMyAdmin. It allows you, to view the database its structure and the records of the tables in the database.

What kind of hosting do you have and which programs or functions are you using?

Login

Who's Online

170 user(s) are online (85 user(s) are browsing Support Forums)


Members: 0


Guests: 170


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits