https://bugs.exim.org/show_bug.cgi?id=2808
Bug ID: 2808
Summary: Passwordless SSL authentication to PostgfeSQL
Product: Exim
Version: N/A
Hardware: x86-64
OS: FreeBSD
Status: NEW
Severity: wishlist
Priority: medium
Component: Unfiled
Assignee: unallocated@exim.org
Reporter: cli_junkie@protonmail.com
CC: exim-dev@exim.org
Passwordless SSL authentication to a PostgreSQL cluster is possible but tricky.
It would be nice if a standard PG key/value connection string and/or a
connection URI could be configured.
The workaround that I found to work (with a huge thank you to Jasen Betts for
the hint) is to manipulate the DB name component of the pgsql_servers
configuration directive. Using macros to make things a tad easier to read, this
works:
DB_HOST = 192.168.45.6
DB_NAME = dbname=exim sslcert=client.crt sslkey=client.key
sslmode=verify-ca sslrootcert=root.crt
DB_PW = notused
DB_USER = thepguser
pgsql_servers = DB_HOST/DB_NAME/DB_USER/DB_PW
From what I can tell, the password portion is not used, but probably needs to
not be empty. I did not test the needs not be empty premise.
Thanks!
--
You are receiving this mail because:
You are on the CC list for the bug.
--
## List details at https://lists.exim.org/mailman/listinfo/exim-dev Exim details at http://www.exim.org/ ##
Bug ID: 2808
Summary: Passwordless SSL authentication to PostgfeSQL
Product: Exim
Version: N/A
Hardware: x86-64
OS: FreeBSD
Status: NEW
Severity: wishlist
Priority: medium
Component: Unfiled
Assignee: unallocated@exim.org
Reporter: cli_junkie@protonmail.com
CC: exim-dev@exim.org
Passwordless SSL authentication to a PostgreSQL cluster is possible but tricky.
It would be nice if a standard PG key/value connection string and/or a
connection URI could be configured.
The workaround that I found to work (with a huge thank you to Jasen Betts for
the hint) is to manipulate the DB name component of the pgsql_servers
configuration directive. Using macros to make things a tad easier to read, this
works:
DB_HOST = 192.168.45.6
DB_NAME = dbname=exim sslcert=client.crt sslkey=client.key
sslmode=verify-ca sslrootcert=root.crt
DB_PW = notused
DB_USER = thepguser
pgsql_servers = DB_HOST/DB_NAME/DB_USER/DB_PW
From what I can tell, the password portion is not used, but probably needs to
not be empty. I did not test the needs not be empty premise.
Thanks!
--
You are receiving this mail because:
You are on the CC list for the bug.
--
## List details at https://lists.exim.org/mailman/listinfo/exim-dev Exim details at http://www.exim.org/ ##