admin and password do not work

[avzamal]

Hello!

I have the same issue with admin login as in previous issue. When I set up the docker container and try to log into the localhost::8080 it says that that the user name and password admin and password are incorrect.

What are the correct credentials?

Thank you in advance!

[lukasmueller]

The best way is to change the default password. Log into the docker and then access the database using psql. psql -h breedbase_db -U postgres breedbase then: begin; set search_path=sgn; update sgn_people.sp_person set password=crypt('your password here', gen_salt('bf')) where username = 'admin'; commit; It is also recommended to change the default name of the database, breedbase, to something else. cheers Lukas

…

________________________________ From: Aleksei Zamalutdinov ***@***.***> Sent: Tuesday, May 14, 2024 7:48 AM To: solgenomics/breedbase_dockerfile ***@***.***> Cc: Subscribed ***@***.***> Subject: [solgenomics/breedbase_dockerfile] admin and password do not work (Issue #50) Hello! I have the same issue with admin login as in previous issue. When I set up the docker container and try to log into the localhost::8080 it says that that the user name and password admin and password are incorrect. What are the correct credentials? Thank you in advance! — Reply to this email directly, view it on GitHub<#50>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AAAV7F63KZEBWCXUEVTUOPLZCH22HAVCNFSM6AAAAABHWAMAL2VHI2DSMVQWIX3LMV43ASLTON2WKOZSGI4TKMRRGM4DINY>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[avzamal]

Dear Lukas, thank you for your suggestion!

I tried it, but it doesn't helped

I checked the structure of the table and sgn_people.sp_person do not have user 'admin'

Is it possible to create admin user or give his rights to any other new user?

[lukasmueller]

it loaded the test database instead of the empty database. I will check and see why

[lukasmueller]

From which repository did you download the code?

[avzamal]

I followed this repo and used "Using docker compose" part for installation as described. The only difference is the change in sgn_local.conf: instead of "dbuser web_usr" I wrote "dbuser postgres" and mounted this file to docker container in docker-compose volume section
"- type: bind
source: ./sgn_local.conf
target: /home/production/cxgn/sgn/sgn_local.conf "
It solved the issue with database connection as it raised an error without it

[lukasmueller]

You loaded the test database. It is probably better to rename it to something like breedbase_old and install an empty database from an empty database dump.

[lukasmueller]

That is, unless you would like to develop code, then the test database is the better option.