Devart Forums

anisbd

Using password consisting of Latin symbols but i am getting same error

conn.ConnectionString = "uid=xxxx;pwd=āāāāā1";
                conn.Protocol = MySqlProtocol.Http;
                conn.HttpOptions.Url = "http://www.xxxxx.com/tunnel.php";
                conn.ConnectionTimeout = 9000;
                conn.Charset = "utf8";
                conn.Open();

Remember that Successfully connected using SQLyog (Both ISP) http://www.xxxxxxxx.com/SQLyogTunnel.php.
But http://www.xxxxx.com/tunnel.php failed

anisbd

I was increased connection timeout but getting error. Can't connect to MySQL server on 'localhost' (10061): Authentication failed.

Code: Select all

MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "server=localhost;uid=xxxx;pwd=xxx";
conn.Protocol = MySqlProtocol.Http;
conn.HttpOptions.Url = "http://www.xxxxxx.com/tunnel.php";
conn.ConnectionTimeout = 2000;
conn.Charset = "utf8";

_connections.id.php detail information from server

Code: Select all

57747 976777 44241
963 825692 41580
810411 875371 52101

httptunnel_server.log

Code: Select all

09.11.2010 21:51:58 - Connected to remote  localhost: 3306
09.11.2010 21:51:58 - Waiting for client...
09.11.2010 21:51:58 - 810411 875371
09.11.2010 21:52:01 - Client: Reading from server script
09.11.2010 21:52:01 - Client accepted
09.11.2010 21:52:01 - Read from client (1): r
09.11.2010 21:52:01 - Script liftetime incremented with 180
09.11.2010 21:52:01 - Read from remote:(70)
09.11.2010 21:52:01 - Write to client(70): B   
5.0.90-community-log Ë$z a#(?EzZ4 ,¢!              4HL$m|G,DQLh 
09.11.2010 21:52:01 - Waiting for client...
09.11.2010 21:52:01 - Client: Read from server 70
09.11.2010 21:52:02 - Client accepted
09.11.2010 21:52:02 - Client: Reading from server script
09.11.2010 21:52:02 - Read from client (1): r
09.11.2010 21:52:02 - Script liftetime incremented with 180
09.11.2010 21:52:08 - Read from remote:(0)
09.11.2010 21:52:08 - Nothing to read from remote.
09.11.2010 21:52:08 - Write to client(0): 
09.11.2010 21:52:08 - Waiting for client...
09.11.2010 21:52:08 - Client: Read from server 0
09.11.2010 21:52:10 - Client accepted
09.11.2010 21:52:10 - Client: Reading from server script
09.11.2010 21:52:10 - Read from client (1): r
09.11.2010 21:52:10 - Script liftetime incremented with 180
09.11.2010 21:52:10 - Read from remote:(0)
09.11.2010 21:52:10 - Nothing to read from remote.
09.11.2010 21:52:10 - Write to client(0): 
09.11.2010 21:52:10 - Waiting for client...
09.11.2010 21:52:10 - Client: Read from server 0
09.11.2010 21:52:10 - Client: Reading from server script
09.11.2010 21:52:10 - Client accepted
09.11.2010 21:52:10 - Read from client (1): r
09.11.2010 21:52:10 - Script liftetime incremented with 180
09.11.2010 21:52:10 - Read from remote:(0)
09.11.2010 21:52:10 - Nothing to read from remote.
09.11.2010 21:52:10 - Write to client(0): 
09.11.2010 21:52:10 - Waiting for client...
09.11.2010 21:52:10 - Client: Read from server 0
09.11.2010 21:52:11 - Client: Reading from server script
09.11.2010 21:52:11 - Client accepted
09.11.2010 21:52:11 - Read from client (1): r
09.11.2010 21:52:11 - Script liftetime incremented with 180
09.11.2010 21:52:11 - Read from remote:(0)
09.11.2010 21:52:11 - Nothing to read from remote.
09.11.2010 21:52:11 - Write to client(0): 
09.11.2010 21:52:11 - Client: Read from server 0
09.11.2010 21:52:11 - Waiting for client...
09.11.2010 21:52:12 - Client accepted
09.11.2010 21:52:12 - Client: Reading from server script
09.11.2010 21:52:12 - Read from client (1): r
09.11.2010 21:52:12 - Script liftetime incremented with 180
09.11.2010 21:52:12 - Read from remote:(0)
09.11.2010 21:52:12 - Nothing to read from remote.
09.11.2010 21:52:12 - Write to client(0): 
09.11.2010 21:52:12 - Waiting for client...
09.11.2010 21:52:12 - Client: Read from server 0
09.11.2010 21:52:15 - Client: Reading from server script
09.11.2010 21:52:15 - Client accepted
09.11.2010 21:52:15 - Read from client (1): r
09.11.2010 21:52:15 - Script liftetime incremented with 180
09.11.2010 21:52:15 - Read from remote:(0)
09.11.2010 21:52:15 - Nothing to read from remote.
09.11.2010 21:52:15 - Write to client(0): 
09.11.2010 21:52:15 - Waiting for client...
09.11.2010 21:52:15 - Client: Read from server 0
09.11.2010 21:52:16 - Client accepted
09.11.2010 21:52:16 - Client: Reading from server script
09.11.2010 21:52:16 - Read from client (1): r
09.11.2010 21:52:16 - Script liftetime incremented with 180
09.11.2010 21:52:16 - Read from remote:(0)
09.11.2010 21:52:16 - Nothing to read from remote.
09.11.2010 21:52:16 - Write to client(0): 
09.11.2010 21:52:16 - Client: Read from server 0
09.11.2010 21:52:16 - Waiting for client...
09.11.2010 21:52:17 - Client accepted
09.11.2010 21:52:17 - Client: Reading from server script
09.11.2010 21:52:17 - Read from client (1): r
09.11.2010 21:52:17 - Script liftetime incremented with 180
09.11.2010 21:52:17 - Read from remote:(0)
09.11.2010 21:52:17 - Nothing to read from remote.
09.11.2010 21:52:17 - Write to client(0): 
09.11.2010 21:52:17 - Waiting for client...
09.11.2010 21:52:17 - Client: Read from server 0
09.11.2010 21:52:18 - Client accepted
09.11.2010 21:52:18 - Client: Reading from server script
09.11.2010 21:52:18 - Read from client (1): r
09.11.2010 21:52:18 - Script liftetime incremented with 180
09.11.2010 21:52:18 - Read from remote:(0)
09.11.2010 21:52:18 - Nothing to read from remote.
09.11.2010 21:52:18 - Write to client(0): 
09.11.2010 21:52:18 - Client: Read from server 0
09.11.2010 21:52:18 - Waiting for client...
09.11.2010 21:52:19 - Client accepted
09.11.2010 21:52:19 - Client: Reading from server script
09.11.2010 21:52:19 - Read from client (1): r
09.11.2010 21:52:19 - Script liftetime incremented with 180
09.11.2010 21:52:19 - Read from remote:(0)
09.11.2010 21:52:19 - Nothing to read from remote.
09.11.2010 21:52:19 - Write to client(0): 
09.11.2010 21:52:19 - Waiting for client...
09.11.2010 21:52:19 - Client: Read from server 0
09.11.2010 21:52:20 - Client: Reading from server script
09.11.2010 21:52:20 - Client accepted
09.11.2010 21:52:20 - Read from client (1): r
09.11.2010 21:52:20 - Script liftetime incremented with 180
09.11.2010 21:52:20 - Read from remote:(0)
09.11.2010 21:52:20 - Nothing to read from remote.
09.11.2010 21:52:20 - Write to client(0): 
09.11.2010 21:52:20 - Client: Read from server 0
09.11.2010 21:52:20 - Waiting for client...
09.11.2010 21:52:21 - Client accepted
09.11.2010 21:52:21 - Read from client (1): x
09.11.2010 21:52:21 - Script liftetime incremented with 180
09.11.2010 21:52:21 - Shutting down on client request.
09.11.2010 21:52:21 - Server script closed.
09.11.2010 21:52:38 - Client accepted
09.11.2010 21:52:38 - ERROR: Bad client.
09.11.2010 21:52:38 - Waiting for client...
09.11.2010 21:52:46 - Client accepted
09.11.2010 21:52:46 - ERROR: Bad client.
09.11.2010 21:52:46 - Waiting for client...

