i have hosted a neo4j database on Graphenedb.com, an my code is hosted here. I have basically a flask app but i am unable to query my database. I can provide snippet of my
@app.route('/login', methods =['GET','POST'])
def login():
form = Login()
if form.validate_on_submit():
user = form.username.data
passw = form.password.data
gdb1 = GraphDatabase.driver(bolt_url, auth=basic_auth(usr_nm_db, pswrd_db))
gdb = gdb1.session()
query = '''MATCH(m:users)WHERE m.username='%s' RETURN m.password AS pass''' % (user)
result = gdb.run(query,parameters={})
i am getting error on this part
gdb1 = GraphDatabase.driver(bolt_url, auth=basic_auth(usr_nm_db, pswrd_db))
I get 500 server error. I will show traceback from error.log but its too long but i shall post anyway just in case
2020-05-13 11:36:07,121: Exception on /login [POST]
Traceback (most recent call last):
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neobolt/direct.py", line 831, in
_connect
s.connect(resolved_address)
ConnectionRefusedError: [Errno 111] Connection refused
**NO MATCH**
During handling of the above exception, another exception occurred:
**NO MATCH**
Traceback (most recent call last):
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/flask/app.py", line 2447, in
wsgi_app
response = self.full_dispatch_request()
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/flask/app.py", line 1952, in
full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/flask/app.py", line 1821, in
handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/flask/_compat.py", line 39, in
reraise
raise value
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/flask/app.py", line 1950, in
full_dispatch_request
rv = self.dispatch_request()
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/flask/app.py", line 1936, in
dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/home/mj2266/mysite/flask_app.py", line 37, in login
gdb1 = GraphDatabase.driver(bolt_url, auth=basic_auth(usr_nm_db, pswrd_db))
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neo4j/__init__.py", line 120, in driver
return Driver(uri, **config)
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neo4j/__init__.py", line 161, in
__new__
return subclass(uri, **config)
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neo4j/__init__.py", line 235, in
__new__
pool.release(pool.acquire())
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neobolt/direct.py", line 715, in
acquire
return self.acquire_direct(self.address)
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neobolt/direct.py", line 608, in
acquire_direct
connection = self.connector(address, error_handler=self.connection_error_handler)
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neo4j/__init__.py", line 232, in
connector
return connect(address, **dict(config, **kwargs))
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neobolt/direct.py", line 972, in
connect
raise last_error
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neobolt/direct.py", line 962, in
connect
s = _connect(resolved_address, **config)
File "/home/mj2266/.virtualenvs/myvirtualenv/lib/python3.7/site-packages/neobolt/direct.py", line 843, in _
_connect
raise ServiceUnavailable("Failed to establish connection to {!r} (reason {})".format(resolved_address, error))
neobolt.exceptions.ServiceUnavailable: Failed to establish connection to ('34.229.164.223', 24787) (reason
[Errno 111] Connection refused)
Sorry if error is too long. If you suggest any edit i will do it! thanks