Re: MYSQL JDBC Connection issue

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 <
> [email protected]> 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>