frayos’s gists

frayos / EnableConsulGUI.txt

Created February 27, 2018 12:01

Enable Consul GUI

	####
	If you are not concerned about the security risks for your deployment, you can enable the Consul web UI as follows:
	####
	Edit: /opt/sas/viya/config/etc/sysconfig/consul/default/sas-consul
	Modify line: CONSUL_OPTIONS=« -client 0.0.0.0 –ui »
	Restart consul: sudo service sas-viya-consul-default restart
	Browse to http://viserver.demo.sas.com:8500/, the Consul UI now works
	Go in settings and set the consul token value (/opt/sas/viya/config/etc/SASSecurityCertificateFramework/tokens/consul/default/client.token) to be able to browse/read/edit KVs

frayos / encodeSASPwd.sas

Created February 27, 2018 14:04

Password encoding SAS

	/**
	FULL DOC : http://go.documentation.sas.com/?docsetId=proc&docsetTarget=n1vzmasf0tdebfn1xec0k1tevq7q.htm&docsetVersion=9.4
	**/

	/** Input the Clear Text Password here ***/
	%let superpass='cleartextpassword';
	/** Choose Encryption methode sas001/sas002/sas003/sas004/sas005 ***/
	%let methodpwd=sas002;

	proc pwencode in=&superpass. method=&methodpwd. ;

frayos / ConnectToViyaConnect.sas

Created February 27, 2018 14:33

SAS/Connect to Viya Connect example

	/* NOT A FULL CODE */
	/* Key Statements only */
	%let myserver=viyahost.connectspawner.com 17551;
	SIGNON myserver user=sasdemo password="******";
	rsubmit;
	CAS mySession host="viyahost.cascontroller.com" ;
	libname mycaslib CAS caslib="CASUSER" host="viyahost.cascontroller.com" port=5570;
	proc upload data=sashelp.heart out=mycaslib.heart94;
	proc mdsummary data=mycas.heart94 ;
	proc download data=myCASlib.heartsum94 out=work.heartsum94 ;

frayos / .authinfo

Last active April 26, 2018 08:18

Auth SAS CAS .authinfo example place in ~ / home/userXX/.authinfo

	host intcas01.race.sas.com port 5570 username user01 password !s3cret
	OR
	host intcas01.race.sas.com port 5570 username user01 password {SAS002}04BB40381E71EF86461A2C990AD38F5E

frayos / ViyaStatusStopStart.sh

Last active March 2, 2018 09:13

Viya Start Stop Status ansible

	##########################
	### UNSUPPORTED ##########
	##########################
	# check the service status.
	ansible sas-all -b -m shell -a "service sas-viya-all-services status" -i inventory.ini

	# stop them
	ansible sas-all -b -m shell -a "service sas-viya-all-services stop" -i inventory.ini

	# start them

frayos / curlSCS.sh

Created March 6, 2018 10:58

Test Access SCS with Curl

curl --show-error -L -i -X PROPFIND https://externalRP/SASContentServer/repository/default/sasfolders/Foldera/V/C/ --basic --user 'sastrust@saspw:SUPERSASTRUSTPASSWORD' --upload-file - -H "Depth: 1"  -k

frayos / nmon.sh

Created March 8, 2018 13:43

nmon perf

	# -t = top process
	# -f = file
	# -s = interval in second
	# -c = count / number of interval
	# -m output directory
	nmon -t -f -s 60 -c 1440 -m /tmp/

frayos / CallSASHDPDebug.sh

Created March 12, 2018 14:43

Debug Hadoop SAS


	<SAHOME>/SASFoundation/9.4/sas -nodms -jreoptions "-Dlog4j.configuration=file:/tmp/debuglog4j.properties"

	### /tmp/debuglog4j.properties ###
	#log4j.rootCategory=DEBUG, F1
	#log4j.appender.F1=org.apache.log4j.FileAppender
	#log4j.appender.F1.file=/tmp/sasjava_log4j.log
	#log4j.appender.F1.layout=org.apache.log4j.PatternLayout
	#log4j.appender.F1.layout.ConversionPattern=%d{MM-dd HH:mm:ss,SSS} [%t][%-5p %c{1}] - %m%n

frayos / Sigar.txt

Created March 15, 2018 12:26

SIGAR command line testing

	# WINDOWS
	#FULL PS
	D:\sas\sashome\SASPrivateJavaRuntimeEnvironment\9.4\jre\bin\java -jar D:\sas\config\Lev1\Web\SASEnvironmentManager\agent-5.8.0-EE\bundles\agent-5.8.0/pdk/lib/sigar-1.6.6.13.jar ps
	# PS SASServer1
	D:\sas\sashome\SASPrivateJavaRuntimeEnvironment\9.4\jre\bin\java -jar D:\sas\config\Lev1\Web\SASEnvironmentManager\agent-5.8.0-EE\bundles\agent-5.8.0/pdk/lib/sigar-1.6.6.13.jar ps "State.Name.sw=java,Args.*.eq=-Dcatalina.base=/sas/config/Lev1/Web/WebAppServer/SASServer1_1 "

	# UNIX
	#FULL PS
	/sas/sashome/SASPrivateJavaRuntimeEnvironment/9.4/jre/bin/java -jar /sas/config/Lev1/Web/SASEnvironmentManager/agent-5.8.0-EE/bundles/agent-5.8.0/pdk/lib/sigar-1.6.6.13.jar ps
	#PS SASServer1

frayos / decodeTCEnc.sh

Last active April 27, 2018 12:42

Decode tcEnc

	#### PHRASE = com.springsource.tcserver.security.PropertyDecoder.passphrase= in catalina.properties (conf)
	#### PWDDEC = value without tceenc
	# UNIX
	SASHOME=/product/sas/system/
	JRECMD=$SASHOME/SASPrivateJavaRuntimeEnvironment/9.4/jre/bin/java
	WASHOME=$SASHOME/SASWebApplicationServer/9.4
	TCVERS=`ls $WASHOME\| grep tomcat-7`
	action=decode
	PHRASE='XXXX'
	PWDDEC='9F3fOC1uoNXXXXvXmAIoASRIvYF2JaKH/9tt4UQNI='

Younes frayos