You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by CH...@SCHNEIDER-ELECTRIC.COM on 2016/01/05 23:14:56 UTC

Thin Client:: Connection Refused

Hi,

I am running HBase on HDP 2.3.2 with the following parameters:


Hadoop Version
2.7.1.2.3.2.0-2950, revision=5cc60e0003e33aa98205f18bccaeaf36cb193c1c

Zookeeper Quorum
sandbox.hortonworks.com:2181

Zookeeper Base Path
/hbase-unsecure

HBase Version
1.1.2.2.3.2.0-2950, revision=58355eb3c88bded74f382d81cdd36174d68ad0fd


The RegionServer is running on sandbox.hortonworks.com,16020,1452022914170

Phoenix version :  phoenix-4.4.0.2.3.2.0-2950-thin-client.jar

I am capable of running sqlline without any problems !
However, the sqline-thin I am always having connection refused with any of 
the following:
./sqline-thin.py
./sqline-thin.py localhost
./sqline-thin.py http://localhost
./sqline-thin.py http://localhost:8765
./sqline-thin.py http://sandbox.hortonworks.com
./sqline-thin.py http://sandbox.hortonworks.com:8765

Any ideas why I am getting connection refused?

Thanks,
-- C

Re: Thin Client:: Connection Refused

Posted by Thomas Decaux <eb...@gmail.com>.
You could  use the  jdbc protocol instead thé thin  client ? Else i dont
see  solution , maybe because the  nature of HTTP (what is using thin
client)
Le 5 janv. 2016 11:43 PM, <CH...@schneider-electric.com> a écrit :

> Hello Thomas,
>
> Thank you ! this what was missing ! :)
>
> I noticed that the dbConnection.commit(); is not supported.
> Is there any other method to commit? the inserted values are not persisted.
>
> Thank you,
> -- C
>
>
>
>
>
> From:        Thomas Decaux <eb...@gmail.com>
> To:        user@phoenix.apache.org,
> Date:        01/05/2016 05:17 PM
> Subject:        Re: Thin Client:: Connection Refused
> ------------------------------
>
>
>
> Did you run thin  server ? (The http server that proxy to Phoenix)
>
> Le 5 janv. 2016 11:15 PM, <*CHARBEL.EL-KAED@schneider-electric.com*
> <CH...@schneider-electric.com>> a écrit :
> Hi,
>
> I am running HBase on HDP 2.3.2 with the following parameters:
> Hadoop Version 2.7.1.2.3.2.0-2950,
> revision=5cc60e0003e33aa98205f18bccaeaf36cb193c1c
> Zookeeper Quorum *sandbox.hortonworks.com:2181*
> <http://sandbox.hortonworks.com:2181/>
> Zookeeper Base Path /hbase-unsecure
> HBase Version 1.1.2.2.3.2.0-2950,
> revision=58355eb3c88bded74f382d81cdd36174d68ad0fd
>
>
>
> The RegionServer is running on
> *sandbox.hortonworks.com,16020,1452022914170*
> <http://sandbox.hortonworks.com:16030/rs-status>
>
> Phoenix version :  phoenix-4.4.0.2.3.2.0-2950-thin-client.jar
>
> I am capable of running sqlline without any problems !
> However, the sqline-thin I am always having connection refused with any of
> the following:
> ./sqline-thin.py
> ./sqline-thin.py localhost
> ./sqline-thin.py *http://localhost* <http://localhost/>
> ./sqline-thin.py *http://localhost:8765* <http://localhost:8765/>
> ./sqline-thin.py *http://sandbox.hortonworks.com*
> <http://sandbox.hortonworks.com/>
> ./sqline-thin.py *http://sandbox.hortonworks.com:8765*
> <http://sandbox.hortonworks.com:8765/>
>
> Any ideas why I am getting connection refused?
>
> Thanks,
> -- C
>
> ______________________________________________________________________
> This email has been scanned by the Symantec Email Security.cloud service.
> ______________________________________________________________________
>

Re: Thin Client:: Connection Refused

Posted by CH...@SCHNEIDER-ELECTRIC.COM.
Hello Thomas,

Thank you ! this what was missing ! :)

I noticed that the dbConnection.commit(); is not supported.
Is there any other method to commit? the inserted values are not 
persisted.

Thank you,
-- C





From:   Thomas Decaux <eb...@gmail.com>
To:     user@phoenix.apache.org, 
Date:   01/05/2016 05:17 PM
Subject:        Re: Thin Client:: Connection Refused



Did you run thin  server ? (The http server that proxy to Phoenix) 
Le 5 janv. 2016 11:15 PM, <CH...@schneider-electric.com> a 
écrit :
Hi, 

I am running HBase on HDP 2.3.2 with the following parameters: 

Hadoop Version 
2.7.1.2.3.2.0-2950, revision=5cc60e0003e33aa98205f18bccaeaf36cb193c1c

Zookeeper Quorum 
sandbox.hortonworks.com:2181

Zookeeper Base Path 
/hbase-unsecure

HBase Version 
1.1.2.2.3.2.0-2950, revision=58355eb3c88bded74f382d81cdd36174d68ad0fd



The RegionServer is running on sandbox.hortonworks.com,16020,1452022914170 


Phoenix version :  phoenix-4.4.0.2.3.2.0-2950-thin-client.jar 

I am capable of running sqlline without any problems !
However, the sqline-thin I am always having connection refused with any of 
the following: 
./sqline-thin.py 
./sqline-thin.py localhost 
./sqline-thin.py http://localhost 
./sqline-thin.py http://localhost:8765 
./sqline-thin.py http://sandbox.hortonworks.com 
./sqline-thin.py http://sandbox.hortonworks.com:8765 

Any ideas why I am getting connection refused? 

Thanks, 
-- C

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
______________________________________________________________________

Re: Thin Client:: Connection Refused

Posted by Thomas Decaux <eb...@gmail.com>.
Did you run thin  server ? (The http server that proxy to Phoenix)
Le 5 janv. 2016 11:15 PM, <CH...@schneider-electric.com> a écrit :

> Hi,
>
> I am running HBase on HDP 2.3.2 with the following parameters:
>
> Hadoop Version 2.7.1.2.3.2.0-2950,
> revision=5cc60e0003e33aa98205f18bccaeaf36cb193c1c
> Zookeeper Quorum sandbox.hortonworks.com:2181
> Zookeeper Base Path /hbase-unsecure
> HBase Version 1.1.2.2.3.2.0-2950,
> revision=58355eb3c88bded74f382d81cdd36174d68ad0fd
>
>
> The RegionServer is running on
> *sandbox.hortonworks.com,16020,1452022914170*
> <http://sandbox.hortonworks.com:16030/rs-status>
>
> Phoenix version :  phoenix-4.4.0.2.3.2.0-2950-thin-client.jar
>
> I am capable of running sqlline without any problems !
> However, the sqline-thin I am always having connection refused with any of
> the following:
> ./sqline-thin.py
> ./sqline-thin.py localhost
> ./sqline-thin.py http://localhost
> ./sqline-thin.py http://localhost:8765
> ./sqline-thin.py http://sandbox.hortonworks.com
> ./sqline-thin.py http://sandbox.hortonworks.com:8765
>
> Any ideas why I am getting connection refused?
>
> Thanks,
> -- C