Architecting, installing and maintaining your SAS environment

Change in StoredProcess Webapp with regards to passwords

Accepted Solution Solved
Reply
Highlighted
Super User
Posts: 10,271
Accepted Solution

Change in StoredProcess Webapp with regards to passwords

Dear all,

 

after some stumbling blocks (see my other post in the admin&deploy community), I managed to update our server installation (AIX) from 9.4 M2 to 9.4 M5.

 

We now face the problem that URLs of the type

http://servername/SASStoredProcess/do?_program=xxxxxx&param=yyyyy&_user=zzzzz&_password={SAS001}ppppppppppp

do not work, although

AllowEncodedPassword

has been set to true (actually always was) in the Advanced tab of the Configuration Manager/SAS Application Infrastructure/Stored Process Web App 9.4 object in SAS MC

Omitting _password= lets the URL work.

The SASServer_1 was restarted with tcruntime-ctl.sh restart after verifying the metadata entry.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

Accepted Solutions
Solution
‎03-14-2018 02:29 AM
Valued Guide
Posts: 534

Re: Change in StoredProcess Webapp with regards to passwords

[ Edited ]
Posted in reply to jklaverstijn

Could you try with the password URL-encoded so at least the curly braces around SAS001 are replaced with %7B and %7D? The actual password may or may not need encoding depending on its value.

 

Hope this helps,

- Jan.

View solution in original post


All Replies
Valued Guide
Posts: 534

Re: Change in StoredProcess Webapp with regards to passwords

Posted in reply to KurtBremser

Hi Kurt,

 

What is the response you get from this URL that makes you decide it does't work? That would maybe help determining where the problem lies. Any relevant lines from the server.log you'd like to share with us?

 

Regards,

- Jan.

Solution
‎03-14-2018 02:29 AM
Valued Guide
Posts: 534

Re: Change in StoredProcess Webapp with regards to passwords

[ Edited ]
Posted in reply to jklaverstijn

Could you try with the password URL-encoded so at least the curly braces around SAS001 are replaced with %7B and %7D? The actual password may or may not need encoding depending on its value.

 

Hope this helps,

- Jan.

Super User
Posts: 10,271

Re: Change in StoredProcess Webapp with regards to passwords 9.4 M5

Posted in reply to jklaverstijn

Bingo!

 

That's it!

 

Somewhere on the way from M2 to M5 the webserver must have changed so that it does not accept the curly braces natively any longer. Replacing them with the encoded values did the trick.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 10,271

Re: Change in StoredProcess Webapp with regards to passwords 9.4 M5

Posted in reply to jklaverstijn

@jklaverstijn wrote:

Hi Kurt,

 

What is the response you get from this URL that makes you decide it does't work? That would maybe help determining where the problem lies. Any relevant lines from the server.log you'd like to share with us?

 

Regards,

- Jan.


Just to answer this one:

Literally nothing happened. Just a blank tab in the browser.

In the server logs I could see the request in the access log of the webserver, but the web application server had a strange entry like this:

xxx.xxx.xxx.xxx - - [13/Mar/2018:20:04:18 +0100] "GET null null" 400 -

so it looks like the webserver sent an empty request to the webapp server.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 432 views
  • 3 likes
  • 2 in conversation