Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - can not create connect in sqoop2


Copy link to this message
-
Re: can not create connect in sqoop2
ch huang 2013-07-17, 07:44
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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
>>
>>
>>
>
>