'TSocket' object has no attribute 'isOpen' #268

tdhopper · 2017-10-04T15:26:35Z

I'm seeing this error for the first time:

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-5-b8033d8b7753> in <module>()
      1 impala.dbapi.connect(host=HOST, port=PORT, auth_mechanism='PLAIN',
----> 2                     user=USER, password=PASSWORD)

~/miniconda2/envs/env/lib/python3.6/site-packages/impala/dbapi.py in connect(host, port, database, timeout, use_ssl, ca_cert, auth_mechanism, user, password, kerberos_service_name, use_ldap, ldap_user, ldap_password, use_kerberos, protocol)
    145                           ca_cert=ca_cert, user=user, password=password,
    146                           kerberos_service_name=kerberos_service_name,
--> 147                           auth_mechanism=auth_mechanism)
    148     return hs2.HiveServer2Connection(service, default_db=database)
    149 

~/miniconda2/envs/env/lib/python3.6/site-packages/impala/hiveserver2.py in connect(host, port, timeout, use_ssl, ca_cert, user, password, kerberos_service_name, auth_mechanism)
    756     transport = get_transport(sock, host, kerberos_service_name,
    757                               auth_mechanism, user, password)
--> 758     transport.open()
    759     protocol = TBinaryProtocol(transport)
    760     if six.PY2:

~/miniconda2/envs/env/lib/python3.6/site-packages/thrift_sasl/__init__.py in open(self)
     65 
     66   def open(self):
---> 67     if not self._trans.isOpen():
     68       self._trans.open()
     69 

AttributeError: 'TSocket' object has no attribute 'isOpen'

These are versions I have installed:

thrift==0.9.3
thrift-sasl==0.3.0
thriftpy==0.3.9
impyla==0.14.0

The text was updated successfully, but these errors were encountered:

wesm · 2017-10-04T15:27:33Z

I just pushed thrift_sasl 0.3.0 yesterday so it must be a version incompatibility. Can you upgrade to thrift 0.10.0? We probably need a version bump in impyla to pin things properly

tdhopper · 2017-10-04T15:29:47Z

@wesm Thanks. I actually get the same error with 0.10.0.

wesm · 2017-10-04T15:32:39Z

OK, well the fix is to pin thrift_sasl at 0.2.1 until we get impyla working on 0.10.0 + thrift_sasl 0.3.0. I am unable to work on it today unfortunately =/

tdhopper · 2017-10-04T15:33:40Z

Yup, that works.

ghost · 2017-10-10T17:31:24Z

Hello!
I can't solve this problem with "AttributeError: 'TSocket' object has no attribute 'isOpen'" even with thrift_sasl == 0.2.1 installated...may be some other libraries should be exact versions? If so, what libraries and their versions should i check?
I use anaconda by the way.
Thanks!

tdhopper · 2017-10-10T18:00:03Z

@rockot Maybe try thrift=0.9.3

ghost · 2017-10-12T11:05:00Z

yes, this works, thanks! and also, suddenly, i needed sasl==0.2.1. And then, all together, it works.

* set thrift_sasl max version It looks like there was a breaking change in thrift_sasl module. Please specify thrift_sasl version <= 0.2.1, and that would resolve the issue. * thrift_sasl<=0.2.1 requirement install thrift_sasl before thrift * pinned thrift_sasl until #268 is closed * removed manditory requirement of thrift_sasl

) * set thrift_sasl max version It looks like there was a breaking change in thrift_sasl module. Please specify thrift_sasl version <= 0.2.1, and that would resolve the issue. * thrift_sasl<=0.2.1 requirement install thrift_sasl before thrift * pinned thrift_sasl until cloudera#268 is closed * removed manditory requirement of thrift_sasl

igorivanov · 2017-10-31T11:04:01Z

Hello!
I create PR - cloudera/thrift_sasl#10 - in a thrift_sasl module. It fix compatibility erors.

rsadaphule · 2018-03-15T16:23:54Z

I attempted to install pip install git+https://github.com/cloudera/thrift_sasl and ran into TSocket thrift_sas1 error. I checked version . It says sasl-0.2.1 thrift-sasl-0.3.0.

Could someone send me exact command to pin to 0.2.1

qp910 · 2018-04-20T07:26:30Z

hlpe me, （if thrift_sasl=0.3.0,it will AttributeError: 'TSocket' object has no attribute 'isOpen'.but, thrift_sasl=0.2.1,it will thriftpy.transport.TTransportException: TTransportException(type=1, message="Could not start SASL: b'Error in sasl_client_start (-4) SASL(-4): no mechanism available: Unable to find a callback: 2'")
supplement
）

