certificate authority – TCP Window with large SSL Packets. Distinguished Names Length 10kb

We are troubleshooting network latency related to SSL Handshake. This doesn’t necessarily cause the delay every time but in some cases, Server take 5-10 seconds just to start sending first SSL packet after Acknowledging Client Hello packet. Attached are snapshot of both Client and Server side captures taken at respective application servers. Please see notes and queries below.

Appreciate your help.

  1. Captures taken at both Client and Server side which are in different location having router and firewalls on the path.
  2. SSL Handshake type is set to ‘Optional’ at Tomcat 8.x on Windows 2016.
  3. Client is a Linux Server.
  4. Client TCP Window is 5840 and Server TCP Window is 8192
  5. Client to Server, DF (Don’t Fragment) bit is set to 0
  6. Server to Client, DF (Don’t Fragment) bit is set to 1
  7. Server’s SSL Segments (Server Hello, Certificate Chain, Server Key, and Certificate Request) is of total 15456 bytes.
  8. Out of 15456 bytes, lass SSL Segment of Certificate Request contains ‘Distinguished Names’ packet length of 10912 bytes. This packet has list of about 90 Trust Stores in it.
  9. Server’s SSL Segments is broken into 12 packets (111330 bytes + 1851 bytes) and they are all pushed in one go from Server without waiting for any ACK from Client.
  10. Server returns Client Hello ACK and that is received immediately at Client side.
  11. For some reason Server is seeing DUP-ACK of Client Hello from Client Side. At Client Side captures, we do not see this DUP-ACK going out to Server. This is happening 5 times in the TCP session. Server does Fast Re-transmit Client Hello ACK.
  12. This Re-transmit of Client Hello ACK is not seen at Client who sees first SSL Packet at 0.94th second (After above Re transmit of Client Hello) and starts sending ACK of these 12 SSL Packets as it received.
  13. At Server ACKs are seen but the Server which is getting ACKs one-by-one, see that it only got ACK of 5th out of 12th packet. This result Server re-transmit of SSL packets from 6th to 12th.
  14. At Client, it sees re-transmitted SSL Packets (as it arrived first time). It doesn’t see original SSL packet 6th to 12th which was previously sent to Client in One-Go.

Questions:

  1. How server is able to send SSL packets of 15456 bytes at one go which is more than TCP Window of 8192 bytes?

    1. Why Server is seeing DUP-ACK of Client Hello from Client Side multiple times but at Client captures we see these DUP-ACKs are not sent?

    2. Why Tomcat Server is sending list of CAs in ‘Distinguished Name’ for ‘Certificate Request’ payload? This is having 10940 bytes length? Is this due to some Windows Registry setting?

    3. Can Server not send CAs list in ‘Certificate Request’ and yet SSL Handshake works? Server
      Certificate is not issued by 3rd party CA but Server’s own CA.

    4. How to fix this issue of SSL Handshake delay and make this TCP session efficient?

    (1):Server Side Capture Image – https://i.stack.imgur.com/rhYNu.jpg

    (2):Client Side Capture Image – https://i.stack.imgur.com/kzZnl.jpg

plugins – How to rename post names and slugs in bulk?

I have nearly more than 10000 posts in my WordPress site. Now, I want to add(concatenate) a text to all my posts’ names & URLs under a certain category alone. How to do this task in an easy way? Manually work seems very time-consuming.

It is now, before renaming: Post name:152, slug: https://example.com/152
After renaming it should be: Post name:text-152, slug: https://example.com/text-152

Are high value domain names renewed at the same cost as a regular domain?

An organization called ICANN (The Internet Corporation for Assigned Names and Numbers) contracts with registries to manage the registration of top level domains (TLDs). In the case of .com, Verisign is the company who manages that TLD. Verisign then works with registrars to resell .com domain names. ICANN places limits on how much Verisign and registrars can charge for the registration of a domain.

So, for Google, who is a registrar, the price to register their domain is the same as any .com domain. The fact that it is “valuable” plays no part in its registration price.

So why do some domains sell for millions of dollars? These domains are resold and are not part of the ICANN controlled registration process. In fact, it is just a domain transfer with the same registration fees charged as any domain transfer with the millions of dollars occurring as a separate business transaction.

function construction – What is a more expedient way to assign variable names to individual elements in a list?

