Thank you..i created a SSH tunnel using putty and was able to successfully send request via jmeter.
On Monday, September 23, 2024, Dmitri T <glin...@live.com> wrote: > Anmol Sarraf wrote: > >> Hi Felix, >> >> Thanks for the reply. >> >> I tried using SSH sftp plugin over JDBC connection configuration. >> >> I can’t share the details but my problem is the same as seen in this post >> refer below link. >> >> https://groups.google.com/g/jmeter-plugins/c/uU8Lzb-j15Y >> >> I am using MySql driver for jdbc connection. >> >> SSh sftp is able to connect but not the JDBC request. >> >> Please let me know in case any more details are required. >> >> Thanks, >> Anmol >> On Saturday, September 21, 2024, Felix Schumacher < >> felix.schumac...@internetallee.de> wrote: >> >> Hi, >>> >>> can you give a bit more information on your JDBC over SSH setup? >>> >>> Can you access the database with mysql cli? >>> >>> Currently I guess it is a networking problem caused by an incorrect SSH >>> tunnel setup. >>> >>> Regards >>> >>> Felix >>> Am 21.09.24 um 08:45 schrieb Anmol Sarraf: >>> >>> Hi Team, >>> >>> I am trying to connect My SQL DB which is over SSH using JDBC connection >>> configuration in Jmeter. I am facing below error: >>> >>> Response message:java.sql.SQLException: Cannot create >>> PoolableConnectionFactory (Communications link failure >>> The last packet sent successfully to the server was 0 milliseconds ago. >>> The >>> driver has not received any packets from the server.) >>> >>> >>> In connection configuration, used database URL-jdbc:mysql://hostname:3306 >>> /schemaname >>> >>> Also using the latest mysql connector jar. >>> >>> Please help!! >>> >>> Thanks, >>> Anmol Sarraf >>> >>> >>> >>> 1. In case of SSH tunnel > <https://www.ssh.com/academy/ssh/tunneling-example> you need to use > *localhost* instead of hostname of the machine where MySQL instance > is running. Local port might also differ, > 2. SSH Sftp plugin (if you're talking about this one > <https://github.com/yciabaud/jmeter-ssh-sampler>) won't provide you > SSH tunnel, you will need to use JSR223 Sampler with Groovy language > <https://www.blazemeter.com/blog/apache-groovy> for this, example > code can be found here <https://stackoverflow.com/a/63248895> > >
