MySQL through a proxy server (General questions)

by Damon, Tuesday, November 08, 2005, 16:16 (6954 days ago)

I was referred to you by MicroOLAP for the problem I'm trying to solve. I'm trying to get MicroOLAP's DAC for MySQL components to connect to a remote MySQL database when the client has to go through a proxy sever. Here's what I'm doing:

[code]
wodTunnel1.Hostname := 'my_mysql_server_hostname';
wodTunnel1.Login := 'demo';
wodTunnel1.Password := 'demo';
wodTunnel1.Port := 3306;
wodTunnel1.ProxyHostname := 'my_proxy_server_hostname';
wodTunnel1.ProxyPort := 8080;
wodTunnel1.ProxyType := ProxyWEBStandard;
wodTunnel1.Connect;

wodTunnel1.Channels.StopAll;
wodTunnel1.Channels.Add(LocalListen, 'localhost', 3306, 'my_proxy_server_hostname', 8080);
wodTunnel1.Channels.StartAll;

DB := TMySQLDatabase.Create(nil);
try
with DB do begin
LoginPrompt := False;
Host := 'my_mysql_server_hostname ';
Port := 3306;
Username := 'my_mysql_username';
UserPassword := 'my_mysql_password';
DatabaseName := 'my_database';
Connected := True;
end;

... do some other stuff here ...

finally
DB.Close;
DB.Free;
end;
[/code]

After calling Connect, I see my HTTP connection on the proxy server from my IP address. When I try to start all channels I get the error: Cannot start/stop channel, not connected to the server . Any ideas on what I'm doing wrong?