Following massage shown in my immediate window

Code: Select all

A first chance exception of type 'Devart.Data.MySql.MySqlException' occurred in Devart.Data.MySql.dll

anisbd

Please specify if you tried connecting with the previous ISP using these exact settings:
Code:

Code: Select all

MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "server=localhost;uid=xxxx;pwd=xxx";
conn.Protocol = MySqlProtocol.Http;
conn.HttpOptions.Url = "http://www.xxxxxx.com/tunnel.php";
conn.ConnectionTimeout = 300;
conn.Charset = "utf8";

Yes I used exact code with previous ISP.
but getting error.
Can't connect to MySQL server on 'localhost' (10061): Authentication failed.

As for the 'Can't connect to mysql server on xxxxxxx.com' problem when using the DNS name of the host, did you try setting
Code:
Code: Select all
conn.Host = "www.xxxxxxxxx.com";

but getting error.
Can't connect to MySQL server on 'www.xxxxx.com' (10061): Authentication failed.

anisbd

Thanks for your replay.

Please check that you are able to connect to this MySQL server directly (i.e., not via the HTTP tunnel) using some standard tool.

Yes, I am try using SQLYog but i can't connect(not via HTTP tunnel).

Error massage is "Error No. 2003
Can't connect to mysql server on xxxxxxx.com (10060)
"

