You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Devin Suiter RDX <ds...@rdx.com> on 2014/03/06 17:59:19 UTC
Microsoft JDBC4 connector
Hello all,
When building import jobs for Sqoop from MSSQL, I'm finding that the only
options for password-protected databases are to pass the password as part
of the connect string or to pass the 'integrated-security' parameter, which
doesn't work since I'm running from CentOS and it needs a Windows .dll
installed. If I pass it with the Sqoop --password or --password-file args
it does not work.
Is there a --password-file option that is compatible in syntax with the
Microsoft JDBC4 SQL Server driver that anyone knows of? This seems a little
irresponsible and I am hoping I am missing something. The password file
option works great for the MySQL driver.
Thanks,
*Devin Suiter*
Jr. Data Solutions Software Engineer
100 Sandusky Street | 2nd Floor | Pittsburgh, PA 15212
Google Voice: 412-256-8556 | www.rdx.com
Re: Microsoft JDBC4 connector
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
Don't hesitate and create doc JIRA for the issue Devin!
Jarcec
On Thu, Mar 06, 2014 at 01:00:10PM -0500, Devin Suiter RDX wrote:
> Martin,
>
> Thanks for the reply. This wasn't exactly the problem. I figured out that
> the problem is the 'newline' character in the password file is interpreted
> by the --password-file logic.
>
> I got around it by
>
> 'echo -n <password> > password.file'
>
> and now the --password-file option works.
>
> I had the same problem earlier with the MySQL driver, but, it was a few
> weeks ago and I forgot that caused a problem.
>
> Might be something to put in the Sqoop User Guide, or remedy in Sqoop? It
> occurs to me this may have been addressed in Sqoop2 already, but I am not
> using Sqoop2 currently. For the record, I am using Sqoop 1.4.3 CDH 4.6.
>
> Thanks again all!
>
> *Devin Suiter*
> Jr. Data Solutions Software Engineer
> 100 Sandusky Street | 2nd Floor | Pittsburgh, PA 15212
> Google Voice: 412-256-8556 | www.rdx.com
>
>
> On Thu, Mar 6, 2014 at 12:08 PM, Martin Thiele <ma...@gmail.com>wrote:
>
> > https://issues.apache.org/jira/browse/SQOOP-1226 has work around to try
> >
> > Sent from my iPhone
> >
> >
> > On Mar 6, 2014, at 11:59 AM, Devin Suiter RDX <ds...@rdx.com> wrote:
> >
> > Hello all,
> >
> > When building import jobs for Sqoop from MSSQL, I'm finding that the only
> > options for password-protected databases are to pass the password as part
> > of the connect string or to pass the 'integrated-security' parameter, which
> > doesn't work since I'm running from CentOS and it needs a Windows .dll
> > installed. If I pass it with the Sqoop --password or --password-file args
> > it does not work.
> >
> > Is there a --password-file option that is compatible in syntax with the
> > Microsoft JDBC4 SQL Server driver that anyone knows of? This seems a little
> > irresponsible and I am hoping I am missing something. The password file
> > option works great for the MySQL driver.
> >
> > Thanks,
> > *Devin Suiter*
> > Jr. Data Solutions Software Engineer
> > 100 Sandusky Street | 2nd Floor | Pittsburgh, PA 15212
> > Google Voice: 412-256-8556 | www.rdx.com
> >
> >
Re: Microsoft JDBC4 connector
Posted by Devin Suiter RDX <ds...@rdx.com>.
Martin,
Thanks for the reply. This wasn't exactly the problem. I figured out that
the problem is the 'newline' character in the password file is interpreted
by the --password-file logic.
I got around it by
'echo -n <password> > password.file'
and now the --password-file option works.
I had the same problem earlier with the MySQL driver, but, it was a few
weeks ago and I forgot that caused a problem.
Might be something to put in the Sqoop User Guide, or remedy in Sqoop? It
occurs to me this may have been addressed in Sqoop2 already, but I am not
using Sqoop2 currently. For the record, I am using Sqoop 1.4.3 CDH 4.6.
Thanks again all!
*Devin Suiter*
Jr. Data Solutions Software Engineer
100 Sandusky Street | 2nd Floor | Pittsburgh, PA 15212
Google Voice: 412-256-8556 | www.rdx.com
On Thu, Mar 6, 2014 at 12:08 PM, Martin Thiele <ma...@gmail.com>wrote:
> https://issues.apache.org/jira/browse/SQOOP-1226 has work around to try
>
> Sent from my iPhone
>
>
> On Mar 6, 2014, at 11:59 AM, Devin Suiter RDX <ds...@rdx.com> wrote:
>
> Hello all,
>
> When building import jobs for Sqoop from MSSQL, I'm finding that the only
> options for password-protected databases are to pass the password as part
> of the connect string or to pass the 'integrated-security' parameter, which
> doesn't work since I'm running from CentOS and it needs a Windows .dll
> installed. If I pass it with the Sqoop --password or --password-file args
> it does not work.
>
> Is there a --password-file option that is compatible in syntax with the
> Microsoft JDBC4 SQL Server driver that anyone knows of? This seems a little
> irresponsible and I am hoping I am missing something. The password file
> option works great for the MySQL driver.
>
> Thanks,
> *Devin Suiter*
> Jr. Data Solutions Software Engineer
> 100 Sandusky Street | 2nd Floor | Pittsburgh, PA 15212
> Google Voice: 412-256-8556 | www.rdx.com
>
>
Re: Microsoft JDBC4 connector
Posted by Martin Thiele <ma...@gmail.com>.
https://issues.apache.org/jira/browse/SQOOP-1226 has work around to try
Sent from my iPhone
> On Mar 6, 2014, at 11:59 AM, Devin Suiter RDX <ds...@rdx.com> wrote:
>
> Hello all,
>
> When building import jobs for Sqoop from MSSQL, I'm finding that the only options for password-protected databases are to pass the password as part of the connect string or to pass the 'integrated-security' parameter, which doesn't work since I'm running from CentOS and it needs a Windows .dll installed. If I pass it with the Sqoop --password or --password-file args it does not work.
>
> Is there a --password-file option that is compatible in syntax with the Microsoft JDBC4 SQL Server driver that anyone knows of? This seems a little irresponsible and I am hoping I am missing something. The password file option works great for the MySQL driver.
>
> Thanks,
> Devin Suiter
> Jr. Data Solutions Software Engineer
>
> 100 Sandusky Street | 2nd Floor | Pittsburgh, PA 15212
> Google Voice: 412-256-8556 | www.rdx.com