Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use tSSH and MySQL Input component to connect to MySQL DB using SSH tunnel,to do so when i try to connect to remote server using tSSH component with publickey with out key phrase and private key its giving me an error saying:
Starting job test_job at 12:11 11/09/2020.
[statistics] connecting to socket on port 3769
[statistics] connected
Exception in component tSSH_2 (test_job)
java.io.IOException: Publickey authentication failed.
at ch.ethz.ssh2.auth.AuthenticationManager.authenticatePublicKey(AuthenticationManager.java:281)
at ch.ethz.ssh2.Connection.authenticateWithPublicKey(Connection.java:459)
at ch.ethz.ssh2.Connection.authenticateWithPublicKey(Connection.java:510)
at t_64.test_job_0_1.test_job.tSSH_2Process(test_job.java:347)
at t_64.test_job_0_1.test_job.runJobInTOS(test_job.java:671)
at t_64.test_job_0_1.test_job.main(test_job.java:520)
Caused by: java.io.IOException: The connection is closed.
at ch.ethz.ssh2.auth.AuthenticationManager.deQueue(AuthenticationManager.java:85)
at ch.ethz.ssh2.auth.AuthenticationManager.getNextMessage(AuthenticationManager.java:113)
at ch.ethz.ssh2.auth.AuthenticationManager.authenticatePublicKey(AuthenticationManager.java:256)
... 5 more
Caused by: java.io.IOException: Cannot read full block, EOF reached.
at ch.ethz.ssh2.crypto.cipher.CipherInputStream.getBlock(CipherInputStream.java:90)
at ch.ethz.ssh2.crypto.cipher.CipherInputStream.read(CipherInputStream.java:119)
at ch.ethz.ssh2.transport.TransportConnection.receiveMessage(TransportConnection.java:234)
at ch.ethz.ssh2.transport.TransportManager.receiveLoop(TransportManager.java:839)
at ch.ethz.ssh2.transport.TransportManager$1.run(TransportManager.java:510)
at java.lang.Thread.run(Thread.java:748)
[statistics] disconnected
Job test_job ended at 12:11 11/09/2020. [exit code=1]
Attached is the screen shot of component design :
I using the private key without key passphrase.
below is Private Key structure inside the file:
-----BEGIN RSA PRIVATE KEY-----
MIIEogIBAAKCAQEAqNqpWh9ARJm6zQ/gk6lVhKn/2MG3q4HPLhWw8T/kZTfpHdVT
tH/R2jMQ87tWH5iHWOplKdsVKpaYPFnCiQGjn1fUTrrWx0UXUrmvpUONH8BGcpDV
TEtKRgHpJmO+4GFhrOaEmBD0O9SXgls9e7eRv1XxuzCvAt/tIopqrWgRV4xnSU2i
aC6fB1FpsldnoHmpGht4THCvD38uvHVOXDeX6p1sK6MDZtjgv/lNtdjltznR375O
DuCegJXxQ3uACMWYtf9ABMgtTbW8gxonwSE+JyRHszGhnM5Sk8q2mKJt5jDd/iWZ
W8fKa8oUCt6k/nyBPMWZTKIF4X5H7AUEbT5gKwIDAQABAoIBAAkW/Fblp8gJnoy7
dhN84iWqISPCCekpq8WHVWcnUVxBjkMU4NSurNVaOmdkhlZdF6wpshh2usT4JmnZ
Syek9vH1AHDcjgNcLM0/Qb1bzZUP/LreIR1iUDVElRCD/hqGI4PzROAKyZsO7rkN
wFmQoD/0mHbDQCifdVyOpv9+wrA7wEcC1lFrEKquxaQqfLroLzwqJl+mb27TG7A2
3flD7pQQmQAIlOk4wg0nbnCzeT1pVs5ZF3jDGy5QvMPZbOlH9/+fG9SyiA/Elf8L
Eiv3qtFh4IOBHkpBEkKqfPt1ZR2xUKyWd+HV45yuNUeyMonkANyztCtSUvfy9Hjy
B4URaUECgYEA3KTF2bKzhQBqAmcjBW5sRZtjEb0Lrg6sf0Jb/Jm1pq88lS7uNuBJ
vXnEltM8JkruwL4cuE5z3eLD/ejFsfKZ2rAjIrgByxqG23j6iMEPTQ594S85ToZa
wBMjPuJ3DpfjNxGksDfd9n9PnAarKujMJhlaTJr2IawbCM8lKR3OOb0CgYEAw+li
PtJnyz4Xj7crB9OnpVs1mqymqrUsev2vzNDhvGgi8Hu4gO4OnCtlNyp0jW+WzmWO
ljKYlY5xXUC4EmOahlMhhhgRgMytlw2HcTXsTCiQNDO+JPvLewLr/fSw2Gf1iOPb
uYRwG7gZ9rec9y0Dv4NzXQTKyC396zzpHGREvAcCgYASFf+RxLAqaspFwCaCv3Zo
jkAkqBZZAiLpm4rmvcLCEwMoR1yHawMgYObYZiA8E1BWxD6ebO/adEgUfAwYdgZe
gqmeou6is13yh4whwZF7g4CWAMT1xtWRgQAWm4Ge1JxvWybguvOazPy9kV5eeg6h
4NoiBWG/iNf+dNxa7nKFEQKBgGgB+jeR6qq7DzUsMDsagfFGqAGy0VTllHTDQ9a/
umgU/R+g/0XrnHQKkdSkxHXmHTD8N6PDvr//fG3ekxqoKHxRnAWdt4UipLIB67sN
vqJ8Enq0Uak+yDtJRNJxWoW5Q2BmX9tw1TfSGG6j8kBDdK7y8YcbqTB3Qkvl7Xg2
P0t3AoGAY8s/XbxENhc5KwY1klywJrRdjNiTs2V609U64DJIq0aKZulctUWdbvpM
653VCYbxk13LEwHgVrtSyzIM4/ckXJJ3HM7Trl/LxjbX1+4n1vFGXCwI4reMu57q
gA9WOpNgfpyPDzPXiX8aHzi+xJjopLydbgGYW+zqcD1ZRSKsuUU=
-----END RSA PRIVATE KEY-----
Please let me know if I am missing anything.
Thanks in Advance.
Regards,
Sharath