search

Ocelot-Social-Community / Ocelot-Social

Free and open-source social network for active citizenship.
https://ocelot.social
Other
93 stars 37 forks source link

🐛 [Bug] Admin statistics error #1511

Closed Tirokk closed 4 years ago

Tirokk commented 4 years ago

Tirokk Authored by Tirokk Closed

:bug: Bugreport

Admin statistics error. Again kind of the same game … 😂

Bildschirmfoto 2019-09-06 um 14 58 52

Steps to reproduce the behavior

  1. login as admin
  2. go to the admin pages (menu > admin)
  3. see the error on the dashboard

Expected behavior

See the statistics.

Additional context

Happened after I merged https://github.com/Human-Connection/Human-Connection/pull/1493 into master …

Tirokk commented 4 years ago

ogerly Authored by ogerly

https://stackoverflow.com/questions/48773505/neo4j-install-apoc-and-graph-algorithms-neo-clienterror-procedure-procedureregis

Tirokk commented 4 years ago

Tirokk Authored by Tirokk

On production this error occurs:

Bildschirmfoto 2019-09-16 um 09.42.29.png

Tirokk commented 4 years ago

ogerly Authored by ogerly

docker-compose neo4j CALL apoc.config.list()

key value
dbms.connector.http.enabled true
causal_clustering.discovery_listen_address 0.0.0.0:5000
unsupported.dbms.block_size.labels 56
dbms.connector.http.listen_address 0.0.0.0:7474
unsupported.dbms.directories.neo4j_home /var/lib/neo4j
dbms.directories.import import
causal_clustering.raft_advertised_address c7918b43ec38:7000
causal_clustering.raft_listen_address 0.0.0.0:7000
ha.host.coordination c7918b43ec38:5001
dbms.connector.https.enabled true
dbms.jvm.additional -XX:+UseG1GC
dbms.tx_log.rotation.retention_policy 100M size
dbms.connectors.default_listen_address 0.0.0.0
EDITION community
dbms.windows_service_name neo4j
unsupported.dbms.block_size.strings 120
dbms.connector.https.listen_address 0.0.0.0:7473
dbms.connector.bolt.listen_address 0.0.0.0:7687
causal_clustering.transaction_advertised_address c7918b43ec38:6000
causal_clustering.discovery_advertised_address c7918b43ec38:5000
unsupported.dbms.block_size.array_properties 120
dbms.memory.pagecache.size 512M
ha.host.data c7918b43ec38:6001
unsupported.dbms.edition community
dbms.directories.logs /logs
dbms.connector.bolt.enabled true
causal_clustering.transaction_listen_address 0.0.0.0:6000
wrapper.java.additional -Dneo4j.ext.udc.source=docker
HOME /var/lib/neo4j

???? dbms.security.procedures.unrestricted=apoc.trigger.,apoc.,algo.*
???? see https://stackoverflow.com/questions/48773505/neo4j-install-apoc-and-graph-algorithms-neo-clienterror-procedure-procedureregis

Tirokk commented 4 years ago

roschaefer Authored by roschaefer

We have this configuration on production and alpha: https://github.com/Human-Connection/Human-Connection/blob/master/deployment/human-connection/templates/configmap.template.yaml#L16

Production still shows an outdated version of the webapp/. I don't know the issue with staging though. Maybe it is indeed some configuration which I had on my laptop but forgot to add to the deployment?

Otherwise we can also just use cypher statements for the statistics.

Tirokk commented 4 years ago

Tirokk Authored by Tirokk

Locally it is my Neo4j setting

Set up apoc.meta.stats call !!!

# For Admin statistics page !!!
# change the './conf/neo4j.conf' file to have as well the setting
#     dbms.security.procedures.unrestricted=algo.*,apoc.*

# stop database and in the Neo4j Terminal edit the config file and add this line
$ nano ./conf/neo4j.conf
# start the database
Tirokk commented 4 years ago

roschaefer Authored by roschaefer

Screenshot - 2019-09-16T234450.926.png

I think this is resolved.

Tirokk commented 4 years ago

Tirokk Authored by Tirokk

It is a Neo4j config problem after all.