----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/45446/#review125995 -----------------------------------------------------------
Ship it! Thanks for updating the patch Sowmya. +1 - will commit after verification - Venkat Ranganathan On March 29, 2016, 3:40 p.m., Sowmya Ramesh wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/45446/ > ----------------------------------------------------------- > > (Updated March 29, 2016, 3:40 p.m.) > > > 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 > >
