http tunnel

http tunnel

Postby oleengvoll » Mon 04 Jun 2012 20:55

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
oleengvoll
 
Posts: 12
Joined: Tue 27 Sep 2011 08:37

Re: http tunnel

Postby Pinturiccio » Tue 05 Jun 2012 14:17

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.
Pinturiccio
Devart Team
 
Posts: 1852
Joined: Wed 02 Nov 2011 09:44

Re: http tunnel

Postby oleengvoll » Tue 05 Jun 2012 15:02

Ok. So no mather if a user blocks his port number 3306 in his firewall, Devart http tunnel will connect to the mySql datatabase?
oleengvoll
 
Posts: 12
Joined: Tue 27 Sep 2011 08:37

Re: http tunnel

Postby oleengvoll » Wed 06 Jun 2012 19:16

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
oleengvoll
 
Posts: 12
Joined: Tue 27 Sep 2011 08:37

Re: http tunnel

Postby oleengvoll » Wed 06 Jun 2012 20:23

Solved (just if somebody else is having same problem)
This is not working: mySqlConn.HttpOptions.Port = 8080;
Port must be included in connectionstring!
oleengvoll
 
Posts: 12
Joined: Tue 27 Sep 2011 08:37


Return to dotConnect for MySQL