hello everyone! has anyone tried to use a sftp-jso...
# replication-troubleshooting
n
hello everyone! has anyone tried to use a sftp-json destination that can help me understand these errors? when i pass in a password (public key) i get an error that the port could not be cast to integer, which is a bit confusing
n
Hi Namer, are you passing it in as
['<your public key>']
?
n
thanks @Nataly Merezhuk (Airbyte) that was it although now im seeing an "invalid ipv6 url" error any tips? i dont find any references to these requirements in the SFTP-JSON overview
n
Could you give more context - like a screenshot or the logs? I need more info to debug that one
n
it seems i need to get the ipv6 of the sftp server url does that sound right to you
u
Yes, that sounds correct.
n
so would it follow that a normal .com hostname should not be entered into the `host`input?
n
Here is what I found, make sure to use square brackets: Because IPv6 addresses contain colons, they cannot be directly used in URLs because the colons would conflict with both the protocol declaration (http:// or https://) and port numbers. Therefore, when a literal IPv6 address is used, it is encased in a bracket, like http//[2001db8:1]80. Let me know if this works!
n
i see tried, didnt work.. the destination is a minio sftp server maybe there is something about the hostname provided by minio that makes it an invalid url?
does the sftp-json destination only allow literal ipv6 addresses?
n
Looks like I need to do some more research on this! I'll get back to you on this
n
okay thank u
any insight @Nataly Merezhuk (Airbyte) Is SFTP-JSON still a supported destination? I don't see it on the main catalog on the website anymore
n
I don't have more insight for you yet, unfortunately, but can confirm that it is a supported destination: https://docs.airbyte.com/integrations/destinations/sftp-json
n
hello everyone I've been trying to use ssh as an authentication method for the existing sftp-json destination connector I've edited the source code to look for system keys when connecting in the sftp client according to a file path parameter can anyone shed light on how/if connectors can access ssh keys from the container airbyte is running in? or point me to similar issues other people have had?
n
Connectors can access SSH keys from the container Airbyte is running in by generating an RSA key in PEM format. To generate this key, run the following command:
Copy code
ssh-keygen -t rsa -m PEM -f myuser_rsa
This produces the private key in pem format, and the public key remains in the standard format used by the
authorized_keys
file on your bastion host. The public key should be added to your bastion host to whichever user you want to use with Airbyte. The private key is provided via copy-and-paste to the Airbyte connector configuration screen, so it may log in to the bastion. Let me know if this helps!