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 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.0/306 - Release Date: 4/9/2006 ------------------------------------------------------- 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
