You can also use the clean_auth.php script in utils. You will have to edit the top of the file where the DB is defined.
Javier Kory wrote: > Dear all, > > I messed up the admin privilege. Anybody knows how to retrieve the full > control of the admin user once again? As you will see, I change the > Host/System/User administration to “NO”. Supposedly, I was adding a new > account and I accidentally changed the admin instead. > > > Thanks, > Gerard > > Gerard, > > In mysql you could issue the following commands" > > use jffnms; > update profiles set value = "6" where profiles_option="8" and userid="2"; > update profiles set value = "32" where profiles_options="14" and userid="2"; > update profiles set value = "34" where profiles_options="15" and userid="2"; > > this would give the user with id 2 admin privileges. This should be the > "admin" user as long as your database is numbered as mine is (I did a by the > book install so it should be good). You can check to see if the numbers are > right by running: > > select * from auth where usern="admin"; > > your if your admin user has a different id than what I have above you'll > probably want to check the rest of the numbers as well. > But I think you should be good with the numbers I have. You can also dig > around in the profiles, profiles_options and the profiles_values tables and > match the values with the options and put the values in the profiles table > for the user id that matches the admin user. > > Your other option is to look through the docs/jffnms-0.8.2.mysql file and > look for the commands that make the add the admin user and give it the > privileges, delete the admin user and re-add it with those commands. > Something like: > > Delete from auth; > Delete from profiles > > INSERT INTO auth VALUES (1,'No > User','$1$txVdymrd$AO3Qa8js9lVNkyscQ552b1','No User > Name',0),(2,'admin','adpexzg3FUZAk','Administrator',0); > > INSERT INTO profiles VALUES > (1,1,1,1),(2,2,9,12),(3,2,11,300),(4,2,13,30),(5,2,16,36),(6,2,20,46),(7,2,2 > 5,50),(8,2,2,8),(9,2,8,6),(10,2,14,32),(11,2,15,34),(12,2,6,20); > > Hope this helps and good luck, > > Kory > -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED] I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
