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
373 stars 150 forks source link

unable to establish connection with SAS Grid from Linux box #362

Closed simontao01 closed 3 years ago

simontao01 commented 3 years ago

I used the same IOM configuration/credential and IOM host:8591 as of successfully running from local Windows to connect with SAS Grid, but failed if run from Linux box after installing saspy. The error is weird, the same IOM host doesn't exist on SAS Grid - is this caused by the Java files within saspy or needs to install client SAS on Linux box?

tomweber-sas commented 3 years ago

I'm going to need to see more info to know the answer. Can you show me your configurations and show me the code being run with the output/error it produces?

simontao01 commented 3 years ago

Could you send to my work email: zhu.yong.tao@citi.com, we cannot send what you require to personal email, thanks.

Best regards,

Simon

From: Tom Weber notifications@github.com Sent: Monday, January 25, 2021 3:11 PM To: sassoftware/saspy saspy@noreply.github.com Cc: simontao01 simontao01@hotmail.com; Author author@noreply.github.com Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

I'm going to need to see more info to know the answer. Can you show me your configurations and show me the code being run with the output/error it produces?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sassoftware/saspy/issues/362#issuecomment-767082993, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQZNZGAZWNMBCQAEROJDMDLS3XF6HANCNFSM4WSISK2A.

tomweber-sas commented 3 years ago

This turned out to be a proxy issue. The Grid has a proxy server you have to go through to get to it. This had been set up on windows by IT but nothing was done on the linux machine. We tracked it down and set it up on linux and now it connects as expected. The proxy SAS doc is here, for reference: https://go.documentation.sas.com/?cdcId=bicdc&cdcVersion=9.4&docsetId=bisecag&docsetTarget=p0tbh3vv7cetrbn1jw6fhxb8hp9r.htm&locale=en So, this one is resolved :) Tom

simontao01 commented 3 years ago

Hi Tom,

Thanks for your kind help to solve the connection issue. One more question for running saspy is the SASsession() sounds continue to run after SAS script run through, the icon on Jupyter Notebook and PyCharm display still running without ending, but it doesn't end after I add sasend() after SASsession() as online said, do you know how to do to end the SAS process?

import saspy SAS =SASsession()

demo = SAS.submit(''' SAS script''')

endsas()

Best regards,

Simon

From: Tom Weber notifications@github.com Sent: Tuesday, January 26, 2021 1:31 PM To: sassoftware/saspy saspy@noreply.github.com Cc: simontao01 simontao01@hotmail.com; Author author@noreply.github.com Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

This turned out to be a proxy issue. The Grid has a proxy server you have to go through to get to it. This had been set up on windows by IT but nothing was done on the linux machine. We tracked it down and set it up on linux and now it connects as expected. The proxy SAS doc is here, for reference: https://go.documentation.sas.com/?cdcId=bicdc&cdcVersion=9.4&docsetId=bisecag&docsetTarget=p0tbh3vv7cetrbn1jw6fhxb8hp9r.htm&locale=en So, this one is resolved :) Tom

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sassoftware/saspy/issues/362#issuecomment-767741097, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQZNZGBIH5TMU42S5YLXO43S34DAJANCNFSM4WSISK2A.

tomweber-sas commented 3 years ago

Just from looking at what you have below, you didn't use the endsas() method from the SASsession object.

SAS.endsas() # is the endsas method of saspy

endsas() # is a non-existant method - didn't this give an error that it didn't know what this method was?

From: simontao01 notifications@github.com Sent: Tuesday, January 26, 2021 3:06 PM To: sassoftware/saspy saspy@noreply.github.com Cc: Tom Weber Tom.Weber@sas.com; State change state_change@noreply.github.com Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

EXTERNAL Hi Tom,

Thanks for your kind help to solve the connection issue. One more question for running saspy is the SASsession() sounds continue to run after SAS script run through, the icon on Jupyter Notebook and PyCharm display still running without ending, but it doesn't end after I add sasend() after SASsession() as online said, do you know how to do to end the SAS process?

import saspy SAS =SASsession()

demo = SAS.submit(''' SAS script''')

endsas()

Best regards,

Simon

From: Tom Weber notifications@github.com<mailto:notifications@github.com> Sent: Tuesday, January 26, 2021 1:31 PM To: sassoftware/saspy saspy@noreply.github.com<mailto:saspy@noreply.github.com> Cc: simontao01 simontao01@hotmail.com<mailto:simontao01@hotmail.com>; Author author@noreply.github.com<mailto:author@noreply.github.com> Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

This turned out to be a proxy issue. The Grid has a proxy server you have to go through to get to it. This had been set up on windows by IT but nothing was done on the linux machine. We tracked it down and set it up on linux and now it connects as expected. The proxy SAS doc is here, for reference: https://go.documentation.sas.com/?cdcId=bicdc&cdcVersion=9.4&docsetId=bisecag&docsetTarget=p0tbh3vv7cetrbn1jw6fhxb8hp9r.htm&locale=en So, this one is resolved :) Tom

