Re: SSL with Access VBA

Hi,

I've written up instructions for setting up a postgres system on Windows
with Access clients, encrypted connections and SSPI authentication.

Although the application itself isn't relevant, these instructions cover
configurations required for that kind of setup that may be useful to you.

Probably don't enable ssl compression, it is an attack vector and so may no
longer be available in tls1.3 anyway.

You can verify if your connection is encrypted by using PSQL, it'll always
print this information on connection. Pgadmin shows that info too.

Server stuff:

https://github.com/lindsay-stevens/openclinica_sqldatamart/blob/master/docs/setup/advanced.md

Client stuff:

https://github.com/lindsay-stevens/openclinica_sqldatamart/blob/master/docs/clients/general.md

Hope it helps

On 10 Nov 2016 11:46 am, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> wrote:

> On 11/09/2016 04:29 PM, Andreas wrote:
>
>> Hello Adrian,
>>
>> thanks for pointing me to this "md5" in your other answer.
>> I fear, I found the SSL issue myself. =8-}
>>
>> Would you know how to turn on the SSL-compression for ADODB.Connections?
>> ... and for PHP, too?
>> Is it some option in the connection string?
>>
>
> I have no idea, I do not use either. Sorry.
>
>
>> On the other hand, I found warnings that enabling ssl-compression brings
>> the danger of exposing oneself to BEAST and CRIME (whatever that might
>> be).
>>
>>
>> Thanks in advance
>> Andreas
>>
>>
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>