jaeddy
commented
5 years ago I've gotten stuck on updating docker-compose.yml — I can't figure out how to get the Python Flask service to connect to the Neo4j server in the separate container. I've added a step to mount authentication config as well as something (wait-for-it) to make sure the app doesn't try to connect until the neo4j server is running. However, I'm still getting an error that the connection is refused (see below).
@Pawel-Madej, @lukasz-rakoczy, @tschaffter - any ideas?
prov-service$ docker-compose up
Starting neo4j ... done
Recreating prov-server ... done
Attaching to neo4j, prov-server
neo4j | Active database: graph.db
prov-server | wait-for-it.sh: waiting 20 seconds for 127.0.0.1:7687
neo4j | Directories in use:
neo4j | home: /var/lib/neo4j
neo4j | config: /var/lib/neo4j/conf
neo4j | logs: /logs
neo4j | plugins: /var/lib/neo4j/plugins
neo4j | import: /var/lib/neo4j/import
neo4j | data: /var/lib/neo4j/data
neo4j | certificates: /var/lib/neo4j/certificates
neo4j | run: /var/lib/neo4j/run
neo4j | Starting Neo4j.
neo4j | 2019-07-15 22:02:29.670+0000 WARN Unknown config option: causal_clustering.discovery_listen_address
neo4j | 2019-07-15 22:02:29.676+0000 WARN Unknown config option: causal_clustering.raft_advertised_address
neo4j | 2019-07-15 22:02:29.677+0000 WARN Unknown config option: causal_clustering.raft_listen_address
neo4j | 2019-07-15 22:02:29.677+0000 WARN Unknown config option: ha.host.coordination
neo4j | 2019-07-15 22:02:29.678+0000 WARN Unknown config option: causal_clustering.transaction_advertised_address
neo4j | 2019-07-15 22:02:29.678+0000 WARN Unknown config option: causal_clustering.discovery_advertised_address
neo4j | 2019-07-15 22:02:29.679+0000 WARN Unknown config option: ha.host.data
neo4j | 2019-07-15 22:02:29.679+0000 WARN Unknown config option: causal_clustering.transaction_listen_address
neo4j | 2019-07-15 22:02:29.706+0000 INFO ======== Neo4j 3.5.7 ========
neo4j | 2019-07-15 22:02:29.730+0000 INFO Starting...
neo4j | 2019-07-15 22:02:33.982+0000 INFO Bolt enabled on 0.0.0.0:7687.
neo4j | 2019-07-15 22:02:37.586+0000 INFO Started.
neo4j | 2019-07-15 22:02:39.797+0000 INFO Remote interface available at http://localhost:7474/
prov-server | ./wait-for-it.sh: line 62: 9 Terminated timeout $WAITFORIT_BUSYTIMEFLAG $WAITFORIT_TIMEOUT $0 --child --host=$WAITFORIT_HOST --port=$WAITFORIT_PORT --timeout=$WAITFORIT_TIMEOUT
prov-server | wait-for-it.sh: timeout occurred after waiting 20 seconds for 127.0.0.1:7687
prov-server | INFO:synprov.config:Connecting to neo4j database
prov-server | INFO:synprov:Checking connection at bolt://127.0.0.1:7687
prov-server | Traceback (most recent call last):
prov-server | File "/usr/local/lib/python3.7/site-packages/neobolt/direct.py", line 835, in _connect
prov-server | s.connect(resolved_address)
prov-server | ConnectionRefusedError: [Errno 111] Connection refused
prov-server |
prov-server | During handling of the above exception, another exception occurred:
prov-server |
prov-server | Traceback (most recent call last):
prov-server | File "/usr/local/lib/python3.7/runpy.py", line 193, in _run_module_as_main
prov-server | "__main__", mod_spec)
prov-server | File "/usr/local/lib/python3.7/runpy.py", line 85, in _run_code
prov-server | exec(code, run_globals)
prov-server | File "/usr/src/app/synprov/__main__.py", line 31, in <module>
prov-server | main()
prov-server | File "/usr/src/app/synprov/__main__.py", line 26, in main
prov-server | init_db()
prov-server | File "/usr/src/app/synprov/__main__.py", line 17, in init_db
prov-server | neo4j_available()
prov-server | File "/usr/src/app/synprov/__init__.py", line 18, in neo4j_available
prov-server | neo4j_connection.run('MATCH () RETURN 1 LIMIT 1')
prov-server | File "/usr/local/lib/python3.7/site-packages/py2neo/database.py", line 533, in run
prov-server | return self.begin(autocommit=True).run(cypher, parameters, **kwparameters)
prov-server | File "/usr/local/lib/python3.7/site-packages/py2neo/database.py", line 828, in run
prov-server | entities=entities))
prov-server | File "/usr/local/lib/python3.7/site-packages/py2neo/internal/connectors.py", line 292, in run
prov-server | return self._run_1(statement, parameters, graph, keys, entities)
prov-server | File "/usr/local/lib/python3.7/site-packages/py2neo/internal/connectors.py", line 241, in _run_1
prov-server | cx = self.pool.acquire()
prov-server | File "/usr/local/lib/python3.7/site-packages/neobolt/direct.py", line 719, in acquire
prov-server | return self.acquire_direct(self.address)
prov-server | File "/usr/local/lib/python3.7/site-packages/neobolt/direct.py", line 612, in acquire_direct
prov-server | connection = self.connector(address, error_handler=self.connection_error_handler)
prov-server | File "/usr/local/lib/python3.7/site-packages/py2neo/internal/connectors.py", line 227, in connector
prov-server | encrypted=cx_data["secure"], **kwargs)
prov-server | File "/usr/local/lib/python3.7/site-packages/neobolt/direct.py", line 976, in connect
prov-server | raise last_error
prov-server | File "/usr/local/lib/python3.7/site-packages/neobolt/direct.py", line 966, in connect
prov-server | s = _connect(resolved_address, **config)
prov-server | File "/usr/local/lib/python3.7/site-packages/neobolt/direct.py", line 847, in _connect
prov-server | raise ServiceUnavailable("Failed to establish connection to {!r} (reason {})".format(resolved_address, error))
prov-server | neobolt.exceptions.ServiceUnavailable: Failed to establish connection to ('127.0.0.1', 7687) (reason [Errno 111] Connection refused)
prov-server exited with code 1
tschaffter
lukasz-rakoczy
These haven't been touched since the switch to neo4j. Need to get working to enable deployment and testing.