- You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sassoftware/saspy/issues/362#issuecomment-767741097, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQZNZGBIH5TMU42S5YLXO43S34DAJANCNFSM4WSISK2A.

- You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsassoftware%2Fsaspy%2Fissues%2F362%23issuecomment-767794951&data=04%7C01%7Ctom.weber%40sas.com%7C87bf07178bbc4b6300e708d8c235bfab%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C637472883395879300%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=HATYe5kUn2i01LNB1XGFgFkKrExweypUPkduRBuGCeY%3D&reserved=0, or unsubscribehttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAEHDYZXUTYPIRSODXWJ2433S34OBBANCNFSM4WSISK2A&data=04%7C01%7Ctom.weber%40sas.com%7C87bf07178bbc4b6300e708d8c235bfab%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C637472883395879300%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=g4EMdJnLa3uuRAnPCJSCpcQ1wBlfGlmMFdhtK%2FlEnqg%3D&reserved=0.

simontao01 commented 3 years ago

Yes, I think you are right, it's method of SAS session, thanks.

Best regards,

Simon

From: Tom Weber notifications@github.com Sent: Tuesday, January 26, 2021 3:10 PM To: sassoftware/saspy saspy@noreply.github.com Cc: simontao01 simontao01@hotmail.com; Author author@noreply.github.com Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

Just from looking at what you have below, you didn't use the endsas() method from the SASsession object.

SAS.endsas() # is the endsas method of saspy

endsas() # is a non-existant method - didn't this give an error that it didn't know what this method was?

From: simontao01 notifications@github.com Sent: Tuesday, January 26, 2021 3:06 PM To: sassoftware/saspy saspy@noreply.github.com Cc: Tom Weber Tom.Weber@sas.com; State change state_change@noreply.github.com Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

EXTERNAL Hi Tom,

Thanks for your kind help to solve the connection issue. One more question for running saspy is the SASsession() sounds continue to run after SAS script run through, the icon on Jupyter Notebook and PyCharm display still running without ending, but it doesn't end after I add sasend() after SASsession() as online said, do you know how to do to end the SAS process?

import saspy SAS =SASsession()

demo = SAS.submit(''' SAS script''')

endsas()

Best regards,

Simon

From: Tom Weber notifications@github.com<mailto:notifications@github.com> Sent: Tuesday, January 26, 2021 1:31 PM To: sassoftware/saspy saspy@noreply.github.com<mailto:saspy@noreply.github.com> Cc: simontao01 simontao01@hotmail.com<mailto:simontao01@hotmail.com>; Author author@noreply.github.com<mailto:author@noreply.github.com> Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

This turned out to be a proxy issue. The Grid has a proxy server you have to go through to get to it. This had been set up on windows by IT but nothing was done on the linux machine. We tracked it down and set it up on linux and now it connects as expected. The proxy SAS doc is here, for reference: https://go.documentation.sas.com/?cdcId=bicdc&cdcVersion=9.4&docsetId=bisecag&docsetTarget=p0tbh3vv7cetrbn1jw6fhxb8hp9r.htm&locale=en So, this one is resolved :) Tom

- You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sassoftware/saspy/issues/362#issuecomment-767741097, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQZNZGBIH5TMU42S5YLXO43S34DAJANCNFSM4WSISK2A.

- You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsassoftware%2Fsaspy%2Fissues%2F362%23issuecomment-767794951&data=04%7C01%7Ctom.weber%40sas.com%7C87bf07178bbc4b6300e708d8c235bfab%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C637472883395879300%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=HATYe5kUn2i01LNB1XGFgFkKrExweypUPkduRBuGCeY%3D&reserved=0, or unsubscribehttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAEHDYZXUTYPIRSODXWJ2433S34OBBANCNFSM4WSISK2A&data=04%7C01%7Ctom.weber%40sas.com%7C87bf07178bbc4b6300e708d8c235bfab%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C637472883395879300%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=g4EMdJnLa3uuRAnPCJSCpcQ1wBlfGlmMFdhtK%2FlEnqg%3D&reserved=0.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sassoftware/saspy/issues/362#issuecomment-767797589, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQZNZGGZGDUPPX6LKISDEBLS34OSRANCNFSM4WSISK2A.

simontao01 commented 3 years ago

Hi Tom,

Do you think we can connect using STDIO SSH to SAS Grid on Linux system from our Linux box? Thanks.

Best regards,

Simon

From: Tom Weber notifications@github.com Sent: Tuesday, January 26, 2021 3:10 PM To: sassoftware/saspy saspy@noreply.github.com Cc: simontao01 simontao01@hotmail.com; Author author@noreply.github.com Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