There is a set of one-dimensional descriptive statistics that I need so often that instead of copying and pasting calculations each time I created a function (generateStatsX(...)) that returns all values in a single list into a second function (statisticalAnalysis(...)). But now I am left having to reassign a name (a variable) to each value so I could use them in further calculations. The code below works but I feel it could be done more expediently within function statisticalAnalysis(...). Is there better way to code this? Please note that I am looking for a solution that does not pollute the Global space.

generateStatsX(raw_, bias_ : Infinity, declen_ : 2) := 
 Block({len, n, range, midrange, (Mu), median, mode, (Sigma)avg, 
   rms, (Sigma)2, (Sigma), Em, Es, skew, kurt, mean},
  {len = Length(raw),(* true length of raw data *)
   n = If(len <= bias, len - 1, len, len - 1),(* 
   adjusted length removes bias in variance if n (LessEqual) 
   bias cutoff *)
   range = Max(raw) - Min(raw),
   midrange = Min(raw) + range/2,
   (Mu) = Mean(raw),
   median = Median(raw),
   mode = Commonest(raw)((1)),
   (Sigma)avg = Sum(Abs(raw((x)) - (Mu)), {x, 1, len})/len,
   rms = Sqrt(Sum((raw((x)) - (Mu))^2, {x, 1, len})/len),
   (Sigma)2 = Total((raw - (Mu))^2)/n, (* variance *)
   (Sigma) = Sqrt((Sigma)2),(* standard deviation *)
   Es = .6745 (Sigma),(* 
   error for single x with 50% of data within 1 std deviation *)
   Em = Es/Sqrt(n),(* standard error of the mean *)
   skew = Skewness(raw),
   kurt = Kurtosis(raw),
   mean = 
    ToString(NumberForm ((Mu), {Infinity, declen})) <> 
     " (PlusMinus) " <> ToString(NumberForm(Em, {Infinity, declen}))}
  )
statisticalAnalysis(raw_) := Block({stats, vars},
  stats = generateStatsX(raw);
  vars = {len = stats((1)), n = stats((2)), range = stats((3)), 
    midrange = stats((4)), (Mu) = stats((5)), median = stats((6)), 
    mode = stats((7)), (Sigma)avg = stats((8)), 
    rms = stats((9)), (Sigma)2 = stats((10)), (Sigma) = stats((11)),
     Em = stats((12)), Es = stats((13)), skew = stats((14)), 
    kurt = stats((15)), mean = stats((16))};
  Row({len, n, range}, "  |  ") (* 
  demo first 3 variables as proof of concept *)
  )
statisticalAnalysis({1.32, 1.37, 1.43, 1.32, 1.36, 1.33, 1.38, 1.35, 
  1.48, 1.28, 1.31, 1.52, 1.51, 1.33, 1.32, 1.27, 1.35, 1.40, 1.27, 
  1.39, 1.50, 1.31, 1.34, 1.48, 1.36, 1.33, 1.40, 1.29, 1.35, 1.36, 
  1.33, 1.30, 1.28, 1.32, 1.34, 1.33, 1.29, 1.34, 1.34, 1.29, 1.35, 
  1.52, 1.29, 1.38, 1.40, 1.28, 1.36, 1.36, 1.32, 1.62, 1.36, 1.34, 
  1.33, 1.33, 1.30, 1.31, 1.33, 1.32, 1.36, 1.41})

sharepoint online – PnP PeoplePicker not working on full names

Below is the PnP Peoplepicker control code that I’m using. The issue that I’m having here is with space-character within the name. Say I have valid user “Rachel Green”. If I type-in “Rachel” I get 10 different Rachel’s. So continue to type “Rachel ” or “Rachel G” or “Rachel Green”, I get no results found. Is there anyway to deal with space-char or able to search based on full name. (If I go by last name i.e Green, since I have only one colleague with Green I’m able to pick correct name).

                        <PeoplePicker
                         peoplePickerCntrlclassName=""
                         context={this.props.context}
                         titleText=""
                         personSelectionLimit={1}
                         groupName={""}
                         showtooltip={false}
                         suggestionsLimit = {10}
                         disabled={false}
                         selectedItems={this._getSelectedProfile}
                         principalTypes={(PrincipalType.User)}
                         defaultSelectedUsers={this.state.defaultUser}
                         resolveDelay={1000}
                         errorMessage={this.state.required}
                       /> 

Thank you for your time !

sharepoint online – How to get File names from a Document Library using a REST GetByTitle query and TypeScript?

I am firing this query:

_api/web/lists/GetByTitle('MyLib')/items?$select=Title,File/Name&$expand=File/Name

I am getting a bunch of files, I see the names I want when running the query in the browser:

<d:Name>INeedThisFileName.jpg</d:Name>

But they are nested in these properties:

/Items(717)/File</id><category term="SP.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /><link rel="edit" href="https://sharepoint.stackexchange.com/Web/Lists(guid"921b46e1-91cf-426d-ab11-9e59bd995f3e')/Items(717)/File" /><title /><updated>2020-05-17T22:20:03Z</updated><author><name /></author><content type="application/xml"><m:properties><d:Name>INeedThisFileName.jpg</d:Name></m:properties></content></entry></m:inline></link><title /><updated>2020-05-17T22:20:03Z</updated><author><name /></author><content type="application/xml" /></entry><entry m:etag="&quot;1&quot;"><id>526c333a-59ef-47eb-9498-12d12973290d</id><category term="SP.Data.MyLibItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /><link rel="edit" href="https://sharepoint.stackexchange.com/Web/Lists(guid"921b46e1-91cf-426d-ab11-9e59bd995f3e')/

The problem is that if I add a Name property in the ListItem interface, I get “undefined” for all files.

export interface ISPList {
  Title: string;
  Name: string
}

Problem with terraform overwriting ssl on custom host names on azur

We use terraform to configure host name bindings among others in azure. Then we have a process that periodically updates the SSL certificate. Everything works well.

The problem is that when we next make a terraform plan or apply it, it wants to change the fingerprint of the host name binding, whatever it is, to null . We do not specify the thumbprint in the terraform.

We also tried to use a custom deployment model that does not contain a digital fingerprint. In test, it works well. I can terraform apply to create it, then define the ssl certificate and when I terraform again, he does not want to make any changes. The only problem is that terraform won't let me add this to the state, so it wants to create it even if it's already there.

Google sheets – I want to 1) get unique names AND 2) delete vacancies AND 3) sort by alpha AND 4) add name, first name

I want 1) to get unique names AND 2) to delete vacancies AND 3) to sort by alpha AND 4) to add the name, the first name.

The names are in Sheet1 and the results are in Sheet2.

I use = SORT (SINGLE (Sheet1! A3: A), 1, TRUE) to do steps 1, 2 and 3, and this removes first names in Sheet2 but I don't know how to do step 4: to enter the corresponding surname in Sheet1 and add it to the corresponding given name in Sheet1 and put them in Sheet2.

Conditional Excel formatting using defined names is not transferred when copying a sheet into another workbook

I regularly create separate workbooks using conditional formatting with built-in defined names. The individual workbooks are then copied (all sheets in the workbook) to a larger multi-sheet workbook.

Until early April 2020, this process worked well. It was in early April when the conditional format rules that contained defined names were no longer transferred when the worksheets were copied to another workbook. This is true that the names defined already exist in the destination workbook or created when copying the workbooks. Once copied, I can see the names defined in the name manager, but all the conditional formats referring to a defined name have not been transferred.

Thoughts? No more MS Excel shit?

How to change the names of the fields in the SharePoint Online list for each language?

SharePoint Online "Display Name" list – Not the same for everyone (location)

Hello guys,

My colleague changed the name of a SharePoint Online list field (via list settings, not the quick editor), but the new name is displayed only for him.

I have executed the following command via PowerShell

Get-PnPField -List LSIT -Identity "FIELDID" | Select *

My results:

SchemaXml: 0
StaticName: Old_x0020_name
Title: Old name

My colleague's result

SchemaXml: 0
StaticName: Old_x0020_name
Title: NEW NAME

Today, I noticed that my colleague is using localization settings in English.

For this reason, I decided to research the location method in SharePoint

https://mycompany.sharepoint.com/_layouts/15/exporttranslations.aspx
(to import, use _layouts / importtranslations.aspx)

I exported both the English version and the Hungarian version and I find that there is a difference.

So my question is, how do I change the field names in the SharePoint Online list for each language?