I try to create a new user by a insert in JIra DB cwd_user table. I see the user into Jira User Management Panel but it seems unable to be logged in.
It also misses information like directory and full name.
This is INSERT QUERY:
INSERT INTO cwd_user (ID,directory_id,user_name,lower_user_name,active,created_date,updated_date,first_name,lower_first_name,last_name,lower_last_name,display_name,lower_display_name,email_address,lower_email_address,CREDENTIAL,deleted_externally,EXTERNAL_ID) VALUES (11620,1,'utest','utest',1,now(),now(),'utestnome','utestnome', 'utest gmail','utest gmail','utente utest gmail', 'utente utest gmail','utest@gmail.com','utest@gmail.com','{PKCS5S2}C850oEnhKd/VvsSCOAH395xN3cKNiYTWM8wn/vi4Fiud1wLXvupc1a+VwIuk37uy',NULL,NULL);
Thanks
Why would you add a user through SQL statement? You should not do it. If you want to add a user, a simple way to do it is to use Jira Rest Api
POST /rest/api/2/user
You can find more information here
https://docs.atlassian.com/software/jira/docs/api/REST/1000.1568.0/#api/2/user
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.