xiaomaosusie · 2018-09-12T14:31:09Z

Hi Guys,

I"m having:
thrift==0.11.0
thrift-sasl==0.3.0
thriftpy==0.3.9
impyla==0.14.1

and I"m getting ''TSSLSocket' object has no attribute 'isOpen'' . Is it also bc of version issues? Shall I downgrade any of them?

Thank you so much for your help! Much appreciated!

Best,
Susie

catchcharan · 2019-01-24T20:42:17Z

Hi guys,

I'm able to resolve this issue with a workaround and little tweaking.

I uninstalled thrift_sasl on my anaconda3 environment. Then copied then directory from anaconda2 directory to anaconda3 directory. This change worked.

cd /opt/anaconda2/lib/python2.7/site-packages/
cp -R thrift_sasl /opt/anaconda3/lib/python3.6/site-packages/

Thanks,
Meher

merritth · 2019-01-25T19:30:47Z

I am experiencing the same issue with TSocket object has no attribute isOpen.

thrift-sasl 0.3.0
sasl 0.2.1
impyla 0.14.1

I'd love to be able to connect to a hive server via python...

RobertFeyerharm · 2019-01-29T15:29:09Z

Make sure to Restart your kernel if you're working in a Jupyter notebook!

I had the same problem connecting to Hive even after pip installing thrift_sasl==0.2.1, and was reminded by IT to restart my kernel before the changes take effect.

yerra · 2019-02-07T19:33:42Z

I am using Anaconda 3 Environment with python 3.6.4 .Even I am getting 'TSocket' object has not attribute 'isOpen' issue.
But I am unable to downgrade thrift_sasl below 0.3.0 Any Idea why I am uable to downgrade ?

thrift = 0.11.0
thrift-sasl 0.3.0
thrift-py=0.3.9
impyla 0.14.1

merritth · 2019-02-08T12:38:04Z

Make sure to Restart your kernel if you're working in a Jupyter notebook!

I had the same problem connecting to Hive even after pip installing thrift_sasl==0.2.1, and was reminded by IT to restart my kernel before the changes take effect.

Do you mean restart your Hive kernel or the kernel within your notebook?

yerra · 2019-02-08T12:47:17Z

I am using Anaconda Snyder . I did restart kernel restart at Ipython console . How to do Hive Kernel restart ?

merritth · 2019-02-08T12:48:35Z

That would be on your IT department I believe. I am not familiar how to reboot a hive/hadoop kernel.

yerra · 2019-02-08T14:23:11Z

I am running this on VM , Which I can do my self if it resolves the issue. I will try and update

RobertFeyerharm · 2019-02-08T15:41:18Z

@merritth Restart the kernel within your notebook. On the notebook toolbar: Kernel -> Restart

416381012 · 2019-04-04T10:03:15Z

I hava resolved it by use 0.2.1 version

* include thrift_sasl in setup.py for Python3 I've also pinned the version pending the resolution of #268 * Add thrift_sasl as optional dependency

Kxrr · 2019-08-20T05:01:52Z

The dependencies below work for me in docker container to initialize hive and impala client both.

system version

Python 3.6.8
Debian GNU/Linux 9 (stretch)

requirements.txt

impyla==0.15.0
sasl==0.2.1
thrift_sasl==0.2.1
thriftpy==0.3.9
thriftpy2==0.4.0

apt packages

sudo apt-get install libsasl2-dev libsasl2-2 libsasl2-modules-gssapi-mit

ampersand-five · 2020-01-24T06:25:04Z

Had the same problem. If you follow the error around, for me at least, the problem is that thrift-sasl calls isOpen() on a TSocket object (which exists in thriftpy2), but that object only has a function called is_open().

Looking at thrift-sasl, this was actually fixed in version 0.4.0 that was released on Dec. 13, 2019.

So make sure your package manager of choice is pulling thrift-sasl >= 0.4.0 and it should be fixed.
pypi at https://pypi.org/project/thrift-sasl/#history shows that thrift-sasl (as of Jan. 23, 2020) only has version 3 being distributed, so most are probably using pip and only getting version 3. Until pypi is updated with version 0.4.0, then the new version can be obtained with pip install thrift-sasl==0.4a1

timarmstrong · 2020-01-24T18:20:10Z

@dknupp do we plan to make the 0.4.0 release of thrift-sasl non-alpha?

MacwinWin · 2020-05-08T09:29:53Z

