MySQL SSL connection

Data Abstract
1

My server application runs on an EC2 Amazon server (Ireland) and connects to a RDS MySQL instance.

My customers connect to my server via HTTPS or TCP/SSL, but I guess I need to also secure the server->Db connection.

Do you have any information on connecting a DA to MySQL (using MyDAC) using an SSL connection?

Thanks,
Graham

2

p.s. the RDS Db instance is also in the same datacenter as my EC2 which I guess reduces the risk of packet sniffers(?) but it would be better to have it secure all the way.

Graham

3

pls address to MyDAC documentation

4

Hi Evgeny,

Sorry, I understand it’s handled by MyDAC, but I do not know how to access the MyDAC connection component through the ConnectionManager, once I can get a handle to the TMyConnection component, I should be fine from there.

Graham

5

something like

procedure TServerDataModule.ConnectionManagerConnectionCreated(Sender: TDAConnectionManager;
  const Connection: IDAConnection);
var
  conn: TMyConnection;
  coa: IDAConnectionObjectAccess;
begin
  if Supports(Connection, IDAConnectionObjectAccess, coa) then begin
    conn := TMyConnection(coa.ConnectionObject);
    ..
  end;
end;
6

Ok, thanks.

I’ve just found that I can specify SslMode=Required in the connection string so hopefully this will be what I need to use.

I’m sure I’ll need your code too so thanks for this.

Kind regards,
Graham