OHDSI/Arachne

Data node admin password truncated upon setup

anthonysena opened this issue · 2 comments

After starting up Arachne via Docker, I was unable to log in with the default credentials. I connected to the Docker container running PostgreSQL and found that the password was truncated. See below:

arachne_datanode=# SELECT password FROM users;
 password
----------
 $2a$10
(1 row)

Updating the password fixes the issue:

arachne_datanode=# \x
Expanded display is on.
arachne_datanode=# SELECT password FROM users;
-[ RECORD 1 ]----
password | $2a$10

arachne_datanode=# UPDATE users SET password = '$2a$10$JrltmCF6zqvfdpZTYOTM0uByU1Cx9C3X0x0iRQFqlXX3bTOEsWJae' where id = 1;
UPDATE 1
arachne_datanode=# SELECT password FROM users;
-[ RECORD 1 ]----------------------------------------------------------
password | $2a$10$JrltmCF6zqvfdpZTYOTM0uByU1Cx9C3X0x0iRQFqlXX3bTOEsWJae

The password's hash is passed incorrectly from the env file via docker-compose.
https://docs.docker.com/compose/environment-variables/env-file/#syntax

Fixed by pull request #39
"password" --> 'password'