sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sowmya Ramesh <sram...@hortonworks.com>
Subject Review Request 45446: Sqoop exec job fails with SQLException Access denied for user
Date Tue, 29 Mar 2016 20:36:51 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/45446/
-----------------------------------------------------------

Review request for Sqoop and Venkat Ranganathan.


Repository: sqoop-trunk


Description
-------

Sqoop exec job fails with SQLException Access denied for user

RUNNING: /usr/hdp/current/sqoop-client/bin/sqoop job --exec myjob -- --username sqoop --password
sqoop
2016-03-22 22:15:22,783|beaver.machine|INFO|3182|139761283794688|Thread-10|Warning: /usr/hdp/2.4.2.0-29/accumulo
does not exist! Accumulo imports will fail.
2016-03-22 22:15:22,783|beaver.machine|INFO|3182|139761283794688|Thread-10|Please set $ACCUMULO_HOME
to the root of your Accumulo installation.
2016-03-22 22:15:27,442|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:27
INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.4.2.0-29
2016-03-22 22:15:28,531|beaver.machine|INFO|3182|139761292187392|Thread-11|SLF4J: Class path
contains multiple SLF4J bindings.
2016-03-22 22:15:28,531|beaver.machine|INFO|3182|139761292187392|Thread-11|SLF4J: Found binding
in [jar:file:/usr/hdp/2.4.2.0-29/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2016-03-22 22:15:28,531|beaver.machine|INFO|3182|139761292187392|Thread-11|SLF4J: Found binding
in [jar:file:/usr/hdp/2.4.2.0-29/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2016-03-22 22:15:28,531|beaver.machine|INFO|3182|139761292187392|Thread-11|SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings
for an explanation.
2016-03-22 22:15:28,542|beaver.machine|INFO|3182|139761292187392|Thread-11|SLF4J: Actual binding
is of type [org.slf4j.impl.Log4jLoggerFactory]
2016-03-22 22:15:30,073|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
ERROR sqoop.SqoopOptions: It seems that you have launched a Sqoop metastore job via
2016-03-22 22:15:30,083|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
ERROR sqoop.SqoopOptions: Oozie with sqoop.metastore.client.record.password disabled.
2016-03-22 22:15:30,083|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
ERROR sqoop.SqoopOptions: But this configuration is not supported because Sqoop can't
2016-03-22 22:15:30,084|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
ERROR sqoop.SqoopOptions: prompt the user to enter the password while being executed
2016-03-22 22:15:30,093|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
ERROR sqoop.SqoopOptions: as Oozie tasks. Please enable sqoop.metastore.client.record
2016-03-22 22:15:30,093|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
ERROR sqoop.SqoopOptions: .password in sqoop-site.xml, or provide the password
2016-03-22 22:15:30,093|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
ERROR sqoop.SqoopOptions: explicitly using --password in the command tag of the Oozie
2016-03-22 22:15:30,094|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
ERROR sqoop.SqoopOptions: workflow file.
2016-03-22 22:15:30,229|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate
connection manager is not being set (via --connection-manager). Sqoop is going to fall back
to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection
manager should be used next time.
2016-03-22 22:15:30,264|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
INFO manager.SqlManager: Using default fetchSize of 1000
2016-03-22 22:15:30,769|beaver.machine|INFO|3182|139761292187392|Thread-11|16/03/22 22:15:30
WARN tool.EvalSqlTool: SQL exception executing statement: java.sql.SQLException: Access denied
for user 'sqoop'@'10.0.0.26' (using password: NO)


Diffs
-----

  src/java/org/apache/sqoop/tool/JobTool.java 2eafac3 

Diff: https://reviews.apache.org/r/45446/diff/


Testing
-------

Manual testing done


Thanks,

Sowmya Ramesh


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message