Re: Add test case for sslinfo - Mailing list pgsql-hackers

From Hao Wu
Subject Re: Add test case for sslinfo
Date
Msg-id CANdi8u1Rb-+UnQMAB48UYFDKi2EAyBZaSBzyfCHSKXfjOu_0Xg@mail.gmail.com
Whole thread Raw
In response to Re: Add test case for sslinfo  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: Add test case for sslinfo  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Hi Thomas,

Thank you for your quick response! I work on greenplum, and I didn't see this folder(src/test/ssl/ssl) before.
I will add more certificates to test and resend again.

Do you have any suggestion about the missing PGDATA? Since the test needs to configure postgresql.conf, maybe there are other ways to determine this environment.

Thank you very much!


On Mon, Jul 8, 2019 at 12:05 PM Thomas Munro <thomas.munro@gmail.com> wrote:
On Mon, Jul 8, 2019 at 2:59 PM Hao Wu <hawu@pivotal.io> wrote:
> I see there is no test case for sslinfo. I have added a test case for it in my project.

Hi Hao Wu,

Thanks!  I see that you created a CF entry
https://commitfest.postgresql.org/24/2203/.  While I was scanning
through the current CF looking for trouble, this one popped in front
of my eyes, so here's some quick feedback even though it's in the next
CF:

+#!/bin/bash

I don't think we can require that script interpreter.

This failed[1] with permissions errors:

+cp: cannot create regular file '/server.crt': Permission denied

It looks like that's because the script assumes that PGDATA is set.

I wonder if we want to include more SSL certificates, or if we want to
use the same set of fixed certificates (currently under
src/test/ssl/ssl) for all tests like this.  I don't have a strong
opinion on that, but I wanted to mention that policy decision.  (There
is also a test somewhere that creates a new one on the fly.)

[1] https://urldefense.proofpoint.com/v2/url?u=https-3A__travis-2Dci.org_postgresql-2Dcfbot_postgresql_builds_555576601&d=DwIBaQ&c=lnl9vOaLMzsy2niBC8-h_K-7QJuNJEsFrzdndhuJ3Sw&r=tqYUKh-fXcYPWSaF4E-D6A&m=N21IAtFKoqkBqeNv3h-dDX50l6qCVe5xQlAHlqn0KeY&s=lgcvJiqqeNAtrRYSM2eGPbfv6a1GxgUgig2PicIES8Q&e=

--
Thomas Munro
https://urldefense.proofpoint.com/v2/url?u=https-3A__enterprisedb.com&d=DwIBaQ&c=lnl9vOaLMzsy2niBC8-h_K-7QJuNJEsFrzdndhuJ3Sw&r=tqYUKh-fXcYPWSaF4E-D6A&m=N21IAtFKoqkBqeNv3h-dDX50l6qCVe5xQlAHlqn0KeY&s=3d9-Snq6Ul9p-LLkcinUksa_kt6tTmq8nBkdUSBRqm8&e=

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: PGOPTIONS="-fh" make check gets stuck since Postgres 11
Next
From: Thomas Munro
Date:
Subject: Re: Implementing Incremental View Maintenance