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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

Redash connect to an external DB - Do I need to open ports?

Scheduled Pinned Locked Moved Solved Redash
6 Posts 3 Posters 440 Views
    • 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.
  • M Offline
    M Offline
    markjames
    wrote on last edited by
    #1

    Hi,
    I'm currently trying to connect to a remote Sql Server DB on port 1433 (the default). I've had this port opened for my cloudron servers IP, but I still can't connect successfully.

    Do I need to add port 1433 in some configuration somewhere to open this port for redash/sql server?

    Thanks
    Mark

    1 Reply Last reply
    0
  • nebulonN Offline
    nebulonN Offline
    nebulon Staff
    wrote on last edited by
    #2

    Since that is an outgoing connection, you should not need to adjust the firewall or such on your Cloudron. Do you have any logs on the Sql Server side to see if your redash instance attempts to login or gets blocked or so?

    1 Reply Last reply
    0
  • M Offline
    M Offline
    markjames
    wrote on last edited by
    #3

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

    I can probably get help to get the logs, but it's a third party who manages the db so I'd prefer to rule out the obvious before I go down that path.

    So is there something I need to configure to open up 1433 for redash?

    girishG 1 Reply Last reply
    0
  • nebulonN Offline
    nebulonN Offline
    nebulon Staff
    wrote on last edited by
    #4

    Generally being able to expose new ports and forward those to the app's docker container needs a package update. But I would be surprised if that external database would indeed connect on its own to the app.

    Since you mention the initial connection from the app to the db, does this work as expected?

    1 Reply Last reply
    0
  • M Offline
    M Offline
    markjames
    wrote on last edited by
    #5

    Thanks Nebulon. I'll follow up with the team administering the db tomorrow. Using the nc command directly from the server running cloudron, I'm not getting an acknowledgement. So i'm hoping it's an issue at their end.

    1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to markjames on last edited by
    #6

    @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.

    1 Reply Last reply
    1

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.