Connect to Microsoft Sharepoint

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

Connect to Microsoft Sharepoint

Campbell. Rory (LIT)
Hi,

When I attempt to connect to Microsoft sharepoint online through JMeter I get a Connection timed out response

I can access the site manually through the browser ok

Any suggestions?

Thanks,

Rory Campbell
Senior Software Engineer in Test
Liberty Information Technology  |  USCM - Claims
Internal: 69277  |  External: +44(0)2890 445277

Reply | Threaded
Open this post in threaded view
|

Re: Connect to Microsoft Sharepoint

Bob Nance
Sorry if this answer is simplistic; the range of experience from people on this list is everything from “what’s a server” to “I am writing my own plugin.”

When you made the connection through the recorder, do you see some session ID information passing through that you didn’t generate? It’s possible that, unless that unique session ID is being sent back to the SharePoint server, it is simply not responding at all in an attempt to protect the site from XSS and other attacks.

If this is the case, you will need to capture the transaction value and then deliver the information back to the server that is dynamically generated for each session. 

This is very common with server security.


---
  Bob Nance
  Novation Systems
  256-534-4620


On Sep 5, 2017, at 10:20 AM, Campbell. Rory (LIT) <[hidden email]> wrote:

Hi,

When I attempt to connect to Microsoft sharepoint online through JMeter I get a Connection timed out response

I can access the site manually through the browser ok

Any suggestions?

Thanks,

Rory Campbell
Senior Software Engineer in Test
Liberty Information Technology  |  USCM - Claims
Internal: 69277  |  External: +44(0)2890 445277


Reply | Threaded
Open this post in threaded view
|

RE: Connect to Microsoft Sharepoint

Campbell. Rory (LIT)
Thanks Bob for your response. Yes it captures cookie information but would those session id’s not be different every time I run the test? Not sure how I can get the session information to put in the request so it will work

Thanks

From: Bob Nance [mailto:[hidden email]]
Sent: Tuesday, September 05, 2017 04:28 PM
To: JMeter Users List <[hidden email]>
Subject: Re: Connect to Microsoft Sharepoint

Sorry if this answer is simplistic; the range of experience from people on this list is everything from “what’s a server” to “I am writing my own plugin.”

When you made the connection through the recorder, do you see some session ID information passing through that you didn’t generate? It’s possible that, unless that unique session ID is being sent back to the SharePoint server, it is simply not responding at all in an attempt to protect the site from XSS and other attacks.

If this is the case, you will need to capture the transaction value and then deliver the information back to the server that is dynamically generated for each session.

This is very common with server security.


---
  Bob Nance
  Novation Systems
  [hidden email]<mailto:[hidden email]>
  256-534-4620

[cid:[hidden email]]

On Sep 5, 2017, at 10:20 AM, Campbell. Rory (LIT) <[hidden email]<mailto:[hidden email]>> wrote:

Hi,

When I attempt to connect to Microsoft sharepoint online through JMeter I get a Connection timed out response

I can access the site manually through the browser ok

Any suggestions?

Thanks,

Rory Campbell
Senior Software Engineer in Test
Liberty Information Technology  |  USCM - Claims
Internal: 69277  |  External: +44(0)2890 445277

Reply | Threaded
Open this post in threaded view
|

Re: Connect to Microsoft Sharepoint

Bob Nance
Record it several times and see if you can find a variable being sent back from the browser that you don’t recognize. It may take some sleuthing. Somewhere in the initial response from the SharePoint server to the first GET, you’ll probably see what looks like a throwaway value that you’ll find in subsequent responses from your browser. That’s the one you need to pull in by REGEX or other variable extraction and then store as a variable to send back.

---
  Bob Nance
  Novation Systems
  256-534-4620


On Sep 5, 2017, at 10:53 AM, Campbell. Rory (LIT) <[hidden email]> wrote:

Thanks Bob for your response. Yes it captures cookie information but would those session id’s not be different every time I run the test? Not sure how I can get the session information to put in the request so it will work

Thanks

From: Bob Nance [[hidden email]]
Sent: Tuesday, September 05, 2017 04:28 PM
To: JMeter Users List <[hidden email]>
Subject: Re: Connect to Microsoft Sharepoint

Sorry if this answer is simplistic; the range of experience from people on this list is everything from “what’s a server” to “I am writing my own plugin.”

