SFTP config working on Filezilla but not with Wappler :) - SOLVED

Wappler General Need Help
1

Hi,
After successfully connecting in FTP mode to my hosting I´m now trying to switch to SFTP mode within Wappler.

though with SFTP mode I keep on getting the path error
Cannot find the uploaded files - Probably wrong URL…"

(the problem disapear if I get back to using FTP)
Meanwhile, typing in the same parameters in Filezilla in SFTP mode. I can connect on the first trial - can browse or create a folder with no obstacle…

A small dif is that Filezilla doesnt require me to enter this “Web Server URL” param… as Wappler does.
else Im using the exact same values in FZ than in Wappler:
SFTP Server.
Port : 7822
User: ***
PW : ***
Remote Dir (not required)
Any idea what in the Wappler config could be modified so as to keep using directly wappler ?
tks

trail%20SFTP
trail SFTP.PNG656×602 58.6 KB

the Wappler partial log return this :

trail%20SFTP%20wappler
trail SFTP wappler.PNG706×443 32.8 KB

EDIT: and could Wappler NOT require this URL Path, if FZ is working fine without it as a Param… ? :thinking:

2

The URL is required for various reasons. It’s used to call and run files and script on the server.

On your Wappler screenshot I don’t see any error about this, are you sure all the data, ports, remote folder and site url is right?

3

As for the Param inputs in FZ, I just do this. from Wappler, I select the values in each 4 fields, then copy/past each of them into opened FZ corresponding fields…so that there is no manual input, just copy and past. Then running the test with FZ, everything works like a charm. create/delete a text file on server pose no problem.
As for wappler…leaving the same values i just copy/past in FZ, the connection test runs but I get the following msg. than Wappler disconect so I can´t proceed in updating s/t in the server´s folder.

In V. 17.6.
*if there was an option to not take into account the field “URL path” maybe I could run a test to see if this fields value is part of the problem.

Note that when using FTP I have the following behavior:
Case A:
Web server URL: http://myserver.com/mytargetfolder
Remote directory: (nothing)
Connect succesfully !

Case B:
Web server URL: http://myserver.com
Remote directory: /mytargetfolder (or) mytargetfolder
Error: cd : acccess failed 550. Cant change directory to /mytargetfolder
no such file or dirrectory.

So I just set it as in Case A and everything works fine.

back to the SFTP error msg : (http://**** hidden)
trail%20SFTP%20ERROR

4

If you want to have your Wappler project inside a sub-folder on your server then you need to create that folder first. Wappler doesn’t create it for you.

Remote directory should point to where the project root is, in a lot of ftp servers it is located under a folder called httpdocs. The remote directory must exist on the remote server, so if you want to place it in a different sub-folder then you need to create it first.

The Web server URL should point to the location where the project root can be accessed. This can be http://myserver.com or also under a sub-folder http://myserver.com/mytargetfolder.

Wappler uploads a test file to ftp server and then checks with the Web server URL if it can access it. This is to ensure that the user has configured it all correctly.

5

ok, just to know> /mytargetfolder was already created on server...before Testing Case A/B...

6

well your server says it isn't

7

maybe because of your typo :slight_smile:

8

its only typo exactly (no way to copy msg content too)
… just as a reminder, everything works fine in FTP mode…same server, same folders…
problem only occurs in SFTP mode.

The typo error was only in this Topic. (I changed the real names for those fake ones)
There is no typo in the FTP SFTP config params during test

9

Sometimes the SFTP points to a different folder on the server then the FTP. SFTP often points to the user folder and not to the http server root.

10

Hi patrick, so that would mean, The Web server URL should NOT be: http://myserver.com/mytargetfolder ?
(..as it is now, working for FTP)

11

Ok, that was the clue, this is now working on both Mode :slightly_smiling_face:

FTP path : http://myserver.com/mytargetfolder
SFTP path : https://myserver.com/public_html/mytargetfolder

tks everyone for supporting the search !

edited : added missing http"S" !!

1 Like
12

I am having the same issue. What in your case is your web server path? I made the public_html/targetfolder and used as you did for my sftp path and still not working. Did you put anything in the remote directory?

13

Hi Wendell,
Nop, I avoided and still fill nothing on the Remote path directory.
Yes, similar "public_html" path way used here:

https://myserver.com/public_html/mytargetfolder
httpS :slight_smile:
Terii

14

I am using SFTP in Filezilla, I can read/write file to a VPS in Google Cloud with no problem.
When generating key in puttygen, I chose no passphrase needed.

Then I tried setting up SFTP in Wappler 2.6.3.
I converted the .ppk file created in puttygen to openssh format which now contains -----BEGIN RSA PRIVATE KEY-----
In Wappler target setting page, I typed my URL, chose SFTP access type, entered FTP server address, username with empty password, and selected the openssh key file.

Testing Connection …

  • set color:use-color yes
  • set cmd:interactive yes
  • set file:charset utf-8
  • set xfer:clobber on
  • set ftp:timezone
  • set cmd:show-status yes
  • set cmd:set-term-status yes
  • set ftp:list-options -a
  • set cmd:fail-exit yes
  • set cmd:time-style “%Y-%m-%d %H:%M:%S”
  • set ftp:ssl-allow no
  • set ssl:verify-certificate no
  • set sftp:auto-confirm yes
  • set sftp:connect-program “ssh -a -x -v -i C:\Users\user1\user****mysite.com”
  • set net:max-retries 3
  • set net:timeout 20
  • set net:reconnect-interval-base 5
  • set net:reconnect-interval-multiplier 1
  • open -u user sftp://xxx.xxx.xxx.xxx
    Password:

It just stuck there as if waiting for password.
What am I doing wrong?