-
Download Banana Lucidworks Banana: https://github.com/lucidworks/banana
-
Create Solr Cores for tables to be viewed through the dashboard
$ bin/dsetool create_core heracles_db.error_log generateResources=true reindex=true $ bin/dsetool create_core heracles_db.error_msgs generateResources=true reindex=true
Copy “banana-release” folder to DSE’s “resources” folder. Rename “banana-release” to “banana”
Path: Services/Installer: /usr/share/dse/resources No services/tarball: install_location/resources
Go to DSE/resources/banana/src/config.js and make the following changes :
- Change “banana_index” to “banana.dashboards”,
- set “solr_core” to "heracles_db.error_log,heracles_db.error_msgs",
1.Get the solrconfig.xml created for the core in step 2
dsetool get_core_config keyspace.table [current=true|false] > "Location Desired" eg: dsetool get_core_config heracles_db.error_log current = true > ~/Downloads/solrconfig.xml
2.Go to $DSE/resources/banana/resources/banana-int-solr-4.5/banana-int/conf Replace the file solrconfig.xml with the one copied in step 1 above.
localhost should be replaced by the IP of the machine as needed.
$ curl --data-binary @solrconfig.xml -H ‘Content-type:text/xml; charset=utf-8’ “http://localhost:8983/solr/resource/banana.dashboards/solrconfig.xml”
$ curl --data-binary @schema.xml -H ‘Content-type:text/xml; charset=utf-8’ “http://localhost:8983/solr/resource/banana.dashboards/schema.xml”
$ curl -X POST -H ‘Content-type:text/xml; charset=utf-8’ “http://localhost:8983/solr/admin/cores?action=CREATE&name=banana.dashboards”
- Update $DSE/resources/tomcat/conf/server.xml, add the following inside the tags:
- Delete $DSE/resources/tomcat/work
service dse restart
or
dse cassandra restart
##Customize Banana Dashboard as per your requirements
https://medium.com/@carolinerg/visualizing-cassandra-solr-data-with-banana-b54bf9dd24c#.dz96jqpq3