I installed the DigitalOcean one-click deploy of Strapi, and logged in as root following:
When I visit the ip, without any changes I get a “Bad Gateway”
I tried editing the pql password according to (because none was set in /srv/strapi/strapi-development/.en):
(logged in as strapi service user) and I get this error:
root@strapi:~# sudo psql -c “ALTER USER strapi with password ‘your-new-password’;”
psql: FATAL: role “root” does not exist
Any ideas?
I was able to set the password with su - postgres then altering the password, however, when I go back to the strapi service user and try to start I get these errors now:
0|strapi-development | > strapi-development@0.1.0 develop /srv/strapi/strapi-development
0|strapi-development | > strapi develop
^X0|strapi-development | [2021-04-28T15:24:41.244Z] debug 
Server wasn’t able to start properly.
0|strapi-development | [2021-04-28T15:24:41.247Z] error error: password authentication failed for user “strapi”
0|strapi-development | at Parser.parseErrorMessage (/srv/strapi/strapi-development/node_modules/pg-protocol/dist/parser.js:287:98)
0|strapi-development | at Parser.handlePacket (/srv/strapi/strapi-development/node_modules/pg-protocol/dist/parser.js:126:29)
0|strapi-development | at Parser.parse (/srv/strapi/strapi-development/node_modules/pg-protocol/dist/parser.js:39:38)
0|strapi-development | at Socket. (/srv/strapi/strapi-development/node_modules/pg-protocol/dist/index.js:11:42)
0|strapi-development | at Socket.emit (events.js:315:20)
0|strapi-development | at addChunk (_stream_readable.js:295:12)
0|strapi-development | at readableAddChunk (_stream_readable.js:271:9)
0|strapi-development | at Socket.Readable.push (_stream_readable.js:212:10)
0|strapi-development | at TCP.onStreamRead (internal/stream_base_commons.js:186:23)
0|strapi-development | npm
0|strapi-development |
0|strapi-development | ERR!
0|strapi-development | code ELIFECYCLE
0|strapi-development | npm ERR! errno 1
0|strapi-development | npm
0|strapi-development |
0|strapi-development | ERR!
0|strapi-development | strapi-development@0.1.0 develop: strapi develop
0|strapi-development | npm ERR! Exit status 1
0|strapi-development | npm ERR!
0|strapi-development | npm ERR! Failed at the strapi-development@0.1.0 develop script.
0|strapi-development | npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
0|strapi-development | npm
0|strapi-development |
0|strapi-development | ERR!
0|strapi-development | A complete log of this run can be found in:
0|strapi-development | npm ERR! /srv/strapi/.npm/_logs/2021-04-28T15_24_41_286Z-debug.log
0|strapi-development | > strapi-development@0.1.0 develop /srv/strapi/strapi-development
0|strapi-development | > strapi develop
^C
strapi@strapi:/root$ cat /srv/strapi/.npm/_logs/2021-04-28T15_24_41_286Z-debug.log
0 info it worked if it ends with ok
1 verbose cli [
1 verbose cli ‘/usr/bin/node’,
1 verbose cli ‘/usr/local/share/.config/yarn/global/node_modules/pm2/lib/ProcessContainerFork.js’,
1 verbose cli ‘run’,
1 verbose cli ‘develop’
1 verbose cli ]
2 info using npm@6.14.6
3 info using node@v12.18.3
4 verbose run-script [ ‘predevelop’, ‘develop’, ‘postdevelop’ ]
5 info lifecycle strapi-development@0.1.0~predevelop: strapi-development@0.1.0
6 info lifecycle strapi-development@0.1.0~develop: strapi-development@0.1.0
7 verbose lifecycle strapi-development@0.1.0~develop: unsafe-perm in lifecycle true
8 verbose lifecycle strapi-development@0.1.0~develop: PATH: /usr/lib/node_modules/npm/node_modules/npm-lifecycle/node-gyp-bin:/srv/strapi/strapi-development/node_modules/.bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin
9 verbose lifecycle strapi-development@0.1.0~develop: CWD: /srv/strapi/strapi-development
10 silly lifecycle strapi-development@0.1.0~develop: Args: [ ‘-c’, ‘strapi develop’ ]
11 silly lifecycle strapi-development@0.1.0~develop: Returned: code: 1 signal: null
12 info lifecycle strapi-development@0.1.0~develop: Failed to exec develop script
13 verbose stack Error: strapi-development@0.1.0 develop: strapi develop
13 verbose stack Exit status 1
13 verbose stack at EventEmitter. (/usr/lib/node_modules/npm/node_modules/npm-lifecycle/index.js:332:16)
13 verbose stack at EventEmitter.emit (events.js:315:20)
13 verbose stack at ChildProcess. (/usr/lib/node_modules/npm/node_modules/npm-lifecycle/lib/spawn.js:55:14)
13 verbose stack at ChildProcess.emit (events.js:315:20)
13 verbose stack at maybeClose (internal/child_process.js:1021:16)
13 verbose stack at Process.ChildProcess._handle.onexit (internal/child_process.js:286:5)
14 verbose pkgid strapi-development@0.1.0
15 verbose cwd /srv/strapi/strapi-development
16 verbose Linux 4.15.0-142-generic
17 verbose argv “/usr/bin/node” “/usr/local/share/.config/yarn/global/node_modules/pm2/lib/ProcessContainerFork.js” “run” “develop”
18 verbose node v12.18.3
19 verbose npm v6.14.6
20 error code ELIFECYCLE
21 error errno 1
22 error strapi-development@0.1.0 develop: strapi develop
22 error Exit status 1
23 error Failed at the strapi-development@0.1.0 develop script.
23 error This is probably not a problem with npm. There is likely additional logging output above.
24 verbose exit [ 1, true ]