sftp issue

[Robert Denny]

Trying to configure an sftp interface to drop a file on a vendors system.

Getting this error in the error log.

[fset:wrte:ERR /0:os_lab_rpt_out:07/07/2011 11:45:33] Error while trying to write (null).

                       

Detailed error:bind failure: Cannot assign requested address

               

Curl errCode:7 Curl error: Couldn’t connect to server

Topic

[Russ Ross]

If you haven’t already manually tested logging in via SSH/SFTP then you might consider doing that to confirm the access is working before chasing your tail.

I’m on AIX and from the command prompt would do the following to test

sftp user@IP_of_foreign_system

for example

sftp russ@123.123.123.123

If you prefer you can use the hostname instead of the IP_of_the_foreign_system.

Russ Ross
RussRoss318@gmail.com

[Robert Denny]

I can connect from my windows client, but when we configure an outbound thread to drop the file on the remote server, we are not able to establish a connection.

[Charlie Bursell]

Do have license ?

Key: cl-aom-sftp

[Russ Ross]

The version of cloverleaf and before that we have 5.6 rev 2 does not sftp capability as a protocol but does have FTPS which is not the same thing.

Since you mentioned TCL curl I’m assuming you know you have to program/script the SFTP login and file movement until the day comes it is a protocol in your version of Cloverleaf.

I think later versions of cloverleaf have or will have SFTP as a protocol.

I wrote mine in TCL/Expect which I’ve been using for a while now and posted the TCL/Expect script SFTP/put source code at this URL:

<a href="https://usspvlclovertch2.infor.com/viewtopic.php?t=2659&#8243; class=”bbcode_url”>https://usspvlclovertch2.infor.com/viewtopic.php?t=2659

I’ve recently developed the SFTP/get script and will be testing it soon but not wanting to post it until used in prodcution for a while.

I’m not saying this is better than using TCL/curl because it might not be.

It was a method that would allow me to send SFTP the password.

Our security group doesn’t endorse a passwordless login and SSH/SFTP is hard to pipe the password to without using something like Expect.

Russ Ross
RussRoss318@gmail.com

[Charlie Bursell]

You cannot use TclCurl in earlier engines for SFTP  either as it was not compiled properly to do that

That is unless you want to download and compile your own version  😀

[Russ Ross]

Thanks Charlie!

That is useful to know becuase one day I might open the covers on TCL curl.

What version of Cloverleaf should I be on before TCL curl works without downloading?

Russ Ross
RussRoss318@gmail.com

[Charlie Bursell]

Not sure Russ, maybe next release. It may work on Unix as I haven’t tried it but I had to get a special version compiled for Windows on 5.8.3

They may not decide to release it as it would bypass the license requirements we have for SFT, FTPS, etc.

Maybe have to ask Rey

[Robert Denny]

No we do not have that license. I will ask our vendor about it.

We go through Mckesson.

Thanks for the information.

[Robert Denny]

Charlie,

How about just regular FTP? We have been attempting to configure interfaces using the ftp protocol and we get this error.

[fset:wrte:ERR /0:          ftp:07/08/2011 09:39:03] Error while trying to write test.txt. Detailed error:Uploading to a URL without a file name! Curl errCode:3 Curl error: URL using bad/illegal format or missing URL

[Charlie Bursell]

Uploading to a URL without a file name

Did you provide a file name?

You may have to contact Support

[Robert Denny]

How about FTP protocol. do we need to have a license for that?

[Bob Richardson]

Greetings,

We have been using TCL curl for our HTTPS interfaces to payers that establishes SSL connections – no certificate exchanges – just creating the encrypted sessions.  We had to start with CIS5.4.1 as the TclCurl was not available in prior releases.  Also: the canned HTTPS query Tcl procs did not work as advertised.  They do work since at least 5.6 for sure (tested them but preferred the Tcl Curl we have as we need to trap garbage coming back from one problematic payer and the canned stuff would dump those responses into the Error Database).

And, yes you need to buy a license for the Secure transfer stuff to work.

Currently we have run the Tcl Curl SSL successfully on Cloverleaf versions

5.4.1, 5.5, 5.6 + successfully.

Let me know if you would like more information.

I did do a presentation back in 2007 (Power Point) and would gladly share that file with anyone in this Forum.

Enjoy.

[Author]

Replies