When you made the connection through the recorder, do you see some session ID information passing through that you didn’t generate? It’s possible that, unless that unique session ID is being sent back to the SharePoint server, it is simply not responding at all in an attempt to protect the site from XSS and other attacks.

If this is the case, you will need to capture the transaction value and then deliver the information back to the server that is dynamically generated for each session.

This is very common with server security.


---
 Bob Nance
 Novation Systems
 [hidden email]<[hidden email]>
 256-534-4620

[<a href="cid:0243C145-BB67-491C-8049-0274AF59D029@nances.us" style="font-family: Menlo-Regular; font-size: 11px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">cid:0243C145-BB67-491C-8049-0274AF59D029@...]

On Sep 5, 2017, at 10:20 AM, Campbell. Rory (LIT) <[hidden email]<[hidden email]>> wrote:

Hi,

When I attempt to connect to Microsoft sharepoint online through JMeter I get a Connection timed out response

I can access the site manually through the browser ok

Any suggestions?

Thanks,

Rory Campbell
Senior Software Engineer in Test
Liberty Information Technology  |  USCM - Claims
Internal: 69277  |  External: +44(0)2890 445277

Reply | Threaded
Open this post in threaded view
|

RE: Connect to Microsoft Sharepoint

Campbell. Rory (LIT)
Ok will give that a go

Thanks for your quick replies Bob

From: Bob Nance [mailto:[hidden email]]
Sent: Tuesday, September 05, 2017 04:56 PM
To: JMeter Users List <[hidden email]>
Subject: Re: Connect to Microsoft Sharepoint

Record it several times and see if you can find a variable being sent back from the browser that you don’t recognize. It may take some sleuthing. Somewhere in the initial response from the SharePoint server to the first GET, you’ll probably see what looks like a throwaway value that you’ll find in subsequent responses from your browser. That’s the one you need to pull in by REGEX or other variable extraction and then store as a variable to send back.

---
  Bob Nance
  Novation Systems
  [hidden email]<mailto:[hidden email]>
  256-534-4620

[cid:[hidden email]]

On Sep 5, 2017, at 10:53 AM, Campbell. Rory (LIT) <[hidden email]<mailto:[hidden email]>> wrote:

Thanks Bob for your response. Yes it captures cookie information but would those session id’s not be different every time I run the test? Not sure how I can get the session information to put in the request so it will work

Thanks

From: Bob Nance [mailto:[hidden email]]
Sent: Tuesday, September 05, 2017 04:28 PM
To: JMeter Users List <[hidden email]<mailto:[hidden email]>>
Subject: Re: Connect to Microsoft Sharepoint

Sorry if this answer is simplistic; the range of experience from people on this list is everything from “what’s a server” to “I am writing my own plugin.”

When you made the connection through the recorder, do you see some session ID information passing through that you didn’t generate? It’s possible that, unless that unique session ID is being sent back to the SharePoint server, it is simply not responding at all in an attempt to protect the site from XSS and other attacks.

If this is the case, you will need to capture the transaction value and then deliver the information back to the server that is dynamically generated for each session.

This is very common with server security.


---
 Bob Nance
 Novation Systems
 [hidden email]<mailto:[hidden email]><mailto:[hidden email]>
 256-534-4620

[cid:[hidden email]]

On Sep 5, 2017, at 10:20 AM, Campbell. Rory (LIT) <[hidden email]<mailto:[hidden email]><mailto:[hidden email]>> wrote:

Hi,

When I attempt to connect to Microsoft sharepoint online through JMeter I get a Connection timed out response

I can access the site manually through the browser ok

Any suggestions?

Thanks,

Rory Campbell
Senior Software Engineer in Test
Liberty Information Technology  |  USCM - Claims
Internal: 69277  |  External: +44(0)2890 445277

Reply | Threaded
Open this post in threaded view
|

RE: Connect to Microsoft Sharepoint

Campbell. Rory (LIT)
In reply to this post by Bob Nance
Hey,

