Deploy an application to RSC that requires proxy usage for a DB connection

[konradino]

Hello,

when I'm deploying different apps to R Studio Connect they often connect to DBs to pull some data, however, some of our DBs always run behind our company proxy. RSC doesn't know that and those reports work locally on my computer when I have the proxy turned on but they they stop after deploying to RSC because it doesn't know about any proxy reference.

What's the best way of setting this up on RSC?

Thanks!

[cole]

Do you mind clarifying a little bit about what you mean by "proxy turned on" locally before you publish to Connect? How does the proxy work? Do you set the HTTP_PROXY or HTTPS_PROXY environment variable to the proxy path? (I've never heard of those used for a database connection before... but it seems possible)

If you can share a bit more about what it takes to enable database connections to take advantage of the proxy through R locally, that should help us determine what needs to be done to enable such a connection on Connect.

[konradino]

Ok, let the solution, which in the end was quite easy, clarify what I needed in the first place: our company id just whitelisted RSC IP for our DBs so that the server side could query them. Is that now somewhat clear?

[cole]

Yes! That makes perfect sense. RStudio Connect was firewalled from accessing the DB, so that needed to be opened up. I'm super happy to hear you got a solution! Thanks for sharing the detail!

[cderv]

If your question's been answered (even by you!), would you mind choosing a solution? It helps other people see which questions still need help, or find solutions if they have similar problems. Here’s how to do it:

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …