Ad Widget

Collapse

Unable to create an user (no password field)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dhl
    Junior Member
    • Mar 2014
    • 9

    #1

    Unable to create an user (no password field)

    Hey,

    I have a problem with creating a new user. The main thing is there is no password field.
    Authentication is set to LDAP, so this might be the cause of the problem, but I need to add some internal users.
    Zabbix is version 2.2.2. Postgre database is used.

    Error details are as following:

    "pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: duplicate key value violates unique constraint "users_pkey"
    DETAIL: Key (userid)=(283) already exists. [users.php:215 → CAPIObject->create() → CAPIObject->__call() → czbxrpc::call() → czbxrpc::callAPI() → call_user_func() → CUser->create() → DB::insert() → DBexecute() → pg_query() in /usr/share/zabbix/include/db.inc.php:536]

    Error in query [INSERT INTO users (alias,name,surname,passwd,url,autologin,autologou t,theme,refresh,rows_per_page,type,lang,userid) VALUES ('testuser','test','user','5fce1b3e34b520afeffb37c e08c7cd66','','0','900','default','30','50','1','e n_GB','283')] [ERROR: duplicate key value violates unique constraint "users_pkey"
    DETAIL: Key (userid)=(283) already exists.]

    SQL statement execution has failed "INSERT INTO users (alias,name,surname,passwd,url,autologin,autologou t,theme,refresh,rows_per_page,type,lang,userid) VALUES ('testuser','test','user','5fce1b3e34b520afeffb37c e08c7cd66','','0','900','default','30','50','1','e n_GB','283')"."
  • coreychristian
    Senior Member
    Zabbix Certified Specialist
    • Jun 2012
    • 159

    #2
    LDAP is what is preventing the password boxes from being set.

    You need to create a user group with with the 'Frontend access' set to 'internal auth'

    Then for the users you want internal (say an admin backdoor account for if LDAP is down), you create the user as a normal LDAP user, assign it to your Internal Auth group.

    Then after the user is created, you should be able to set/change the password through the user's page.

    Comment

    • dhl
      Junior Member
      • Mar 2014
      • 9

      #3
      Had a problem with database indexes. It's working now, though still we need to create user, add it to internal login users group and then edit user to give it a password.

      Asked Zabbix support for their opinion to make it clearer, as LDAP users really do not need to create internal password, but at the moment it needs double editing for internal users (first to create user and then edit the user to add a password).

      Comment

      Working...