tSSH Component Giving Error in Talend Open Studio

sharushady — Sat, 16 Nov 2024 01:28:57 GMT

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

topic tSSH Component Giving Error in Talend Open Studio in Talend Studio

tSSH Component Giving Error in Talend Open Studio