You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Pablo Torre <pa...@gmail.com> on 2015/10/27 11:57:24 UTC
Sqoop Security
Hi guys,
I was reading a book about Hadoop Security , and I realized that Sqoop can
be configured to connect to a database that supports SSL with SSL enabled.
Something similar to this:
$ URI="jdbc:mysql://mysql01.example.com/sqoop"
$ URI="${URI}?verifyServerCertificate=true"
$ URI="${URI}&useSSL=true"
$ URI="${URI}&requireSSL=true"
...
Anyone tried it? I would appreciate any help with this.
Best,
--
Pablo Torre.
Freelance software engineer and Ruby on Rails developer.
Oleiros (Coruña)
*Personal site <http://www.pablotorrerodriguez.com>*
My blog <http://www.aboutechnologies.com>
Re: Sqoop Security
Posted by Pablo Torre <pa...@gmail.com>.
Thanks Jarek. If I try finally this option, I will let you know the
results.
Best,
Pablo
2015-10-27 17:09 GMT+01:00 Jarek Jarcec Cecho <ja...@apache.org>:
> I haven’t tried it myself, but as Sqoop is “yet another JDBC client”, I
> think that it generally should work.
>
> One thing that you might need to do extra is to ensure that the all the
> SSL relevant files (trust strore, …) are either available on all nodes in
> your cluster or ship them to backend via “-file” argument. I’m expecting
> that it will be required because Sqoop can open connection to the database
> from any node in the cluster.
>
> Jarcec
>
> > On Oct 27, 2015, at 3:57 AM, Pablo Torre <pa...@gmail.com> wrote:
> >
> > Hi guys,
> >
> > I was reading a book about Hadoop Security , and I realized that Sqoop
> can be configured to connect to a database that supports SSL with SSL
> enabled.
> >
> > Something similar to this:
> >
> > $ URI="jdbc:mysql://mysql01.example.com/sqoop"
> > $ URI="${URI}?verifyServerCertificate=true"
> > $ URI="${URI}&useSSL=true"
> > $ URI="${URI}&requireSSL=true"
> > ...
> >
> > Anyone tried it? I would appreciate any help with this.
> >
> > Best,
> >
> > --
> > Pablo Torre.
> > Freelance software engineer and Ruby on Rails developer.
> > Oleiros (Coruña)
> > Personal site
> > My blog
>
>
--
Pablo Torre.
Freelance software engineer and Ruby on Rails developer.
Oleiros (Coruña)
*Personal site <http://www.pablotorrerodriguez.com>*
My blog <http://www.aboutechnologies.com>
Re: Sqoop Security
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
I haven’t tried it myself, but as Sqoop is “yet another JDBC client”, I think that it generally should work.
One thing that you might need to do extra is to ensure that the all the SSL relevant files (trust strore, …) are either available on all nodes in your cluster or ship them to backend via “-file” argument. I’m expecting that it will be required because Sqoop can open connection to the database from any node in the cluster.
Jarcec
> On Oct 27, 2015, at 3:57 AM, Pablo Torre <pa...@gmail.com> wrote:
>
> Hi guys,
>
> I was reading a book about Hadoop Security , and I realized that Sqoop can be configured to connect to a database that supports SSL with SSL enabled.
>
> Something similar to this:
>
> $ URI="jdbc:mysql://mysql01.example.com/sqoop"
> $ URI="${URI}?verifyServerCertificate=true"
> $ URI="${URI}&useSSL=true"
> $ URI="${URI}&requireSSL=true"
> ...
>
> Anyone tried it? I would appreciate any help with this.
>
> Best,
>
> --
> Pablo Torre.
> Freelance software engineer and Ruby on Rails developer.
> Oleiros (Coruña)
> Personal site
> My blog