Hi Dmitrii,
The issue stems from the fact that 'su' is designed to run interactively, so it expects a tty to read the password securely. You have to find a way to run a command as another user non-interactively.
If you have the option, you can use 'sudo' with the -S flag instead.
-S, --stdin read password from standard input
Example:
#dim cmd As %String = "echo "_password_" | sudo -S ls"
set status = Session.Execute(cmd, .device)
$$$ThrowOnError(status)
use device
read response:2
use 0
zwrite response
Otherwise 'expect' might work,
expect -c 'spawn su - root -c "ls"; expect "Password :"; send "password\n"; interact
Hi John,
Which version of IRIS did you install? Perhaps there is an issue with the webgateway? Have you tried to access the gateway and see if it the configuration is correct?
http://hostname/csp/bin/Systems/Module.cxw
Certifications & Credly badges:
Ludwig has no Certifications & Credly badges yet.
Global Masters badges:
Followers:
Ludwig has no followers yet.
Following:
Ludwig has not followed anybody yet.
Hi,
I just tried putting a database as read-only and then executing a dynamic SQL query which worked for me.
Are you able to provide some more information? For example, the SQL query, any <PROTECT> in the audit log? etc
Thank you