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
Hello Dwight,i had a peek at the Connection.xml and didnt found the proxy-port parameter in there: MySQL False xxxxxxx srv D27C7CFF:Production yyyyyyyy False 0001-01-01T00:00:00.0000000 Maybe thats a related issue? However, if i open the connection manager, the correct port (8080 in our case) is shown...regardsMarc
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
Doc Jones,Hey, no problem. What was the misunderstanding. Maybe there's something that we can do to make this process easier.
Heyas Dwight,sorry for the inconvenience, but the HTTP Proxy stuff still does not work (tested with latest Beta 22.214.171.124). 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?regardsMarc