Creating user account on cBioPortal

[Aditi Gulati]

Hello,

I'm not able to create an account using keycloak. The command I'm using is:

/path/to/keycloak-5.0.0/bin/add-user-keycloak.sh -u <admin_user> -p <password>

After executing this command, I restart keycloak server using this command:

path/to/bin/standalone.sh -b <ipaddress> &

And that's the error I get:

13:52:19,237 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 60) Unique index or primary key violation: "UK_RU8TT6T700S9V50BU18WS5HA6_INDEX_B ON PUBLIC.USER_ENTITY(REALM_ID, USERNAME) VALUES ('master', 'bcnadmin', 2)"; SQL statement:

insert into USER_ENTITY (CREATED_TIMESTAMP, EMAIL, EMAIL_CONSTRAINT, EMAIL_VERIFIED, ENABLED, FEDERATION_LINK, FIRST_NAME, LAST_NAME, NOT_BEFORE, REALM_ID, SERVICE_ACCOUNT_CLIENT_LINK, USERNAME, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-193]

13:52:19,256 ERROR [org.keycloak.services] (ServerService Thread Pool -- 60) KC-SERVICES0010: Failed to add user 'bcnadmin' to realm 'master': user with username exists

Could someone please help?

Many thanks,

Aditi

[Benjamin Gross]

Hi Aditi,

Just looking at the snippet of error you sent, I see:

"Failed to add user 'bcnadmin' to realm 'master': user with username exists”

It appears that the user is already in the database.

Does the server start up after this error?  Can you access the web interface and login?

I’m not sure what procedure you are using to setup keycloak, but the one describe here is concise and easy to follow:

https://www.keycloak.org/getting-started/getting-started-zip

Let us know if you have any more questions.

-Benjamin

--
You received this message because you are subscribed to the Google Groups "cBioPortal for Cancer Genomics Discussion Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cbioportal+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cbioportal/3621ea17-b397-4275-858c-f2cae5a78d9cn%40googlegroups.com.

[Aditi Gulati]

Yes, that was it, thanks Benjamin.

Best,

Aditi