In that server(www.xxxxxx.com) I already give permission for remote database access hosts ( like %).

Also, please use the DNS name or IP of the machine where the MySQL server is installed instead of 'localhost' in the connection string (note that for tunnel connections 'localhost' means the machine where the script is installed).

Besides that, please check that the character set specified in the connection string is the same as the one used on the server.

Code: Select all

MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "uid=xxxxx;pwd=xxxxxxx";
conn.Protocol = MySqlProtocol.Http;
conn.HttpOptions.Url = "http://www.xxxxxxxxx.com/tunnel.php";
conn.ConnectionTimeout = 300;
conn.Charset = "utf8";
conn.Host = "xxxxxxxxx.com";
conn.Open();

But i am fail again.......

UPDATE on 04-Nov-2010 :
I was tested on same PC (but another ISP (WIMAX)) . I was successfully connected. (not via HTTP tunnel)
Using following code I was connected via HTTP tunnel in same PC but another ISP (WIMAX).

MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "server=localhost;uid=xxxx;pwd=xxx";
conn.Protocol = MySqlProtocol.Http;
conn.HttpOptions.Url = "http://www.xxxxxx.com/tunnel.php";
conn.ConnectionTimeout = 300;
conn.Charset = "utf8";
conn.Open();

Now What's the problem... I think problem in ISP.
Please help me what can I do?

Note : Successfully connected using SQLyog (Both ISP) http://www.xxxxxxxx.com/SQLyogTunnel.php.

anisbd

Thanks to msdev and StanislavK.

I am fall in same problem as like msdev .
I am using dotConnect for MySQL 6.0 Beta.

Code: Select all

using Devart.Data;
using Devart.Data.MySql;


MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "server=localhost;uid=xxxxx;pwd=xxxxx";
conn.Protocol = MySqlProtocol.Http;
conn.HttpOptions.Url = "http://www.xxxxxxxxx.com/tunnel.php";
conn.Open();

I am getting following error -
Can't connect to MySQL server on 'localhost' (10061): Authentication failed.

httptunnel_server.log contains following massage -

Code: Select all

