Google analytics data import via SFTP

Question

I've been trying to import costs via SFTP, but I'm unable to get past Create & generate key. For testing purposes, I've created a SFTP server, and I'm able to connect to it from outside the network just fine, but when I pass the correct username & server url to the Data import settings, it just throws 500 without any further information.

Strange is that the Analytics are actually trying to connect to the SFTP server (I can see it through the logs) with the username placeholder, but they fail because of lack of public key - which they are supposed to give me AFTER Create & generate key button is pressed. Thanks for any advice.

EDIT:

Since Analytics are trying to connect to the server with JSch library, I've tried to implement it my self, and it was able to successfully connect to the server. The main thing that bothers me is that google is for some reason trying to connect to the server without providing the key first and with wrong username as well. I've also found out, that others had the same problem, and already asked on the google support - but without any response.

EDIT 2:

I've realized, that you should not provide username as part of the server URL - as stated in documentation, but even if server URL without username is provided, it still does the same thing.

Answer 1

To your /etc/ssh/sshd_config add following lines.

HostKeyAlgorithms +ssh-rsa
PubkeyAcceptedKeyTypes +ssh-rsa

Then restart service

sudo systemctl restart sshd

Issue is that in newer versions they removed ssh-rsa by default and Google Analytics still require it. There is no documentation about it so... enjoy :)

Also here is Community Post about it