PyArango.Connection Fails with json.decoder.JSONDecodeError was unhandled by user code

Question

I am attempting to use the PyArango driver for ArangoDB. I am using Python 3.5.2 for Windows (that is what is provided by my organization) and ArangoDB 3.0 running locally on my computer.

I run the following in the python interactive shell (or in a script):

from pyArango.connection import *
myConnection = Connection()

When the Connection() line is evaluated the following is output to the console:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "C:\Users\xxxxx\AppData\Local\Programs\Python\Python35-32\lib\site-packages\pyArango\connection.py", line 88, in __init__
    self.reload()
  File "C:\Users\xxxxx\AppData\Local\Programs\Python\Python35-32\lib\site-packages\pyArango\connection.py", line 107, in reload
    data = r.json()
  File "C:\Users\xxxxx\AppData\Local\Programs\Python\Python35-32\lib\site-packages\requests\models.py", line 812, in json
    return complexjson.loads(self.text, **kwargs)
  File "C:\Users\xxxxx\AppData\Local\Programs\Python\Python35-32\lib\json\__init__.py", line 319, in loads
    return _default_decoder.decode(s)
  File "C:\Users\xxxxx\AppData\Local\Programs\Python\Python35-32\lib\json\decoder.py", line 339, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "C:\Users\xxxxx\AppData\Local\Programs\Python\Python35-32\lib\json\decoder.py", line 357, in raw_decode
    raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

The online tutorial/Documentation at https://www.arangodb.com/tutorials/tutorial-python/ and https://github.com/tariqdaouda/pyArango indicates support for ArangoDB 3.x and Python 3.4. Has enyone else encountered this problem attempting to use Python 3.5 with the pyArango driver? If so is there a resolution to this issue?

Thanks

pyArango is automatically tested on both 2.7 and 3.5. I've just pushed an update for printing the request content whenever a call to json() fails. Could you do a git pull and retry? That should give us more infos about what is going on. — tariqdaouda
– tariqdaouda, Commented Jul 25, 2016 at 22:20
Thanks. I pulled the latest update. The problem is due to the proxy server rejecting the python http client's attempt to connect to the ArangoDB server. The proxy server returns an html error page which is not parsable by the json parser. — muddlednbefuddled
– muddlednbefuddled, Commented Jul 27, 2016 at 18:15

muddlednbefuddled · Accepted Answer · 2016-07-27 20:10:14Z

1

The problem was caused by the firewall/proxy blocking http requests from the python http client. The firewall/proxy returned an html error page which caused the json decode error when it was processed by the json parser used by pyArango. The maintainers of pyArango added a log output on json decode failure that made this error condition obvious. Attempting to access the arango server with a browser such as firefox was not blocked by the firewall/proxy.

answered Jul 27, 2016 at 20:10

muddlednbefuddled

857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dothebart · Accepted Answer · 2016-07-22 11:09:12Z

0

we have updated the tutorial - it was missing the authentification steps.

However, I've not been able to get your error message about the failed json parser; I get:

>>> myConnection = Connection()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python3.5/dist-packages/pyArango-1.1.0-py3.5.egg/pyArango/connection.py", line 88, in __init__
  File "/usr/local/lib/python3.5/dist-packages/pyArango-1.1.0-py3.5.egg/pyArango/connection.py", line 105, in reload
  File "/usr/local/lib/python3.5/dist-packages/pyArango-1.1.0-py3.5.egg/pyArango/connection.py", line 30, in __call__
pyArango.theExceptions.ConnectionError: Unauthorized access, you must supply a (username, password) with the correct credentials. URL: http://localhost:8529/_api/database/user, status: 401. Errors: b''

which is the expected error message.

answered Jul 22, 2016 at 11:09

dothebart

6,07718 silver badges41 bronze badges

1 Comment

muddlednbefuddled Over a year ago

I am running on Windows using python 3.5 and pyArango==1.2.3. I attempted to downgrade to version 1.1 to match the version of pyArango you are using but on Windows the module fails to load with the following error: >>> from pyArango.connection import * Traceback (most recent call last): File "<stdin>", line 1, in <module> File "C:\Users\xxxxx\Downloads\dist\pyArango-1.1.0\pyArango\connection.py", l ine 4, in <module> from database import Database, DBHandle ImportError: No module named 'database'

Collectives™ on Stack Overflow

PyArango.Connection Fails with json.decoder.JSONDecodeError was unhandled by user code

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related