You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by dloscalzo <dl...@isminc.com> on 2007/07/20 13:21:26 UTC
JMeter problems when connecting to a MySQL database
I am attempting to test out a MySQL database using Apache Jmeter. When I do
so, Jmeter logs the following error message to a file:
java.sql.SQLException: No suitable driver
I've googled around, but I don't have a lot of Java knowledge and I'm
finding it difficult to determine what the classpath is, let alone how to
set it or even where to grab this driver file that it's looking for (which
is com.mysql.jdbc.Driver, I'm assuming).
The same error message also occurs on a Windows XP VM that I used for
testing, so I know it's not an OS X specific problem, but that's the one
that I'll be running it from.
Any assistance would be greatly appreciated!
--
View this message in context: http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11706383
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Return a data!
Posted by keerat <ke...@gmail.com>.
Yes- in exactly the same fashion.
After your HTTP Sampler, add a Regular Expression Extractor.
Note the Reference Name (assume you call it: regexName).
Add in the appropriate regular expression. Typically something like this:
form.name="foo".action="(.+)"
You'd be matching on the template $1$, and you'd probably want a specific
(typically first) match.
In a subsequent HTTP sampler, fire the HTTP request using the reference name
you defined in the regex extractor as ${regexName}.
You'll need to tweak the GET/POST options, and perhaps add in another regex
to pull out the requisite POST params that you might need and submit them
with the same naming convention as a request parameter.
On 7/23/07, TMustafa@etq.com <TM...@etq.com> wrote:
>
> Thank you, also I like to ask if we can get a data from the response of
> the first http request and use it in the next http request.
>
>
>
>
> regards,
>
> Thaer.
>
>
>
>
> keerat <ke...@gmail.com>
> 07/22/2007 09:04 PM
> Please respond to
> "JMeter Users List" <jm...@jakarta.apache.org>
>
>
> To
> "JMeter Users List" <jm...@jakarta.apache.org>
> cc
>
> Subject
> Re: Return a data!
>
>
>
>
>
>
> Absolutely. Use the regular expression extractor to create a variable that
> stores the form action, and another to extract a variable (if you have
> choices), and reference the above in a subsequent HTTP request sampler.
>
> On 7/22/07, TMustafa@etq.com <TM...@etq.com> wrote:
> >
> > Hello,
> >
> > can any one tell whether we can use jmeter to return a data (value for
> > certain parameter) from a requested page and use it in another http
> > request.
> >
> >
> > thanks,
> >
> > Thaer.
>
>
>
>
> --
> http://recursor.blogspot.com
>
>
--
http://recursor.blogspot.com
Re: Return a data!
Posted by TM...@etq.com.
Thank you, also I like to ask if we can get a data from the response of
the first http request and use it in the next http request.
regards,
Thaer.
keerat <ke...@gmail.com>
07/22/2007 09:04 PM
Please respond to
"JMeter Users List" <jm...@jakarta.apache.org>
To
"JMeter Users List" <jm...@jakarta.apache.org>
cc
Subject
Re: Return a data!
Absolutely. Use the regular expression extractor to create a variable that
stores the form action, and another to extract a variable (if you have
choices), and reference the above in a subsequent HTTP request sampler.
On 7/22/07, TMustafa@etq.com <TM...@etq.com> wrote:
>
> Hello,
>
> can any one tell whether we can use jmeter to return a data (value for
> certain parameter) from a requested page and use it in another http
> request.
>
>
> thanks,
>
> Thaer.
--
http://recursor.blogspot.com
Re: Return a data!
Posted by keerat <ke...@gmail.com>.
Absolutely. Use the regular expression extractor to create a variable that
stores the form action, and another to extract a variable (if you have
choices), and reference the above in a subsequent HTTP request sampler.
On 7/22/07, TMustafa@etq.com <TM...@etq.com> wrote:
>
> Hello,
>
> can any one tell whether we can use jmeter to return a data (value for
> certain parameter) from a requested page and use it in another http
> request.
>
>
> thanks,
>
> Thaer.
--
http://recursor.blogspot.com
Re: JMeter problems when connecting to a MySQL database
Posted by dloscalzo <dl...@isminc.com>.
I'm still not seeing anything. I have a single thread running for the
purposes of the test, which has been set to stop thread in the event of an
error. If I run the test, the 'light' turns green and continues to do so
indefinitely. There is nothing available under the tab with all options
checked under the configuration screen so as to grab any possible clue as to
what could be happening.
keerat wrote:
>
> Try and add the "View Results Tree" Listener to your thread group.
>
> In the Sampler Result tab, you might see some informative output after you
> run your test plan and select the JDBC sampler result.
>
>
> On 7/23/07, dloscalzo <dl...@isminc.com> wrote:
>>
>>
>> It is. I've chose to use 'MySQL' as the name. Is it possible that it
>> must
>> only be in lowercase?
>>
>> Is there anything else that I can check?
>>
>>
>> keerat wrote:
>> >
>> > You might want to double check that the JDBC Connection Configuration's
>> > "Variable Name Bound to Pool" name is the same as what you use within
>> your
>> > JDBC request's "Variable Name Bound to Pool".
>> >
>> > On 7/23/07, dloscalzo <dl...@isminc.com> wrote:
>> >>
>> >>
>> >> OK. I tried putting the 'mysql-connector-java-5.0.6-bin.jar' into the
>> >> /lib
>> >> folder as well, but still no dice.
>> >>
>> >> Just to rehash it all -
>> >>
>> >> Under the JDBC Connection Configuration element, I have the following
>> set
>> >> up:
>> >>
>> >> I have the database URL listed as:
>> >> jdbc:mysql://<serveripaddress>/<databasename>
>> >>
>> >> I have the JDBC driver class listed as: com.mysql.jdbc.Driver
>> >>
>> >> Both the user name and password are also correct. Is there something
>> >> wrong
>> >> with the syntax of the information that I've keyed in? I did check
>> the
>> >> manual and it should be correct, but I figured it was worth
>> >> double-checking.
>> >>
>> >> The server is available, scans show that port 3306 is available, but
>> the
>> >> output file doesn't have anything written to it other than the columns
>> >> headers. After execution, the process continues to run until stopped.
>> >>
>> >> Is there any other way to tell what is happening? I'm kind of stuck
>> here
>> >> without an error message to go on.
>> >>
>> >>
>> >>
>> >> Tracy Zhu wrote:
>> >> >
>> >> > In my experience, you should put the .jar file under lib/ folder.
>> >> >
>> >> >
>> >> > On 7/21/07, dloscalzo <dl...@isminc.com> wrote:
>> >> >>
>> >> >>
>> >> >> OK. I modified the 'my.cnf' file, restarted the mysql daemon and
>> made
>> >> >> sure
>> >> >> that it was listening on the local address. The port now shows as
>> >> being
>> >> >> open when I scan the machine.
>> >> >>
>> >> >> Jmeter still seems to have trouble connecting as it's still hanging
>> >> after
>> >> >> the test is started and logging nothing to the output file other
>> than
>> >> the
>> >> >> column headers.
>> >> >>
>> >> >>
>> >> >> André Pfeiler wrote:
>> >> >> >
>> >> >> > On Friday 20 July 2007 17:25, dloscalzo wrote:
>> >> >> >> After reading the Jmeter user manual page closely, I changed the
>> >> >> database
>> >> >> >> URL to the following:
>> >> >> >>
>> >> >> >> jdbc:mysql://<serveraddress>/<databasename>
>> >> >> >>
>> >> >> >> I scanned the machine and port 3306 is not open. Is this a
>> >> possible
>> >> >> >> cause
>> >> >> >> of the issue?
>> >> >> >>
>> >> >> >> The log file only writes headers, but Jmeter hangs when the test
>> is
>> >> >> run
>> >> >> >> and
>> >> >> >> nothing happens until I stop the job. I'm assuming that it is
>> now
>> >> >> >> attempting to communicate with the database on the machine, but
>> is
>> >> >> unable
>> >> >> >> to. There is no firewall running on this machine either.
>> >> >> >
>> >> >> > check out the mysql config file. skip-networking or an option
>> like
>> >> this
>> >> >> > and
>> >> >> > comment
>> >> >> >
>> >> >> >>
>> >> >> >> Piotr Swiecicki wrote:
>> >> >> >> > On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
>> >> >> >> >> Hello Piotr, thank you for responding so quickly.
>> >> >> >> >>
>> >> >> >> >> I have downloaded the JDBC drive for MySQL, but I am not sure
>> if
>> >> I
>> >> >> >> have
>> >> >> >> >> installed it correctly.
>> >> >> >> >>
>> >> >> >> >> I have copied the mysql-connector-java-5.0.6-bin.jar file to
>> the
>> >> >> >> >> /lib/ext directory, but I now see the following error message
>> >> >> repeated
>> >> >> >> >> in the output
>> >> >> >> >> file:
>> >> >> >> >>
>> >> >> >> >> com.mysql.jdbc.CommunicationsException: Communications link
>> >> failure
>> >> >> >> due
>> >> >> >> >> to
>> >> >> >> >> underlying exception:
>> >> >> >> >
>> >> >> >> > It depends what the underlying exception says. Without those
>> >> >> details
>> >> >> >> > I can only guess that the database is not authenticating your
>> >> >> >> > connection. Are the username, password and database name
>> >> >> correct? Is
>> >> >> >> > your host allowed to contact the database you are connecting
>> to?
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> > Piotr Swiecicki
>> >> >> >> >
>> >> >> >> >
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> > To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> > For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> > --
>> >> >> > André Pfeiler
>> >> >> >
>> >> >> > The e-Spirit Company GmbH
>> >> >> > Barcelonaweg 14
>> >> >> > D-44269 Dortmund
>> >> >> > http://www.FIRSTspirit.de
>> >> >> >
>> >> >> > fax: +49 231 28661-59
>> >> >> > e-mail: pfeiler@e-Spirit.de
>> >> >> >
>> >> >> > Geschäftsführer:
>> >> >> > Jörn Bodemann, Michael Kenfenheuer
>> >> >> > Amtsgericht Dortmund (HRB 13961)
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11712100
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11743832
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> >
>> > --
>> > http://recursor.blogspot.com
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11744128
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
>
> --
> http://recursor.blogspot.com
>
>
--
View this message in context: http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11744456
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JMeter problems when connecting to a MySQL database
Posted by keerat <ke...@gmail.com>.
Try and add the "View Results Tree" Listener to your thread group.
In the Sampler Result tab, you might see some informative output after you
run your test plan and select the JDBC sampler result.
On 7/23/07, dloscalzo <dl...@isminc.com> wrote:
>
>
> It is. I've chose to use 'MySQL' as the name. Is it possible that it
> must
> only be in lowercase?
>
> Is there anything else that I can check?
>
>
> keerat wrote:
> >
> > You might want to double check that the JDBC Connection Configuration's
> > "Variable Name Bound to Pool" name is the same as what you use within
> your
> > JDBC request's "Variable Name Bound to Pool".
> >
> > On 7/23/07, dloscalzo <dl...@isminc.com> wrote:
> >>
> >>
> >> OK. I tried putting the 'mysql-connector-java-5.0.6-bin.jar' into the
> >> /lib
> >> folder as well, but still no dice.
> >>
> >> Just to rehash it all -
> >>
> >> Under the JDBC Connection Configuration element, I have the following
> set
> >> up:
> >>
> >> I have the database URL listed as:
> >> jdbc:mysql://<serveripaddress>/<databasename>
> >>
> >> I have the JDBC driver class listed as: com.mysql.jdbc.Driver
> >>
> >> Both the user name and password are also correct. Is there something
> >> wrong
> >> with the syntax of the information that I've keyed in? I did check the
> >> manual and it should be correct, but I figured it was worth
> >> double-checking.
> >>
> >> The server is available, scans show that port 3306 is available, but
> the
> >> output file doesn't have anything written to it other than the columns
> >> headers. After execution, the process continues to run until stopped.
> >>
> >> Is there any other way to tell what is happening? I'm kind of stuck
> here
> >> without an error message to go on.
> >>
> >>
> >>
> >> Tracy Zhu wrote:
> >> >
> >> > In my experience, you should put the .jar file under lib/ folder.
> >> >
> >> >
> >> > On 7/21/07, dloscalzo <dl...@isminc.com> wrote:
> >> >>
> >> >>
> >> >> OK. I modified the 'my.cnf' file, restarted the mysql daemon and
> made
> >> >> sure
> >> >> that it was listening on the local address. The port now shows as
> >> being
> >> >> open when I scan the machine.
> >> >>
> >> >> Jmeter still seems to have trouble connecting as it's still hanging
> >> after
> >> >> the test is started and logging nothing to the output file other
> than
> >> the
> >> >> column headers.
> >> >>
> >> >>
> >> >> André Pfeiler wrote:
> >> >> >
> >> >> > On Friday 20 July 2007 17:25, dloscalzo wrote:
> >> >> >> After reading the Jmeter user manual page closely, I changed the
> >> >> database
> >> >> >> URL to the following:
> >> >> >>
> >> >> >> jdbc:mysql://<serveraddress>/<databasename>
> >> >> >>
> >> >> >> I scanned the machine and port 3306 is not open. Is this a
> >> possible
> >> >> >> cause
> >> >> >> of the issue?
> >> >> >>
> >> >> >> The log file only writes headers, but Jmeter hangs when the test
> is
> >> >> run
> >> >> >> and
> >> >> >> nothing happens until I stop the job. I'm assuming that it is
> now
> >> >> >> attempting to communicate with the database on the machine, but
> is
> >> >> unable
> >> >> >> to. There is no firewall running on this machine either.
> >> >> >
> >> >> > check out the mysql config file. skip-networking or an option like
> >> this
> >> >> > and
> >> >> > comment
> >> >> >
> >> >> >>
> >> >> >> Piotr Swiecicki wrote:
> >> >> >> > On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
> >> >> >> >> Hello Piotr, thank you for responding so quickly.
> >> >> >> >>
> >> >> >> >> I have downloaded the JDBC drive for MySQL, but I am not sure
> if
> >> I
> >> >> >> have
> >> >> >> >> installed it correctly.
> >> >> >> >>
> >> >> >> >> I have copied the mysql-connector-java-5.0.6-bin.jar file to
> the
> >> >> >> >> /lib/ext directory, but I now see the following error message
> >> >> repeated
> >> >> >> >> in the output
> >> >> >> >> file:
> >> >> >> >>
> >> >> >> >> com.mysql.jdbc.CommunicationsException: Communications link
> >> failure
> >> >> >> due
> >> >> >> >> to
> >> >> >> >> underlying exception:
> >> >> >> >
> >> >> >> > It depends what the underlying exception says. Without those
> >> >> details
> >> >> >> > I can only guess that the database is not authenticating your
> >> >> >> > connection. Are the username, password and database name
> >> >> correct? Is
> >> >> >> > your host allowed to contact the database you are connecting
> to?
> >> >> >> >
> >> >> >> > --
> >> >> >> > Piotr Swiecicki
> >> >> >> >
> >> >> >> >
> >> >>
> ---------------------------------------------------------------------
> >> >> >> > To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> > For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >
> >> >> > --
> >> >> > André Pfeiler
> >> >> >
> >> >> > The e-Spirit Company GmbH
> >> >> > Barcelonaweg 14
> >> >> > D-44269 Dortmund
> >> >> > http://www.FIRSTspirit.de
> >> >> >
> >> >> > fax: +49 231 28661-59
> >> >> > e-mail: pfeiler@e-Spirit.de
> >> >> >
> >> >> > Geschäftsführer:
> >> >> > Jörn Bodemann, Michael Kenfenheuer
> >> >> > Amtsgericht Dortmund (HRB 13961)
> >> >> >
> >> >> >
> >> ---------------------------------------------------------------------
> >> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >>
> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11712100
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11743832
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> >
> > --
> > http://recursor.blogspot.com
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11744128
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
--
http://recursor.blogspot.com
Re: JMeter problems when connecting to a MySQL database
Posted by dloscalzo <dl...@isminc.com>.
It is. I've chose to use 'MySQL' as the name. Is it possible that it must
only be in lowercase?
Is there anything else that I can check?
keerat wrote:
>
> You might want to double check that the JDBC Connection Configuration's
> "Variable Name Bound to Pool" name is the same as what you use within your
> JDBC request's "Variable Name Bound to Pool".
>
> On 7/23/07, dloscalzo <dl...@isminc.com> wrote:
>>
>>
>> OK. I tried putting the 'mysql-connector-java-5.0.6-bin.jar' into the
>> /lib
>> folder as well, but still no dice.
>>
>> Just to rehash it all -
>>
>> Under the JDBC Connection Configuration element, I have the following set
>> up:
>>
>> I have the database URL listed as:
>> jdbc:mysql://<serveripaddress>/<databasename>
>>
>> I have the JDBC driver class listed as: com.mysql.jdbc.Driver
>>
>> Both the user name and password are also correct. Is there something
>> wrong
>> with the syntax of the information that I've keyed in? I did check the
>> manual and it should be correct, but I figured it was worth
>> double-checking.
>>
>> The server is available, scans show that port 3306 is available, but the
>> output file doesn't have anything written to it other than the columns
>> headers. After execution, the process continues to run until stopped.
>>
>> Is there any other way to tell what is happening? I'm kind of stuck here
>> without an error message to go on.
>>
>>
>>
>> Tracy Zhu wrote:
>> >
>> > In my experience, you should put the .jar file under lib/ folder.
>> >
>> >
>> > On 7/21/07, dloscalzo <dl...@isminc.com> wrote:
>> >>
>> >>
>> >> OK. I modified the 'my.cnf' file, restarted the mysql daemon and made
>> >> sure
>> >> that it was listening on the local address. The port now shows as
>> being
>> >> open when I scan the machine.
>> >>
>> >> Jmeter still seems to have trouble connecting as it's still hanging
>> after
>> >> the test is started and logging nothing to the output file other than
>> the
>> >> column headers.
>> >>
>> >>
>> >> André Pfeiler wrote:
>> >> >
>> >> > On Friday 20 July 2007 17:25, dloscalzo wrote:
>> >> >> After reading the Jmeter user manual page closely, I changed the
>> >> database
>> >> >> URL to the following:
>> >> >>
>> >> >> jdbc:mysql://<serveraddress>/<databasename>
>> >> >>
>> >> >> I scanned the machine and port 3306 is not open. Is this a
>> possible
>> >> >> cause
>> >> >> of the issue?
>> >> >>
>> >> >> The log file only writes headers, but Jmeter hangs when the test is
>> >> run
>> >> >> and
>> >> >> nothing happens until I stop the job. I'm assuming that it is now
>> >> >> attempting to communicate with the database on the machine, but is
>> >> unable
>> >> >> to. There is no firewall running on this machine either.
>> >> >
>> >> > check out the mysql config file. skip-networking or an option like
>> this
>> >> > and
>> >> > comment
>> >> >
>> >> >>
>> >> >> Piotr Swiecicki wrote:
>> >> >> > On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
>> >> >> >> Hello Piotr, thank you for responding so quickly.
>> >> >> >>
>> >> >> >> I have downloaded the JDBC drive for MySQL, but I am not sure if
>> I
>> >> >> have
>> >> >> >> installed it correctly.
>> >> >> >>
>> >> >> >> I have copied the mysql-connector-java-5.0.6-bin.jar file to the
>> >> >> >> /lib/ext directory, but I now see the following error message
>> >> repeated
>> >> >> >> in the output
>> >> >> >> file:
>> >> >> >>
>> >> >> >> com.mysql.jdbc.CommunicationsException: Communications link
>> failure
>> >> >> due
>> >> >> >> to
>> >> >> >> underlying exception:
>> >> >> >
>> >> >> > It depends what the underlying exception says. Without those
>> >> details
>> >> >> > I can only guess that the database is not authenticating your
>> >> >> > connection. Are the username, password and database name
>> >> correct? Is
>> >> >> > your host allowed to contact the database you are connecting to?
>> >> >> >
>> >> >> > --
>> >> >> > Piotr Swiecicki
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >
>> >> > --
>> >> > André Pfeiler
>> >> >
>> >> > The e-Spirit Company GmbH
>> >> > Barcelonaweg 14
>> >> > D-44269 Dortmund
>> >> > http://www.FIRSTspirit.de
>> >> >
>> >> > fax: +49 231 28661-59
>> >> > e-mail: pfeiler@e-Spirit.de
>> >> >
>> >> > Geschäftsführer:
>> >> > Jörn Bodemann, Michael Kenfenheuer
>> >> > Amtsgericht Dortmund (HRB 13961)
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11712100
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11743832
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
>
> --
> http://recursor.blogspot.com
>
>
--
View this message in context: http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11744128
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JMeter problems when connecting to a MySQL database
Posted by keerat <ke...@gmail.com>.
You might want to double check that the JDBC Connection Configuration's
"Variable Name Bound to Pool" name is the same as what you use within your
JDBC request's "Variable Name Bound to Pool".
On 7/23/07, dloscalzo <dl...@isminc.com> wrote:
>
>
> OK. I tried putting the 'mysql-connector-java-5.0.6-bin.jar' into the
> /lib
> folder as well, but still no dice.
>
> Just to rehash it all -
>
> Under the JDBC Connection Configuration element, I have the following set
> up:
>
> I have the database URL listed as:
> jdbc:mysql://<serveripaddress>/<databasename>
>
> I have the JDBC driver class listed as: com.mysql.jdbc.Driver
>
> Both the user name and password are also correct. Is there something
> wrong
> with the syntax of the information that I've keyed in? I did check the
> manual and it should be correct, but I figured it was worth
> double-checking.
>
> The server is available, scans show that port 3306 is available, but the
> output file doesn't have anything written to it other than the columns
> headers. After execution, the process continues to run until stopped.
>
> Is there any other way to tell what is happening? I'm kind of stuck here
> without an error message to go on.
>
>
>
> Tracy Zhu wrote:
> >
> > In my experience, you should put the .jar file under lib/ folder.
> >
> >
> > On 7/21/07, dloscalzo <dl...@isminc.com> wrote:
> >>
> >>
> >> OK. I modified the 'my.cnf' file, restarted the mysql daemon and made
> >> sure
> >> that it was listening on the local address. The port now shows as
> being
> >> open when I scan the machine.
> >>
> >> Jmeter still seems to have trouble connecting as it's still hanging
> after
> >> the test is started and logging nothing to the output file other than
> the
> >> column headers.
> >>
> >>
> >> André Pfeiler wrote:
> >> >
> >> > On Friday 20 July 2007 17:25, dloscalzo wrote:
> >> >> After reading the Jmeter user manual page closely, I changed the
> >> database
> >> >> URL to the following:
> >> >>
> >> >> jdbc:mysql://<serveraddress>/<databasename>
> >> >>
> >> >> I scanned the machine and port 3306 is not open. Is this a possible
> >> >> cause
> >> >> of the issue?
> >> >>
> >> >> The log file only writes headers, but Jmeter hangs when the test is
> >> run
> >> >> and
> >> >> nothing happens until I stop the job. I'm assuming that it is now
> >> >> attempting to communicate with the database on the machine, but is
> >> unable
> >> >> to. There is no firewall running on this machine either.
> >> >
> >> > check out the mysql config file. skip-networking or an option like
> this
> >> > and
> >> > comment
> >> >
> >> >>
> >> >> Piotr Swiecicki wrote:
> >> >> > On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
> >> >> >> Hello Piotr, thank you for responding so quickly.
> >> >> >>
> >> >> >> I have downloaded the JDBC drive for MySQL, but I am not sure if
> I
> >> >> have
> >> >> >> installed it correctly.
> >> >> >>
> >> >> >> I have copied the mysql-connector-java-5.0.6-bin.jar file to the
> >> >> >> /lib/ext directory, but I now see the following error message
> >> repeated
> >> >> >> in the output
> >> >> >> file:
> >> >> >>
> >> >> >> com.mysql.jdbc.CommunicationsException: Communications link
> failure
> >> >> due
> >> >> >> to
> >> >> >> underlying exception:
> >> >> >
> >> >> > It depends what the underlying exception says. Without those
> >> details
> >> >> > I can only guess that the database is not authenticating your
> >> >> > connection. Are the username, password and database name
> >> correct? Is
> >> >> > your host allowed to contact the database you are connecting to?
> >> >> >
> >> >> > --
> >> >> > Piotr Swiecicki
> >> >> >
> >> >> >
> >> ---------------------------------------------------------------------
> >> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> >> >
> >> > --
> >> > André Pfeiler
> >> >
> >> > The e-Spirit Company GmbH
> >> > Barcelonaweg 14
> >> > D-44269 Dortmund
> >> > http://www.FIRSTspirit.de
> >> >
> >> > fax: +49 231 28661-59
> >> > e-mail: pfeiler@e-Spirit.de
> >> >
> >> > Geschäftsführer:
> >> > Jörn Bodemann, Michael Kenfenheuer
> >> > Amtsgericht Dortmund (HRB 13961)
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11712100
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11743832
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
--
http://recursor.blogspot.com
Re: JMeter problems when connecting to a MySQL database
Posted by dloscalzo <dl...@isminc.com>.
OK. I tried putting the 'mysql-connector-java-5.0.6-bin.jar' into the /lib
folder as well, but still no dice.
Just to rehash it all -
Under the JDBC Connection Configuration element, I have the following set
up:
I have the database URL listed as:
jdbc:mysql://<serveripaddress>/<databasename>
I have the JDBC driver class listed as: com.mysql.jdbc.Driver
Both the user name and password are also correct. Is there something wrong
with the syntax of the information that I've keyed in? I did check the
manual and it should be correct, but I figured it was worth double-checking.
The server is available, scans show that port 3306 is available, but the
output file doesn't have anything written to it other than the columns
headers. After execution, the process continues to run until stopped.
Is there any other way to tell what is happening? I'm kind of stuck here
without an error message to go on.
Tracy Zhu wrote:
>
> In my experience, you should put the .jar file under lib/ folder.
>
>
> On 7/21/07, dloscalzo <dl...@isminc.com> wrote:
>>
>>
>> OK. I modified the 'my.cnf' file, restarted the mysql daemon and made
>> sure
>> that it was listening on the local address. The port now shows as being
>> open when I scan the machine.
>>
>> Jmeter still seems to have trouble connecting as it's still hanging after
>> the test is started and logging nothing to the output file other than the
>> column headers.
>>
>>
>> André Pfeiler wrote:
>> >
>> > On Friday 20 July 2007 17:25, dloscalzo wrote:
>> >> After reading the Jmeter user manual page closely, I changed the
>> database
>> >> URL to the following:
>> >>
>> >> jdbc:mysql://<serveraddress>/<databasename>
>> >>
>> >> I scanned the machine and port 3306 is not open. Is this a possible
>> >> cause
>> >> of the issue?
>> >>
>> >> The log file only writes headers, but Jmeter hangs when the test is
>> run
>> >> and
>> >> nothing happens until I stop the job. I'm assuming that it is now
>> >> attempting to communicate with the database on the machine, but is
>> unable
>> >> to. There is no firewall running on this machine either.
>> >
>> > check out the mysql config file. skip-networking or an option like this
>> > and
>> > comment
>> >
>> >>
>> >> Piotr Swiecicki wrote:
>> >> > On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
>> >> >> Hello Piotr, thank you for responding so quickly.
>> >> >>
>> >> >> I have downloaded the JDBC drive for MySQL, but I am not sure if I
>> >> have
>> >> >> installed it correctly.
>> >> >>
>> >> >> I have copied the mysql-connector-java-5.0.6-bin.jar file to the
>> >> >> /lib/ext directory, but I now see the following error message
>> repeated
>> >> >> in the output
>> >> >> file:
>> >> >>
>> >> >> com.mysql.jdbc.CommunicationsException: Communications link failure
>> >> due
>> >> >> to
>> >> >> underlying exception:
>> >> >
>> >> > It depends what the underlying exception says. Without those
>> details
>> >> > I can only guess that the database is not authenticating your
>> >> > connection. Are the username, password and database name
>> correct? Is
>> >> > your host allowed to contact the database you are connecting to?
>> >> >
>> >> > --
>> >> > Piotr Swiecicki
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> > --
>> > André Pfeiler
>> >
>> > The e-Spirit Company GmbH
>> > Barcelonaweg 14
>> > D-44269 Dortmund
>> > http://www.FIRSTspirit.de
>> >
>> > fax: +49 231 28661-59
>> > e-mail: pfeiler@e-Spirit.de
>> >
>> > Geschäftsführer:
>> > Jörn Bodemann, Michael Kenfenheuer
>> > Amtsgericht Dortmund (HRB 13961)
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11712100
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
>
--
View this message in context: http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11743832
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JMeter problems when connecting to a MySQL database
Posted by Tracy Zhu <tr...@gmail.com>.
In my experience, you should put the .jar file under lib/ folder.
On 7/21/07, dloscalzo <dl...@isminc.com> wrote:
>
>
> OK. I modified the 'my.cnf' file, restarted the mysql daemon and made
> sure
> that it was listening on the local address. The port now shows as being
> open when I scan the machine.
>
> Jmeter still seems to have trouble connecting as it's still hanging after
> the test is started and logging nothing to the output file other than the
> column headers.
>
>
> André Pfeiler wrote:
> >
> > On Friday 20 July 2007 17:25, dloscalzo wrote:
> >> After reading the Jmeter user manual page closely, I changed the
> database
> >> URL to the following:
> >>
> >> jdbc:mysql://<serveraddress>/<databasename>
> >>
> >> I scanned the machine and port 3306 is not open. Is this a possible
> >> cause
> >> of the issue?
> >>
> >> The log file only writes headers, but Jmeter hangs when the test is run
> >> and
> >> nothing happens until I stop the job. I'm assuming that it is now
> >> attempting to communicate with the database on the machine, but is
> unable
> >> to. There is no firewall running on this machine either.
> >
> > check out the mysql config file. skip-networking or an option like this
> > and
> > comment
> >
> >>
> >> Piotr Swiecicki wrote:
> >> > On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
> >> >> Hello Piotr, thank you for responding so quickly.
> >> >>
> >> >> I have downloaded the JDBC drive for MySQL, but I am not sure if I
> >> have
> >> >> installed it correctly.
> >> >>
> >> >> I have copied the mysql-connector-java-5.0.6-bin.jar file to the
> >> >> /lib/ext directory, but I now see the following error message
> repeated
> >> >> in the output
> >> >> file:
> >> >>
> >> >> com.mysql.jdbc.CommunicationsException: Communications link failure
> >> due
> >> >> to
> >> >> underlying exception:
> >> >
> >> > It depends what the underlying exception says. Without those details
> >> > I can only guess that the database is not authenticating your
> >> > connection. Are the username, password and database name
> correct? Is
> >> > your host allowed to contact the database you are connecting to?
> >> >
> >> > --
> >> > Piotr Swiecicki
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> > --
> > André Pfeiler
> >
> > The e-Spirit Company GmbH
> > Barcelonaweg 14
> > D-44269 Dortmund
> > http://www.FIRSTspirit.de
> >
> > fax: +49 231 28661-59
> > e-mail: pfeiler@e-Spirit.de
> >
> > Geschäftsführer:
> > Jörn Bodemann, Michael Kenfenheuer
> > Amtsgericht Dortmund (HRB 13961)
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11712100
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
Return a data!
Posted by TM...@etq.com.
Hello,
can any one tell whether we can use jmeter to return a data (value for
certain parameter) from a requested page and use it in another http
request.
thanks,
Thaer.
Re: JMeter problems when connecting to a MySQL database
Posted by dloscalzo <dl...@isminc.com>.
OK. I modified the 'my.cnf' file, restarted the mysql daemon and made sure
that it was listening on the local address. The port now shows as being
open when I scan the machine.
Jmeter still seems to have trouble connecting as it's still hanging after
the test is started and logging nothing to the output file other than the
column headers.
André Pfeiler wrote:
>
> On Friday 20 July 2007 17:25, dloscalzo wrote:
>> After reading the Jmeter user manual page closely, I changed the database
>> URL to the following:
>>
>> jdbc:mysql://<serveraddress>/<databasename>
>>
>> I scanned the machine and port 3306 is not open. Is this a possible
>> cause
>> of the issue?
>>
>> The log file only writes headers, but Jmeter hangs when the test is run
>> and
>> nothing happens until I stop the job. I'm assuming that it is now
>> attempting to communicate with the database on the machine, but is unable
>> to. There is no firewall running on this machine either.
>
> check out the mysql config file. skip-networking or an option like this
> and
> comment
>
>>
>> Piotr Swiecicki wrote:
>> > On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
>> >> Hello Piotr, thank you for responding so quickly.
>> >>
>> >> I have downloaded the JDBC drive for MySQL, but I am not sure if I
>> have
>> >> installed it correctly.
>> >>
>> >> I have copied the mysql-connector-java-5.0.6-bin.jar file to the
>> >> /lib/ext directory, but I now see the following error message repeated
>> >> in the output
>> >> file:
>> >>
>> >> com.mysql.jdbc.CommunicationsException: Communications link failure
>> due
>> >> to
>> >> underlying exception:
>> >
>> > It depends what the underlying exception says. Without those details
>> > I can only guess that the database is not authenticating your
>> > connection. Are the username, password and database name correct? Is
>> > your host allowed to contact the database you are connecting to?
>> >
>> > --
>> > Piotr Swiecicki
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
> --
> André Pfeiler
>
> The e-Spirit Company GmbH
> Barcelonaweg 14
> D-44269 Dortmund
> http://www.FIRSTspirit.de
>
> fax: +49 231 28661-59
> e-mail: pfeiler@e-Spirit.de
>
> Geschäftsführer:
> Jörn Bodemann, Michael Kenfenheuer
> Amtsgericht Dortmund (HRB 13961)
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11712100
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JMeter problems when connecting to a MySQL database
Posted by André Pfeiler <pf...@e-spirit.de>.
On Friday 20 July 2007 17:25, dloscalzo wrote:
> After reading the Jmeter user manual page closely, I changed the database
> URL to the following:
>
> jdbc:mysql://<serveraddress>/<databasename>
>
> I scanned the machine and port 3306 is not open. Is this a possible cause
> of the issue?
>
> The log file only writes headers, but Jmeter hangs when the test is run and
> nothing happens until I stop the job. I'm assuming that it is now
> attempting to communicate with the database on the machine, but is unable
> to. There is no firewall running on this machine either.
check out the mysql config file. skip-networking or an option like this and
comment
>
> Piotr Swiecicki wrote:
> > On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
> >> Hello Piotr, thank you for responding so quickly.
> >>
> >> I have downloaded the JDBC drive for MySQL, but I am not sure if I have
> >> installed it correctly.
> >>
> >> I have copied the mysql-connector-java-5.0.6-bin.jar file to the
> >> /lib/ext directory, but I now see the following error message repeated
> >> in the output
> >> file:
> >>
> >> com.mysql.jdbc.CommunicationsException: Communications link failure due
> >> to
> >> underlying exception:
> >
> > It depends what the underlying exception says. Without those details
> > I can only guess that the database is not authenticating your
> > connection. Are the username, password and database name correct? Is
> > your host allowed to contact the database you are connecting to?
> >
> > --
> > Piotr Swiecicki
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
--
André Pfeiler
The e-Spirit Company GmbH
Barcelonaweg 14
D-44269 Dortmund
http://www.FIRSTspirit.de
fax: +49 231 28661-59
e-mail: pfeiler@e-Spirit.de
Geschäftsführer:
Jörn Bodemann, Michael Kenfenheuer
Amtsgericht Dortmund (HRB 13961)
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JMeter problems when connecting to a MySQL database
Posted by dloscalzo <dl...@isminc.com>.
After reading the Jmeter user manual page closely, I changed the database URL
to the following:
jdbc:mysql://<serveraddress>/<databasename>
I scanned the machine and port 3306 is not open. Is this a possible cause
of the issue?
The log file only writes headers, but Jmeter hangs when the test is run and
nothing happens until I stop the job. I'm assuming that it is now
attempting to communicate with the database on the machine, but is unable
to. There is no firewall running on this machine either.
Piotr Swiecicki wrote:
>
> On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
>>
>> Hello Piotr, thank you for responding so quickly.
>>
>> I have downloaded the JDBC drive for MySQL, but I am not sure if I have
>> installed it correctly.
>>
>> I have copied the mysql-connector-java-5.0.6-bin.jar file to the /lib/ext
>> directory, but I now see the following error message repeated in the
>> output
>> file:
>>
>> com.mysql.jdbc.CommunicationsException: Communications link failure due
>> to
>> underlying exception:
>
> It depends what the underlying exception says. Without those details
> I can only guess that the database is not authenticating your
> connection. Are the username, password and database name correct? Is
> your host allowed to contact the database you are connecting to?
>
> --
> Piotr Swiecicki
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11710231
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JMeter problems when connecting to a MySQL database
Posted by Piotr Swiecicki <sw...@gmail.com>.
On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
>
> Hello Piotr, thank you for responding so quickly.
>
> I have downloaded the JDBC drive for MySQL, but I am not sure if I have
> installed it correctly.
>
> I have copied the mysql-connector-java-5.0.6-bin.jar file to the /lib/ext
> directory, but I now see the following error message repeated in the output
> file:
>
> com.mysql.jdbc.CommunicationsException: Communications link failure due to
> underlying exception:
It depends what the underlying exception says. Without those details
I can only guess that the database is not authenticating your
connection. Are the username, password and database name correct? Is
your host allowed to contact the database you are connecting to?
--
Piotr Swiecicki
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JMeter problems when connecting to a MySQL database
Posted by dloscalzo <dl...@isminc.com>.
Hello Piotr, thank you for responding so quickly.
I have downloaded the JDBC drive for MySQL, but I am not sure if I have
installed it correctly.
I have copied the mysql-connector-java-5.0.6-bin.jar file to the /lib/ext
directory, but I now see the following error message repeated in the output
file:
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
What have I done wrong?
Piotr Swiecicki wrote:
>
> On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
>>
>> I am attempting to test out a MySQL database using Apache Jmeter. When I
>> do
>> so, Jmeter logs the following error message to a file:
>>
>> java.sql.SQLException: No suitable driver
>
>
> Download a MySQL connector from here:
> http://www.mysql.com/products/connector/
> and install downloaded jar library under lib/ext/ directory of your
> jmeter installation.
> HTH, cheers
>
> --
> Piotr Swiecicki
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JMeter-problems-when-connecting-to-a-MySQL-database-tf4116479.html#a11708613
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JMeter problems when connecting to a MySQL database
Posted by Piotr Swiecicki <sw...@gmail.com>.
On 7/20/07, dloscalzo <dl...@isminc.com> wrote:
>
> I am attempting to test out a MySQL database using Apache Jmeter. When I do
> so, Jmeter logs the following error message to a file:
>
> java.sql.SQLException: No suitable driver
Download a MySQL connector from here:
http://www.mysql.com/products/connector/
and install downloaded jar library under lib/ext/ directory of your
jmeter installation.
HTH, cheers
--
Piotr Swiecicki
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org