UniDAC with SSL

[abraao895]

Hi,

I would like to display all the data that the UniConnection component transfer/receive in a Memo. I would like to see the SSL HandShake process. Is there a mode of implement this in my project? Thanks very much!

[AndreyZ]

Hello,

To show all queries that are made through TUniConnection, you can use the TUniSQLMonitor component and its OnSQL event. Here is a code example:

Code: Select all

procedure TForm1.UniSQLMonitor1SQL(Sender: TObject; Text: String;
  Flag: TDATraceFlag);
begin
  Memo1.Lines.Add(Text);
end;

Please specify in more details the functionality that concerns SSL you want to obtain. Also, please specify the database server you are working with.

[abraao895]

Hi Andrey, thanks of your answer.

I am using the PostgreSQL Server 9.1. I would like to see the messages of negociation of SSL HandShake, like this:

SSL_connect:before/connect initialization
SSL_connect:SSLv2/v3 write client hello A
SSL_connect:error in SSLv2/v3 read server hello A
SSL_connect:SSLv3 read server hello A
SSL_connect:SSLv3 read server certificate A
SSL_connect:SSLv3 read server key exchange A
SSL_connect:SSLv3 read server done A
SSL_connect:SSLv3 write client key exchange A
SSL_connect:SSLv3 write change cipher spec A
SSL_connect:SSLv3 write finished A
SSL_connect:SSLv3 flush data
SSL_connect:error in SSLv3 read finished A
SSL_connect:error in SSLv3 read finished A
SSL_connect:SSLv3 read finished A
SSL handshake has read 1584 bytes and written 346 bytes
SSL-Session:

My intention is have assurance that my delphi project with unidac is using a SSL connection with my PostgreSQL.

Someone?