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=<NA>
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 <jzhong@hortonworks.com> 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.


Date: Wednesday, April 2, 2014 1:10 PM

To: <user@phoenix.incubator.apache.org>
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):

<configuration>
  <property>
    <name>hbase.rootdir</name>
    <value>hdfs://oak:54310/data/hbase</value>
  </property>
  <property>
    <name>hbase.zookeeper.property.dataDir</name>
    <value>/usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper</value>
  </property>
  <property>
    <name>hbase.zookeeper.property.clientPort</name>
    <value>2181</value>
  </property>
  <property>
    <name>hbase.zookeeper.quorum</name>
    <value>oak.local</value>
 </property>
</configuration>


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 <jzhong@hortonworks.com> 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 <jzhong@hortonworks.com>
Date: Wednesday, April 2, 2014 10:27 AM
To: <user@phoenix.incubator.apache.org>
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=<path to the hbase-site.xml>:<path to your phoenix home folder> and then invoke sqlline again.

  <property>

       <name>hbase.defaults.for.version.skip</name>

        <value>true</value>

  </property>



From: Kleiton Silva <kleiton.contato@gmail.com>
Reply-To: <user@phoenix.incubator.apache.org>
Date: Wednesday, April 2, 2014 7:43 AM
To: <user@phoenix.incubator.apache.org>
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<RETURN>' for list of supported commands.
Type "exit<RETURN>" 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]
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.<init>(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.