Problem:
[Nest] 14608 - 13.03.2023, 17:48:36 ERROR [TypeOrmModule] Unable to connect to the database. Retrying (2)... error: password authentication failed for user "postges" |
Solution:
die Werte in der Datei orm.config.ts müssen korrekt sein.
Dabei gilt auch CaseSensitive
import { TypeOrmModuleOptions } from "@nestjs/typeorm"; export const config: TypeOrmModuleOptions={ type: 'postgres', username: 'postgres', password: 'root', port: 5432, host:'localhost', //host:'127.0.0.1', database:'ArticlesDB', synchronize:true, entities:['dist/**/*.entity{.ts,.js}'], } |
Hierzu kann man pgAdmin 4 öffnen und 1: die Server Properties in Server.Properties.Connection finden
Host
Port
Username für Server
Und in der Datenbank den Database Name und den Owner
[Nest] 14608 - 13.03.2023, 17:48:33 LOG [NestFactory] Starting Nest application... [Nest] 14608 - 13.03.2023, 17:48:33 LOG [InstanceLoader] TypeOrmModule dependencies initialized +57ms [Nest] 14608 - 13.03.2023, 17:48:33 LOG [InstanceLoader] ArticlesModule dependencies initialized +1ms [Nest] 14608 - 13.03.2023, 17:48:33 LOG [InstanceLoader] AppModule dependencies initialized +0ms [Nest] 14608 - 13.03.2023, 17:48:33 ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)... error: password authentication failed for user "postges" at Parser.parseErrorMessage (D:\Development\WebApps\Vue\_demo\nestjs_demo\nestjs_demo01\node_modules\pg-protocol\src\parser.ts:369:69) at Parser.handlePacket (D:\Development\WebApps\Vue\_demo\nestjs_demo\nestjs_demo01\node_modules\pg-protocol\src\parser.ts:188:21) jector.js:247:19) at Parser.parse (D:\Development\WebApps\Vue\_demo\nestjs_demo\nestjs_demo01\node_modules\pg-protocol\src\parser.ts:103:30) .js:200:33) at Socket.<anonymous> (D:\Development\WebApps\Vue\_demo\nestjs_demo\nestjs_demo01\node_modules\pg-protocol\src\index.ts:7:48) at Socket.emit (node:events:513:28) at addChunk (node:internal/streams/readable:324:12) .js:135:27) at readableAddChunk (node:internal/streams/readable:297:9) at Socket.Readable.push (node:internal/streams/readable:234:10) at TCP.onStreamRead (node:internal/stream_base_commons:190:23) |