Skip to content

sql_exporter ssl issue #819

@Batyray

Description

@Batyray

Problem

The sql-exporter ConfigMap is generated from a bundled data/sql-exporter.yaml
with a hardcoded DSN:

data_source_name: "postgres://crate@localhost:5432/?connect_timeout=5"

There is no field in the CrateDB CR spec to inject connection parameters like
sslmode=disable. This causes the sql-exporter sidecar to fail on CrateDB
clusters that do not have SSL enabled on the PostgreSQL interface:

pq: SSL is not enabled on the server

Expected Behavior

The CrateDB CR should expose a field (e.g. spec.cluster.sqlExporter.sslMode
or spec.cluster.sqlExporter.connectionParams) that gets appended to the DSN
when the ConfigMap is generated in get_sql_exporter_config().

Environment

  • crate-operator version:
  • CrateDB version:
  • SSL enabled on cluster: No

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions