topic Re: Invoking a script in a remote server and returning the exit code in Talend Studio

Invoking a script in a remote server and returning the exit code

Anonymous — Sat, 16 Nov 2024 14:01:45 GMT

Do you know if there is any component that invokes a script in a remote server?
For example, I'd like to invoke a C or PHP script in a remote Unix Server using Talend.
The script returns an exit code that indicates success (0) or failure (1).
Is this something I can do through Talend?
Thanks,
Daniel

Re: Invoking a script in a remote server and returning the exit code

Anonymous — Fri, 20 Mar 2009 23:03:03 GMT

Hi,
tSSH should do it.
HTH,

Re: Invoking a script in a remote server and returning the exit code

Anonymous — Mon, 23 Mar 2009 21:13:21 GMT

Thanks for the reply. I am now using the tSSH component to run a PHP script in a remote server. The command line I've put in the component is as below.
"php /var/www/html/sample/www/test/crontest.php"
The tSSH successfully ran the script. However, I am still not sure how I can return the exit code so to know if the php script ran successfully or not.
Although I've tried "exit 0", "exit 1", or "exit -1" in the PHP script, it all led to the "Success" message box, not the "Fail" message box.
Am I missing something?

Thank you!!!!
Daniel

Re: Invoking a script in a remote server and returning the exit code

Anonymous — Tue, 24 Mar 2009 03:33:03 GMT

Hello Daniel
tSSH component run actually ok even thought the exit code is 1 or 0 return by php script.
Did you try the global variable: ((Integer)globalMap.get("tSSH_1_EXIT_CODE")). Check the value of this variable when your php script run successfully or not.
tSSH--RunIf(((Integer)globalMap.get("tSSH_1_EXIT_CODE"))==1)-->tMsgBox
|
RunIf(((Integer)globalMap.get("tSSH_1_EXIT_CODE"))==0)-->tMsgBox
Best regards

shong

Re: Invoking a script in a remote server and returning the exit code

Anonymous — Tue, 24 Mar 2009 16:17:11 GMT

I appreciate your help Shong. It worked perfectly.