Bug 1954590

Description of problem:
When an external pgsql server is used, the connection to the database fails with:


Version-Release number of selected component (if applicable):
koji-hub-1.24.0-1.el8.noarch

How reproducible:
On every access of an client.

Steps to Reproduce:
1. Let an client connect to the hub

Actual results:
The hub can't connect to the database:
Log:
2021-04-28 14:02:33,840 [ERROR] m=None u=None p=53674 r=X.X.X.X:35074 koji.db: Traceback (most recent call last):
[Wed Apr 28 14:02:33.840463 2021] [wsgi:error] [pid 53674:tid 140651907766016] [client X.X.X.X:35074]   File "/usr/lib/python3.6/site-packages/koji/db.py", line 191, in connect
[Wed Apr 28 14:02:33.840468 2021] [wsgi:error] [pid 53674:tid 140651907766016] [client X.X.X.X:35074]     conn = psycopg2.connect(**opts)
[Wed Apr 28 14:02:33.840472 2021] [wsgi:error] [pid 53674:tid 140651907766016] [client X.X.X.X:35074]   File "/usr/lib64/python3.6/site-packages/psycopg2/__init__.py", line 130, in connect
[Wed Apr 28 14:02:33.840475 2021] [wsgi:error] [pid 53674:tid 140651907766016] [client X.X.X.X:35074]     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
[Wed Apr 28 14:02:33.840478 2021] [wsgi:error] [pid 53674:tid 140651907766016] [client X.X.X.X:35074] psycopg2.OperationalError: FATAL:  password authentication failed for user "koji"
[Wed Apr 28 14:02:33.840488 2021] [wsgi:error] [pid 53674:tid 140651907766016] [client X.X.X.X:35074] FATAL:  no pg_hba.conf entry for host "Z.Z.Z.Z", user "koji", database "koji", SSL off
[Wed Apr 28 14:02:33.840491 2021] [wsgi:error] [pid 53674:tid 140651907766016] [client X.X.X.X:35074] 
[Wed Apr 28 14:02:33.840497 2021] [wsgi:error] [pid 53674:tid 140651907766016] [client X.X.X.X:35074] 



Expected results:
An working connection to the database.

Additional info:
For security reasons, the connection to an external database must be encrypted.

Workaround:
/usr/lib/python3.6/site-packages/koji/db.py:
change:
opts = _DBopts
to:
opts = _DBopts
opts['sslmode'] = 'require'