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

[Loo-Ree]

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
2. open the browser at
   http://localhost:3000
3. fill up connection info
4. 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
5. 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!

[akikawa1123]

I was in the same boat. When I turned off [require_secure_transport] server parameter on azure portal, I could connect the database.
https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-connect-tls-ssl

However, I'm not able to see any graphs. When I executed SET search_path = ag_catalog, "$user", public;, it says that Access to library "age" is not allowed. Can you see graphs from age-viewer?