jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From keerat <kee...@gmail.com>
Subject Re: JMeter problems when connecting to a MySQL database
Date Mon, 23 Jul 2007 13:51:54 GMT
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 <dloscalzo@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 <dloscalzo@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 <dloscalzo@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message