Configuration Question

[mkumpf]

Paul,

I am struggling with getting this working - most of the issue is that I am an FTP newbie.

I installed the module, configured it and got it working with no issues on my local machine. I pointed it to an ftp site I set up at www.brickftp.com and was able to retrieve files with no issues.

When I deploy to the cloud, I get errors in the log. error messages look something like:

Apr 21 14:54:09.377 127.0.0.1 tr10000: ERROR - (S)FTP: (1/63) org.apache.commons.net.MalformedServerReplyException: Could not parse response code.
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (2/63) Server Reply: Protocol mismatch.
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (3/63)
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (4/63) at org.apache.commons.net.ftp.FTP.__getReply(FTP.java:337)
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (5/63) at org.apache.commons.net.ftp.FTP.__getReply(FTP.java:294)
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (6/63) at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:483)
Apr 21 14:54:09.380 127.0.0.1 tr10000: ERROR - (S)FTP: (7/63) at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:608)
Apr 21 14:54:09.380 127.0.0.1 tr10000: ERROR - (S)FTP: (8/63) at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:582)
Apr 21 14:54:09.380 127.0.0.1 tr10000: ERROR - (S)FTP: (9/63) at org.apache.commons.net.ftp.FTP.quit(FTP.java:864)

etc. etc. I attached the whole error stack to this issue as a file.
FTPErrorMessage.txt

I have not set up SSH keys or any other security settings in the cloud installation. Can you give me a beginner's run down of how to go about doing that? Also, if you see something in the errors that may give me a direction to go in to resolve this, I would really appreciate it.

Thanks,

Mike

[Mcpoowl]

Hi Mike,

If you've used the same settings as locally, my guess is that is something
being blocked by the cloud. I'll try to test it a bit tomorrow. I'll keep
you posted!
Op 21 apr. 2016 22:04 schreef "mkumpf" notifications@github.com:

Paul,

I am struggling with getting this working - most of the issue is that I am
an FTP newbie.

I installed the module, configured it and got it working with no issues on
my local machine. I pointed it to an ftp site I set up at www.brickftp.com
and was able to retrieve files with no issues.

When I deploy to the cloud, I get errors in the log. error messages look
something like:

Apr 21 14:54:09.377 127.0.0.1 tr10000: ERROR - (S)FTP: (1/63)
org.apache.commons.net.MalformedServerReplyException: Could not parse
response code.
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (2/63) Server
Reply: Protocol mismatch.
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (3/63)
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (4/63) at
org.apache.commons.net.ftp.FTP.__getReply(FTP.java:337)
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (5/63) at
org.apache.commons.net.ftp.FTP.__getReply(FTP.java:294)
Apr 21 14:54:09.379 127.0.0.1 tr10000: ERROR - (S)FTP: (6/63) at
org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:483)
Apr 21 14:54:09.380 127.0.0.1 tr10000: ERROR - (S)FTP: (7/63) at
org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:608)
Apr 21 14:54:09.380 127.0.0.1 tr10000: ERROR - (S)FTP: (8/63) at
org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:582)
Apr 21 14:54:09.380 127.0.0.1 tr10000: ERROR - (S)FTP: (9/63) at
org.apache.commons.net.ftp.FTP.quit(FTP.java:864)

etc. etc. I attached the whole error stack to this issue as a file.
FTPErrorMessage.txt
https://github.com/Mcpoowl/SFTPModule/files/230632/FTPErrorMessage.txt

I have not set up SSH keys or any other security settings in the cloud
installation. Can you give me a beginner's run down of how to go about
doing that? Also, if you see something in the errors that may give me a
direction to go in to resolve this, I would really appreciate it.

Thanks,

Mike

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub
#6

[mkumpf]

Paul

Thanks for getting back to me - your help is much appreciated!

Mike

[mkumpf]

BTW, in case you want to use the same FTP site I am using:

brook.brickftp.com

username: spstest

password: password

directory is called out (there are 2 documents in that directory)

[RCatersels]

Could it be that without the SSL it will fall back to normal FTP and thus not function in the cloud?

[RCatersels]

