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]
