You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Karthik S (JIRA)" <ji...@apache.org> on 2014/12/22 05:57:13 UTC
[jira] [Created] (SQOOP-1933) CryptoFileLoader does not work for
saved jobs
Karthik S created SQOOP-1933:
--------------------------------
Summary: CryptoFileLoader does not work for saved jobs
Key: SQOOP-1933
URL: https://issues.apache.org/jira/browse/SQOOP-1933
Project: Sqoop
Issue Type: Bug
Affects Versions: 1.4.5
Environment: Red Hat Enterprise Linux Server release 6.3 (Santiago)
Reporter: Karthik S
I am able to use the CryptoFile Loader to read encrypted passwords from a simple import command. However, the same command does not work from saved jobs
The below command works. There are no problems with it. It successfully decrypts the password and imports into hdfs
sqoop import -Dorg.apache.sqoop.credentials.loader.class=org.apache.sqoop.util.password.CryptoFileLoader -Dorg.apache.sqoop.credentials.loader.crypto.passphrase=sqooppass --driver com.mysql.jdbc.Driver --connect jdbc:mysql://00.00.000.000:0000/test --username user --password-file /user/user1/temp.txt --table emp --target-dir /user/user1/karthik/e129 --split-by emp_id
However, When i try using saved jobs, it does not work.
sqoop job -Dorg.apache.sqoop.credentials.loader.class=org.apache.sqoop.util.password.CryptoFileLoader -Dorg.apache.sqoop.credentials.loader.crypto.passphrase=sqooppass --create job9 -- import --driver com.mysql.jdbc.Driver --connect jdbc:mysql://00.00.000.000:3306/test --username user --password-file /user/user1/temp.txt --table emp --target-dir /user/user1/karthik/e130 --split-by emp_id
sqoop job -exec job9 -- --target-dir /user/user1/emp_103
It gives error
14/12/22 15:39:48 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Unable to fetch password from file.
java.lang.RuntimeException: Unable to fetch password from file.
at org.apache.sqoop.SqoopOptions.loadPasswordProperty(SqoopOptions.java:667)
at org.apache.sqoop.SqoopOptions.loadProperties(SqoopOptions.java:617)
at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.read(HsqldbJobStorage.java:299)
at org.apache.sqoop.tool.JobTool.execJob(JobTool.java:198)
at org.apache.sqoop.tool.JobTool.run(JobTool.java:283)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Caused by: java.io.IOException: Can't decrypt the password
at org.apache.sqoop.util.password.CryptoFileLoader.loadPassword(CryptoFileLoader.java:151)
at org.apache.sqoop.util.CredentialsUtil.fetchPasswordFromLoader(CredentialsUtil.java:81)
at org.apache.sqoop.SqoopOptions.loadPasswordProperty(SqoopOptions.java:664)
... 10 more
Caused by: javax.crypto.BadPaddingException: Given final block not properly padded
at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:811)
at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:676)
at com.sun.crypto.provider.AESCipher.engineDoFinal(AESCipher.java:313)
at javax.crypto.Cipher.doFinal(Cipher.java:2087)
at org.apache.sqoop.util.password.CryptoFileLoader.loadPassword(CryptoFileLoader.java:149)
... 12 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)