How can I initialize the user db?

Camunda 7 Topics Discussion & Questions
,
1

I’m deploying camunda to a new qa environment for the first time from the camunda docker image. I have removed the invoice and examples. I tried to initialize the user db by copying the pattern from https://github.com/camunda/camunda-bpm-dropwizard/blob/77d04fbdc10064bebe4674e8156a027b7a6f27b4/examples/camunda_mysql.sql

E.g. INSERT INTO ACT_ID_USER (ID_, REV_, FIRST_, LAST_, EMAIL_, PWD_, PICTURE_ID_) VALUES
(‘brent.fisher@taulia.com’, 1, ‘Brent’, ‘Fisher’, ‘brent.fisher@taulia.com’, ‘{SHA}ieSV55Qc+eQOaYDRSha/AjzNTJE=’, NULL),
…
INSERT INTO ACT_ID_GROUP (ID_, REV_, NAME_, TYPE_) VALUES
(‘wcm’, 1, ‘Working Capital Management’, ‘WORKFLOW’),
(‘camunda-admin’, 1, ‘camunda BPM Administrators’, ‘SYSTEM’);
…
INSERT INTO ACT_ID_MEMBERSHIP (USER_ID_, GROUP_ID_) VALUES
(‘brent.fisher@taulia.com’, ‘camunda-admin’),
…
INSERT INTO ACT_RU_AUTHORIZATION (ID_, REV_, TYPE_, GROUP_ID_, USER_ID_, RESOURCE_TYPE_, RESOURCE_ID_, PERMS_) VALUES
(‘aff5ea53-8f8c-11e4-a486-0a0027000000’, 1, 1, NULL, ‘brent.fisher@taulia.com’, 1, ‘brent.fisher@taulia.com’, 2147483647), // identity brent.fisher@taulia.com has all permissions [MAX_VALUE:2147483647] on resource type 1 [User] and resource ID brent.fisher@taulia.com
…
(‘affe27ba-8f8c-11e4-a486-0a0027000000’, 1, 1, ‘camunda-admin’, NULL, 2, ‘camunda-admin’, 2),
(‘afffd56b-8f8c-11e4-a486-0a0027000000’, 1, 1, ‘camunda-admin’, NULL, 0, ‘’, 2147483647),
(‘b000e6dc-8f8c-11e4-a486-0a0027000000’, 1, 1, ‘camunda-admin’, NULL, 1, '’, 2147483647),
(‘b0021f5d-8f8c-11e4-a486-0a0027000000’, 1, 1, ‘camunda-admin’, NULL, 2, ‘’, 2147483647),
(‘b00309be-8f8c-11e4-a486-0a0027000000’, 1, 1, ‘camunda-admin’, NULL, 3, '’, 2147483647),
(‘b0041b2f-8f8c-11e4-a486-0a0027000000’, 1, 1, ‘camunda-admin’, NULL, 4, ‘’, 2147483647),
(‘b00553b0-8f8c-11e4-a486-0a0027000000’, 1, 1, ‘camunda-admin’, NULL, 5, '’, 2147483647),

I tested this locally and it seems to work. On my qa environment, it doesn’t seem to work. I get
Login Failed : Wrong credentials or missing access rights to application

Before I created these tables, it prompted me to set up the users.
After this failed, I attempted to DELETE these tables and get back to that, and that fails too.

What can I do?

2

Hi @pescador_bob,

The db script looks okay so far.

I assume that you tried to login with the following credentials:
user id: brent.fisher@taulia.com
password: demo

Is that correct?

Have you tried to use this to set up an admin user? Could you login into the webapps with this user?

What does fail? The set up of an admin user or the login?

Cheers,
Roman

3

What ended up happening is that we went from green to blue, but I wasn’t aware, so everything I was doing was to the wrong system. Nevermind.