Mike, I always use WinSCP to test the setup. They have some good tutorials on how to create keys and do a test setup. See here: [https://winscp.net/eng/docs/public_key] . To be able to use the keys you have to make them openssh compatible. In puttygen you can do that by clicking conversion / export to openssh. Now place the private key in the resources/SFTP map if your Mendix project directory. Now change the know_hosts file and add the brook.brickftp.com site in that file. Each SFTP server needs a new line.
And some last double checking. SFTP is something different then FTPS. Make sure that you connect with an SFTP server.

Ronald

[Mcpoowl]

Mike,

Can you (preferably with screenshots) tell me what you're settings are and if you can see your documents in the application

[Mcpoowl]

Mike,

I managed to get it working in a Sandbox environment, without really doing anything different as to my local setup.

Here is my settings screen using your FTP credentials

And the actual document overview

Let me know if this works for you. Please bear in mind that this is the regular FTP connection, so no SFTP. For that you need to have a private.key and a known_hosts file in your resources folder which match with your server.

[mkumpf]

Paul and Ronald

Thanks for the assistance!

@Mcpoowl - what Mendix version did you use for this testing
@RCatersels - I will work with the ssh key resources you included in your comments. I had a key in the resources folder, but not sure if it was created correctly.

I'll keep you posted on my progress with this.

Miek

[Mcpoowl]

Hi Mike,

I tried a late Mx5 version since the module isn't Mendix 6 compatible from
the Appstore. I used 5.21.1 if I recall correctly.

Good luck!
Paul
Op 22 apr. 2016 15:22 schreef "mkumpf" notifications@github.com:

Paul and Ronald

Thanks for the assistance!

@Mcpoowl https://github.com/Mcpoowl - what Mendix version did you use for
this testing
@RCatersels https://github.com/RCatersels - I will work with the ssh key
resources you included in your comments. I had a key in the resources
folder, but not sure if it was created correctly.

I'll keep you posted on my progress with this.

Miek

—
You are receiving this because you were mentioned.

Reply to this email directly or view it on GitHub
#6 (comment)

[mkumpf]

@RCatersels & @Mcpoowl I generated a key using PuttyGEN. Then I converted it to an OpenSSH key - which generated a file. I assume this file is my private key - is this correct? I also saved the public key and private key on my machine. The Resources directory for my project does not have a folder for SFTP - so I am going to create one, create a text file in that directory called known_hosts (does this file need an extension) and then put one line in that file with the following text: brook.brickftp.com Finally, I will past the generated OpenSSH key into this resources file. What do I do with the public key? I searched out some known_hosts file examples on line and they seemed to have the domain followed by a key - is that the public key? Do I need to paste my public key into the known_hosts file?

Anything else I am missing?

Thanks again for your help!

[RCatersels]

Strange that you do not have a SFTP directory in your resource folder. The private key is for the Mendix server, the public key you hand out to the other side. That key must be added to the SFTP server where you connect with. The known_hosts has no extension and only holds the server names you want to connect with. That can be an IP address or the name of the server. There is nothing else you need to put there. If you still not get it to work I will see if I can make you a demo project and database so you can check out the setup.
Have a nice weekend,
Ronald

[mkumpf]

Ronald
I have tried a number of different configurations and setups without success. I created public and private keys and think they are in the correct places. If you have time to set up a small demo project, that would be great! Let me know if you need any additional info from me.
Mike

[Mcpoowl]

Hi Mike,

Quick question. Do you want to connect via SFTP, or regular FTP.
Ronald (thanks for all the responses btw!) is talking about settings regarding an SFTP connection, however, when connecting through regular FTP these files aren't neccesary. As said the above screenshots that I posted are done through FTP.

Can you verify that works for you? Or do you want to connect with SFTP? I'm asking since the error you posted contains a part of the stacktrace of apache.commons, which is the FTP library, and has "nothing" to do with SFTP (which uses the jsch library)

Just to make things clear :)

[mkumpf]

Paul

Actually, I need to do both. For this app, I have 1 vendor that I can
connect with via FTP and another that requires connection via SFTP. I
haven't gotten either to work in the acceptance instance of my Mendix cloud
deployment. I have gotten FTP to via the modeler to work but not SFTP.
When I added the certificate and known hosts to the modeler and tried to
connect via SFTP, the modeler never responds, no error message, just no
response when I call the Java action.

Let me know if I can provide any additional info.

Mike
On Apr 25, 2016 3:52 AM, "Paul Ketelaars" notifications@github.com wrote:

Hi Mike,

Quick question. Do you want to connect via SFTP, or regular FTP.
Ronald (thanks for all the responses btw!) is talking about settings
regarding an SFTP connection, however, when connecting through regular FTP
these files aren't neccesary. As said the above screenshots that I posted
are done through FTP.

Can you verify that works for you? Or do you want to connect with SFTP?
I'm asking since the error you posted contains a part of the stacktrace of
apache.commons, which is the FTP library, and has "nothing" to do with SFTP
(which uses the jsch library)

Just to make things clear :)

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
#6 (comment)

[Mcpoowl]

Can you please verify if the above setup works for you in your cloud environment using FTP to connect. Since I got it working in the sandbox It should work in a licensed cloud node aswell..

As far as SFTP goes, it's clear to me that @RCatersels has a lot more knowledge in that area compared to me :-)