ReportServer Forum

matraxa

Member

Registered: 2023-10-26

Issue regarding SFTP configuration

Hi,
I'm trying to use the SFTP server in order to copy some existing groovy scripts in order to test some automation for an existing instance using ReportServer without having to manually put them using the UI. However, I'm having issues when I'm trying to connect to it. I'm receiving the following error:

$ sftp -i /opt/reportserver/ssh/hostkey -P 8022 root@localhost
Received disconnect from 127.0.0.1 port 8022:9: getKexProposal() no resolved signatures available
Disconnected from 127.0.0.1 port 8022
Connection closed.
Connection closed

Here is a bit more information regarding my current setup. I'm using Ubuntu 22.04 (jammy). I've set up ReportServer Enterprise 4.6.1-6098 using the best practice guide (https://reportserver.net/en/tutorials/i … /#database). For the ssh key, I've created it using the ssh-keygen command. The public/private keys are using the RSA algorithm and are 2048 bits in size. I've also changed the tomcat user to be the owner of those keys as well as the directory they are in. Finally here is the configuration of the
/fileserver/etc/misc/misc.cf file:

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
   <database>
      <oracle>
         <filter>
            <convertclobs>true</convertclobs>
         </filter>
      </oracle>
   </database>
   <remoteaccess>
      <sftp disabled="false"><!-- Use $generated in order to generate a key on first start. -->
         <keylocation>/opt/reportserver/ssh/hostkey.pem</keylocation>
         <port>8022</port>
      </sftp>
   </remoteaccess>
</configuration>

Any help would be appreciated, thanks. Apologies for the lack of formatting in this post.

Last edited by matraxa (2023-10-26 14:33:01)

matraxa

Member

Registered: 2023-10-26

Re: Issue regarding SFTP configuration

Nevermind, I managed to fix it. It seems that it was not liking my keys for some reason so I just used the $generated option to create a new one.