Kerberos replay attack within allowed range – authenticator won’t prevent it?

In kerberos protocol the client, after receiving a ticket to the TGS server, sends a request to the TGS and adds an authenticator to the request.

What if an attacker performs a replay attack within the allowed clock skew, so that the difference between the timestamp in the authenticator the attacker copied and the TGS’s clock is still allowed. What kind of check will the TGS perform in such a case ?

If the clock skew is 5 minutes then shouldn’t there be some cache memory holding all requests from the last 5 minutes so that if the same authenticator arrives again TGS will reject it since the same timestamp already exists in its cache ? (because a valid client sending a second request would generate a new timestamp while an attacker will use an existing timestamp) ?

Is there such a cache for the case of a replay attack within the allowed time range ?

Grabbing only non-empty cells from a row range for every row

I have a survey that sends responses into a Google Sheet. The raw data that is inserted is messy, so I have another sheet that processes the incoming raw data.

One of the things I need to do is: from a range of columns in one row, pull the non-empty cells–and do this automatically with every new response that comes in.

This is what I’ve come up with that works with a single row, but I can’t figure out how to have it automatically apply to the entire column:

=transpose(QUERY(unique(transpose({'Raw Data'!AL3:AY3,'Raw Data'!AL3:AY3})),"SELECT Col1 WHERE Col1 <> '' ORDER BY Col1 ASC LIMIT 8",0))

Because the survey will insert rows, it ends up adjusting any cell references in my ‘Processed Data’ sheet, so I’ve been trying to use ARRAYFORMULA unsuccessfully.

Also, the range of columns will be more than 400 (options of schools), so manually writing out individual column names would probably be unfeasible.

Here’s a link to the spreadsheet

The column of issue starts on column O

Background: In the survey, a respondent can select multiple schools to a maximum of 8 out of a selection of 400+ schools. In the ‘Raw Data’ sheet, each school option is represented by a column.

Hopefully all of that made sense. Any help would be greatly greatly appreciated–I’ve been stuck on this for a while!

IP Range using Netplan

Is it possible to configure Netplan with Static IP range? Or do you need to specify each IP like in old ifupdown configuration.

Basically I want to do something similar to RedHat:

IPADDR_START=192.168.0.2 IPADDR_END=192.168.0.254 PREFIX=24 CLONENUM_START=0 

The old way is doing this way: https://serverfault.com/questions/27160/how-to-add-multiple-24-network-ips-in-ubuntu

iface eth0 inet static   address 192.168.0.1   netmask 255.255.255.0   up ip addr add 192.168.0.2/24 dev eth0   up ip addr add 192.168.0.3/24 dev eth0   up ip addr add 192.168.0.4/24 dev eth0   up ip addr add 192.168.0.5/24 dev eth0   ... 

Would I need to just specify each IP like bellow or is there a simpler way to specify a range?

# This file is generated from information provided by  # the datasource. Changes to it will not persist across an instance.  # To disable cloud-init's network configuration capabilities, write a file  # /etc/cloud/cloud.cfg.d/99-disable-network-config.cfg with the following:  # network: {config: disabled}   network:      renderer: networkd      ethernets:           enp0s3:              addresses: [192.168.0.2/24, 192.168.0.3/24, ... , 192.168.0.254/24 ]               gateway4: 192.168.0.1               nameservers:                   addresses: [8.8.8.8,8.8.4.4]               dhcp4: no      version: 2  

Can you auto update the range for a filter in Google Sheets?

I have a Google Sheet document with many rows in it. I have several filters set up to view different collections of rows.

The problem is, this sheet has new rows automatically added to it several times a day from automated external sources.

So, whenever someone goes to view one of the filters, it is no longer filtering all rows, as the range for the filter does not include the rows added to the sheet since the last set.

Is there a way to have this range automatically update the end of the range to be the “last” row of the sheet?

Range of values for Kolmogorov complexity

Let $ n$ be a positive integer. Is it true that for all $ 1\leq i \leq n$ there exists a length $ n$ binary string $ w$ such that $ K(w) = i$ . Where $ K(w)$ is the Kolmogorov complexity of $ w$ .

For each $ i$ there are clearly $ 2^i$ programs of that length. But can we be sure at least one of them (when executed) generate a length $ n$ binary string?

Index or range of Last ocurence of bytes in file

I’m trying to find the last occurence of a byte pattern in a file. I can sucessfully find the first with:

let mtrkChunk = Data(bytes: [0x4D, 0x54, 0x72, 0x6B] as [UInt8], count: 4) and then let mtrkChRng = data.range(of: mtrkChunk)

But can’t work out how to make it match the second occurence instead. Any help as ever would be appreciated

Render Date Range on node template

I’m trying to render both start and end date on a node template in Drupal 8 from the Date range field from the content type. I’ve tried multiple ways to no avail.

— Only shows start date —

{{ kint(node.field_date_range.value ) }}   {% if node.field_date_range %} {{ node.field_date_range.value|date(format='l M j') }} {% endif %} 

Use a range of cells as criteria in SUMIF

As an example, I have the below formula:

=SUMIF(G1:G25,E1,H1:H25)+SUMIF(G1:G25,E2,H1:H25)+SUMIF(G1:G25,E3,H1:H25) 

It is 3 SUMIFs all using the same criteria and sum range, the criteria uses 3 cells all in the same range.

I want to be able to condense this formula to something like the below:

=SUMIF(G1:G25,E1:E3,H1:H25) 

where the criteria is the range of cells. I have tried:

{=SUMIF(G1:G25,E1:E3,H1:H25)} 

&

=SUMIF(G1:G25,{E1:E3},H1:H25) 

&

=SUM(SUMIF(G1:G25,{E1:E3},H1:H25)) 

Is there a way to achieve this ? perhaps even with SUMPRODUCT ?

Also, in place of the range E1:E3 I would like to use a named range, if possible, If not just a way of condensing the multiple SUMIFs will do for me.

Google Sheets find next/previous non-blank cell, but without a specified range

I’ve come across plenty of formulas to find blank cells within a certain specified range, but can’t seem to figure this out / find an answer.

I have a spreadsheet kind of like this:

enter image description here.

Where column A is empty except for these header bars, and there are lots of sections going down the sheet with these header bars.

What I’m trying to do is have a formula that can find the row of the cell A header from within a section, but so that the formula will work in any section.

So in the above “sheet”, let’s say I was in cell B52. Maybe there’s a formula to look at A52, and if empty keep moving up until it found that cell A48 was the first cell upwards to have a value, and return the value as 48 (the row).

I’m also hoping this can be done with regular formulas and avoid using gss if possible so it can remain dynamic.

Any thoughts? Thanks!!

edit1:

apparently not quite clear enough. I made another sheet to help illustrate further what the data looks like and what I’m after:

enter image description here

I’m hoping for a formula that when placed in cell B32 as highlighted, it will return A28, or just 28, as in the row of the previous non-blank cell, but then ideally, the same formula could then be placed anywhere else, say for example B46, which would then return A37 as the previous non-blank cell in the A column.