[ https://issues.apache.org/jira/browse/SQOOP-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sowmya Ramesh reassigned SQOOP-2896: ------------------------------------ Assignee: Sowmya Ramesh > Sqoop exec job fails with SQLException Access denied for user > ------------------------------------------------------------- > > Key: SQOOP-2896 > URL: https://issues.apache.org/jira/browse/SQOOP-2896 > Project: Sqoop > Issue Type: Bug > Reporter: Kavan Suresh > Assignee: Sowmya Ramesh > > Sqoop save jobs which records the config information required to execute a > Sqoop command have been failing on recent builds with an access denied > exception. The default behavior is to create a job and then invoke the job > with exec job command by passing username and password. In the recent builds > of HDP 2.4 the parameter is not being passed when executing the exec command > as seen in the below logs: > {code:java} > RUNNING: /usr/hdp/current/sqoop-client/bin/sqoop job --create myjob -- eval > --driver com.mysql.jdbc.Driver --connect > jdbc:mysql://hn0-sqoop.sqoop-hadl24-ssh.c7.internal.cloudapp.net/employees -e > "select e.emp_no, e.first_name, e.last_name from employees as e limit 10" > --username sqoop --password sqoop > 2016-03-22 > 22:15:02,464|beaver.machine|INFO|3182|139761292187392|Thread-4|Warning: > /usr/hdp/2.4.2.0-29/accumulo does not exist! Accumulo imports will fail. > 2016-03-22 > 22:15:02,464|beaver.machine|INFO|3182|139761292187392|Thread-4|Please set > $ACCUMULO_HOME to the root of your Accumulo installation. > 2016-03-22 > 22:15:05,815|beaver.machine|INFO|3182|139761283794688|Thread-5|16/03/22 > 22:15:05 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.4.2.0-29 > 2016-03-22 > 22:15:06,682|beaver.machine|INFO|3182|139761283794688|Thread-5|SLF4J: Class > path contains multiple SLF4J bindings. > 2016-03-22 > 22:15:06,683|beaver.machine|INFO|3182|139761283794688|Thread-5|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:06,683|beaver.machine|INFO|3182|139761283794688|Thread-5|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:06,683|beaver.machine|INFO|3182|139761283794688|Thread-5|SLF4J: See > http://www.slf4j.org/codes.html#multiple_bindings for an explanation. > 2016-03-22 > 22:15:06,693|beaver.machine|INFO|3182|139761283794688|Thread-5|SLF4J: Actual > binding is of type [org.slf4j.impl.Log4jLoggerFactory] > 2016-03-22 > 22:15:07,710|beaver.machine|INFO|3182|139761283794688|Thread-5|16/03/22 > 22:15:07 WARN tool.BaseSqoopTool: Setting your password on the command-line > is insecure. Consider using -P instead. > 2016-03-22 > 22:15:08,550|beaver.machine|INFO|3182|139761510102848|MainThread|RUNNING: > /usr/hdp/current/sqoop-client/bin/sqoop job --list > 2016-03-22 > 22:15:08,572|beaver.machine|INFO|3182|139761292187392|Thread-6|Warning: > /usr/hdp/2.4.2.0-29/accumulo does not exist! Accumulo imports will fail. > 2016-03-22 > 22:15:08,573|beaver.machine|INFO|3182|139761292187392|Thread-6|Please set > $ACCUMULO_HOME to the root of your Accumulo installation. > 2016-03-22 > 22:15:12,014|beaver.machine|INFO|3182|139761283794688|Thread-7|16/03/22 > 22:15:12 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.4.2.0-29 > 2016-03-22 > 22:15:12,855|beaver.machine|INFO|3182|139761283794688|Thread-7|SLF4J: Class > path contains multiple SLF4J bindings. > 2016-03-22 > 22:15:12,855|beaver.machine|INFO|3182|139761283794688|Thread-7|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:12,856|beaver.machine|INFO|3182|139761283794688|Thread-7|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:12,856|beaver.machine|INFO|3182|139761283794688|Thread-7|SLF4J: See > http://www.slf4j.org/codes.html#multiple_bindings for an explanation. > 2016-03-22 > 22:15:12,864|beaver.machine|INFO|3182|139761283794688|Thread-7|SLF4J: Actual > binding is of type [org.slf4j.impl.Log4jLoggerFactory] > 2016-03-22 > 22:15:13,961|beaver.machine|INFO|3182|139761292187392|Thread-6|Available jobs: > 2016-03-22 > 22:15:13,962|beaver.machine|INFO|3182|139761292187392|Thread-6|myjob > {code} > {code:java} > 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) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)