Forums

Getting 500 internal server error, using Neo4j Database

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

deleted-user-7358650 | 1 post | May 13, 2020, 12:28 p.m. | permalink

hmm- as a free user, you are limited to a whitelist of sites that you can access externally, and only over http/https.

Staff conrad | 4232 posts | PythonAnywhere staff | May 14, 2020, 4:15 a.m. | permalink

At what pricing tier does this whitelisting limitation get lifted?

sne2 | 1 post | Dec. 11, 2021, 5:08 a.m. | permalink

All paid plans have full internet access, so they don't need to worry about whether something is whitelisted. One thing that sometimes catches people out -- if you start a console before you upgrade to a paid account, it will still be running with the old settings. Starting a fresh console and running your code there will clear up any problems like that.

Staff giles | 11800 posts | PythonAnywhere staff | Dec. 11, 2021, 4:55 p.m. | permalink