Devart Forums

I'm using Delphi 2009 and a licenced version of TMyConnection to connect to a MySQL database hosted remotely on my ISP's server over port 3306. I wanted to see if I could do this securely instead so I downloaded 'Securebridge 9.2 for Delphi 2009' and ran the installer to see if securebridge was what I wanted. I accepted the default install locations.

I couldn't find any documentation or help files explaining what to do to run the demos (at least none that I could open) so I picked one of the demos at random from C:\Users\Public\Documents\Devart\SecureBridge for RAD Studio 2009\Demos\SSHClientApp to see if I could look at some code.

Opening SSHClient.dproj from the default folder immediately gave me the completely meaningless error - at least meaningless to me,
followed by lots of other similar errors.

Now I can't even open Delphi without getting the error, no matter which of my other Delphi projects I choose.

So far I'm not sure I agree with the Devart web page where it says

easy to install and use: it is enough to place several components on the form and specify the server address and user credentials to establish a secure connection

.

Can anyone help me to get this demo working (if that's the right one) so that I can see if this securebridge component will allow me to connect and work as usual, except with encrypted transmission, and is therefore worth buying.

In case its any help I don't seem to have a component called Idiohandler in my IDE and don't have IndyCore20.bpl anywhere on my system. Should I have?

When installing SecureBridge using the installer, you can use the option Indy Components is set during installation at the "Select Components" step of the SecureBridge installation wizard.
This option allows you to install Indy non-standard components, and Devart SecureBridge Components for Indy that include the TScIdIOHandler component, which serves as an adapter between SecureBridge and Indy to create a secure SSH connection.
When this option is enabled, Devart SecureBridge Components for Indy will be automatically installed when installing SecureBridge. If you do not plan to use SecureBridge and Indy to create a secure SSH connection, then you do not have to select this option.
To uninstall Devart SecureBridge Components for Indy to perform the following step:
- remove Devart SecureBridge Components for Indy from [Components]-[Install Packages].

Also, you can install or reinstall Devart SecureBridge Components for Indy by yourself. You can find source files for Devart SecureBridge Components for Indy in the 'Demos\IndyX' folder of the SecureBridge demo projects installation directory. X is the version of the used Indy.
To reinstall Devart SecureBridge Components for Indy to perform the following steps:
- remove Devart SecureBridge Components for Indy from [Components]-[Install Packages] ;
- rebuild the packages: indyXsbridgeXX.dpk;
- install indyXsbridgeXX.dpk;
- restart IDE.

The TMySSHIOHandler (TMySSLIOHandler) component is located in the mydacsbridge package. This package comes with MyDAC, not with SecureBridge and is included in the MyDAC demos. See the package installation instructions in the file "%MyDACDemos%\TechnologySpecific\SecureBridge\Readme.html", where %MyDACDemos% is the MyDAC Demo projects installation path on your computer.
To test this functionality, you can use our SSH (SSL) demo project, which you can find in the directory: %MyDACDemos%\TechnologySpecific\SecureBridge\Demo\SSH (SSL), where %MyDACDemos% is the MyDAC Demo projects installation path on your computer.

Thank you for a comprehensive reply. I don't use Indy, just MyDac so it looks like part of the issue was that I was getting confused by the mention of Indy and partly because I didn't realise I had to manually install components before I could run the demos. I thought the install did that for me.

I'll take time to re-read your reply carefully but a few things immediately are apparent,
(1) I don't have TMySSHIOHandler in the MyDAC palette in Delphi, just these ones

TMyConnection
TMyQuery
TMyTable
TMyStoredProc
TMyCommaned
TMyScript
TMyUpdateSQL
TMyDataSource
TMyMetaData
TMyConnectDialog
TMySQLMonitor


Maybe there is something missing.

and (2) I don't seem to have the demo folder '...\Demo\SSH (SSL)' either, just these ones

SSHClient
SSHClientApp
SFTPClient
SignalR
SimpleSSHServer
SSHServer
SSHServerService
Base
CBiulder
Indy9
Indy10

Which demo program do you mean to help show the same connection as using TMyConnection but encrypted ?

As we noted earlier, the TMySSHIOHandler (TMySSLIOHandler) component is located in the mydacsbridge package. This package comes with MyDAC, not with SecureBridge, and is included in the MyDAC demos. See the package installation instructions in the file "%MyDACDemos%\TechnologySpecific\SecureBridge\Readme.html", where %MyDACDemos% is the MyDAC Demo projects installation path on your computer.
After successfully compiling and installing the mydacsbridge package, you should see the TMySSHIOHandler component in the MyDAC palette.
Our SSH (SSL) demo project is located in the directory %MyDACDemos%\TechnologySpecific\SecureBridge\Demo\SSH (SSL), where %MyDACDemos% is the MyDAC Demo projects installation path on your computer. The SSH demo project is located in MyDAC Demo projects, not in SecureBridge demo projects.