sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarek Jarcec Cecho <jar...@apache.org>
Subject Re: can not create connect in sqoop2
Date Wed, 17 Jul 2013 14:56:22 GMT
Hi sir,
it seems that you are using CDH version of Sqoop, so you might consider asking this question
on cdh-user@ mailing list instead [1].

As you are using CDH, I would suggest you to follow CDH installation guides that are describing
installation of the JDBC drivers [2] as well.

Jarcec

Links:
1: https://groups.google.com/a/cloudera.org/forum/#!forum/cdh-user
2: http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/latest/CDH4-Installation-Guide/cdh4ig_topic_14_3.html

On Wed, Jul 17, 2013 at 03:44:18PM +0800, ch huang wrote:
> thanks for reply ,my sqoop2 version is 1.99.1,and i have
> mysql-connector-java in lib path,and i can not find addtowar.sh script
> 
> # find /usr/lib/sqoop2/lib/ -name '*connect*'
> /usr/lib/sqoop2/lib/mysql-connector-java.jar
> 
> # rpm -qa|grep sqoop2
> sqoop2-server-1.99.1+115-1.cdh4.3.0.p0.11.el6.noarch
> sqoop2-client-1.99.1+115-1.cdh4.3.0.p0.11.el6.noarch
> sqoop2-1.99.1+115-1.cdh4.3.0.p0.11.el6.noarch
> 
> 
> # find / -name 'addtowar*'
> no output!!
> 
> On Wed, Jul 17, 2013 at 2:12 PM, Abraham Elmahrek <abe@cloudera.com> wrote:
> 
> > It looks like the mysql jdbc driver is missing. You should be able to
> > download it from http://dev.mysql.com/downloads/connector/j/. The
> > installation procedure will vary depending on the version of sqoop2 you are
> > using. If you are using latest sqoop2, you'll need to add this jar to
> > /usr/lib/sqoop2/lib. Otherwise, you'll have to use the addtowar.sh command
> > as per http://sqoop.apache.org/docs/1.99.2/Installation.html.
> >
> > -Abe
> >
> >
> > On Tue, Jul 16, 2013 at 8:11 PM, ch huang <justlooks@gmail.com> wrote:
> >
> >> hi ,all:
> >>    i have problem in create connection in sqoop2,anyone can help?
> >>
> >> sqoop:000> create connection --cid 1
> >> Creating connection for connector with id 1
> >> Please fill following values to create new connection object
> >> Name: first-connection
> >>
> >> Connection configuration
> >>
> >> JDBC Driver Class: com.mysql.jdbc.Driver
> >> JDBC Connection String: jdbc:mysql://192.168.10.118/metastore
> >> Username: sqoop2
> >> Password: ******
> >> JDBC Connection Properties:
> >> There are currently 0 values in the map:
> >> entry#
> >>
> >> Security related configuration options
> >>
> >> Max connections: 123
> >>
> >> There are issues with entered data, please revise your input:
> >> Name: first-connection
> >>
> >> Connection configuration
> >> Warning message: Can't connect to the database with given credentials: No
> >> suitable driver found for jdbc:mysql://192.168.10.118/metastore
> >>
> >>
> >>
> >
> >

Mime
View raw message