01-03-2017 10:34 PM - edited 01-03-2017 11:41 PM
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.
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.
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";
command="df -g >/drift/logs/admin/ADM_DF_Disk_Usage_dc4coj.txt";
--> 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
# This script extends connectserver.sh. Add local environment variables
# to this file so they will be preserved.
USERMODS_OPTIONS=" -xcmd "
$ cat sasv9_usermods.cfg
01-04-2017 06:01 AM
Take a look at the connect spawner configuration in SAS metadata.
01-04-2017 07:10 PM
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?
01-06-2017 03:47 AM
Please try updating ConnectSpawner_usermods.sh file in your compute tier. Add the following:
Restart Connect spwner and test.