pandas.read_sql() still not working under thrift-sasl-0.4.2 but thrift-sasl-0.2.1 works fine

dreyco676 added a commit to dreyco676/impyla that referenced this issue Oct 9, 2017

pinned thrift_sasl until cloudera#268 is closed

ba26c25

dreyco676 mentioned this issue Oct 9, 2017

Pinned thrift_sasl to 0.2.1 until #268 is resolved #269

Merged

r-richmond mentioned this issue Oct 25, 2017

include thrift_sasl in setup.py #273

Merged

igorivanov mentioned this issue Oct 31, 2017

Fix erorrs in apache thrift compatibility cloudera/thrift_sasl#10

Merged

acherici added a commit to acherici/superset that referenced this issue Nov 29, 2017

Fix for Impyla issue (cloudera/impyla#268)

740f7fe

ccphillippi mentioned this issue Mar 21, 2018

Make compatible with Apache Thrift's isOpen and thriftpy's is_open cloudera/thrift_sasl#13

Merged

xmnlab mentioned this issue Apr 2, 2019

Error on Login into Hive on Kerberized Cluster ibis-project/ibis#1752

Closed

RASBORA mentioned this issue May 27, 2019

can't install thrift-sasl==0.2.1 with Python3.7 #352

Open

cpcloud mentioned this issue Jun 6, 2019

AttributeError: 'TSSLSocket' object has no attribute 'isOpen' ibis-project/ibis#1813

Closed

timarmstrong pushed a commit that referenced this issue Jul 15, 2019

include thrift_sasl in setup.py (#273)

8819cbd

* include thrift_sasl in setup.py for Python3 I've also pinned the version pending the resolution of #268 * Add thrift_sasl as optional dependency

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

'TSocket' object has no attribute 'isOpen' #268

'TSocket' object has no attribute 'isOpen' #268

tdhopper commented Oct 4, 2017

wesm commented Oct 4, 2017

tdhopper commented Oct 4, 2017

wesm commented Oct 4, 2017 •

edited

tdhopper commented Oct 4, 2017

ghost commented Oct 10, 2017

tdhopper commented Oct 10, 2017

ghost commented Oct 12, 2017 •

edited by ghost

igorivanov commented Oct 31, 2017

rsadaphule commented Mar 15, 2018

qp910 commented Apr 20, 2018

xiaomaosusie commented Sep 12, 2018

catchcharan commented Jan 24, 2019

merritth commented Jan 25, 2019

RobertFeyerharm commented Jan 29, 2019

yerra commented Feb 7, 2019

merritth commented Feb 8, 2019

yerra commented Feb 8, 2019

merritth commented Feb 8, 2019

yerra commented Feb 8, 2019

RobertFeyerharm commented Feb 8, 2019

416381012 commented Apr 4, 2019

Kxrr commented Aug 20, 2019 •

edited

ampersand-five commented Jan 24, 2020 •

edited

timarmstrong commented Jan 24, 2020

MacwinWin commented May 8, 2020

'TSocket' object has no attribute 'isOpen' #268

'TSocket' object has no attribute 'isOpen' #268

Comments

tdhopper commented Oct 4, 2017

wesm commented Oct 4, 2017

tdhopper commented Oct 4, 2017

wesm commented Oct 4, 2017 • edited

tdhopper commented Oct 4, 2017

ghost commented Oct 10, 2017

tdhopper commented Oct 10, 2017

ghost commented Oct 12, 2017 • edited by ghost

igorivanov commented Oct 31, 2017

rsadaphule commented Mar 15, 2018

qp910 commented Apr 20, 2018

xiaomaosusie commented Sep 12, 2018

catchcharan commented Jan 24, 2019

merritth commented Jan 25, 2019

RobertFeyerharm commented Jan 29, 2019

yerra commented Feb 7, 2019

merritth commented Feb 8, 2019

yerra commented Feb 8, 2019

merritth commented Feb 8, 2019

yerra commented Feb 8, 2019

RobertFeyerharm commented Feb 8, 2019

416381012 commented Apr 4, 2019

Kxrr commented Aug 20, 2019 • edited

system version

requirements.txt

apt packages

ampersand-five commented Jan 24, 2020 • edited

timarmstrong commented Jan 24, 2020

MacwinWin commented May 8, 2020

wesm commented Oct 4, 2017 •

edited

ghost commented Oct 12, 2017 •

edited by ghost

Kxrr commented Aug 20, 2019 •

edited

ampersand-five commented Jan 24, 2020 •

edited