topic Re: su command with expect script in Operating System - Linux

su command with expect script

Rohit Khaladkar — Wed, 15 Oct 2008 04:43:53 GMT

Hi All!
I need to automate the su command using expect script.Suppose I login as a user A , I need to change the user to oracle using the su oracle command and execute the command "sqlplus -ver".

I tried writing a expect script for the same , but can't figure out the reason it is not working.

Can someone please help. Below is the expect script that I wrote:

#!/usr/bin/expect -f
set timeout -1
spawn /bin/su oracle -c date
expect "Password: "
send "oracle\r"
expect "\r\n"
send "sqlplus -ver\n"

Re: su command with expect script

Ivan Ferreira — Wed, 15 Oct 2008 18:37:50 GMT

Probably you don't need expect for this. You only need SUDO. Give SUDO a try.

Re: su command with expect script

Rohit Khaladkar — Thu, 16 Oct 2008 04:08:13 GMT

Yes I thought about the sudo option. But that means I would have to make an entry in the /etc/sudoers file.Since the application I am developing has a constraint that no changes should be made to the file system on the server, I cannot use the sudo option.

Please let me know if you need anymore information on this.

Thanks!
Rohit Khaladkar

Re: su command with expect script

Matti_Kurkela — Fri, 17 Oct 2008 10:49:10 GMT

The su command in your expect script is "/bin/su oracle -c date", which means only the command "date" is executed as user "oracle". After that, the su session will not accept further commands: the su session will simply end.

You should be doing something like:

#!/usr/bin/expect -f
set timeout -1
spawn /bin/su oracle -c "sqlplus -ver"
expect "Password: "
send "oracle\r"
expect "\r\n"
# add here suitable expect lines to catch the entire sqlplus -ver output

MK