Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved Reading Wekan Mongo DB from Metabase/Grafana

    Support
    mongodb wekan metabase grafana
    2
    3
    142
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • ChristopherMag
      ChristopherMag last edited by girish

      I would like to create some Kanban based dashboards, like cumulative flow diagrams, cycle time reporting, etc. using the data in the Mongo DB instance used by Wekan.

      I believe I can create the dashboard I would like using Metabase and/or Grafana with the Wekan Mongo DB instance as the datasource.

      What would be the right way to go about exposing the Mongo DB instance used by Wekan to inbound connections from Metabse and/or Grafana?

      1 Reply Last reply Reply Quote 1
      • girish
        girish Staff last edited by

        @ChristopherMag If the Metabase/Grafana is in the same Cloudron , then you can :

        • Cloudron Dashboard -> Wekan -> Console -> Web Terminal
        • env | grep CLOUDRON_MONGODB. This gives mongodb credentials to configure metabase and grafana.

        If your Metabase/Grafana is hosted outside Cloudron, it's more complicated since we don't have a way to expose the database and we don't recommend this since we have not vetted exposing a database directly to the internet for security. One approach is to setup an SSH tunnel, but let me know if you want to go down this route.

        1 Reply Last reply Reply Quote 2
        • ChristopherMag
          ChristopherMag last edited by

          I am trying to only do this from the Cloudron hosted versions of Metabase/Grafana.

          I followed your instructions and this worked perfectly, took the username, password, port, host, and database name from the environment variables within the Wekan web console, entered them in Metabase, and was able to connect and see the data.

          Thank you!

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Powered by NodeBB