sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ch huang <justlo...@gmail.com>
Subject Re: can not create connect in sqoop2
Date Wed, 17 Jul 2013 07:44:18 GMT
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