This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JForum and the fly likes Lost admin Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Lost admin" Watch "Lost admin" New topic
Author

Lost admin

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
It seems like I've changed my admin users priviliges to non-admin. I log in as adamin but I cant get to the admin pages. Any way to recover from this? * Some days it's just not worth getting out of bed
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
The easier way is to remove all roles and set them again. Do the following in some mysql ( or postgresql ) client":





then get the Admin user_id:



and then make sure the user is in the administrators group. The table is "jforum_user_groups". So, if the Admin user id is 2, you must have an entry like



this should return "2" and "2".

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Perfect! Thanks!
[originally posted on jforum.net by Anonymous]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Lost admin
 
Similar Threads
deploying axis service on ssl
2 Managed server instances
Devaka's simulator propblem with installation
Portals and Portlets
RAD 7.5 Installation issues