I am trying to get this running locally to see if I can help out with fixing any of the current accessibility issues, or raise new accessibility issues to fix.
**Problem:** I cannot get past the migration stage.
In the section titled “Docker for development” it says:
```sh
cd dev/
docker-compose build
docker-compose run --rm web pnpm run init
docker-compose up -d
```
Should that start with this line so that there is actually a `docker-compose` file in the `dev` directory?
```sh
cp dev/docker-compose.yml.example dev/docker-compose.yml
```
If I copy that file first, *then* I can run those `docker-compose` commands. Otherwise, I get nothing happening in there—because the `.example` file is unknown.
I have copied `.config/example.env` to `.config/docker.env` and tried different values:
```sh
# .config/docker.env
POSTGRES_DB=calckey
POSTGRES_PASSWORD=SecretPassword
POSTGRES_USER=postgres
```
But each time I run `docker-compose run --rm web pnpm run init`, it fails at the same step:
```log
docker-compose run --rm web pnpm run init
[+] Running 16/2
✔ db 8 layers [⣿⣿⣿⣿⣿⣿⣿⣿] 0B/0B Pulled 16.5s
✔ redis 6 layers [⣿⣿⣿⣿⣿⣿] 0B/0B Pulled 9.5s
[+] Running 3/3
✔ Network dev_network Created 0.2s
✔ Container calckey_db Created 2.3s
✔ Container calckey_redis Created 2.3s
[+] Running 2/2
✔ Container calckey_redis Started 3.0s
✔ Container calckey_db Started 3.0s
> calckey@13.1.4.1 init /calckey
> pnpm run migrate
> calckey@13.1.4.1 migrate /calckey
> pnpm --filter backend run migrate
> backend@ migrate /calckey/packages/backend
> typeorm migration:run -d ormconfig.js
Error during migration run:
error: password authentication failed for user "postgres"
at Parser.parseErrorMessage (/calckey/node_modules/.pnpm/pg-protocol@1.5.0/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/calckey/node_modules/.pnpm/pg-protocol@1.5.0/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/calckey/node_modules/.pnpm/pg-protocol@1.5.0/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket. (/calckey/node_modules/.pnpm/pg-protocol@1.5.0/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
length: 103,
severity: 'FATAL',
code: '28P01',
detail: undefined,
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'auth.c',
line: '330',
routine: 'auth_failed'
}
/calckey/packages/backend:
ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL backend@ migrate: `typeorm migration:run -d ormconfig.js`
Exit status 1
ELIFECYCLE Command failed with exit code 1.
ELIFECYCLE Command failed with exit code 1.
```
This leads me to this somewhat ambiguous section in your [README](https://codeberg.org/calckey/calckey/#create-database):
> “Assuming you set up PostgreSQL correctly, all you have to run is:”
>
> `psql postgres -c "create database calckey with encoding = 'UTF8';"`
Judging by this line:
```log
error: password authentication failed for user "postgres"
```
…I guess we can assume that I didn’t set up PostgreSQL correctly.
But, that line remains ambiguous with regard to local development in Docker.
So, my question is this:
**What do I need to do to get PostgreSQL to connect during local development using Docker, and can someone amend the README to reflect that to make it a lot easier for people to help out?**
Thanks.
Phil Sherry
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.