Network Management

 View Only
Expand all | Collapse all

Lost Admin Password

This thread has been viewed 6 times
Nathan French

Nathan FrenchFeb 27, 2013 12:37 AM

  • 1.  Lost Admin Password

    Posted Feb 26, 2013 06:31 PM

    Hi Everyone,

     

    Is there anyway of resetting the admin password from a other user in the admin group.

    Or would we need to backup iMC databases, uninstall iMC and then reinstall iMC again?

     

    Thanks

     

    iMC 5.2

    Windows 2008 R2 x64


    #Passwordreset


  • 2.  RE: Lost Admin Password

    Posted Feb 26, 2013 08:15 PM
    IMC stores the password hash in the DB. If you've got DB access, you could try overwriting the hash with the hash of a known password


  • 3.  RE: Lost Admin Password

    Posted Feb 26, 2013 10:12 PM

    Thanks For that,

    Would you happen to know were and in which table that could be found?

     



  • 4.  RE: Lost Admin Password



  • 5.  RE: Lost Admin Password

    Posted Feb 27, 2013 12:37 AM

    Much Thanks.

     

    That Worked for iMC 5.2

     

     



  • 6.  RE: Lost Admin Password

    Posted Feb 27, 2013 03:57 PM

    Awesome! It's something that I've done in a lab, but it's nice to know that it works when it's really needed.



  • 7.  RE: Lost Admin Password

    Posted Mar 04, 2014 10:58 AM
    He,
     
    I just read your post,
    I have a similar problem.

    By mistake, the privileges of the administrator group have changed. So I have more access to the menu:
    system - operator management - operator group

    Is what I can find it?

    or how to restore db?

    Please help me!


  • 8.  RE: Lost Admin Password

    Posted May 13, 2014 08:19 AM

    CG46 did you find an answer? I have had a similar thing happen.  I can't access the site mentioned above so I am not sure where to look in the database.



  • 9.  RE: Lost Admin Password

    Posted May 13, 2014 03:26 PM

    config_db, tbl_plat_operator contains a list of usernames/passwords.

     

    I have seen this situation before, where people think that they've lost admin privileges, but it's because they're looking at the standby system. Do you have an active/standby setup?



  • 10.  RE: Lost Admin Password

    Posted May 14, 2014 03:56 AM

    Thanks for the reply and I will look at the database now.

     

    One question though how do I know if I have active/standby setup?



  • 11.  RE: Lost Admin Password

    Posted May 14, 2014 06:11 PM

    Well usually you know if you've installed either one or  two servers.

     

    Standby system has fewer menu options, and there's many things you can look at, but not change - exactly as you are describing.

     

    Look at the Deployment Monitoring Agent, and see if it's set up to use Auto Backup from the primary, with Auto Restore on the secondary.

     

     



  • 12.  RE: Lost Admin Password

    Posted May 15, 2014 03:40 AM

    Sorry I get what you mean now (Terminology) We only have the one server.  

     

    I have looked in that table and I can see the admin users and I am able to change settings and password hashes.

     

    However I am still in the situation where the admin users don't have full access to the system.

     

    I have a backup of the database before I upgraded, if I was to uninstall and then install V7 from scratch could I use the database backup or is the database modified in the upgrade?



  • 13.  RE: Lost Admin Password

    Posted May 15, 2014 03:52 AM

    Yes, the DB gets modified during upgrade.

     

    Depending on how important your data is/how much time and money you have, I would be looking at one of more of these courses of action:

     

    1/ Roll back the upgrade.

    2/ Log support case, or engage local technical resource to investigate

    3/ Dig deeper into the DB yourself, look at  what's going on with roles, etc. Check that system is not set to Auto-Restore.

    4/ Roll back the upgrade, and try upgrade again.



  • 14.  RE: Lost Admin Password

    Posted May 15, 2014 04:29 AM

    Thanks for getting back so quick.

     

    I have a case logged with HP however they seem very slow to even come back to acknowledge me.

     

    We are a School so money is an issue we were very lucky to get iMC .

     

    I have checked and "enable auto backup and recovery" is not checked.

     

    My iMC install is on a VM so I think I will go to an earlier snapshot.  Shame I really wanted to understand what had happened



  • 15.  RE: Lost Admin Password

    Posted May 15, 2014 04:38 AM
    I'd like to know what's happened too! But yeah, sometimes it's better to take the path of least resistance.

    In classic computer engineering style, roll back, run the upgrade again, and see if it works this time. (Yeah, not a lot of help, I know).

    If you want to, you could keep a separate clone of the broken system, for further digging later.


  • 16.  RE: Lost Admin Password

    Posted May 15, 2014 05:13 AM

    Thats is exactly what I have done saved a vm to put in a test enviroment.

     

    I have restored a snapshot and all is fine however I am back on 5.2 so I will now try again.



  • 17.  RE: Lost Admin Password

    Posted May 15, 2014 05:20 AM

    One thing I forgot to mention - if you aren't already doing it, go straight to 7.0 E0202. Good thing is you don't need to go to 7.0 base + patch.



  • 18.  RE: Lost Admin Password

    Posted May 15, 2014 05:36 AM

    Thanks downloading now I will update how its goes this time.