Postgresql код ошибки 28000

I’m currently running openSuse on an rPi3B+ (aarch64) and have hit a wall running a NodeJS connection script.

I went through the standard install of PostgreSQL (v10 is what is offered on this version of openSuse) then created a new role with

CREATE ROLE new_role LOGIN PASSWORD 'passwd';

and then a db with

CREATE DATABASE new_db OWNER new_role;

Both the l & du return the expected outputs show that both the role and db have been created successfully with the correct owner.

So I then quickly created a node project directory and copied the test script from the docs: https://node-postgres.com/features/connecting

const { Pool, Client } = require('pg')
const connectionString = 'postgresql://new_role:passwd@localhost:5432/new_db'

const pool = new Pool({
  connectionString: connectionString,
})

pool.query('SELECT NOW()', (err, res) => {
  console.log(err, res)
  pool.end()
})

const client = new Client({
  connectionString: connectionString,
})
client.connect()

client.query('SELECT NOW()', (err, res) => {
  console.log(err, res)
  client.end()
})

This returns a few broken promise errors that I haven’t caught(.cath()) correctly yet, and an error code of 28000 that looks like this:

{ error: Ident authentication failed for user "new_role"
at Connection.parseE (/home/eru/postgresDB/node_modules/pg/lib/connection.js:554:11)
at Connection.parseMessage (/home/eru/postgresDB/node_modules/pg/lib/connection.js:379:19)
at Socket.<anonymous> (/home/eru/postgresDB/node_modules/pg/lib/connection.js:119:22)
at Socket.emit (events.js:182:13)
at addChunk (_stream_readable.js:283:12)
at readableAddChunk (_stream_readable.js:264:11)
at Socket.Readable.push (_stream_readable.js:219:10)
at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
  name: 'error',
  length: 99,
  severity: 'FATAL',
  code: '28000',
  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: '328',
  routine: 'auth_failed' } undefined

So I’m pretty sure the attempt made it to the intended port otherwise I wouldn’t have received the detailed error in terminal. The error code = invalid_authorization_specification

Is the there something I need to do on the server ,psql interface, that will fulfill the authorization specification?

When I’ve looked into that specific one I can’t seem to find useful search results relevant to my situation.

Fairly new to postgres here so I’m sure this is a pretty noob mistake that I’m missing but any help or input is very appreciated!

I’m Getting This Error While Applying Migrations To Create New Database Hosted in database Cluster in Digitalocean.

my connection string is:

                var conn = "User ID=test;Password=testPassword;Server=db-postgresql-tor1-xxxxx-do-user-xxxxxxxxx-0.b.db.ondigitalocean.com;port=25060;Database=TestAuthentication;Integrated Security=false;Pooling=true;";

Npgsql.PostgresException (0x80004005): 28000: no pg_hba.conf entry for host «XXX.xx.xx.192», user «test», database «TestAuthentication», SSL off
at Npgsql.NpgsqlConnector.<>c__DisplayClass160_0.<g__ReadMessageLong|0>d.MoveNext() in C:projectsnpgsqlsrcNpgsqlNpgsqlConnector.cs:line 933
— End of stack trace from previous location —
at Npgsql.NpgsqlConnector.<>c__DisplayClass160_0.<g__ReadMessageLong|0>d.MoveNext() in C:projectsnpgsqlsrcNpgsqlNpgsqlConnector.cs:line 973
— End of stack trace from previous location —
at Npgsql.NpgsqlConnector.Authenticate(String username, NpgsqlTimeout timeout, Boolean async) in C:projectsnpgsqlsrcNpgsqlNpgsqlConnector.Auth.cs:line 22
at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken) in C:projectsnpgsqlsrcNpgsqlNpgsqlConnector.cs:line 389
at Npgsql.NpgsqlConnection.<>c__DisplayClass32_0.<g__OpenLong|0>d.MoveNext() in C:projectsnpgsqlsrcNpgsqlNpgsqlConnection.cs:line 240
— End of stack trace from previous location —
at Npgsql.NpgsqlConnection.Open() in C:projectsnpgsqlsrcNpgsqlNpgsqlConnection.cs:line 119
at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Exists()
at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists()
at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Exception data:
Severity: FATAL
SqlState: 28000
MessageText: no pg_hba.conf entry for host «XXX.xx.xx.192», user «test», database «TestAuthentication», SSL off
File: auth.c
Line: 496
Routine: ClientAuthentication
28000: no pg_hba.conf entry for host «XXX.xx.xx.192», user «test», database «TestAuthentication», SSL off

Здравствуйте, вот подробный ответ на ваш вопрос!
Datatable warning: table id=example — произошла ошибка при подключении к базе данных. Ошибка сообщает сервер: SQLSTATE[28000] [1045] Access denied for user ‘postgres’@’localhost’ (using password: YES)
///////////////////////////
Я подключен к моей Amazon EC2 instance. Я могу войти с MySQL root с помощью этой команды:
mysql -u root -p
Предоставляются все привилегии для пользователя Билл:
grant all privileges on . to ‘bill’@’%’ with grant option;
Тогда я выход От пользователя root и попробуйте Войти с Биллом:
mysql -u bill -p
ввели правильный пароль и получил эту ошибку:
ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
//////////////////////////////////
Когда несколько матчей, возможно, сервер должен определить, какой из них использовать. Он решает этот вопрос следующим образом: (…)

Когда клиент пытается подключиться, сервер смотрит через rows [таблицы mysql.user] в отсортированном порядке.
Сервер использует первую строку, которая совпадает с клиента имя хоста и имя пользователя.
(…) Сервер использует правила сортировки, что порядок строк с наиболее конкретных принимающих значения в первую очередь. Буквальные имена Хостов (например, ‘localhost’] и IP-адреса являются наиболее конкретными.

I’m trying to run pgloader (version «3.6.3047c9a») on a Red Hat Enterprise Linux 7 Azure VM against an Azure PostgreSQL server v11 but I’m getting an error:

bash# pgloader —dry-run pgl.load
….
Failed to connect to pgsql at «mypgsrv.privatelink.postgres.database.azure.com» (port 5432) as user «my-managed-identity-role@mypgsrv»: Database error 28000: Invalid connection parameters specified. Check connection parameters, and try again.

I am able to connect with a simple «psql» command without arguments, by using the same environment variable set PGHOST=mypgsrv.privatelink.postgres.database.azure.com
PGUSER=my-managed-identity-role@mypgsrv
PGPASSWORD=[fresh token generated from azure url]
PGDATABASE=postgres
PGLOADERCONNECTION=postgresql:///
FILE_NAME=mytbl.data

pgl.load:

LOAD FIXED
FROM ‘{{FILE_NAME}}’
(
ID FROM 0 FOR 4
)
INTO {{PGLOADERCONNECTION}}
TARGET TABLE public.mytbl
WITH truncate
;