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 Plain View
Sqoop >> mail # user >> can not create connect in sqoop2


+
ch huang 2013-07-17, 03:11
+
Abraham Elmahrek 2013-07-17, 06:12
+
ch huang 2013-07-17, 07:44
Copy link to this message
-
Re: can not create connect in sqoop2
I just downloaded sqoop 1.99.1. addtowar.sh is there. Did you download the
source or binary versions of sqoop? You should be downloading
sqoop-<version>-bin-<hadoop version>.tgz from one of the mirrors listed in
http://www.apache.org/dyn/closer.cgi/sqoop/.
On Wed, Jul 17, 2013 at 12:44 AM, ch huang <[EMAIL PROTECTED]> 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 <[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
>>>
>>>
>>>
>>
>>
>
+
Jarek Jarcec Cecho 2013-07-17, 14:56
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