Just from looking at what you have below, you didn't use the endsas() method from the SASsession object.

SAS.endsas() # is the endsas method of saspy

endsas() # is a non-existant method - didn't this give an error that it didn't know what this method was?

From: simontao01 notifications@github.com Sent: Tuesday, January 26, 2021 3:06 PM To: sassoftware/saspy saspy@noreply.github.com Cc: Tom Weber Tom.Weber@sas.com; State change state_change@noreply.github.com Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

EXTERNAL Hi Tom,

Thanks for your kind help to solve the connection issue. One more question for running saspy is the SASsession() sounds continue to run after SAS script run through, the icon on Jupyter Notebook and PyCharm display still running without ending, but it doesn't end after I add sasend() after SASsession() as online said, do you know how to do to end the SAS process?

import saspy SAS =SASsession()

demo = SAS.submit(''' SAS script''')

endsas()

Best regards,

Simon

From: Tom Weber notifications@github.com<mailto:notifications@github.com> Sent: Tuesday, January 26, 2021 1:31 PM To: sassoftware/saspy saspy@noreply.github.com<mailto:saspy@noreply.github.com> Cc: simontao01 simontao01@hotmail.com<mailto:simontao01@hotmail.com>; Author author@noreply.github.com<mailto:author@noreply.github.com> Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

This turned out to be a proxy issue. The Grid has a proxy server you have to go through to get to it. This had been set up on windows by IT but nothing was done on the linux machine. We tracked it down and set it up on linux and now it connects as expected. The proxy SAS doc is here, for reference: https://go.documentation.sas.com/?cdcId=bicdc&cdcVersion=9.4&docsetId=bisecag&docsetTarget=p0tbh3vv7cetrbn1jw6fhxb8hp9r.htm&locale=en So, this one is resolved :) Tom

- You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sassoftware/saspy/issues/362#issuecomment-767741097, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQZNZGBIH5TMU42S5YLXO43S34DAJANCNFSM4WSISK2A.

- You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsassoftware%2Fsaspy%2Fissues%2F362%23issuecomment-767794951&data=04%7C01%7Ctom.weber%40sas.com%7C87bf07178bbc4b6300e708d8c235bfab%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C637472883395879300%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=HATYe5kUn2i01LNB1XGFgFkKrExweypUPkduRBuGCeY%3D&reserved=0, or unsubscribehttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAEHDYZXUTYPIRSODXWJ2433S34OBBANCNFSM4WSISK2A&data=04%7C01%7Ctom.weber%40sas.com%7C87bf07178bbc4b6300e708d8c235bfab%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C637472883395879300%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=g4EMdJnLa3uuRAnPCJSCpcQ1wBlfGlmMFdhtK%2FlEnqg%3D&reserved=0.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sassoftware/saspy/issues/362#issuecomment-767797589, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQZNZGGZGDUPPX6LKISDEBLS34OSRANCNFSM4WSISK2A.

tomweber-sas commented 3 years ago

Well, STDIO over SSH can connect to SAS on another Linux machine. So yes. Now whether you have access to do so, and whether or not your IT folks want you doing that is another thing, or two. That has nothing to so with saspy. But, if you can, you will be just starting up your own SAS sessions form the SAS deployment on those machines. not connecting to the defined Workspace servers, and bypassing any of the Grid infrastructure and policies that are in place for that whole system. I think we talked about this on the phone, if I'm remembering right.

simontao01 commented 3 years ago

Oh, directly turn around saspy is not my job, that's for IT guy. What I've seen within saspy there also has STDIO over SSH access method available, I wonder maybe I can try that one because my manager wants to use Functional/team ID instead of my personal ID and password, I found STDIO works with passwordless SSH, and SAS Grid is set up on Linux system...

Best regards,

Simon

From: Tom Weber notifications@github.com Sent: Thursday, January 28, 2021 4:29 PM To: sassoftware/saspy saspy@noreply.github.com Cc: simontao01 simontao01@hotmail.com; Author author@noreply.github.com Subject: Re: [sassoftware/saspy] unable to establish connection with SAS Grid from Linux box (#362)

Well, STDIO over SSH can connect to SAS on another Linux machine. So yes. Now whether you have access to do so, and whether or not your IT folks want you doing that is another thing, or two. That has nothing to so with saspy. But, if you can, you will be just starting up your own SAS sessions form the SAS deployment on those machines. not connecting to the defined Workspace servers, and bypassing any of the Grid infrastructure and policies that are in place for that whole system. I think we talked about this on the phone, if I'm remembering right.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sassoftware/saspy/issues/362#issuecomment-769411191, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQZNZGDTTNQUVSGPF4IZRXDS4HJNFANCNFSM4WSISK2A.

tomweber-sas commented 3 years ago

Yes, if you have passwordless ssh access to the machine where SAS is installed, then it will work. That's what it's designed for.