#9 Sftp transfer with Keepass CS

[Romain Joachim]

Hi,

When I try to use Keepass for sftp transfer it fails because the username is not retrieved from CS.

In Jade output we see that username is missing before the @:

(@torciep02.fsp.ch:22) com.jcraft.jsch.JSchException - Auth fail
(@torciep02.fsp.ch:22) com.jcraft.jsch.JSchException - Auth fail
(@torciep02.fsp.ch:22) com.jcraft.jsch.JSchException - Auth fail ((@xxxxxxxx.xxx.xx:22) com.jcraft.jsch.JSc
hException - Auth fail)

Server logs confirm that username is not transmitted.

Mar 12 07:56:51 xxxxxxxxsshd[18813]: Invalid user from XX.X.X.XX
Mar 12 07:56:51 xxxxxxxxsshd[18813]: error: PAM: User not known to the underlying authentication module for illegal user from XXXXXXXXXX.XXX.XX
Mar 12 07:56:51 xxxxxxxx sshd[18813]: Failed keyboard-interactive/pam for invalid user from XX.X.X.XX port 58935 ssh2

CS is ok because hostname is retrieved from it.

Regards,

Romain Joachim

[Romain Joachim]

Jade configuration file is containing the following data:

[Keepass_DataBase]
use_credential_Store = true
CredentialStore_FileName = C:\app\jade\client\config\jadev2.kdb
CredentialStoreAuthenticationMethod = password
CredentialStore_password = toto

[sftpwithkeepass]
source_include = Keepass_DataBase
source_CredentialStore_KeyPath = sos/server/myserver
source_protocol=sftp
source_dir=/somepath
source_pre_transfer_commands=/somescript.sh
source_post_command=mv "$SourceFileName" /somepath
target_host=destserver.dom.co
target_dir=\somepath
target_protocol=local
target_pre_transfer_commands=net use \somepath
file_spec=^(..pdf|..PDF|..xls|..XLS)$
operation=copy
remove_files=false
force_files=false
recursive=false

[SOSMP]

Hi There

Couple of questions

1. which version of JADE you are using?
2. how did you called the JADE? CLI or JobScheduler JITL job?

[Romain Joachim]

Version of Jade is 1.8.1
I use the command line (jade.cmd)

[SOSMP]

Here is my simple working profile, I think you have just missed one parameter source_ssh_auth_method=password.

IMP : For FTP protocol default auth method is password, but with SFTP there could be two possible auth methods i.e. password or public key, thus you have to specify which one should JADE use.

[homer.sos_keepass]
file_spec                         = TRXDDLW1000.PDF
operation                         = copy
verbose                           = 20
;;
source_use_credential_Store       = true
source_CredentialStore_FileName   = /home/sos/sos-berlin.com/jade_client/config/credential_store/jade-keepassx.kdb
source_CredentialStore_password   = testing
source_CredentialStore_KeyPath    = sos/server/homer.sos
;;
source_dir                     = /home/test/data/from_homer
source_protocol                = sftp
source_ssh_auth_method         = password
;;
target_protocol                = local
target_host                    = localhost
target_dir                     = /home/sos/data/to_galadriel
;

---

Session Log

[sos@galadriel jade_current]$
[sos@galadriel jade_current]$ /home/sos/sos-berlin.com/jade_client/jade_current/bin/jade.sh -settings=/home/sos/sos-berlin.com/jade_client/config/100_jade_settings_credential_store.ini -profile=homer.sos_keepass


+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+                       START  : JADE.SH                          +
+                       ----------------                          +
+ DATE     : Do 12. Mär 12:08:07 CET 2015                        +
+ HOSTNAME : galadriel                                            +
+ USER     : sos                                                  +
+ CALL     : /home/sos/sos-berlin.com/jade_client/jade_current/bin/jade.sh -settings=/home/sos/sos-berlin.com/jade_client/config/100_jade_settings_credential_store.ini -profile=homer.sos_keepass +
+                                                                 +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

main INFO  12:08:09,646   (SOSDataExchangeEngineMain.java:72) ::Execute SOSDataExchange - Kommandozeilenprogram startet .... -- 1.8.1 (2015-02-06 09:44, revision f26d25f776a52f2714265c63422ac402e1269258) Copyright 2003-2014 SOS GmbH Berlin
main INFO  12:08:09,864   (SOSDataExchangeEngine.java:275) ::Execute $Id$ -- 1.8.1 (2015-02-06 09:44, revision f26d25f776a52f2714265c63422ac402e1269258) Copyright 2003-2014 SOS GmbH Berlin
main INFO  12:08:09,865   (SOSOptionLogFileName.java:178) ::setLogger setLogger without instance of logger called.
main INFO  12:08:09,872   (SOSDataExchangeEngine.java:290) ::Execute
*************************************************************************

*                                                                       *
*                JADE - JobScheduler Advanced Data Exchange             *
*                ---jade.sos-berlin.com---------------------            *
*                                                                       *
*************************************************************************
version              = $Id$ -- 1.8.1 (2015-02-06 09:44, revision f26d25f776a52f2714265c63422ac402e1269258) Copyright 2003-2014 SOS GmbH Berlin
date                 = 2015-03-12 12:08:09
operation            = copy
protocol             = local
port                 = 21
file regExp          = TRXDDLW1000.PDF
file path            =
source host          = homer.sos
source directory     = /home/test/data/from_homer
target host          = localhost
target directory     = /home/sos/data/to_galadriel
ErrorWhenNoData      = true
*************************************************************************

main INFO  12:08:10,077   (SOSDataExchangeEngine.java:786) ::setInfo 1 files found for regexp 'TRXDDLW1000.PDF'.
main INFO  12:08:10,077   (SOSFileListEntry.java:812) ::run SOSVfs_I_0108: Übertragung von /home/test/data/from_homer/TRXDDLW1000.PDF gestartet
main INFO  12:08:10,171   (SOSFileListEntry.java:333) ::doTransfer SOSVfs_I_274: Security hash (MD5) der Datei TRXDDLW1000.PDF ist b2d1236c286a3c0704224fe4105eca49
main INFO  12:08:10,176   (SOSDataExchangeEngine.java:305) ::Execute Elapsed time = 312, per File = 312, total bytes = 1
main INFO  12:08:10,180   (SOSDataExchangeEngine.java:316) ::Execute
*************************************************************************
 Ausführungsstatus     = Ohne Fehler.
 Erfolgreiche Übertragungen = 1
 Fehlgeschlagene Übertragungen     = 0
 letzter aufgetretener Fehler           =
*************************************************************************

main INFO  12:08:10,181   (SOSVfsTransferBaseClass.java:1164) ::logINFO (SOSVfsSFtpJCraft::disconnect) disconnect OK
main INFO  12:08:10,181   (SOSVfsTransferBaseClass.java:1164) ::logINFO (SOSVfsSFtpJCraft::disconnect) disconnect OK
main INFO  12:08:10,181   (SOSDataExchangeEngineMain.java:94) ::Execute SOSDataExchangeEngineMain::Execute - Programm wurde ohne Fehler beendet


+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+                         END  : JADE.SH                          +
+                         --------------                          +
+ DATE     : Do 12. Mär 12:08:10 CET 2015                        +
+ HOSTNAME : galadriel                                            +
+ USER     : sos                                                  +
+ CALL     : /home/sos/sos-berlin.com/jade_client/jade_current/bin/jade.sh -settings=/home/sos/sos-berlin.com/jade_client/config/100_jade_settings_credential_store.ini -profile=homer.sos_keepass +
+ EXIT     : 0                                                    +
+                                                                 +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

[sos@galadriel jade_current]$