#2838 Option for using SSL is missing, when the pgsql server is an network one.
Closed: Fixed 2 years ago by tkopecek. Opened 2 years ago by frank-mdc.

When the database for hub will run on an central database server, then the hub will try always to connect to it without ssl encryption. So the database server will reject the connection.
I have try to add an dirty hack to the python lib for the database connection. Then the connection will work, but not local databases will don't work any more. So it must be implemented as an option, but I don'*t know the code in detail to write an pull request. So I simple add the bugzilla link where I noted what I have done.


Metadata Update from @tkopecek:
- Custom field Size adjusted to None
- Issue set to the milestone: 1.26

2 years ago

I like how psycopg2 passes options directly through to libpq. https://www.psycopg.org/docs/module.html

I wonder if we could expose that in the Koji hub configuration somehow, so we don't have to keep adding options into Koji one-by-one. Then we would get "sslmode" for free (and "sslrootcert", "sslcrl", plus the kerberos options, etc), and as long as psycopg2 / libpq support it, Koji would support it also.

Metadata Update from @tkopecek:
- Issue set to the milestone: 1.27 (was: 1.26)

2 years ago

Metadata Update from @jcupova:
- Issue set to the milestone: 1.26 (was: 1.27)

2 years ago

Metadata Update from @tkopecek:
- Issue set to the milestone: 1.27 (was: 1.26)
- Issue tagged with: testing-ready

2 years ago

Metadata Update from @jcupova:
- Issue untagged with: testing-ready

2 years ago

Metadata Update from @tkopecek:
- Issue set to the milestone: 1.26 (was: 1.27)

2 years ago

Metadata Update from @jcupova:
- Issue tagged with: testing-done, testing-ready

2 years ago

Login to comment on this ticket.

Metadata
Related Pull Requests
  • #2958 Merged 2 years ago
  • #2957 Closed 2 years ago