Here you go, @girish @robi! Thank you for your thoughts on this!

Apr 22 17:43:59 [2022-04-22 16:43:59,412][PID:2931][INFO][metrics] method=GET path=/api/jobs/c2156c30-d706-4dbb-984d-32f9881bbac8 endpoint=job status=200 content_type=application/json content_length=187 duration=5.55 query_count=2 query_duration=4.52 Apr 22 17:44:00 [2022-04-22 16:44:00,088][PID:3015][INFO][metrics] method=GET path=/ endpoint=redash_index status=302 content_type=text/html; charset=utf-8 content_length=291 duration=1.05 query_count=0 query_duration=0.00 Apr 22 17:44:01 2022/04/22 16:44:01 [worker_healthcheck] Received TICK_60 event from supervisor Apr 22 17:44:01 2022/04/22 16:44:01 [worker_healthcheck] No processes in state RUNNING found for process worker Apr 22 17:44:01 RESULT 2

@marcusquinn https://redash.io/help/user-guide/visualizations/pivot-table-visualizations

Accessible from the in app help under Visualizations

@dilipsook The default credentials are

Email: admin@cloudron.local Password: changeme

There will be a popup showing you this information after the app is installed.

0c0912d2-3d8a-4c9f-8eba-37b0e6d1aa3b-image.png

If you forget to make a note of it, you can always get this from the First Time Setup menu (click on the book button):

349ec37c-6f14-4db5-90f2-58dabfc7e1b8-image.png

@girish I have updated and been using everything for the last two days and it has been working as expected. Good to go from me, thank you!

@girish Hey! Its working nice. Thanks!

@christophermag yes, didn't forget but got backlogged. Just looking into this now. I have posting at https://forum.cloudron.io/topic/6187/has-anyone-used-v10-1-0 with the progress.

@girish thank you so much! 🙂

Thanks, Girish. I'm happy to test it once you've got it running if that helps?

@markjames said in Redash connect to an external DB - Do I need to open ports?:

While the initial request will be outgoing, the db will respond on port 1433 as well won't it?

This is a bit technical but the DB will respond to the port from which the request was made. This is usually a dynamic TCP port that the Cloudron app opened. The firewall has special rule to allow all incoming packets if it's an "established" connection. This is the reason why an outsider can connect to a port as long as it was cloudron that initiated the conversation first.