Toad World® Forums

Using CLI with remote server root user/pw got access denied error


#1

I am trying to access MySQL through Toad Edge (TE) CLI using the connection XML file generated via CICD Wizard. I am getting access denied error from the remote server.

Further trouble-shooting found that TE CLI is appending the localhost IP to the root user account, instead of using root account for the endpoint server, which is specified in connection XML file / HOST tag below.

  1. Is this because CICD Wizard not generating connection XML with correct account?
  2. Is this caused by CLI not recognizing root account on remote server? 50.127 shown below is the ip for localhost, also the TE/CLI host PC.
  3. What is the correct syntax for remote server account that I should use in the connection XML?
    Below are the command output and a snippet of the connection XML.

C:\Program Files\Quest Software\Toad Edge\CLI>java -jar toadedge.jar -snapshot -in “./connection/ETL (BSFAurora).xml” -out “./snapshot/BSFAurora_ETL.json”
2018-06-22 09:04:52,892 INFO : Command: snapshot
2018-06-22 09:04:52,894 INFO : Loading source input
2018-06-22 09:04:53,633 ERROR: java.sql.SQLException: Access denied for user ‘root’@‘192.168.50.127’ (using password: YES)
com.quest.toad.execution.ExecutionException: java.sql.SQLException: Access denied for user ‘root’@‘192.168.50.127’ (using password: YES)
at com.quest.toad.execution.executor.SqlExecutor.getConnection(SqlExecutor.java:309)
at com.quest.toad.mysql.core.sql.MySqlExecutor.createConnection(MySqlExecutor.java:109)
at com.quest.toad.execution.executor.SqlExecutor.doReconnect(SqlExecutor.java:163)

<?xml version="1.0" encoding="UTF-8"?> MYSQL ETL Dev(BSFAurora) dev-etl-sandbox.cluster-cc6qja0eindn.us-east-1.rds.amazonaws.com 3306 root true encrypted password true 2018-06-21T09:11:34 #00FF00 BSFAurora

Thanks,

Eugene


#2

After regenerated the connection file the CLI command ran through with no error. This is resolved.


#3

Hi, thanks for information. There is also open support case, so i guess it can be closed

Miroslav Stanik


#4

Yes, please.

Thanks,

Eugene