Home | About | Sematext search-lucene.com search-hadoop.com
 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