topic Re: XCMD command for SAS/Connect in Administration and Deployment

XCMD command for SAS/Connect

Nishant2000 — Wed, 04 Jan 2017 04:41:51 GMT

Hi All,

I am running below code but it fails with message “ERROR: Shell escape is not valid in this SAS session”. This code basically via SAS/Connect connects to remote host and run X command.

When I run the same command via workspace Server(i.e. via SAS EG on local host) the code works. What I understood is it is becasue Connect Server starts with -NOXCMD option.

I tried to make change from -NOXCMD to XCMD, by making changes in sasv9_usermods.cfg and ConnectServer_usermods.sh but nothing works.

Please suggest.

PS: XCMD is working fine for workspace server in remote and local, also permission of file is correct. And Connect Server is working fine as TCP connection is happening.

--> Code:

LIBNAME ADM00 BASE "Data/ETLA-System_Administrasjon/ADM.00_Common";
Option NOCONNECTMETACONNECTION ;

%LET TCPHOST = dc4coj 7552;
options remote=TCPHOST comamid=tcp;

signon TCPHOST user=sasftp pass="XXXX";

rsubmit TCPHOST;

data _null_;
command="df -g >/drift/logs/admin/ADM_DF_Disk_Usage_dc4coj.txt";
call system(command);
run;

endrsubmit;

signoff;

--> Startup Script for Connect Server:

/local/apps/SAS94/config/Lev1/SASETL/ConnectServer/ConnectServer.sh -DMR -COMAMID TCP -NOXCMD -NOTERMINAL

--> Changes in sasv9_usermods.cfg and ConnectServer_usermods.sh

$ cat ConnectServer_usermods.sh

#!/bin/sh -p

# connectserver_usermods.sh

# This script extends connectserver.sh. Add local environment variables

# to this file so they will be preserved.

USERMODS_OPTIONS=" -xcmd "

$ cat sasv9_usermods.cfg

-xcmd

Re: XCMD command for SAS/Connect

Kurt_Bremser — Wed, 04 Jan 2017 11:01:08 GMT

Take a look at the connect spawner configuration in SAS metadata.

Re: XCMD command for SAS/Connect

Nishant2000 — Thu, 05 Jan 2017 00:10:24 GMT

Hi,

I checked in Meta environment there is no configuration for connect spawner, and as connect server is in compute layer the configuration looks to be fine.

What exactly I need to check in metadata?

Re: XCMD command for SAS/Connect

abhijit_das — Fri, 06 Jan 2017 08:47:52 GMT

Please try updating ConnectSpawner_usermods.sh file in your compute tier. Add the following:

USERMODS_OPTIONS="JREOPTIONS -allowxcmd"

Restart Connect spwner and test.

regards,

Abhijit

Re: XCMD command for SAS/Connect

Nishant2000 — Mon, 29 Jan 2018 05:52:15 GMT

Hi,

Apologies for so delayed response, but it got solved.

We had to do two things:

1) Add xcmd entry in connectserver.sh script

2) Add entry in connect spawner option for xcmd.

Followed below link

http://support.sas.com/kb/16/109.html