DSXchange

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

What (precise) error message is being logged?

Hi Ray,

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

Thanks,
Mounika

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?

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.

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

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

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

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".

Cut and Paste what you are seeing.

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

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.

So... what was the resolution?

Hi All,

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

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