Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
>>
>>
>>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB