Bug 35761 - Add an administration editor for FTP and SFTP servers
Summary: Add an administration editor for FTP and SFTP servers
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Kyle M Hall
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-01-10 16:46 UTC by Kyle M Hall
Modified: 2024-01-31 16:53 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Kyle M Hall 2024-01-10 16:46:29 UTC
For EDI, our partners will often create a vendor and EDI vendor record for each account they have with a vendor. This ends with a ton of duplicate FTP data. It would be great if we defined FTP/SFTP servers in their own section of the admin area and could then select a single defined FTP/SFTP for multiple EDI vendor records. That way if the password needs changed, or a vendor upgrades from FTP to SFTP, only a single record needs to be edited.

In the future, this could be use to allow tools such as runreport.pl, export_records.pl, export_borrowers.pl and others to directly upload their file outputs to a remote server rather than require a second step afterward.
Comment 1 Kyle M Hall 2024-01-31 16:53:38 UTC
We can accept the host keys when we add a new SFTP server via
 ssh-keyscan -h <ip or name of host> >> known_hosts 
when a new SFTP server is added

Then, if the key changes we can detect the error ( via Net::SFTP::Foreign ) to flag e given SFTP server has no longer having a matching key.

We could then add the option to "reset" the public key via "ssh-keygen -R <ip or name of host>"