Error: Unknown auth message code 1375731712

[Dreamkarifha9]

Error: Unknown auth message code 1375731712
at Connection.handleAuth (connection.ts:216:15)
at Connection.startup (connection.ts:170:16)
at async Client.connect (client.ts:163:5)
at async RegisteractModel.findfristpage (Registeract_test.ts:104:7)
at async getFristpage (RegisterController_test.ts:19:19)
at async dispatch (middleware.ts:39:7)
at async authMiddleware (authMiddleware.ts:17:7)
at async dispatch (middleware.ts:39:7)
at async dispatch (middleware.ts:39:7)
at async dispatch (middleware.ts:39:7)

[Dreamkarifha9]

Another One

PartialReadError: Encountered UnexpectedEof, data only partially read
at BufReader.readFull (bufio.ts:183:19)
at async Connection.readMessage (connection.ts:120:5)
at async Connection._simpleQuery (connection.ts:313:11)
at async Connection.query (connection.ts:589:16)
at async RegisteractModel.findfristpage (Registeract_test.ts:115:22)
at async getFristpage (RegisterController_test.ts:19:19)
at async dispatch (middleware.ts:39:7)
at async authMiddleware (authMiddleware.ts:17:7)
at async dispatch (middleware.ts:39:7)
at async dispatch (middleware.ts:39:7)

[seilon-zhang]

I made the same mistake
const dbPool = new Pool({ user: "postgres", password: "123456", database: "deno", hostname: "192.168.18.200", port: 5432, }, POOL_CONNECTIONS);

error: Uncaught (in promise) Error: Unknown auth message code 10 throw new Error(Unknown auth message code ${code}); ^ at Connection.handleAuth (connection.ts:216:15) at Connection.startup (connection.ts:170:16) at async Pool._createConnection (pool.ts:38:5) at async pool.ts:67:7 at async Promise.all (index 3) at async Pool._startup (pool.ts:69:25) at async Pool.connect (pool.ts:90:5) at async runQueryObject (database.ts:14:30) at async app.ts:6:1

[Soremwar]

Hi there @Dreamkarifha9 and @seilon-zhang

Could you please provide information about your Postgres server setup? Specifically what authentication method are you using and Postgres version,

The next thing in the todo list is to provide other connection methods different than standard user password authentication

SSL/TLS for example aren't supported right now, but knowing what other authentication methods could be supported in the meanwhile will be of great help

[seilon-zhang]

The database version used is 13, which is the default setting, and no other changes have been made

[seilon-zhang]

@Soremwar I've browsed your previous questions and answers, which should be about the verification of the screen-sha-256

[Soremwar]

@seilon-zhang You are right. I will be adding support for this authentication method in the following days

@Dreamkarifha9 I just released a new version that parses the Postgres error messages instead of just showing the error code. Could you pleased update adn tell me what the new error tells you

[Dreamkarifha9]

@Soremwar

I have updated to the last version. 0.7.0

Error Another

Error: Unknown auth message code 1375731712
at Connection.handleAuth (connection.ts:216:15)
at Connection.startup (connection.ts:170:16)
at async Client.connect (client.ts:163:5)
at async RegisteractModel.findfristpage (Registeract_test.ts:104:7)
at async getFristpage (RegisterController_test.ts:19:19)
at async dispatch (middleware.ts:39:7)
at async authMiddleware (authMiddleware.ts:17:7)
at async dispatch (middleware.ts:39:7)
at async dispatch (middleware.ts:39:7)
at async dispatch (middleware.ts:39:7)

My setting Config.ts

const dbConfigsetup: ConnectionOptions = {
user: "postgres",
password: "",
database: "",
hostname: "",
port: 5432,
};
export const config: Config = {
dbConfigsetup,
jwtSecret: Deno.env.get("JWT_SECRET")!,
};

My setting Controller

export async function getFristpage(ctx: RouterContext) {
try {
const { response } = ctx;
const posts = await Registeract.findfristpage();
response.status = 200;
response.body = posts;
} catch (error) {
console.log(error);
throw error;
}
}

My setting modules

class RegisteractModel {
private dbClient: Client;

constructor(dbClient: Client) {
this.dbClient = dbClient;
}

async findfristpage(): Promise {
try {
await this.dbClient.connect();
const text =
SELECT machineactivitydetails.id, machineactivitydetails.actcode, machineactivitydetails.description as actdescription, machineactivitydetails.duratypeid, machineactivitydetails.is_active, machineactivitydetails.update_date, machinedetails.idmachine, machineactivitydetails.update_by, duratype.description, duratype.dura_day, machinedetails.name, machinedetails.orders, machineactivitydetails.machinegroupid, machinegroup.name as machinegroupname, machineactivitydetails.machinedetailsid, machineactivitydetails.standard FROM machineactivity AS machineactivitydetails LEFT JOIN duratype on duratype.id = machineactivitydetails.duratypeid LEFT JOIN machinedetails on machinedetails.id = machineactivitydetails.machinedetailsid LEFT JOIN machinegroup on machinegroup.id = machineactivitydetails.machinegroupid ORDER BY machineactivitydetails.id DESC LIMIT 10 ;;
const result = await this.dbClient.queryObject({
text,
});
await this.dbClient.end();
return result.rows;
} catch (error) {
console.log(error);
throw error;
}
}

}

[Soremwar]

@Dreamkarifha9 The patch to check the error was released on 0.7.1 :/

[Dreamkarifha9]

@Soremwar

update on 0.7.1 error

Error: Unknown auth message code 1375731712
at Connection.handleAuth (connection.ts:233:15)
at Connection.startup (connection.ts:171:16)
at async Client.connect (client.ts:163:5)
at async RegisteractModel.findfristpage (Registeract_test.ts:104:7)
at async getFristpage (RegisterController_test.ts:19:19)
at async dispatch (middleware.ts:39:7)
at async authMiddleware (authMiddleware.ts:17:7)
at async dispatch (middleware.ts:39:7)
at async dispatch (middleware.ts:39:7)
at async dispatch (middleware.ts:39:7)

Another one error
BadResource: Bad resource ID
at unwrapResponse (deno:cli/rt/10_dispatch_minimal.js:59:13)
at sendAsync (deno:cli/rt/10_dispatch_minimal.js:98:12)
at async read (deno:cli/rt/12_io.js:99:19)
at async BufReader.read (bufio.ts:146:12)
at async BufReader.readFull (bufio.ts:178:20)
at async Connection.readMessage (connection.ts:120:5)
at async Connection.startup (connection.ts:170:11)
at async Client.connect (client.ts:163:5)
at async RegisteractModel.findfristpage (Registeract_test.ts:104:7)
at async getFristpage (RegisterController_test.ts:19:19)

[Soremwar]

@Dreamkarifha9 Ok, so it doesn't seem to be a connection error

What method are you using to authenticate with your database? Plain password? SSL? TLS?

[Dreamkarifha9]

@Soremwar

I use setup

const dbConfigsetup: ConnectionOptions = {
user: "postgres",
password: "200711",
database: "",
hostname: "",
port: 5432,
};
export const config: Config = {
dbConfigsetup,
};
export { database, dbconfig };

How am i supposed To do that?

[Soremwar]

No, I mean how is your database configured. Or if you are using a database provided as a service (Amazon, Azure, etc) which one are you using and what are your settings?

I'm trying to understand what the driver is lacking in order to connect to your database

[Dreamkarifha9]

@Soremwar

I use postgresql
And i use Docker on windows serve

[Soremwar]

Did you configured the docker image yourself?

Also can you come to the discord server? It's kinda annoying trying to figure out the issue this way