Devart Forums

Hi! We can't get the http tunnel system to work. When we blockport 3306 on our test PC, devart "MySqlConnection" cant make a connection to our mysql server.

So we wonder; What to do?

-----------------------------------------
Native error code is 10013
Socket error code is "System.Net.Sockets.SocketError.AccessDenied"
Translated error message:
Can't connect to MySQL server on '91.189.181.14' (10061):
An attempt was made to access a contact in a way that is forbidden by access permissions 91.xxx.yyy.14:3306

---------------------------------------
Here is the initialization code:

MySqlConnection mySqlConn = new MySqlConnection();
mySqlConn.Protocol = MySqlProtocol.Http;
mySqlConn.ConnectionTimeout = 30;
mySqlConn.ConnectionString = "server=http://www.democupassist.com;uid=abcde;pwd=defg;Database=ourmysqldbname";
mySqlConn.HttpOptions.Url = "http://www.democupassist.com/tunnel.php";
mySqlConn.HttpOptions.User = "demouser";
mySqlConn.HttpOptions.Password = "demopassword";
mySqlConn.Open();

--------------------------------------

Regs Ole

We have checked the connection http://91.189.181.14/tunnel.php, the following error occurs when establishing the connection: "Error: Failed to create (_connections.id.php) file: Permission denied."
Verify that the session.save_path variable settings of your php.ini are set correctly, and check the access permissions for php, as it is likely that the session for work of tunnel.php cannot be created because of wrong settings.
The tunnel.php script configured correctly with the PHP configured correctly will write you as follows:
Tunnel script is installed correctly.
You can establish connections through the HTTP tunnel.

Ok. So no mather if a user blocks his port number 3306 in his firewall, Devart http tunnel will connect to the mySql datatabase?

Hi! We found a restriction as Pinturiccio mentioned. This is fixed. But still no connection (same error as before):
"Can't connect to MySQL server on '91.189.181.14' (10061):
An attempt was made to access a contact in a way that is forbidden by access permissions 91.xxx.yyy.14:3306"

Please remember that we have set a blocking rule for port 3306 in the Windows firewall on the test PC. Without this rule, everything is working.

Regs Ole

Solved (just if somebody else is having same problem)
This is not working: mySqlConn.HttpOptions.Port = 8080;
Port must be included in connectionstring!