[GitHub] [incubator-age-viewer] david-m-m commented on issue #6: Problem connecting to postgres/AGE (remote, TLS)

[GitBox]

david-m-m commented on issue #6:
URL: 
https://github.com/apache/incubator-age-viewer/issues/6#issuecomment-954726852


   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:
   
![wireshark-age-viewer](https://user-images.githubusercontent.com/34392985/139438233-c170da19-e522-4b80-b8c9-9ea1e7d12a70.png)
   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:
   
![wireshark-psql](https://user-images.githubusercontent.com/34392985/139438330-3399f6ed-ebfc-4264-8fef-6d3a30b63d8a.png)
   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


-- 
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

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