Page 1 of 1
UniDAC with SSL
Posted: Wed 31 Oct 2012 19:12
by 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!
Re: UniDAC with SSL
Posted: Thu 01 Nov 2012 11:37
by 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.
Re: UniDAC with SSL
Posted: Thu 01 Nov 2012 12:19
by 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?