Grokbase › Groups › Hadoop › scm-users › May 2013
FAQ
Hi Guys,
   when i import the data from remote mysql server to hdfs. i got the below
error any body can help me to slove this problem.
java.sql.SQLException: null, message from server: "Host '166.78.101.111'
is not allowed to connect to this MySQL server"
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
         at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1104)
         at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
         at com.mysql.jdbc.ConnectionImpl.(JDBC4Connection.java:46)
         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
         at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
         at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
         at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
         at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
         at java.sql.DriverManager.getConnection(DriverManager.java:582)
         at java.sql.DriverManager.getConnection(DriverManager.java:185)
         at
org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:665)
         at
org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
         at
org.apache.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:101)
         at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)
         at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
         at org.apache.sqoop.Sqoop.main(Sqoop.java:238)

Search Discussions

  • Serega Sheypak at May 29, 2013 at 9:45 am ⇧
    You should properly configure access from with ip 166.78.101.111 on mysql
    server side.
    Here is the explanation and solution:
    http://stackoverflow.com/questions/1913984/re-assign-host-access-permission-to-mysql-user

    You can also do it using some mysql admin tool without submitting SQL DCL
    queries



    2013/5/29 Srinivasan Ramalingam <[email protected]>
    Hi Guys,
    when i import the data from remote mysql server to hdfs. i got the below
    error any body can help me to slove this problem.
    java.sql.SQLException: null, message from server: "Host '166.78.101.111'
    is not allowed to connect to this MySQL server"
    at com.mysql.jdbc.SQLError.**createSQLException(SQLError.**
    java:1055)
    at com.mysql.jdbc.SQLError.**createSQLException(SQLError.**
    java:956)
    at com.mysql.jdbc.MysqlIO.**doHandshake(MysqlIO.java:1104)
    at com.mysql.jdbc.ConnectionImpl.**createNewIO(ConnectionImpl.**
    java:2142)
    at com.mysql.jdbc.ConnectionImpl.**<init>(ConnectionImpl.java:**
    781)
    at com.mysql.jdbc.**JDBC4Connection.<init>(**
    JDBC4Connection.java:46)
    at sun.reflect.**NativeConstructorAccessorImpl.**newInstance0(Native
    Method)
    at sun.reflect.**NativeConstructorAccessorImpl.**newInstance(**
    NativeConstructorAccessorImpl.**java:39)
    at sun.reflect.**DelegatingConstructorAccessorI**mpl.newInstance(*
    *DelegatingConstructorAccessorI**mpl.java:27)
    at java.lang.reflect.Constructor.**newInstance(Constructor.java:**
    513)
    at com.mysql.jdbc.Util.**handleNewInstance(Util.java:**406)
    at com.mysql.jdbc.ConnectionImpl.**getInstance(ConnectionImpl.**
    java:352)
    at com.mysql.jdbc.**NonRegisteringDriver.connect(**
    NonRegisteringDriver.java:284)
    at java.sql.DriverManager.**getConnection(DriverManager.**
    java:582)
    at java.sql.DriverManager.**getConnection(DriverManager.**
    java:185)
    at org.apache.sqoop.manager.**SqlManager.makeConnection(**
    SqlManager.java:665)
    at org.apache.sqoop.manager.**GenericJdbcManager.**getConnection(*
    *GenericJdbcManager.java:52)
    at org.apache.sqoop.manager.**CatalogQueryManager.**listTables(**
    CatalogQueryManager.java:101)
    at org.apache.sqoop.tool.**ListTablesTool.run(**
    ListTablesTool.java:49)
    at org.apache.sqoop.Sqoop.run(**Sqoop.java:145)
    at org.apache.hadoop.util.**ToolRunner.run(ToolRunner.**java:70)
    at org.apache.sqoop.Sqoop.**runSqoop(Sqoop.java:181)
    at org.apache.sqoop.Sqoop.**runTool(Sqoop.java:220)
    at org.apache.sqoop.Sqoop.**runTool(Sqoop.java:229)
    at org.apache.sqoop.Sqoop.main(**Sqoop.java:238)
  • Serega Sheypak at May 29, 2013 at 9:58 am ⇧
    I suppose that 166.78.101.111 has NameNode and *TaskTracker* where sqoop
    mapper runs.
    In general 166.78.101.111 - is an IP address of MySQL client.
    you should read provided link and give access from all TaskTracker hosts to
    Mysql DB using DCL. You can't predict exact mapper TaskTracker.

    MySQL Server response means that connect FROM 166.78.101.111 is not
    allowed. Modify MySQL user properties on MySQL server side.


    2013/5/29 Srinivasan Ramalingam <[email protected]>
    Hi ,
    it is my name node ip address.my mysql server ip address
    is totally different. my sqoop command is
    sqoop-import-all-tables --connect jdbc:mysql://ip:3306/vms -username
    srindfi -password root --hive-import -m1;

    i already done your suggestion. i tried the telnet command the port was
    working fine. when i run the sqoop command it shows the namenode ip
    address.

    On Wed, May 29, 2013 at 3:15 PM, Serega Sheypak wrote:

    You should properly configure access from with ip 166.78.101.111 on
    mysql server side.
    Here is the explanation and solution:

    http://stackoverflow.com/questions/1913984/re-assign-host-access-permission-to-mysql-user

    You can also do it using some mysql admin tool without submitting SQL DCL
    queries



    2013/5/29 Srinivasan Ramalingam <[email protected]>
    Hi Guys,
    when i import the data from remote mysql server to hdfs. i got the
    below error any body can help me to slove this problem.
    java.sql.SQLException: null, message from server: "Host
    '166.78.101.111' is not allowed to connect to this MySQL server"
    at com.mysql.jdbc.SQLError.**createSQLException(SQLError.**
    java:1055)
    at com.mysql.jdbc.SQLError.**createSQLException(SQLError.**
    java:956)
    at com.mysql.jdbc.MysqlIO.**doHandshake(MysqlIO.java:1104)
    at com.mysql.jdbc.ConnectionImpl.**createNewIO(ConnectionImpl.**
    java:2142)
    at com.mysql.jdbc.ConnectionImpl.**<init>(ConnectionImpl.java:**
    781)
    at com.mysql.jdbc.**JDBC4Connection.<init>(**
    JDBC4Connection.java:46)
    at sun.reflect.**NativeConstructorAccessorImpl.**newInstance0(Native
    Method)
    at sun.reflect.**NativeConstructorAccessorImpl.**newInstance(**
    NativeConstructorAccessorImpl.**java:39)
    at sun.reflect.**DelegatingConstructorAccessorI**
    mpl.newInstance(**DelegatingConstructorAccessorI**mpl.java:27)
    at java.lang.reflect.Constructor.**newInstance(Constructor.java:
    **513)
    at com.mysql.jdbc.Util.**handleNewInstance(Util.java:**406)
    at com.mysql.jdbc.ConnectionImpl.**getInstance(ConnectionImpl.**
    java:352)
    at com.mysql.jdbc.**NonRegisteringDriver.connect(**
    NonRegisteringDriver.java:284)
    at java.sql.DriverManager.**getConnection(DriverManager.**
    java:582)
    at java.sql.DriverManager.**getConnection(DriverManager.**
    java:185)
    at org.apache.sqoop.manager.**SqlManager.makeConnection(**
    SqlManager.java:665)
    at org.apache.sqoop.manager.**GenericJdbcManager.**
    getConnection(**GenericJdbcManager.java:52)
    at org.apache.sqoop.manager.**CatalogQueryManager.**listTables(*
    *CatalogQueryManager.java:101)
    at org.apache.sqoop.tool.**ListTablesTool.run(**
    ListTablesTool.java:49)
    at org.apache.sqoop.Sqoop.run(**Sqoop.java:145)
    at org.apache.hadoop.util.**ToolRunner.run(ToolRunner.**java:70)
    at org.apache.sqoop.Sqoop.**runSqoop(Sqoop.java:181)
    at org.apache.sqoop.Sqoop.**runTool(Sqoop.java:220)
    at org.apache.sqoop.Sqoop.**runTool(Sqoop.java:229)
    at org.apache.sqoop.Sqoop.main(**Sqoop.java:238)

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedMay 29, '13 at 9:35a
activeMay 29, '13 at 9:58a
posts3
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Serega Sheypak: 2 posts Srinivasan Ramalingam: 1 post

Content

People

Support

Translate

site design / logo © 2023 Grokbase