You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-issues@hadoop.apache.org by "Aaron Kimball (JIRA)" <ji...@apache.org> on 2009/07/06 19:37:14 UTC

[jira] Created: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Sqoop should read and transmit passwords in a more secure manner
----------------------------------------------------------------

                 Key: MAPREDUCE-710
                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
             Project: Hadoop Map/Reduce
          Issue Type: Improvement
          Components: contrib/sqoop
            Reporter: Aaron Kimball
            Assignee: Aaron Kimball
         Attachments: MAPREDUCE-710.patch

Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.

Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Tom White (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tom White updated MAPREDUCE-710:
--------------------------------

       Resolution: Fixed
    Fix Version/s: 0.21.0
     Hadoop Flags: [Reviewed]
           Status: Resolved  (was: Patch Available)

I've just committed this. Thanks Aaron!

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>             Fix For: 0.21.0
>
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.3.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-710:
------------------------------------

    Status: Patch Available  (was: Open)

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.3.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-710:
------------------------------------

    Status: Open  (was: Patch Available)

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.3.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-710:
------------------------------------

    Status: Open  (was: Patch Available)

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-710:
------------------------------------

    Status: Patch Available  (was: Open)

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729902#action_12729902 ] 

Aaron Kimball commented on MAPREDUCE-710:
-----------------------------------------

Test failures are still unrelated to the patch.  :)

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.3.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Hudson (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12731623#action_12731623 ] 

Hudson commented on MAPREDUCE-710:
----------------------------------

Integrated in Hadoop-Mapreduce-trunk #23 (See [http://hudson.zones.apache.org/hudson/job/Hadoop-Mapreduce-trunk/23/])
    . Sqoop should read and transmit passwords in a more secure manner. Contributed by Aaron Kimball.


> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>             Fix For: 0.21.0
>
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.3.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729895#action_12729895 ] 

Hadoop QA commented on MAPREDUCE-710:
-------------------------------------

-1 overall.  Here are the results of testing the latest attachment 
  http://issues.apache.org/jira/secure/attachment/12413143/MAPREDUCE-710.3.patch
  against trunk revision 792901.

    +1 @author.  The patch does not contain any @author tags.

    +1 tests included.  The patch appears to include 8 new or modified tests.

    +1 javadoc.  The javadoc tool did not generate any warning messages.

    +1 javac.  The applied patch does not increase the total number of javac compiler warnings.

    +1 findbugs.  The patch does not introduce any new Findbugs warnings.

    +1 release audit.  The applied patch does not increase the total number of release audit warnings.

    -1 core tests.  The patch failed core unit tests.

    -1 contrib tests.  The patch failed contrib unit tests.

Test results: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-vesta.apache.org/376/testReport/
Findbugs warnings: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-vesta.apache.org/376/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-vesta.apache.org/376/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-vesta.apache.org/376/console

This message is automatically generated.

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.3.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12727784#action_12727784 ] 

Aaron Kimball commented on MAPREDUCE-710:
-----------------------------------------

These test failures are unrelated to the patch.

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12727764#action_12727764 ] 

Hadoop QA commented on MAPREDUCE-710:
-------------------------------------

-1 overall.  Here are the results of testing the latest attachment 
  http://issues.apache.org/jira/secure/attachment/12412634/MAPREDUCE-710.patch
  against trunk revision 791418.

    +1 @author.  The patch does not contain any @author tags.

    +1 tests included.  The patch appears to include 8 new or modified tests.

    +1 javadoc.  The javadoc tool did not generate any warning messages.

    +1 javac.  The applied patch does not increase the total number of javac compiler warnings.

    +1 findbugs.  The patch does not introduce any new Findbugs warnings.

    +1 release audit.  The applied patch does not increase the total number of release audit warnings.

    -1 core tests.  The patch failed core unit tests.

    -1 contrib tests.  The patch failed contrib unit tests.

Test results: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-vesta.apache.org/357/testReport/
Findbugs warnings: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-vesta.apache.org/357/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-vesta.apache.org/357/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-vesta.apache.org/357/console

This message is automatically generated.

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-710:
------------------------------------

    Attachment: MAPREDUCE-710.patch

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Tom White (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729674#action_12729674 ] 

Tom White commented on MAPREDUCE-710:
-------------------------------------

+1 

Minor nitpick: Can you use org.apache.hadoop.util.Shell instead of manipulating Process directly for running chmod?

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-710:
------------------------------------

    Attachment: MAPREDUCE-710.2.patch

Attaching rebased patch after MAPREDUCE-685, 713.

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12727630#action_12727630 ] 

Aaron Kimball commented on MAPREDUCE-710:
-----------------------------------------

This patch adds a {{\-P}} flag which prompts for password on the console using java.io.Console.readPassword().

It also changes the mysqldump logic to write a user-readable-only file containing the password and use that instead of {{\-\-password}} on the command-line, which is insecure. Since mysqldump reads its password directly from the console, not from stdin, it is impossible to "directly" feed the password to mysqldump. Thus the user-only file is the means I've chosen to transmit the password.

I have added a new test case which Hudson won't run by default, to test this behavior. Users with mysql who wish to run this test should run {{ant jar \-Dtestcase=MySQLAuthTest}} in the {{src/contrib/sqoop}} directory.


> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-710:
------------------------------------

    Attachment: MAPREDUCE-710.3.patch

New patch including Tom's suggestion

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.2.patch, MAPREDUCE-710.3.patch, MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12727632#action_12727632 ] 

Aaron Kimball commented on MAPREDUCE-710:
-----------------------------------------

Oops - that should be {{ant test \-Dtestcase=MySQLAuthTest}}, not {{ant jar}}. 

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-710) Sqoop should read and transmit passwords in a more secure manner

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-710:
------------------------------------

    Status: Patch Available  (was: Open)

> Sqoop should read and transmit passwords in a more secure manner
> ----------------------------------------------------------------
>
>                 Key: MAPREDUCE-710
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-710
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-710.patch
>
>
> Sqoop's current support for passwords involves reading passwords from the command line "--password foo", which makes the password visible to other users via 'ps'. An invisible-console approach should be taken.
> Related, Sqoop transmits passwords to mysqldump in the same fashion, which is also insecure.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.