Skip to content

[Bug]: Postgresql remote connection has no effect #1022

@webard

Description

@webard

Installation Type *

VPS

Vito Version *

3.20.0

Describe the Bug *

There is no way to enable remote connection due to default postgresql config.

  1. There is no proper line in pg_hba.conf
  2. listen_addresses directive in postgresql.conf is commented, and by default PGSQL listens on localhost

Steps to Reproduce *

  1. Enable remote connection on postgreSQl user
  2. Try to connect from remote host

Expected Behavior *

  1. Vito should change listen_addresses to '*' during installation
  2. Vito should add host all all 0.0.0.0/0 scram-sha-256 to pg_hba.conf during installatiojn

This should not be a security vulnerability due to firewall that protects network. User should also enable port 5432 to allow remote connections, and user should be informed about this in remote connection section.

Logs *

None

Screenshots

No response

Additional Context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions