Re: ODBC Connection Failed when using Telstra
Hi Kevin,
The user name in MySQL consists of two parts 'mysql_user'@'client_host'.
The client_host part depends on how the client host network address is resolved.
It looks that the ODBC clients machines do not have neither a permanent global IP address nor a dedicated domain name. Hence, they are completely dependent on the name resolution.
I see two ways of dealing with the situation:
1. Less secure and hence less preferable would be creating a MySQL user
'MyUserID'@'%.lnk.telstra.net' or even 'MyUserID'@'%.telstra.net' on
the server side.
2. More proper and secure way is a global permanent IP address and a dedicated
domain name, which unambiguously identifies the user attempting the
connection.
Subject
Written By
Posted
December 04, 2016 04:46PM
Re: ODBC Connection Failed when using Telstra
December 18, 2016 11:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.