local-ai-packaged - n8n-import error - password authentication failed for user "root"

[shawnhank]

Hello.

I'm following the readme in the local-ai-packaged folder under ai-agents-masterclass and after copying and renaming the .env.example to .env I run docker-compose-up, I am getting an error: FATAL: password authentication failed for user "root" and then it gracefully stops and the final message is service "n8n-import" didn't complete successfully: exit 1

I didn't change any of the settings in the new .env file, so the password for the database is still password.

Do I need to change the password and other setting in the .env file for this to work? It's not called out in the instructions so I'm not sure why this isn't working out of the box.

Any assistance with this would be greatly appreciated.

Here is the error output after running docker-compose-up:

(ai-agents-masterclass) ➜ local-ai-packaged git:(main) docker-compose up [+] Running 5/0 ✔ Container qdrant Running 0.0s ✔ Container flowise Running 0.0s ✔ Container local-ai-packaged-postgres-1 Running 0.0s ✔ Container n8n-import Created 0.0s ✔ Container open-webui Running 0.0s Attaching to flowise, postgres-1, n8n, n8n-import, open-webui, qdrant n8n-import | Permissions 0644 for n8n settings file /home/node/.n8n/config are too wide. This is ignored for now, but in the future n8n will attempt to change the permissions automatically. To automatically enforce correct permissions now set N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=true (recommended), or turn this check off set N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=false. n8n-import | User settings loaded from: /home/node/.n8n/config postgres-1 | 2024-12-12 04:16:02.694 UTC [729] FATAL: password authentication failed for user "root" postgres-1 | 2024-12-12 04:16:02.694 UTC [729] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" n8n-import | There was an error initializing DB n8n-import | Error: There was an error initializing DB n8n-import | at ImportCredentialsCommand.exitWithCrash (/usr/local/lib/node_modules/n8n/dist/commands/base-command.js:116:49) n8n-import | at /usr/local/lib/node_modules/n8n/dist/commands/base-command.js:82:59 n8n-import | at processTicksAndRejections (node:internal/process/task_queues:95:5) n8n-import | at ImportCredentialsCommand.init (/usr/local/lib/node_modules/n8n/dist/commands/base-command.js:82:9) n8n-import | at ImportCredentialsCommand._run (/usr/local/lib/node_modules/n8n/node_modules/@oclif/core/lib/command.js:301:13) n8n-import | at Config.runCommand (/usr/local/lib/node_modules/n8n/node_modules/@oclif/core/lib/config/config.js:424:25) n8n-import | at run (/usr/local/lib/node_modules/n8n/node_modules/@oclif/core/lib/main.js:94:16) n8n-import | at /usr/local/lib/node_modules/n8n/bin/n8n:71:2 n8n-import | n8n-import | password authentication failed for user "root" n8n-import | error: password authentication failed for user "root" n8n-import | at Parser.parseErrorMessage (/usr/local/lib/node_modules/n8n/node_modules/pg-protocol/dist/parser.js:283:98) n8n-import | at Parser.handlePacket (/usr/local/lib/node_modules/n8n/node_modules/pg-protocol/dist/parser.js:122:29) n8n-import | at Parser.parse (/usr/local/lib/node_modules/n8n/node_modules/pg-protocol/dist/parser.js:35:38) n8n-import | at Socket.<anonymous> (/usr/local/lib/node_modules/n8n/node_modules/pg-protocol/dist/index.js:11:42) n8n-import | at Socket.emit (node:events:519:28) n8n-import | at Socket.emit (node:domain:488:12) n8n-import | at addChunk (node:internal/streams/readable:559:12) n8n-import | at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) n8n-import | at Socket.Readable.push (node:internal/streams/readable:390:5) n8n-import | at TCP.onStreamRead (node:internal/stream_base_commons:191:23) n8n-import | n8n-import exited with code 1 Gracefully stopping... (press Ctrl+C again to force) service "n8n-import" didn't complete successfully: exit 1