Problems with MyDac 7.1.4 and http tunneling

[pepetolo]

Hi!
I am testing http tunneling. My code is:

MyConnection := TMyConnection.Create(self);
MyConnection.Server := 'localhost';
MyConnection.Port := 3306;
MyConnection.Username := 'usrxx';
MyConnection.Password := 'myxx';
MyConnection.database := 'dbxx';
MyConnection.Options.Protocol := mpHttp;
MyConnection.HttpOptions.Url := 'http://www.xxx.com/tunnel.php';

MyConnection.LoginPrompt := False;
MyConnection.Connect;

When I run the program I get this message "Failed to open _connections.id.php". I copied tunnel.php to my web server but I don't have more php files. Please, can you help me?

Thanks,

Pep

[AndreyZ]

Hello,

The tunnel.php script creates the _connections.id.php file on a server. Please try connecting to a server and check if such file exists on a server after this. If it doesn't, it means that this file is removed by some antivirus software or firewall. To solve the problem, you should set up the software correctly so it doesn't remove the _connections.id.php file.

[frednerk]

I am also having the same problem.
My server is on a local Linux machine.
I have given 777 access to the www folder and it still comes up with the same error.
Any thoughts.

Tom

[ViktorV]

The "Failed to open _connections.id.php " error may occur due to some limitations on the PHP server (an antivirus or firewall blocks creation of this file, file system access restrictions, etc.). Such server behavior doesn't depend on MyDAC and is not within our competence. To solve the problem, you should contact your ISP technical support.

[frednerk]

The server is running in my house.
It is a raspberry pi running Linux.
I just hoped someone else had seen the same error and had a solution.
Tom

[ViktorV]

MyDAC allows to connect to MySQL http tunneling without additional setup, as well as any other software, in case if there are no restrictions (lack of access rights to the file system, closed ports, etc.). As we wrote above, this error may occur due to some restrictions on the side of PHP server or its settings.

[frednerk]

This is what I said, sorry about that.

I have had success in my setting up with my local machine with tunnel.php
However, if I run in debug mode I get a blocking error.
If I run the exe then all is now fine.
Any thoughts on how I can reconfigure the debug mode to accept this error and work.

Thanks in advance.

Tom

[ViktorV]

Please provide the full error text that occurs in you application in debug mode.

[frednerk]

Windows 7 64 bit
Delphi 7 32bit

Exception class HttpException.
Error on reading data from connection.
A blocking operation to WSACancelBlockingCall.
Socket Error code: 100004

When this is run as a program all is fine.
Works like a charm, but not with the debugger.

Tom

[ViktorV]

This exception is raised internally and it is processed by MyDAC. You can see this exception only if you run the application from IDE.
If you want to hide this message during the development of your application, then in the "Debugger Exception Notification" window select the "Ignore this exception type" check box and click "Continue".

[frednerk]

With Delphi 7 this option is not available.

[ViktorV]

To hide this message during development of your application in Delphi 7, you should follow the steps below:
- call the Debugger Options dialog using the main menu Tools-Debugger Options;
- on the Language Exception tab click the Add button;
- in the edit form enter HttpException and click Оk;
- click Ок in the Debugger Options dialog.

[frednerk]

Thanks for that.
Works like a charm.

[ViktorV]

It is good to see that the problem has been solved. Feel free to contact us if you have any further questions about MyDAC.