CVS Dataset Config Usage?
Hi, i am experimenting with the csv dataset config but it seems like i do not quite understand its inner workings. What i am trying to achieve is the following: - keep a file of usernames, passwords and other config for users around which is always 100 lines long. - for testing a new jmeter script i would like use different settings for threads and repeat (eg. 2 threads, 10 repeats) I thought that jmeter reads the cvs file at the beginning of the testcase, assigns values to the different threads (=users) and thats it. But that does not work. With 1 thread and 10 repeats the second repeat of the test gets the config for user 2 (=line 2 of csv file). So it seems like the file is read in every iteration. How is the csv config thought to be used? Do i have to exactly match the lines in the file to the number of threads i want to use? What if one of the threads gets an error and is stopped? Will not the correlation between thread csv config will be mixed up? Kind regards, peter - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JMeter problems when connecting to a MySQL database
On 7/20/07, dloscalzo [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JMeter problems when connecting to a MySQL database
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 [EMAIL PROTECTED] 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: [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#a11708613 Sent from the JMeter - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Jmeter Plugin
Thanks for the answer. But I can't find this topic from the tutorial, I just see the following from the tutorial: Distributed Testing Recording Tests JUnit Sampler Access Log Sampler None of them contain the information for this topic. Please let me know the URL for the tutorial. Thanks, Tiffany Peter Lin wrote: either way should work. there's a link to a tutorial on jmeter's home page towards the bottom. peter On 7/19/07, tiffany [EMAIL PROTECTED] wrote: Hi, I am developing a Jmeter Plugin, I have the following question: Do I have to build Jmeter with the Plugin code, use ant all command to build all components and protocols? OR Can I compile this Plugin against Jmeter and then generate a jar file from this Plugin class. Put back this jar file to the Jmeter library and then execute Jmeter. Thanks, Tiffany -- View this message in context: http://www.nabble.com/Jmeter-Plugin-tf4112765.html#a11694609 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-Plugin-tf4112765.html#a11708840 Sent from the JMeter - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JMeter problems when connecting to a MySQL database
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]
Re: Jmeter Plugin
sorry about that. looks like the link isn't on the homepage. here is the link http://svn.apache.org/viewvc/jakarta/jmeter/branches/rel-2-2/xdocs/extending/jmeter_tutorial.pdf?view=log peter On 7/20/07, tiffany [EMAIL PROTECTED] wrote: Thanks for the answer. But I can't find this topic from the tutorial, I just see the following from the tutorial: Distributed Testing Recording Tests JUnit Sampler Access Log Sampler None of them contain the information for this topic. Please let me know the URL for the tutorial. Thanks, Tiffany Peter Lin wrote: either way should work. there's a link to a tutorial on jmeter's home page towards the bottom. peter On 7/19/07, tiffany [EMAIL PROTECTED] wrote: Hi, I am developing a Jmeter Plugin, I have the following question: Do I have to build Jmeter with the Plugin code, use ant all command to build all components and protocols? OR Can I compile this Plugin against Jmeter and then generate a jar file from this Plugin class. Put back this jar file to the Jmeter library and then execute Jmeter. Thanks, Tiffany -- View this message in context: http://www.nabble.com/Jmeter-Plugin-tf4112765.html#a11694609 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-Plugin-tf4112765.html#a11708840 Sent from the JMeter - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JMeter problems when connecting to a MySQL database
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]
RE: Can't adjust characters per second
Hi Sebb- Is there a library that I need to load to get access to the httpclient.socket.http.cps related methods? If so, how would I do that? If not, then why do I get a null pointer exception every time I enable this feature with Jmeter 2.2 and 2.3? Is the bandwidth constraint applied on a per thread basis, or across all the threads cumulatively? Thanks, Alan -Original Message- From: Christensen, Alan Sent: Wednesday, July 18, 2007 11:48 AM To: JMeter Users List Subject: Can't adjust characters per second I tried using the characters/second setting in the jmeter.properties file. My recollection is that this only works with the commons HTTP client. Is that correct? When I set cps to 1 cps using the following statements in jmeter.properties httpclient.socket.http.cps=1 httpclient.socket.https.cps=1 then I get a null pointer exception for every http request that I make using the HTTP Request HTTPClient sampler. From jmeter.log: ERROR - jmeter.threads.JMeterThread: java.lang.NullPointerException at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:72 0) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMe thodDirector.java:386) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMetho dDirector.java:170) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:3 96) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:3 24) at org.apache.jmeter.protocol.http.sampler.HTTPSampler2.sample(HTTPSampler2 .java:527) at org.apache.jmeter.protocol.http.sampler.HTTPSamplerBase.sample(HTTPSampl erBase.java:658) at org.apache.jmeter.protocol.http.sampler.HTTPSamplerBase.sample(HTTPSampl erBase.java:647) at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:247) at java.lang.Thread.run(Unknown Source) The HTTP Request HTTPClient works fine when the lines above are commented out. I am running jmeter 2.1. Is this bug fixed in 2.3? I also have a question about when jmeter reads the jmeter.properties file. I am assuming that jmeter only reads this file when it is first started. Is this correct? Thanks, Alan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JMeter problems when connecting to a MySQL database
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]