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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >> >> > For additional commands, e-mail: [EMAIL PROTECTED] >> > >> > -- >> > André Pfeiler >> > >> > The e-Spirit Company GmbH >> > Barcelonaweg 14 >> > D-44269 Dortmund >> > http://www.FIRSTspirit.de >> > >> > fax: +49 231 28661-59 >> > e-mail: [EMAIL PROTECTED] >> > >> > Geschäftsführer: >> > Jörn Bodemann, Michael Kenfenheuer >> > Amtsgericht Dortmund (HRB 13961) >> > >> > --------------------------------------------------------------------- >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> > For additional commands, e-mail: [EMAIL PROTECTED] >> > >> > >> > >> >> -- >> 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: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
