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')"."
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')"."
Comment