topic Re: SAS 9.4 SASDM.EXE import .cer files unattended in Administration and Deployment

SAS 9.4 SASDM.EXE import .cer files unattended

Pollewops — Wed, 25 Oct 2017 13:09:20 GMT

Is there a way to unattended add .cer files to the SAS 9.4 configuration ?

Now I need to go through the wizard which is time consuming.

Any idea if such a command line is possible ?

Re: SAS 9.4 SASDM.EXE import .cer files unattended

JuanS_OCS — Wed, 25 Oct 2017 13:28:18 GMT

the java keytool command is your friend, since SAS basically uses the java certificate store (SASPrivateJRE) and the certificates on the Web Server you can manage them as a normal Apache server on ht httpd-ssl.cfg file. As simple as that.

Google: https://www.google.nl/search?q=java+import+certificates+keytool&oq=java+import+certificates+keytool&aqs=chrome..69i57.5572j0j7&sourceid=chrome&ie=UTF-8

Kind regards,

Juan

Re: SAS 9.4 SASDM.EXE import .cer files unattended

alexal — Wed, 25 Oct 2017 13:32:49 GMT

@Pollewops,

Basically, you have to update two files in /<SASHome>/SASSecurityCertificateFramework/1.1/cacerts

trustedcerts.pem - just a text file, where you need to append your Base-64 encoded X.509 certificate
trustedcerts.jks - this file can be updated with Java Key Tool as was mentioned above

Re: SAS 9.4 SASDM.EXE import .cer files unattended

Pollewops — Thu, 26 Oct 2017 11:05:05 GMT

SOLVED. I would like to share my current DOS script which works:

@echo off

set folder=%~dp0
if #%folder:~-1%# == #\# set folder=%folder:~0,-1%

rd /s /q "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\SAS\Utilities"
rd /s /q "%appdata%\Microsoft\Windows\Start Menu\Programs\SAS"

md "%appdata%\SAS\MetadataServerProfiles"
xcopy /e /y /r %folder%\config\*.swa "%appdata%\SAS\MetadataServerProfiles\"

echo install certificates
rem C:\Program Files\SASHome\SASSecurityCertificateFramework\1.1\cacerts
for /f "tokens=*" %%i in ('dir /b "%folder%\CI Certficates\"') do set cert=%%i && call :add_cert %cert%

pause
exit

:add_cert
echo cert %cert%
call :create_rspfile %cert%
"C:\Program Files\SASHome\SASDeploymentManager\9.4\sasdm.exe" -quiet -responsefile "%temp%\cert.rsp"
goto :eof

:create_rspfile
rem create response file
set rspfilelocation=%folder%\CI Certficates\%cert%
echo MANAGE_TASK=certframe_add > "%temp%\cert.rsp"
echo certframe.add.file=%rspfilelocation% >> "%temp%\cert.rsp"
goto :eof