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 GitHubhttps://github.com/solgenomics/breedbase_dockerfile/issues/50, or unsubscribehttps://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.