HTTP Tunnel Timeout Problem

[kmdavisjr]

I need to do some dev work on a MySQL database Hosted on Rackspace so I do not have root access to this server or its variables. I have placed the tunnel.php file on the server and when I test the connection, I get the following error: "Lost connection to MySQL server during query" The http tab on the connection properties tab is correctly set and points to the tunnel.php file. The information is also correct on is is the general tab. I have tried changing the timeout setting on the advanced tab, which does nothing. I need to get into this DB very soon because of the dev work I need to get done on the server-side MySQL database. I am using DbForge Professional Edition v 5.0.97

Thanks

[alexa]

Could you please perform the following:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log'. Click 'OK'.
4. Navigate to the 'SQL Log' tab of the 'Output' window (select 'View -> Output' from the main menu).
5. Create a connection with HTTP tunneling, try to open it in Windows Explorer, and tell us whether the connection opens and if so, please provide us the content of the 'SQL Log' tab if there was added any since the connection opened.
6. Send us the 'httptunnel_server.log' file that is created on the server and located in the folder with the 'tunnel.php' file.

[kmdavisjr]

Could you please perform the following:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log'. Click 'OK'.
4. Navigate to the 'SQL Log' tab of the 'Output' window (select 'View -> Output' from the main menu).
5. Create a connection with HTTP tunneling, try to open it in Windows Explorer, and tell us whether the connection opens and if so, please provide us the content of the 'SQL Log' tab if there was added any since the connection opened.
6. Send us the 'httptunnel_server.log' file that is created on the server and located in the folder with the 'tunnel.php' file.

Windows Output:

Devart HttpTunnel v1.69
Tunnel script is installed correctly.
You can establish connections through the HTTP tunnel.

The DbForge SQL Log Tab in the output window is blank. No Output at all. There is no log on the server either. However, I was able to tunnel into another site, so I know that the tunnel file and dbforge are okay

[alexa]

The problem may be connected with the privileges on the server. Please try to grant the 777 permissions to the folder with the script and try to connect once again.

[kmdavisjr]

Hi,

Thanks for the answers and help. I have decided to use the host external IP in lieu of a http tunnel.

I do have another question however. Using SQL Server Management Studio it is pretty straight forward to find the physical location and file size of the SQL Server database files. Is this possible with DbForge?

[alexa]

We are planning to implement such functionality in one of the next versions of dbForge Studio for SQL Server.