Admin Lockout

[kkuhl]

We recently, with the open source Sugar CRM, did a mass update on all of our CRM users including the admin by mistake (yes bad i know ). I was wondering if there is any way to get back admin rights to the admin user by manipulation or something of the sort, or if the only way to fix this problem is to perform a reinstall. Thanks!
-Kevin

[susiewilliams]

Hi there,

Do you know how to log in to your MySQL (or MSSQL) database? If so, you could update the record directly to restore it to its correct state.

[kkuhl]

Hi there,

Do you know how to log in to your MySQL (or MSSQL) database? If so, you could update the record directly to restore it to its correct state.

I do know how to get in to mysql and update / change records, however I'm not sure what exactly would need to be changed and where to locate it as I am not familiar with the structure. My coworker, who set the system up is away at the moment. Could you provide some insight?

[Markku]

Please see this thread:
http://www.sugarcrm.com/forums/showthread.php?t=23259

[kkuhl]

Re-adding the admin user record will have restore all original permissions to the admin account? Of course, re-writing the data will almost surely do this, just wanting to make sure!

[kkuhl]

Awesome guys, got it taken care of, thanks so much for the help!

[andydreisch]

kkuhl, did you do the INSERT after all?

Andy

[kkuhl]

Yes we did, it worked fine. Thanks!