bartwr
commented
6 years ago We wanted to query the mongo database that is available on every of our bigchaindb nodes.
Marijn and I made querying mongodb directly possible, by doing the following:
- We created a SSH tunnel from the API server, for direct access to the mongodb of one of the bigchaindb nodes: https://github.com/OEHU/oehu-api#tests
- We implemented queries for getting the right data: https://github.com/OEHU/oehu-api/commit/70c249a4b6959088e133fd75979bd288014834b6
The reason for direct access to the mongo database is that is makes more advanced queries possible, for example filtering on a date range. It's still a decentralized network of bigchaindb nodes, and everyone that has its own node can query the companioned mongodb as well. This way it's still an open source project that anyone can use: decentralized & with self owned data.
I would like to redefine the scope of this issue.
Right now we have these statistics on the homepage:
This issue can be closed if the following is true:
- [x] "Meters connected" shows the amount of meters that are active. Active means:
- [x] At least one data point in the past 24 hours
- [x] At least 0.01 kWh delivered
- [x] Average KwH usage per household (last 24h) shows the data that you'd expect
- [x] Average KwH generated per household (last 24h) shows the data that you'd expect
- [x] Gas used per household (last 24h) shows the data that you'd expect
If all the checks above pass, this issue can be closed.
While it should be possible, I cannot get the connection to work with MongoDB. The port (27017) is open, IP is 188.166.15.225, auth is known, databasename is bigchaindb, but cannot establish connection.
https://docs.bigchaindb.com/en/latest/query.html?highlight=query https://blog.bigchaindb.com/using-mongodb-to-query-bigchaindb-data-3fc651e0861b