SSL connection support for DB's

[ziadkiwan]

Hello,
we are trying to setup mainflux on a managed Database service and we are wondering if there is SSL support for database connection if yes, then how to enable and path the SSL certificate for the database connection ?

  ## If you want to use an external database, set this to false and change postgresqlHost
  enabled: false
  name: postgresql-users
  postgresqlHost: localhost
  postgresqlUsername: postgres
  postgresqlPassword: mainflux
  postgresqlDatabase: users
  resources:
    requests:
      cpu: 25m
  persistence:
    size: 1Gi```

[blokovi]

Hello @ziadkiwan
The short answer is currently this chart doesn't support SSL connection to DB
But, if you look at core services, for example users, you will see that this is supported with environment variables MF_USERS_DB_SSL_MODE, MF_USERS_DB_SSL_CERT, MF_USERS_DB_SSL_KEY and MF_USERS_DB_SSL_ROOT_CERT
I haven't tried SSL connection to external db, but with some modification of this chart maybe you can try. You can try adding this env vars into users deployment template and test it

[ziadkiwan]

Hello @blokovi,

Thank you for the informative answer, i will edit the template and the helm chart and provide a PR request.