Unable to connect to Azure Flexible Server for PostgreSQL with AGE extension
- 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.