apache / apache/age-viewer

Problem connecting to postgres/AGE (remote, TLS)

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

Description

**Description**
I am trying to connect the agviewer to a remote postgres which is enforcing TLS.

The database connection fails with this error message:

```
Database Connection Failed

Failed to connect to the database. Are you sure the database is running on the server?
no pg_hba.conf entry for host "", user "age_user", database "age", SSL off
```
**To Reproduce**
Steps to reproduce the behavior:
1. Set up remote postgres running AGE with TLS enabled, use an internal CA or self signed certificate
2. Run ageviewer locally
> docker run --publish=3001:3001--name=agviewer bitnine/agviewer
3. Open ageviewer FE in browser and enter data for DB
4. See above error

**Expected behavior**
The error message should be more informative and propose actionable items. (No pg_hba.conf exists in ageviewer image...)

Ideally the error should not occur and the connection to the DB should be established.

**Additional context**
To my understanding these factors could play a role:
* TLS (vs. unencrypted)
* internal CA / self signed certificate for DB (How would I inject the new CA in the image)

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.