Job to connect to remote server using SSH

mouniV · Post by **mouniV** » Mon Apr 23, 2012 11:51 pm

Hi,

I need to connect to a remote server through SSH through datastage job. I am trying to use execute command stage and the script i am giving is ssh <server_name> ; <user_name>
keys are established between the 2 servers.

But the job is failing.

Can some one help me with the script I have to give and if this is possible using any other stage apart from execute command stage.

Thanks,
Mounika

ray.wurlod · Post by **ray.wurlod** » Tue Apr 24, 2012 12:59 am

What (precise) error message is being logged?

mouniV · Post by **mouniV** » Tue Apr 24, 2012 2:58 am

Hi Ray,

ssh usename@servername did not finish ok. is the warning that i am getting.

Thanks,
Mounika

chulett · Post by **chulett** » Tue Apr 24, 2012 6:04 am

All that means is your script did not return success, a zero status. What else are you doing in the script besides this ssh command? Have you tried adding any debugging statements to it?

PaulVL · Post by **PaulVL** » Tue Apr 24, 2012 6:44 pm

Can you simplify the process by writing something like this:

ssh user@host "hostname";

break it down to testing the ssh connection and seeing if you can get there.

Then you can test the script/command you want to execute.

chrisjones · Post by **chrisjones** » Tue Apr 24, 2012 7:10 pm

Might be Keys not setup properly.

Did you try to connect from unix to remote server before connecting from datastage?

Execute the below syntax on unix and if there is error or prompting for password then fix the key issues else you are good with key setup.

ssh userid@remote server name

mouniV · Post by **mouniV** » Wed Apr 25, 2012 10:53 pm

Hi All,

Thanks for the replies.

I have tried ssh username@servername.
I am not doing any debugging.
Even then i am getting the same error. May be the key is not set properly. If key is not set, cant we login using ssh username/password@servername?

Thanks,
Mounika

mouniV · Post by **mouniV** » Wed Apr 25, 2012 11:18 pm

Hi All,
I was able to provide the password at command line and was able to establish connection. But, after connecting to remote server, it is asking for some user id. I am trying with that. THe command i have used is ssh username@servername --password='password'

Thanks,,
Mounika

chulett · Post by **chulett** » Thu Apr 26, 2012 6:45 am

OK... just for grins, clarify something. Are you executing an actual script in the Execute Command stage or not? It almost sounds like all you have in the stage is just the "ssh" command but that would make zero sense. What are you trying to accomplish? You need to ssh to a remote server and then what?

If you are running that ssh from the command line using the same credentials as the job and it prompts for the password, then you don't have the RSA keys / credentials setup correctly. And you won't be able to pass the password on the command line as that would make it not... "secure".

PaulVL · Post by **PaulVL** » Thu Apr 26, 2012 9:50 am

Cut and Paste what you are seeing.

mouniV · Post by **mouniV** » Mon May 07, 2012 2:21 am

Hi All,

Sorry for the late reply.
I am providing the server name, user name and password as well along with ssh.
How ever even while connecting manually, i need to provide the user id , apart from teh connection id and password i use for login.

RSA was not set up properly. So, we are trying to provide password while doing ssh.

Thanks,
Mounika

PaulVL · Post by **PaulVL** » Mon May 07, 2012 5:00 am

a password should never be required for an ssh connection.

that's why you were asked to manually validate the key.

If you got prompted for a password, then you have key issues.

chulett · Post by **chulett** » Mon May 07, 2012 6:29 am

So... what was the resolution?

mouniV · Post by **mouniV** » Wed May 09, 2012 11:58 pm

Hi All,

The keys were set up properly with the remote server and now we are able to connect without any issue.

chulett · Post by **chulett** » Thu May 10, 2012 6:30 am

Thank you... figured as much but wanted to confirm.