search

sassoftware / saspy

A Python interface module to the SAS System. It works with Linux, Windows, and Mainframe SAS as well as with SAS in Viya.
https://sassoftware.github.io/saspy
Other
366 stars 149 forks source link

Databricks saspy Connection Error #596

Closed grup2986 closed 1 month ago

grup2986 commented 3 months ago

I am trying to connect to connect to a remote SAS server using saspy on a Databricks workspace hosted on Azure - it gives me the following error (redacted host & port):

We failed in getConnection The application could not log on to the server "iomhost:iomport". The machine name is not valid.

I can connect locally using the same code but when I test it in my Databricks workspace it fails. Is this a firewall issue and I have to establish a site to site connection with my remote sas workspace?

import saspy import sys

sas = saspy.SASsession(results = 'html', java = '/usr/bin/java', iomhost = ['iomhost'],
iomport = iomport, encoding = 'utf-8', omruser = '', omrpw = '')

tomweber-sas commented 3 months ago

Hey @grup2986 , that error, from some remote cloud client environment, certainly implies a network issue where you don't have access to your on prem from there. That's a DNS error because it has no idea what that host name resolves to. You could try using the IP, but if you don't have access through the firewall it still wont work. You could try it though.

tomweber-sas commented 3 months ago

Were you able to see about being able to connect back to your on prem system from there? Anything else that I can do for you? I can't help w/ cooperate firewalls unfortunately. Tom

grup2986 commented 3 months ago

Thanks Tom. I have a ticket open with our IT team

On Tue, Mar 26, 2024 at 12:10 PM Tom Weber @.***> wrote:

Were you able to see about being able to connect back to your on prem system from there? Anything else that I can do for you? I can't help w/ cooperate firewalls unfortunately. Tom

— Reply to this email directly, view it on GitHub https://github.com/sassoftware/saspy/issues/596#issuecomment-2021270561, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJDUSRVLUZOHLRNY2ZAEB7LY2HBZ7AVCNFSM6AAAAABE5KYVBCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMRRGI3TANJWGE . You are receiving this because you were mentioned.Message ID: @.***>

tomweber-sas commented 2 months ago

Hey, just checking on this. Make any progress? I was thinking I can close this and if you need more help later you could reopen it if necessary.

tomweber-sas commented 1 month ago

I'm going to close this, as it's in your court being a network restriction, not something that can be fixed in saspy. If you need anything else, feel free to reopen it!

Thanks, Tom

grup2986 commented 1 month ago

Sorry Tom for not responding and thanks for your help! On Fri, May 10, 2024 at 2:25 PM Tom Weber @.***> wrote:

I'm going to close this, as it's in your court being a network restriction, not something that can be fixed in saspy. If you need anything else, feel free to reopen it!

Thanks, Tom

— Reply to this email directly, view it on GitHub https://github.com/sassoftware/saspy/issues/596#issuecomment-2105153708, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJDUSRTVHBLZ3W6J2LGPELLZBUNKZAVCNFSM6AAAAABE5KYVBCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMBVGE2TGNZQHA . You are receiving this because you were mentioned.Message ID: @.***>