How to collect data from a .csv file on a password protected FTP server in RSA Identity Governance and Lifecycle 7.0.0
Originally Published: 2016-11-03
Last Modified: 2023-10-06
Article Number
Applies To
RSA Product/Service Type: All
Issue
- Data Source Type: Database
- DB type: CSV
- URL in the following format: jdbc:csv:ftp://<hostname>/<path>?<properties>
java.sql.SQLException: Failed to load table sherine:sun.net.ftp.FtpLoginException: Invalid username/password
Resolution
- Include the FTP username and password in the connection URL, with the following format:
jdbc:csv:ftp://<USERNAME>:<PASSWORD>@<IP>?<properties>
- Mount the ftp and browse to it locally in the collection. For more information and examples, review this article on how to mount remote ftp directory host locally into linux filesystem. The commands would be as follows:
acm-700:~ # zypper install curlftpfs acm-700:~ # su - oracle oracle@acm-700:~> mkdir mnt_ftp oracle@acm-700:~> curlftpfs <Username>:<Password>@<IP> /home/oracle/mnt_ftp/
In this case the connection URL will be in the following format:
jdbc:csv:////home/oracle/mnt_ftp/?<properties>
Related Articles
DSA-2020-196: RSA Authentication Manager Security Update for Dell EMC iDRAC Vulnerability Number of Views The "Forgot My Password" URL for RSA Identity Governance and Lifecycle is incorrect and returns a connection error Number of Views RSA ID Plus Admin MFA Trial Tutorial Number of Views Identity Data Collector (IDC) collection fails with the error: "ORA-00918: column ambiguously defined" during the Identit… Number of Views RSA Governance & Lifecycle SAP Connector Datasheet Number of Views
Trending Articles
RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.1 Quick Setup Fails with "Failed to Attach Replica Instance" User Application Portal How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device The RSA Identity Governance & Lifecycle AD Collector and AD ADC authentication source fail to establish a TLS 1.2 SSL conn…
Don't see what you're looking for?
