Ok Jeffrey i will read the link, but i still receive the follow error, do you have any ideal? 2014-04-02 20:22:45,119 [Thread-10-SendThread(oak:2181)] INFO org.apache.zookeeper.ClientCnxn - Opening socket connection to server oak/ 127.0.0.1:2181. Will not attempt to authenticate using SASL (java.lang.SecurityException: Unable to locate a login configuration) 2014-04-02 20:22:45,119 [Thread-10-SendThread(oak:2181)] WARN org.apache.zookeeper.ClientCnxn - Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599) at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361) at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081) 2014-04-02 20:22:45,148 [Thread-10-SendThread(oak:2181)] INFO org.apache.zookeeper.ClientCnxn - Opening socket connection to server oak/ 127.0.0.1:2181. Will not attempt to authenticate using SASL (java.lang.SecurityException: Unable to locate a login configuration) 2014-04-02 20:22:45,149 [Thread-10-SendThread(oak:2181)] WARN org.apache.zookeeper.ClientCnxn - Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599) at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361) at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081) *My host file is*: 127.0.0.1 localhost 127.0.0.1 oak 127.0.0.1 oak.local Any ideal? *My hbase log*: Qua 2 Abr 2014 20:10:55 PDT Starting master on OAK.local core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 256 pipe size (512 bytes, -p) 1 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 266 virtual memory (kbytes, -v) unlimited 2014-04-02 20:10:56,131 INFO [main] util.VersionInfo: HBase 0.98.0-hadoop1 2014-04-02 20:10:56,132 INFO [main] util.VersionInfo: Subversion https://svn.apache.org/repos/asf/hbase/tags/0.98.0RC2 -r 1565492 2014-04-02 20:10:56,132 INFO [main] util.VersionInfo: Compiled by apurtell on Thu Feb 6 16:20:15 PST 2014 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:zookeeper.version=3.4.5--1, built on 10/05/2013 16:05 GMT 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:host.name=oak 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:java.version=1.6.0_65 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:java.vendor=Apple Inc. 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:java.home=/System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home 2014-04-02 20:10:56,621 INFO [main] server.ZooKeeperServer: Server environment:java.class.path=/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../conf:/Library/Java/Home/lib/tools.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/..:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/activation-1.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/asm-3.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-beanutils-1.7.0.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-beanutils-core-1.8.0.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-cli-1.2.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-codec-1.7.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-collections-3.2.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-configuration-1.6.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-digester-1.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-el-1.0.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-httpclient-3.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-io-2.4.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-lang-2.6.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-logging-1.1.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-math-2.2.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-net-1.4.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/core-3.1.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/findbugs-annotations-1.3.9-1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/guava-12.0.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hadoop-core-1.2.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hamcrest-core-1.3.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-client-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-common-0.98.0-hadoop1-tests.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-common-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-examples-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-hadoop-compat-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-hadoop1-compat-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-it-0.98.0-hadoop1-tests.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-it-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-prefix-tree-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-protocol-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-server-0.98.0-hadoop1-tests.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-server-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-shell-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-testing-util-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-thrift-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/high-scale-lib-1.1.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/htrace-core-2.04.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/httpclient-4.1.3.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/httpcore-4.1.3.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jackson-core-asl-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jackson-jaxrs-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jackson-xc-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jamon-runtime-2.3.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jasper-compiler-5.5.23.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jasper-runtime-5.5.23.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jaxb-api-2.2.2.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jaxb-impl-2.2.3-1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jersey-core-1.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jersey-json-1.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jersey-server-1.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jettison-1.3.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jetty-6.1.26.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jetty-sslengine-6.1.26.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jetty-util-6.1.26.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jruby-complete-1.6.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jsp-2.1-6.1.14.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jsp-api-2.1-6.1.14.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jsr305-1.3.9.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/junit-4.11.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/libthrift-0.9.0.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/log4j-1.2.17.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/metrics-core-2.1.2.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/netty-3.6.6.Final.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/phoenix-core-4.0.0-incubating.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/protobuf-java-2.5.0.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/servlet-api-2.5-6.1.14.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/slf4j-api-1.6.4.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/slf4j-log4j12-1.6.4.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/stax-api-1.0.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/xmlenc-0.52.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/zookeeper-3.4.5.jar: 2014-04-02 20:10:56,622 INFO [main] server.ZooKeeperServer: Server environment:java.library.path=.:/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java 2014-04-02 20:10:56,622 INFO [main] server.ZooKeeperServer: Server environment:java.io.tmpdir=/var/folders/zz/zzzivhrRnAmviuee+++++++++++/-Tmp-/ 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:java.compiler= 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:os.name=Mac OS X 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:os.arch=x86_64 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:os.version=10.6.8 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:user.name=root 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:user.home=/Users/eduardofilho 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:user.dir=/usr/lib/hbase/hbase-0.98.0-hadoop1/bin 2014-04-02 20:10:56,668 INFO [main] server.ZooKeeperServer: Created server with tickTime 2000 minSessionTimeout 4000 maxSessionTimeout 40000 datadir /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper/zookeeper_0/version-2 snapdir /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper/zookeeper_0/version-2 2014-04-02 20:10:56,705 INFO [main] server.NIOServerCnxnFactory: binding to port 0.0.0.0/0.0.0.0:54310 2014-04-02 20:10:56,718 INFO [main] persistence.FileTxnSnapLog: Snapshotting: 0x0 to /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper/zookeeper_0/version-2/snapshot.0 On Wed, Apr 2, 2014 at 1:46 PM, Jeffrey Zhong wrote: > > The zookeeper error should be a warning. If you already have a Hbase > table, you should follow > http://phoenix.incubator.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table to > re-create it in Phoenix. > > You can test if your env is good by either using ./sqlline to create a > table or ruing "./psql.py oak.local ../examples/WEB_STAT.sql > ../examples/WEB_STAT.csv ../examples/WEB_STAT_QUERIES.sql" to see if your > env can create WEB_STAT table, load data into it and query data from the > WEB_STAT table. > > > From: Kleiton Silva > Reply-To: > Date: Wednesday, April 2, 2014 1:10 PM > > To: > Subject: Re: Help to Connect via SQuirrel > > Hey Jeffrey, > > Now i face another error, i couldn't connect because it receive connection > refuse, as shown below. > > My Hbase is ok, this is my hbase-site.xml (HBASE/conf): > > > > hbase.rootdir > hdfs://oak:54310/data/hbase > > > hbase.zookeeper.property.dataDir > /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper > > > hbase.zookeeper.property.clientPort > 2181 > > > hbase.zookeeper.quorum > oak.local > > > > > My host file: > > 10.2.103.214 oak > 10.2.103.214 localhost > 10.2.103.214 oak.local > > > The error that i receive: > > 2014-04-02 17:03:27,034 [Thread-11-SendThread(oak:2811)] WARN > org.apache.zookeeper.ClientCnxn - Session 0x0 for server null, unexpected > error, closing socket connection and attempting reconnect > java.net.ConnectException: Connection refused > at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) > at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599) > at > org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:350) > at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1068) > > > > > Doubt: > > My HBASE already have a table called 'test', this would be shown with the > !table command or not? > > Because i will use Phoenix with Sqoop to transfer data between from one > Hbase to another Hbase. > > Thank you. > > Kleiton > > > On Wed, Apr 2, 2014 at 10:48 AM, Jeffrey Zhong wrote: > >> >> Hey Kleiton, >> >> Just to make sure you are aware of that Phoenix 4.0 is supposed to >> running against Hbase 0.98.1. You need to create a table firstly in Phoenix >> in order to be seen from !table command from sqlline. >> >> Thanks, >> -Jeffrey >> >> From: Jeffrey Zhong >> Date: Wednesday, April 2, 2014 10:27 AM >> To: >> Subject: Re: Help to Connect via SQuirrel >> >> >> You can put the following configuration settings in hbase-site.xml under >> the bin folder and invoke the sqlline.py from bin folder OR you can set >> PHOENIX_LIB_DIR env variable such as export PHOENIX_LIB_DIR=> hbase-site.xml>: and then invoke sqlline >> again. >> >> >> >> hbase.defaults.for.version.skip >> >> true >> >> >> >> >> From: Kleiton Silva >> Reply-To: >> Date: Wednesday, April 2, 2014 7:43 AM >> To: >> Subject: Help to Connect via SQuirrel >> >> I am trying to do the same configuration as in >> http://phoenix.incubator.apache.org/download.html#SQL-Client, to connect >> with Squirrel, but a receive the error bellow: >> >> *Environment*: >> >> HBASE: /usr/lib/hbase/hbase-0.98.0-hadoop1/bin >> PHOENIX: phoenix-4.0.0-incubating >> HADOOP: /usr/lib/hadoop/hadoop-1.2.1 >> >> HBase test(Commands): >> >> *OAK:bin eduardofilho$ ./hbase shell* >> HBase Shell; enter 'help' for list of supported commands. >> Type "exit" to leave the HBase Shell >> Version 0.98.0-hadoop1, r1565492, Thu Feb 6 16:20:15 PST 2014 >> >> *hbase(main):001:0> scan 'test'* >> SLF4J: Class path contains multiple SLF4J bindings. >> SLF4J: Found binding in >> [jar:file:/usr/lib/hbase/hbase-0.98.0-hadoop1/lib/slf4j-log4j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class] >> SLF4J: Found binding in >> [jar:file:/usr/lib/hadoop/hadoop-1.2.1/lib/slf4j-log4j12-1.4.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] >> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an >> explanation. >> ROW COLUMN+CELL >> >> row1 column=cf:a, timestamp=1396129288479, value=value1 >> >> row2 column=cf:b, timestamp=1396129295034, value=value2 >> >> row3 column=cf:c, timestamp=1396129303288, value=value3 >> >> 3 row(s) in 0.1700 seconds >> >> *Phoenix Test(Commands)* >> >> OAK:bin eduardofilho$ ./sqlline.py oak.local >> Setting property: [isolation, TRANSACTION_READ_COMMITTED] >> issuing: !connect jdbc:phoenix:oak.local none none >> org.apache.phoenix.jdbc.PhoenixDriver >> Connecting to jdbc:phoenix:oak.local >> Connected to: Phoenix (version 4.0) >> Driver: org.apache.phoenix.jdbc.PhoenixDriver (version 4.0) >> Autocommit status: true >> Transaction isolation: TRANSACTION_READ_COMMITTED >> Building list of tables and columns for tab-completion (set fastconnect >> to true to skip)... >> 53/53 (100%) Done >> Done >> sqlline version 1.1.2 >> 0: jdbc:phoenix:oak.local> !tables >> >> +------------+-------------+------------+------------+------------+------------+ >> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | >> TYPE_NAME | >> >> +------------+-------------+------------+------------+------------+------------+ >> | null | SYSTEM | CATALOG | SYSTEM TABLE | null | >> null | >> | null | SYSTEM | SEQUENCE | SYSTEM TABLE | null | >> null | >> >> +------------+-------------+------------+------------+------------+------------+ >> 0: jdbc:phoenix:oak.local> >> >> >> This command not show my table 'test' >> >> *ERROR*: >> >> 2014-04-02 11:19:48,368 [Thread-8] ERROR >> net.sourceforge.squirrel_sql.client.gui.db.ConnectToAliasCallBack - >> Unexpected Error occured attempting to open an SQL connection. >> java.lang.RuntimeException: hbase-default.xml file seems to be for and >> old version of HBase (null), this version is 0.98.1-hadoop1 >> at >> org.apache.hadoop.hbase.HBaseConfiguration.checkDefaultsVersion(HBaseConfiguration.java:70) >> at >> org.apache.hadoop.hbase.HBaseConfiguration.addHbaseResources(HBaseConfiguration.java:102) >> at >> org.apache.hadoop.hbase.HBaseConfiguration.create(HBaseConfiguration.java:113) >> at >> org.apache.phoenix.query.ConfigurationFactory$ConfigurationFactoryImpl.getConfiguration(ConfigurationFactory.java:41) >> at >> org.apache.phoenix.query.QueryServicesOptions.withDefaults(QueryServicesOptions.java:146) >> at >> org.apache.phoenix.query.QueryServicesImpl.(QueryServicesImpl.java:34) >> at >> org.apache.phoenix.jdbc.PhoenixDriver.getQueryServices(PhoenixDriver.java:96) >> at >> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:114) >> at >> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112) >> at >> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133) >> at >> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97) >> at >> net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:280) >> at >> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) >> at java.lang.Thread.run(Thread.java:695) >> >> >> >> I Would appreciate if someone could me help. >> >> Thanks. >> >> Kleiton >> >> >> >> CONFIDENTIALITY NOTICE >> NOTICE: This message is intended for the use of the individual or entity >> to which it is addressed and may contain information that is confidential, >> privileged and exempt from disclosure under applicable law. If the reader >> of this message is not the intended recipient, you are hereby notified that >> any printing, copying, dissemination, distribution, disclosure or >> forwarding of this communication is strictly prohibited. If you have >> received this communication in error, please contact the sender immediately >> and delete it from your system. Thank You. >> > > > CONFIDENTIALITY NOTICE > NOTICE: This message is intended for the use of the individual or entity > to which it is addressed and may contain information that is confidential, > privileged and exempt from disclosure under applicable law. If the reader > of this message is not the intended recipient, you are hereby notified that > any printing, copying, dissemination, distribution, disclosure or > forwarding of this communication is strictly prohibited. If you have > received this communication in error, please contact the sender immediately > and delete it from your system. Thank You. >