Announcement

Collapse
No announcement yet.

how to reset the Admin password without gui access

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

    how to reset the Admin password without gui access

    The title says it all. Its zabbix 1.8. Thank you. I know it must be a database command, but, not familiar enough with mysql to do it.

    #2
    In the user table set the password for the admin user to blank. Then you can log in without a password, however you will need/want to change it to something with a password quickly. :-D
    RHCE, author of zbxapi
    Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
    Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

    Comment


      #3
      Hi

      Our sysadmin left and I have to get into zabbix and try to get access to the super user

      In the user table I set the password for the admin user to blank

      update users set passwd='' where name='Zabbix';

      mysql> select name, alias, passwd from users where name='Zabbix';
      +--------+-------+--------+
      | name | alias | passwd |
      +--------+-------+--------+
      | Zabbix | Admin | |
      +--------+-------+--------+

      I restarted zabbix : ./zabbix_agentd stop; ./zabbix_agentd start

      However, when trying to log in, I get

      ERROR: Login name or password is incorrect

      I would appreciate any help. Is there some logging I can turn on to see what is happening

      Thank you

      Comment


        #4
        Fortunately for me I was just at install so I dropped the database and re-created it from scratch.
        However, Mysqladmin makes sure the password is encrypted. I using RHEL5, with 5.0 of mysql.
        From the linux shell as the root user,

        mysqladmin -u <user> password '<new_password>'
        mysqladmin -u <user> -h <host> password '<new_password>'

        Comment


          #5
          Thank you for your reply.
          But this would be for the mysql user
          I am actually trying to reset the zabbix admin/super user password
          And this does not work for me

          Comment


            #6
            Go to www.mysql.com and do a search for Mysql 5.0 Manual...
            thats about as much as I can do.

            Comment


              #7
              update zabbix.users set passwd=md5('mynewpassword') where alias='Admin';
              Zabbix 3.0 Network Monitoring book
              Zabbix tips and inspiration (blog)

              Comment


                #8
                cool. it works. Thanks a lot
                I had to restart the web server as well

                Comment


                  #9
                  Help password

                  I've just upgraded to 1.8.1 from 1.1.
                  Can't connect... This SQL statement works, but I still can't connect...

                  Comment


                    #10
                    Hi All,

                    Please help I will need to do the same for Oracle environment....

                    Thanks!

                    Comment


                      #11
                      aic, have you tried any of the above?
                      RHCE, author of zbxapi
                      Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
                      Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

                      Comment


                        #12
                        on a sidenote: shouldn't the password be salted in the database?
                        Free and Open Source Zabbix Templates Repository | Hosted Zabbix @ Tribily (http://tribily.com)

                        Comment


                          #13
                          Hi nelsonab,

                          Actually, I didn't tried the options suggested above because I am using Oracle Database instead of MySQL.

                          I fixed this issue applying the default hash (password) for Admin user.

                          Anyway, thanks for your reply!

                          Have a good week.

                          Comment


                            #14
                            Originally posted by aic View Post
                            Hi nelsonab,

                            Actually, I didn't tried the options suggested above because I am using Oracle Database instead of MySQL.

                            I fixed this issue applying the default hash (password) for Admin user.

                            Anyway, thanks for your reply!

                            Have a good week.
                            Hi,
                            I use oracle database,and use update users set passwd=hash(password) where name='zabbix';
                            but oracle error is not hash,pls help,how are you doing?THKS!

                            Comment

                            Working...
                            X