error: error: password authentication failed for user "electron_release_server_user"

Question

I was messing around with this amazing Sails project here.

I managed to get it 100% functional on my Macbook Pro with little to no difficulty.

Now I'm trying to get it working on an Azure Ubuntu 14.04 box and after running it with npm start which just calls node app.js I get this error:

Error creating a connection to Postgresql using the following settings:
{ host: 'localhost',
 port: 5432,
 schema: true,
 ssl: false,
 adapter: 'sails-postgresql',
 user: 'electron_release_server_user',
 password: '[redacted]',
 database: 'electron_release_server',
 identity: 'postgresql' }

* * *
Complete error details:
 { error: password authentication failed for user "electron_release_server_user"
    at Connection.parseE (/home/azureuser/electron-release-server/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:539:11)
at Connection.parseMessage (/home/azureuser/electron-release-server/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:366:17)
at Socket.<anonymous> (/home/azureuser/electron-release-server/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:105:22)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at readableAddChunk (_stream_readable.js:172:18)
at Socket.Readable.push (_stream_readable.js:130:10)
at TCP.onread (net.js:535:20)
 name: 'error',
 length: 117,
 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: '285',
 routine: 'auth_failed' }

In my local.js I have:

connections: {
    postgresql: {
      adapter: 'sails-postgresql',
      host: 'localhost',
      user: 'electron_release_server_user',
      password: '<SECRET>',
      database: 'electron_release_server'
    }
  },

This exact configuration worked on my local machine but now that it's on this Ubuntu VM... no luck.

Anyone? I need this in order to release a product!

`error: password authentication failed for user "electron_release_server_user"` looks clear to me. — wildplasser, May 04 '16 at 20:41

score 13 · Accepted Answer · answered May 07 '16 at 05:09

13

So it turned out to be my version of Node.

Node.js 6.0 just didn't seem to work. Once I downgraded to LTS, poof, everything worked as expected.

answered May 07 '16 at 05:09

Tyler James Leonhardt

804
1
9
24

1

Thank you.. U save my time.. Keep it up. – iSmita May 16 '16 at 06:09
2

This solved it for me. I downgraded to 5.12.0 and it worked. – dalton_c Aug 23 '16 at 05:36
Any idea if this issue persists on Node 9.4.0 ? – larrydalmeida Jan 17 '18 at 14:43
Any idea if the issue exist on Node 8.11.3? – Hemadri Dasari Oct 09 '18 at 09:21
The issue still exists on Node.js 9, at least when using old versions of the pg library (necessary in my case for connecting to a PostgreSQL 8 server). I used the npm version manager "n" to install a second installation at 5.12.0, and running my application with that 5.12.0 installation instead of Node.js 9 solved the issue. – Josh1billion Jan 09 '19 at 22:35
using lts for version 8, 9, 10 got the same error, upgrading nodejs cancelled :)) – emaniacs Oct 07 '22 at 10:02

score 2 · Answer 2 · edited May 23 '17 at 12:32

2

Per my experience, the issue belongs to the scope of Client Authentication problems that you can refer to the Postgres document to know it, please see http://www.postgresql.org/docs/9.1/static/client-authentication-problems.html.

The usual solution is that checking or changing the password for the specified user via the Postgres command ALTER USER, please see the document http://www.postgresql.org/docs/9.1/static/sql-alteruser.html.

There is an exsiting SO thread which you can refer to, please see Postgresql: password authentication failed for user "postgres".

Hope it helps.

edited May 23 '17 at 12:32

Community

1
1

answered May 05 '16 at 09:18

Peter Pan

23,476
4
25
43

Thanks for this. I've seen that SO thread and unfortunately the suggestions did not solve my issue. That's why I posted this question hopping that this was a Sails issue. I attempted to connect to that database using: `psql -U electron_release_server_user -h localhost electron_release_server` I was prompted for the password, I put it in, and it worked. I was successfully connected to the database: `electron_release_server=>` is my prompt. – Tyler James Leonhardt May 06 '16 at 13:40

error: error: password authentication failed for user "electron_release_server_user"

2 Answers2