Ad Widget

Collapse

Zabbix 1.4.6: User 'Admin' deleted. How to recreate a new Admin?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Junior
    Junior Member
    • Feb 2011
    • 2

    #1

    Zabbix 1.4.6: User 'Admin' deleted. How to recreate a new Admin?

    Hello, Im a new Zabbix-User and I have a Problem with Zabbix 1.4.6. When I insert Systems into my Zabbix, the 'Admin' account was deleted unintentionally. So I have tried to create a new Admin in my SQL and granted all to this user. But it doesnt work in Zabbix What do I have to do that the 'admin' has admin privileges?
  • Junior
    Junior Member
    • Feb 2011
    • 2

    #2
    push....

    Comment

    • marcel
      Senior Member
      Zabbix Certified Specialist
      • Oct 2010
      • 112

      #3
      Code:
      mysql> select * from users where alias="Admin";
      +--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+-------------+----------------+----------------+---------------+---------------+
      | userid | alias | name   | surname       | passwd                           | url | autologin | autologout | lang  | refresh | type | theme       | attempt_failed | attempt_ip     | attempt_clock | rows_per_page |
      +--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+-------------+----------------+----------------+---------------+---------------+
      |      1 | Admin | Zabbix | Administrator | 2ca9230cbea06b0f28d0b46f7fa5c6ea |     |         0 |        900 | en_gb |     130 |    3 | default.css |              0 | 95.102.240.167 |    1292784915 |           400 | 
      +--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+-------------+----------------+----------------+---------------+---------------+
      Code:
      mysql> select * from users_groups where userid="1"
          -> ;
      +----+----------+--------+
      | id | usrgrpid | userid |
      +----+----------+--------+
      |  1 |        7 |      1 | 
      +----+----------+--------+
      1 row in set (0.00 sec)
      Code:
      mysql> select * from usrgrp where usrgrpid=7;
      +----------+-----------------------+------------+--------------+------------+------------+
      | usrgrpid | name                  | gui_access | users_status | api_access | debug_mode |
      +----------+-----------------------+------------+--------------+------------+------------+
      |        7 | Zabbix administrators |          0 |            0 |          0 |          0 | 
      +----------+-----------------------+------------+--------------+------------+------------+
      1 row in set (0.02 sec)

      Replace Admin password with pass from a different user.
      Zabbix Certified Specialist for Large Environments since 12/2010

      Comment

      Working...