Comments (10)
I tried to find out the cause of the problem you are experiencing, but it is difficult to identify at the moment. Instead, as you said, we will correct the error log so that it can be guided in more detail.
from age-viewer.
@ChipNowacek
Because you're running in a container, perhaps you need to set the URL to host.docker.internal instead of localhost or 127.0.0.1
This should work MAC and Windows environments. For other OS try 172.17.0.1 (yes 172, not 127) or try the suggestions here...
https://dev.to/natterstefan/docker-tip-how-to-get-host-s-ip-address-inside-a-docker-container-5anh
from age-viewer.
Great, thank you very much. With that information I can either solve it or provide more information.
from age-viewer.
I cannot connect to a database running locally. Error:
Database Connection Failed
Failed to connect to the database. Are you sure the database is running on the server?
connect ECONNREFUSED 127.0.0.1:5432
Edit 1: Same steps to reproduce.
Edit 2: Edit 1
from age-viewer.
@ChipNowacek Because you're running in a container, perhaps you need to set the URL to host.docker.internal instead of localhost or 127.0.0.1
This should work MAC and Windows environments. For other OS try 172.17.0.1 (yes 172, not 127) or try the suggestions here...
https://dev.to/natterstefan/docker-tip-how-to-get-host-s-ip-address-inside-a-docker-container-5anh
It's wonderful finding geniuses who help non-geniuses. I'm connected. Thanks.
I hope I can use PostgreSQL for graph work. I have been searching for months.
from age-viewer.
I finally had a bit more time to investigate.
Looking at the network traffic shows that the age-viewer does not try to establish a tls connection:
Packet No. 4 containing the plaintext authentication request:
PostgreSQL
Type: Startup message
Length: 58
Parameter name: user
Parameter value: age_owner
Parameter name: database
Parameter value: age
Parameter name: client_encoding
Parameter value: UTF8
In contrast the (working) connection with psql looks like this:
Packet No.4 in this case is the request for SSL/TLS:
PostgreSQL
Type: SSL request
Length: 8
So that's most likely my problem.
Although I'm not a JavaScript developer I think I'd start looking here: https://github.com/apache/incubator-age-viewer/blob/4c912a0cdd4baaa4092f35229f8752d0214166f1/backend/src/models/agensgraph/agensGraphRepository.js#L26
from age-viewer.
@shinhanbyeol progress?
from age-viewer.
It's being developed and tested.
If you are interested, you can come to my repository and take a look.
here -> https://github.com/shinhanbyeol/incubator-age-viewer/tree/feautre/ssl-connnector
from age-viewer.
It seems that the error message indicates that there is no entry in the pg_hba.conf
file for your IP address, user, and database. This file is used to configure client authentication and can be found in the PostgreSQL data directory.
To connect to a remote PostgreSQL server with TLS enabled, you need to ensure that the server certificate and key files are available, and the SSL configuration is enabled. You also need to make sure that the pg_hba.conf
file rules are updated accordingly
from age-viewer.
It seems that the error message indicates that there is no entry in the
pg_hba.conf
file for your IP address, user, and database. This file is used to configure client authentication and can be found in the PostgreSQL data directory.To connect to a remote PostgreSQL server with TLS enabled, you need to ensure that the server certificate and key files are available, and the SSL configuration is enabled. You also need to make sure that the
pg_hba.conf
file rules are updated accordingly
Hi, Thanks for your suggestion. I have updated the pg_hba.conf file updated with rules. and even then this is not connecting with SSL. just that i dont see the Pg.js or the GraphRepository.js is calling out for SSL.
was able to connect with my psql client and pgAdmin no issues at all. is there is this working. or am i missing something. any help is greatly appreciated.
length: 173,
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: '545',
routine: 'ClientAuthentication'
from age-viewer.
Related Issues (20)
- Scrolling behaviour in Age-viewer HOT 1
- Refresh button doesn't work properly
- Properties not showing in Age Viewer for any graph
- Copy query to editor message HOT 2
- issue connecting viewer the apache-age running on docker HOT 6
- Text spam in console logs HOT 2
- Tooltips for Node Menu Items HOT 1
- start frontend error:BREAKING CHANGE: The request './nonIterableRest' failed to resolve only because it was resolved as fully specified
- AGEViewer or browser is not clickable.. HOT 1
- AGEViewer or browser is not clickable..and i have attched the error from console below..can anyone help me out HOT 7
- Installation error at 'npm run start' HOT 1
- Error in 'npm run setup' HOT 1
- Error when trying to run with "npm run start" HOT 1
- AGE-Viewer front-end not building (backend seems fine) HOT 7
- Incompatible Postgres version 16 with age-viewer's backend HOT 1
- Allow collapsing a vertice
- Timeout exception, unable to recover
- Would like to be able to specify what property or label name itself to use when presenting visualization of linked nodes and / or edges
- Would like to be able to view data output in JSON vs. TABULAR ( HTML TABLE ) format. Possibly being able to add/remove visible fields / sort.
- Design 3D view into graph with controls similar to XBox hand in AR glasses
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from age-viewer.