So I have a JMeter test created and the final step consists of 1 request which checks if a document has been uploaded to a site. I have this request contained in a While Controller which checks the response and stops once the response shows that the document has been uploaded. So this step could loop several times.
I then run this test in Jenkins and add load to it (say 10 users with a loop count of 10).
However when I view the results the request response times are all listed together and I can’t differentiate between the responses that showed the document as not uploaded yet and the responses that confirm the document has been uploaded.
Any ideas how I can separate each thread result in Jenkins rather than showing all the response times for all the threads in a long list? Then I would be able to see how long it took for the document to get uploaded for each thread

Thanks

From: Campbell. Rory (LIT)
Sent: Tuesday, September 05, 2017 04:58 PM
To: JMeter Users List <[hidden email]>
Subject: RE: Connect to Microsoft Sharepoint

Ok will give that a go

Thanks for your quick replies Bob

From: Bob Nance [mailto:[hidden email]]
Sent: Tuesday, September 05, 2017 04:56 PM
To: JMeter Users List <[hidden email]<mailto:[hidden email]>>
Subject: Re: Connect to Microsoft Sharepoint

Record it several times and see if you can find a variable being sent back from the browser that you don’t recognize. It may take some sleuthing. Somewhere in the initial response from the SharePoint server to the first GET, you’ll probably see what looks like a throwaway value that you’ll find in subsequent responses from your browser. That’s the one you need to pull in by REGEX or other variable extraction and then store as a variable to send back.

---
  Bob Nance
  Novation Systems
  [hidden email]<mailto:[hidden email]>
  256-534-4620

[cid:[hidden email]]

On Sep 5, 2017, at 10:53 AM, Campbell. Rory (LIT) <[hidden email]<mailto:[hidden email]>> wrote:

Thanks Bob for your response. Yes it captures cookie information but would those session id’s not be different every time I run the test? Not sure how I can get the session information to put in the request so it will work

Thanks

From: Bob Nance [mailto:[hidden email]]
Sent: Tuesday, September 05, 2017 04:28 PM
To: JMeter Users List <[hidden email]<mailto:[hidden email]>>
Subject: Re: Connect to Microsoft Sharepoint

Sorry if this answer is simplistic; the range of experience from people on this list is everything from “what’s a server” to “I am writing my own plugin.”

When you made the connection through the recorder, do you see some session ID information passing through that you didn’t generate? It’s possible that, unless that unique session ID is being sent back to the SharePoint server, it is simply not responding at all in an attempt to protect the site from XSS and other attacks.

If this is the case, you will need to capture the transaction value and then deliver the information back to the server that is dynamically generated for each session.

This is very common with server security.


---
 Bob Nance
 Novation Systems
 [hidden email]<mailto:[hidden email]><mailto:[hidden email]>
 256-534-4620

[cid:[hidden email]]

On Sep 5, 2017, at 10:20 AM, Campbell. Rory (LIT) <[hidden email]<mailto:[hidden email]><mailto:[hidden email]>> wrote:

Hi,

When I attempt to connect to Microsoft sharepoint online through JMeter I get a Connection timed out response

I can access the site manually through the browser ok

Any suggestions?

Thanks,

Rory Campbell
Senior Software Engineer in Test
Liberty Information Technology  |  USCM - Claims
Internal: 69277  |  External: +44(0)2890 445277

ZK
Reply | Threaded
Open this post in threaded view
|

RE: Connect to Microsoft Sharepoint

ZK
Hi,
1 option would be to add:
${__threadNum}

to the Request Sampler Name for the sampler contained in the While condition
loop

<http://www.jmeter-archive.org/file/t254617/Capture.jpg>




ZK



--
Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

RE: Connect to Microsoft Sharepoint

Campbell. Rory (LIT)
Thanks,

That's improved the reporting and shows the requests for each thread. How can I narrow that down even more to show each loop for each thread? Is there a property I can add to the name that gets the loop number too?

-----Original Message-----
From: ZK [mailto:[hidden email]]
Sent: Thursday, September 14, 2017 09:48 AM
To: [hidden email]
Subject: RE: Connect to Microsoft Sharepoint

Hi,
1 option would be to add:
${__threadNum}

to the Request Sampler Name for the sampler contained in the While condition loop

<http://www.jmeter-archive.org/file/t254617/Capture.jpg>




ZK



--
Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

ZK
Reply | Threaded
Open this post in threaded view
|

RE: Connect to Microsoft Sharepoint

ZK
This post was updated on .
Hi,
you could add a 'Counter' config element inside your while controller

