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 <[EMAIL PROTECTED]> 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 <[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] >> >> > > > -- > 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
