search

Ylianst / MeshCentral

A complete web-based remote monitoring and management web site. Once setup you can install agents and perform remote desktop session to devices on the local network or over the Internet.
https://meshcentral.com
Apache License 2.0
3.97k stars 535 forks source link

cannot connect postgres with PG bouncer. #4643

Open a-imran99 opened 1 year ago

a-imran99 commented 1 year ago

Hi @Ylianst @si458 , I have been trying to connect mesh-central to postgres-SQL maintained by PGbouncer. But could not establish a connection and it throws SSL error even SSL is disabled at both the levels.

It throws SSL required or Self signed certificate error when postgres credentials is passed in config.json

https://github.com/zalando/postgres-operator/issues/1034#issuecomment-890481115

https://github.com/zalando/postgres-operator/issues/1034

https://github.com/zalando/postgres-operator/issues/868

These are above mentioned PGbouncer known issues.

Ylianst commented 1 year ago

I am not familiar with PGbouncer. MeshCentral uses PG (npm link here) to connect to PostgreSQL. Connection documentation is here.

I just pass anything in the "Postgres" section of the config.json into the connection parameters of the library. So, you can look in the documentation for any additional connection options you need and add them to the config.json.

There is a section on SSL connection here. Hopefully that helps. MeshCentral does not directly connect to Postgres, it uses this library to do it.

dinger1986 commented 9 months ago

@si458 stale and probably works just needs documented by someone who uses PGbouncer