There is already SQOOP-1294. The problem with trim as mentioned by Jarcec in the JIRA ticket is that whitespace can be a legitimate part of the password. We need to trim the trailing new line only.
Thanks Venkat On Wed, Jul 23, 2014 at 7:18 AM, Jarek Jarcec Cecho <[email protected]> wrote: > The easiest way how to create password file without new line character at the > end is to use “echo” command: > > echo -n “my-password” > password.file > > The switch “-n” will disable outputting trailing new line character. > > Jarcec > > On Jul 23, 2014, at 5:50 AM, Kathleen Ting <[email protected]> wrote: > >> Hi, I think there was a typo in Abe's earlier reply and what he meant is >> that newlines are _not_ acceptable password characters unfortunately. >> >> Regards, >> Kate >> >> >> On Wed, Jul 23, 2014 at 1:07 AM, [email protected] >> <[email protected]> wrote: >> >> Hey,Everyone: >> I tried to create a user in my mysql server using a password which >> contians a '\n' character in the end. >> But when I am loging to my mysql server.I recivied a error message from >> mysql.If newline are acceptable by database >> then how to use a password that contains a newline to log on the server. >> Waiting for your reply sincere. >> >> >> From: Abraham Elmahrek >> Date: 2014-07-23 13:34 >> To: [email protected] >> Subject: Re: sqoop1.4.4 password-file parameter >> Hey there, >> >> I do believe that newlines are acceptable password characters unfortunately. >> You could use emacs, "printf <password> > <password file>", or "tr -d '\n' < >> <password file> > <new password file>" instead. >> >> -Abe >> >> >> On Tue, Jul 22, 2014 at 10:13 PM, [email protected] >> <[email protected]> wrote: >> hi，all： >> forgive my poor English~ >> I find a problem about the parameter password-file。When i create a >> password-file using Vi editor,then vi will put a '\n' in the end of the >> line(eol)。 >> This character '\n' will lead failure。You should modify as blow i >> think。wating for your reply，thank you。 >> org.apache.sqoop.util.CredentialsUtil >> >> <Catch(07-23-11-1(07-23-16-04-01).jpg> >> >> >> >> >> > -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