01.11.2010 02:01:48 - Connected to remote  localhost: 3306
01.11.2010 02:01:48 - Waiting for client...
01.11.2010 02:01:48 - 532994 52786
01.11.2010 02:01:49 - Client accepted
01.11.2010 02:01:49 - Client: Reading from server script
01.11.2010 02:01:49 - Read from client (1): r
01.11.2010 02:01:49 - Script liftetime incremented with 180
01.11.2010 02:01:49 - Read from remote:(70)
01.11.2010 02:01:49 - Write to client(70): B���
5.0.90-community-log�.�c�Cs<p?*TF�,�!��������������EdJ$q3HO4W8R�
01.11.2010 02:01:49 - Client: Read from server 70
01.11.2010 02:01:49 - Waiting for client...
01.11.2010 02:01:49 - Client accepted
01.11.2010 02:01:49 - Client: Reading from server script
01.11.2010 02:01:49 - Read from client (1): r
01.11.2010 02:01:49 - Script liftetime incremented with 180
01.11.2010 02:01:58 - Read from remote:(0)
01.11.2010 02:01:58 - Nothing to read from remote.
01.11.2010 02:01:58 - Write to client(0): 
01.11.2010 02:01:58 - Waiting for client...
01.11.2010 02:01:58 - Client: Read from server 0
01.11.2010 02:01:58 - Client: Reading from server script
01.11.2010 02:01:58 - Client accepted
01.11.2010 02:01:58 - Read from client (1): r
01.11.2010 02:01:58 - Script liftetime incremented with 180
01.11.2010 02:01:58 - Read from remote:(0)
01.11.2010 02:01:58 - Nothing to read from remote.
01.11.2010 02:01:58 - Write to client(0): 
01.11.2010 02:01:58 - Client: Read from server 0
01.11.2010 02:01:58 - Waiting for client...
01.11.2010 02:01:59 - Client: Reading from server script
01.11.2010 02:01:59 - Client accepted
01.11.2010 02:01:59 - Read from client (1): r
01.11.2010 02:01:59 - Script liftetime incremented with 180
01.11.2010 02:01:59 - Read from remote:(0)
01.11.2010 02:01:59 - Nothing to read from remote.
01.11.2010 02:01:59 - Write to client(0): 
01.11.2010 02:01:59 - Client: Read from server 0
01.11.2010 02:01:59 - Waiting for client...
01.11.2010 02:01:59 - Client: Reading from server script
01.11.2010 02:01:59 - Client accepted
01.11.2010 02:01:59 - Read from client (1): r
01.11.2010 02:01:59 - Script liftetime incremented with 180
01.11.2010 02:01:59 - Read from remote:(0)
01.11.2010 02:01:59 - Nothing to read from remote.
01.11.2010 02:01:59 - Write to client(0): 
01.11.2010 02:01:59 - Waiting for client...
01.11.2010 02:01:59 - Client: Read from server 0
01.11.2010 02:02:00 - Client: Reading from server script
01.11.2010 02:02:00 - Client accepted
01.11.2010 02:02:00 - Read from client (1): r
01.11.2010 02:02:00 - Script liftetime incremented with 180
01.11.2010 02:02:00 - Read from remote:(0)
01.11.2010 02:02:00 - Nothing to read from remote.
01.11.2010 02:02:00 - Client: Read from server 0
01.11.2010 02:02:00 - Write to client(0): 
01.11.2010 02:02:00 - Waiting for client...
01.11.2010 02:02:01 - Client accepted
01.11.2010 02:02:01 - Client: Reading from server script
01.11.2010 02:02:01 - Read from client (1): r
01.11.2010 02:02:01 - Script liftetime incremented with 180
01.11.2010 02:02:01 - Read from remote:(0)
01.11.2010 02:02:01 - Nothing to read from remote.
01.11.2010 02:02:01 - Write to client(0): 
01.11.2010 02:02:01 - Client: Read from server 0
01.11.2010 02:02:01 - Waiting for client...
01.11.2010 02:02:01 - Client: Reading from server script
01.11.2010 02:02:01 - Client accepted
01.11.2010 02:02:01 - Read from client (1): r
01.11.2010 02:02:01 - Script liftetime incremented with 180
01.11.2010 02:02:01 - Read from remote:(0)
01.11.2010 02:02:01 - Nothing to read from remote.
01.11.2010 02:02:01 - Write to client(0): 
01.11.2010 02:02:01 - Waiting for client...
01.11.2010 02:02:01 - Client: Read from server 0
01.11.2010 02:02:02 - Client: Reading from server script
01.11.2010 02:02:02 - Client accepted
01.11.2010 02:02:02 - Read from client (1): r
01.11.2010 02:02:02 - Script liftetime incremented with 180
01.11.2010 02:02:02 - Read from remote:(0)
01.11.2010 02:02:02 - Nothing to read from remote.
01.11.2010 02:02:02 - Client: Read from server 0
01.11.2010 02:02:02 - Write to client(0): 
01.11.2010 02:02:02 - Waiting for client...
01.11.2010 02:02:02 - Client accepted
01.11.2010 02:02:02 - Client: Reading from server script
01.11.2010 02:02:02 - Read from client (1): r
01.11.2010 02:02:02 - Script liftetime incremented with 180
01.11.2010 02:02:02 - Read from remote:(0)
01.11.2010 02:02:02 - Nothing to read from remote.
01.11.2010 02:02:02 - Write to client(0): 
01.11.2010 02:02:02 - Waiting for client...
01.11.2010 02:02:02 - Client: Read from server 0
01.11.2010 02:02:03 - Client accepted
01.11.2010 02:02:03 - Client: Reading from server script
01.11.2010 02:02:03 - Read from client (1): r
01.11.2010 02:02:03 - Script liftetime incremented with 180
01.11.2010 02:02:03 - Read from remote:(0)
01.11.2010 02:02:03 - Nothing to read from remote.
01.11.2010 02:02:03 - Write to client(0): 
01.11.2010 02:02:03 - Waiting for client...
01.11.2010 02:02:03 - Client: Read from server 0
01.11.2010 02:02:03 - Client: Reading from server script
01.11.2010 02:02:03 - Client accepted
01.11.2010 02:02:03 - Read from client (1): r
01.11.2010 02:02:03 - Script liftetime incremented with 180
01.11.2010 02:02:03 - Read from remote:(0)
01.11.2010 02:02:03 - Nothing to read from remote.
01.11.2010 02:02:03 - Client: Read from server 0
01.11.2010 02:02:03 - Write to client(0): 
01.11.2010 02:02:03 - Waiting for client...
01.11.2010 02:02:04 - Client accepted
01.11.2010 02:02:04 - Read from client (1): x
01.11.2010 02:02:04 - Script liftetime incremented with 180
01.11.2010 02:02:04 - Shutting down on client request.
01.11.2010 02:02:04 - Server script closed.

Note : I am testing http://www.xxxxxxxx.com/SQLyogTunnel.php using SQLyog this tunnel was connected successfully.

Please help me...

Search found 5 matches