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
http tunnel
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: http tunnel
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.
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.
-
- Posts: 12
- Joined: Tue 27 Sep 2011 08:37
Re: 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?
-
- Posts: 12
- Joined: Tue 27 Sep 2011 08:37
Re: http tunnel
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
"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
-
- Posts: 12
- Joined: Tue 27 Sep 2011 08:37
Re: http tunnel
Solved (just if somebody else is having same problem)
This is not working: mySqlConn.HttpOptions.Port = 8080;
Port must be included in connectionstring!
This is not working: mySqlConn.HttpOptions.Port = 8080;
Port must be included in connectionstring!