|
Replies:
5
-
Pages:
1
-
Last Post:
Mar 9, 2010 11:37 PM
by: DocJones
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
50
Registered:
2/22/10
|
|
|
|
HTTP Proxy Connection
Posted:
Mar 1, 2010 5:45 AM
|
|
|
Heyas,
i am trying to access a remote MySQL Database via HTTP Proxy. However, i get a instant 10061: 'Can't connect to MySQL server on 'xxxxxx' (10061)' when i try to connect.
I grabbed the Exception log from the ExceptionTrace.log below. Does the stacktrace tell me that the proxy is denying the connection or is it the remote machine?
--------------------
Devart.Data.MySql.MySqlException: Can't connect to MySQL server on 'xxxxxx' (10061)
Stack trace:
bei Devart.Data.MySql.u.a(String A_0, String A_1, String A_2, String A_3, Int32 A_4, String A_5, Int32 A_6, SshOptions A_7, SslOptions A_8, ProxyOptions A_9, MySqlHttpOptions A_10, HttpOptions A_11)
bei Devart.Data.MySql.MySqlInternalConnection.Connect(String userId, String password, String host, String database, Int32 port, Int32 connectionTimeout, MySqlProtocol protocol, Boolean compress, Boolean clientInteractive)
bei Devart.Data.MySql.MySqlInternalConnection..ctor(p connectionOptions)
bei Devart.Data.MySql.ao.a(aa A_0, Object A_1, DbConnectionBase A_2)
bei Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0, aa A_1)
bei Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
bei Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
bei Devart.Common.DbConnectionBase.Open()
bei Devart.Data.MySql.MySqlConnection.Open()
bei Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
bei Quest.Toad.MySQL.MySQLConnection.OpenConnection(IDbConnection connection)
bei Quest.Toad.Db.Connection.AllocConnection()
bei Quest.Toad.Db.Connection.Connect(Boolean notify)
bei Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
--------------------
regards
/Marc
|
Level 197 Nanomage NT from Rimor speaking... err, wait: Wrong Forum!
|
|
Posts:
68
Registered:
8/22/07
|
|
|
|
Re: HTTP Proxy Connection
Posted:
Mar 1, 2010 12:13 PM
in response to: DocJones
|
|
|
Marc,
This is definitely not the behavior that we were looking for. I'm going to pass this along to our team and see what they can come up with.
Dwight
|
|
|
Posts:
50
Registered:
2/22/10
|
|
|
|
Re: HTTP Proxy Connection
Posted:
Mar 2, 2010 1:41 AM
in response to: Dwight
|
|
|
Hello Dwight,
i had a peek at the Connection.xml and didnt found the proxy-port parameter in there:
<Connection type="MySQL" autoCommit="True">
<Path>MySQL</Path>
<AutoConnect>False</AutoConnect>
<Database>
</Database>
<Host>xxxxxxx</Host>
<User>srv</User>
<Category>D27C7CFF:Production</Category>
<Password>yyyyyyyy</Password>
<WinAuth>False</WinAuth>
<LastConnectionDate>0001-01-01T00:00:00.0000000</LastConnectionDate>
<Options>
<Protocol type="Socket" port="47001" compress="yes" />
<HTTP host="proxy.ids-logistik.de" />
</Options>
</Connection>
Maybe thats a related issue? However, if i open the connection manager, the correct port (8080 in our case) is shown...
regards
Marc
|
Level 197 Nanomage NT from Rimor speaking... err, wait: Wrong Forum!
|
|
Posts:
50
Registered:
2/22/10
|
|
|
|
Re: HTTP Proxy Connection
Posted:
Mar 2, 2010 1:51 AM
in response to: DocJones
|
|
|
|
|
Nevermind, my fault (haven't looked good enough), skip this issue! Sorry for Spam!
---------------------------------------------------
Hello Dwight,
while i was investigating above mentioned issue, i discovered that i have 12 connections in my Connection.xml file, while the connection manager only shows 11 (see image).
I can send you the Connection.xml file in a seperate mail, if you need it. Would like to avoid posting due to passwords being stored in there.
regards
/M
Message was edited by: DocJones
|
Level 197 Nanomage NT from Rimor speaking... err, wait: Wrong Forum!
|
|
Posts:
68
Registered:
8/22/07
|
|
|
|
Re: HTTP Proxy Connection
Posted:
Mar 9, 2010 11:26 AM
in response to: DocJones
|
|
|
Doc Jones,
Hey, no problem. What was the misunderstanding. Maybe there's something that we can do to make this process easier.
Dwight
|
|
|
Posts:
50
Registered:
2/22/10
|
|
|
|
Re: HTTP Proxy Connection
Posted:
Mar 9, 2010 11:37 PM
in response to: Dwight
|
|
|
|
|
Heyas Dwight,
sorry for the inconvenience, but the HTTP Proxy stuff still does not work (tested with latest Beta 5.0.0.157).
The connection file does not show the proxy port (8080 in our case). If i set it to a different port (eg 8079), the port="8079" parameter will be saved to the connection file, so i assume you are only saving non defaults?
The stack trace in Exceptions.xml is the same as mentioned in my first post.
When i try to connect to a connection from the connection manager after the initial load, TOAD tries to connect to 'localhost' (and subsequently fails - see attached image).
Anything i can provide you with?
regards
Marc
|
Level 197 Nanomage NT from Rimor speaking... err, wait: Wrong Forum!
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
