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>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
For additional commands, e-mail: user-h...@jmeter.apache.org
