[I] Unable to connect to Azure Flexible Server for PostgreSQL with AGE extension [age-viewer]

[via GitHub]

Loo-Ree opened a new issue, #180:
URL: https://github.com/apache/age-viewer/issues/180

   **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 
permits to connect to the database and run queries flawlessly. 
   Any idea? Thank you!
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org