+While Controller
++Counter
++Request checking file has been uploaded


To configure the Counter config element:
start = 1
increment = 1
Reference Name = loopCounter
Track counter independently for each user = checked
Reset counter on each Thread Group Iteration = checked

Then as mentioned in my previous reply, the Request Sampler Name for the
sampler contained in the While condition could be some thing like:
HTTP Request - wait for file to be uploaded -  Thread number =
${__threadNum} - Loop Number = ${loopCounter}


ZK






--
Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org

Reply | Threaded
Open this post in threaded view
|

RE: Connect to Microsoft Sharepoint

Campbell. Rory (LIT)
Thanks! And 1 last question. Is there a way I can add all the response times together for a request used in a while controller?

The request loops until I get an expected response back but I want to know how long in total it took for that expected response to be returned

-----Original Message-----
From: ZK [mailto:[hidden email]]
Sent: Thursday, September 14, 2017 10:52 AM
To: [hidden email]
Subject: RE: Connect to Microsoft Sharepoint

Hi,
you could add a 'Counter' config element inside your while controller

+While Controller
++Counter
++Request checking file has been uploaded


To configure the Counter config element:
start = 1
increment = 1
Reference Name = loopCounter
Track counter independently for each user = checked

Then as mentioned in my previous reply, the Request Sampler Name for the sampler contained in the While condition could be some thing like:
HTTP Request - wait for file to be uploaded -  Thread number = ${__threadNum} - Loop Number = ${loopCounter}


ZK






--
Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

ZK
Reply | Threaded
Open this post in threaded view
|

RE: Connect to Microsoft Sharepoint

ZK
Hi,

One option would be (I am not a programmer):

Add a 'User Defined Variables' (Add>Config Element>User Defined Variables)
to your thread Group with the variable:
name = responseTime
value = 0

Add a JSR223 PostProcessor (Add>Post Processor>JSR223 PostProcessor) as a
child of the request that is looping
Set the language of this PostProcessor to 'java' and use the following
script:

overallTime = Long.parseLong(vars.get("responseTime"));
long currentResponseTime=prev.getTime();
totalTime = overallTime + currentResponseTime;
vars.put("responseTime", ""+totalTime);

You should remove the values mentioned in my previous posts from the Name
field in the 'Request checking file has been uploaded '

After the While Controller add a 'Debug Sampler' with this in the name
field:
ThreadNum = ${__threadNum} - Loop Number = ${loopCounter} -
OverallResponseTime = ${responseTime}


So your test plan would look something like this:

Test Plan
+Thread Group
++User Defined Variables
++While Controller
+++Counter
+++Request checking file has been uploaded
++++JSR223 PostProcessor
++Debug Sampler


let me know how it goes

ZK





--
Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

RE: Connect to Microsoft Sharepoint

Felix Schumacher
In reply to this post by Campbell. Rory (LIT)


Am 14. September 2017 13:39:40 MESZ schrieb "Campbell. Rory (LIT)" <[hidden email]>:
>Thanks! And 1 last question. Is there a way I can add all the response
>times together for a request used in a while controller?

You might want to have a look at http://jmeter.apache.org/usermanual/component_reference.html#Transaction_Controller

Regards,
Felix

>
>The request loops until I get an expected response back but I want to
>know how long in total it took for that expected response to be
>returned
>
>-----Original Message-----
>From: ZK [mailto:[hidden email]]
>Sent: Thursday, September 14, 2017 10:52 AM
>To: [hidden email]
>Subject: RE: Connect to Microsoft Sharepoint
>
>Hi,
>you could add a 'Counter' config element inside your while controller
>
>+While Controller
>++Counter
>++Request checking file has been uploaded
>
>
>To configure the Counter config element:
>start = 1
>increment = 1
>Reference Name = loopCounter
>Track counter independently for each user = checked
>
>Then as mentioned in my previous reply, the Request Sampler Name for
>the sampler contained in the While condition could be some thing like:
>HTTP Request - wait for file to be uploaded -  Thread number =
>${__threadNum} - Loop Number = ${loopCounter}
>
>
>ZK
>
>
>
>
>
>
>--
>Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [hidden email]
>For additional commands, e-mail: [hidden email]
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [hidden email]
>For additional commands, e-mail: [hidden email]

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]