apache / apache/age-viewer

Unable to connect to Azure Flexible Server for PostgreSQL with AGE extension

Open
#180 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
JavaScript
Stars
387
Forks
268
PR merge metrics
No merged PRs in 30d

Description

**Describe the bug**
Not sure if this is an issue or my fault, nonetheless I'm unable to have age-viewer connected to an Azure Flexible Server for PostgreSQL with AGE extension.

**To Reproduce**
Steps to reproduce the behavior:
1. run
`>npm run setup`
and then
`>npm run start`
3. open the browser at
`http://localhost:3000`
4. fill up connection info
5. See error on upper section of the page:
`Database Connection Failed
Failed to connect to the database. Are you sure the database is running on the server?
[FATAL]:(28000) no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "padmin", database "postgres", no encryption`
6. See error in console:
`error: no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "padmin", database "postgres", no encryption
at C:\...\age-viewer\age-viewer\backend\node_modules\pg-pool\index.js:45:11
at processTicksAndRejections (node:internal/process/task_queues:105:5) {
length: 164,
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: '630',
routine: 'ClientAuthentication'
}
info: ::1 - - [19/Nov/2024:16:01:25 +0000] "POST /api/v1/db/connect HTTP/1.1" 500 155
{"timestamp":"2024-11-19 17:01:25"}`

**Desktop:**
- OS: Windows 11
- Browser: Edge
- Version: 131.0.2903.51 (Official build) (64-bit)

**Additional context**
```
>node -v
v22.11.0
> npm -v
10.9.0
```
Please note that the very same connection parameters used by pgAdmin4 permit to connect to the database and run queries flawlessly.
Any idea? Thank you!

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.