sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kavan Suresh (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-2896) Sqoop exec job fails with SQLException Access denied for user
Date Mon, 28 Mar 2016 18:08:25 GMT
Kavan Suresh created SQOOP-2896:
-----------------------------------

             Summary: 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
          Components: sqoop2-client
            Reporter: Kavan Suresh


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)

Mime
View raw message