vpn – Restrict subnet access based on LDAP group

I’ve got 3 VLANs: Server, IT and Staff. The Staff VLAN has restricted access to the Server VLAN, while the IT VLAN has access to everything.

When someone connects to the VPN I’d like to give them similar permissions based on whether they’re in the Staff or IT LDAP groups.

Is this possible with OpenVPN? How would it be implemented?

worksheet function – Excel – Filter columns based on starting string, read number from filtered cells and perform arithmetic operation to generate row summary

I am having a Project and resource allocation report. I need help in generating the formula to display summary on the right section of the report.

Here’re the specifications of my report:

  • Column A from Row 2 to Row 15 represents the Resource (persons) allocated for each project
  • Column B, Column C…. represents the percentage of resource allocated in each project per month
  • Each resource of column A is merged into 2 cells because each resource can either work in 1 or 2 project per month
  • Resource working on single project in a month will have both the cells merged . Resource working on 2 projects will have 2 rows representing the project
  • Against each project there is number representing the percentage of that resource allocated to the project

Here’s the screenshot of my report:

Project Resource Allocation Sheet screenshot

Here in the summary, I am representing the total number of weeks each person will be spending on each
project. To keep the calculation simplified, I am assuming each month is equivalent to exactly 4 weeks. So,

  • If a Person A is working 100% in Project B in February. Then number to be considered for summation in summary should be 4 for Project B
  • Similarly if Person A is working 50-50% on 2 projects in January. Then number to be considered for summation should be 2-2 weeks for each project

In general, the number to be considered in summary could be mathematically represented as:

4 *(Percentage from column) / 100

Here’s what I am trying to achieve:

  1. Read string from cells (F1 – J1)
  2. Do a lookup in the person column on two rows (B2, C2… ) and (B3, C3…) to get the cells starting with project string
  3. Filter the numbers from the above cells (from step 2)
    Do summation of the numbers and divide by 100 and multiply by 4 (to get number of weeks)

Note:

  1. For column with two cells merged, calculation should be considered just once for that person.
  2. Calculation of my summary is based on data from two rows

PS: It is similar to my previous question where I was generating summary on single column, where two cells within the column could be merged: Excel – Filter rows based on starting string, read number from filtered rows and perform arithmetic operation to generate column summary . However, here I am performing calculation on two rows to get the summary. And merged cells row cells needs to be considered only once for calculation.

logrotate – can I rotate log based on file creation time?

I have logrotate config like this:

/var/log/example*.log {
    weekly
    rotate 1
    missingok
    notifempty
    compress
}

Some of the example*.log files have existed for quite long time more than few months. I want to compress them with logrotate. But the config is newly added, thus it will only start to rotate them after another week.

rotating pattern: /var/log/example*.log  weekly (1 rotations)
empty log files are not rotated, old logs are removed
considering log /var/log/example-a.log
Creating new state
  Now: 2021-01-23 10:07
  Last rotated at 2021-01-23 10:00
  log does not need rotating (log has been already rotated)
considering log /var/log/example-b.log
Creating new state
  Now: 2021-01-23 10:07
  Last rotated at 2021-01-23 10:00
  log does not need rotating (log has been already rotated)
considering log /var/log/example-c.log
Creating new state
  Now: 2021-01-23 10:07
  Last rotated at 2021-01-23 10:00
  log does not need rotating (log has been already rotated)

I wonder is there a way to let the logrotate rotate files based on the creation time or mtime, when it is too old then compress them.

Another problem is the files matching wild card are all rotated together. No matter if the log file is newly created or not. I checked the /var/lib/logrotate/logrotate.status It seems like example*.log is treated as whole. That means all files match this pattern will be rotated at same day. For example: a new log file example-d.log has been added after 6 days of last rotation. Then it will be rotated the next day after it created. But I would like the newly added log example-d.log to rotate after 1 week. Is there any other tool can rotate logs like what I want?

Do you gain XP based on your "level" or your XP total?

Let’s say a 3rd-level character with 5900 XP (100 away from reaching 4th level) clears two EL 5 encounters during an adventure. The PHB says on page 58 that XP is handed out at the end of each adventure, so this means they were in both of these encounters while they were 3rd level.

According to the table on page 38 of the DMG, a party of four 3rd-level characters gains 450 XP per character from an EL 5 encounter, whereas a party of four 4th-level characters gains 400 XP per character.

So, at the end of the above example, would the character have gained 900 XP (they were treated as a 3rd level character during the second encounter, because at the time of the encounter they had 3 HDs and the class features of a 3rd-level character, etc.) or 850 XP (they were treated as 4th level during the second encounter, because at the time of the encounter they had between 6000 and 9999 XP)?

search – Redirect template based on permalink rather than $wp_query

I’m trying to separate out different templates which utilise WordPress’ search (s query var) along with different post types.

Situation 1: Default WordPress search page (search.php). Example: example.com?s=test

Situation 2: Post type archive (archive-{$post_type}.php), with search and taxonomy query var filtering ability. Example: example.com/questions?s=test&category=wordpress

Situation 2 has a few different final templates based on what post type is being queried.

So far I’ve managed to get the above to work with a function similar to this:

function wpse_redirect_search_page_post_types( $template ) {
    global $wp_query;

    if ( $wp_query->is_search ) {
        if ( get_query_var( 'post_type' ) === 'question' ) {
            return locate_template( 'archive-question.php' );
        }
    }
    return $template;
}
add_filter( 'template_include', 'wpse_redirect_search_page_post_types' );

However I encountered an issue when attempting to filter the search results page with different post types. I’ve got a bunch of checkboxes to filter what post types to show on the search results page, and the moment I’ve got only one post type (eg example.com?s=test&post_type=question) it sets the template to archive-question.php.

In terms of the $wp_query, they’re identical (barring query hash differences) for
example.com?s=test&post_type=question
and
example.com/question?s=test&post_type=question.

What’s the best way to do a check for whether I’m intending to show the search or archive template? The only other way I know how to do this is access the url through $_SERVER('REQUEST_URI'), but I was hoping there was a more WordPress-centric way of checking what template it intends to use.

Final use-case goals:

  • example.com/questions?s=test (archive)
  • example.com/questions (archive)
  • example.com/?s=test (search)
  • example.com/?s=test&post_type=question (search)
  • example.com/?s=test&post_type=question,answer (search)

Calculate Column Based On Self (Circular Reference Workaround)

I have a date and time data type calculated column named “Date of Review” with the following formula:

=IF((Status)<>”Select”,NOW(),””)

Formula explained, if the choice column “Status” has a value other than “Select”, the “Date of Review” column will be populated with NOW(), in effect creating a timestamp for when the status was changed.

The problem is any time the record is edited, the “Date of Review” refreshes to NOW().

I understand that you can’t use ISBLANK() but I understand I could compare the current value of the column to another.

With that, I created a column “EmptyDate” that is not on any form and is always blank.

What I am trying to do is something like this, but I don’t know what I am missing:

=IF((Date Of Review)=(Empty Date),(IF((Status)<>”Select”,NOW(),””),””)

I can’t get it to work. Any suggestions?

Thanks!

Hiding Rows based on cell value in columns

I am trying to hide rows with either conditional formatting or formula. I am looking to hide all rows that contact a zero value in column k and also hide rows with any value at all in column L. I can’t get the formula to work properly and I can’t get macro or VBA to run how I need it to…
ScreenShot

I will build pro1 seo usa based hight quality dofollow profile backlink for $5

I will build pro1 seo usa based hight quality dofollow profile backlink

About This GigHello…..
50 High pr SEO Backlinks for google ranking .Here i will create 50 High pr SEO Backlinks, For google ranking these links

are white hat High Authority SEO Backlinks Link buildingThese are profile links not blog comments or redirectWhitehat 50 High pr SEO Backlinks100% Penguin, Panda, and Hummingbird safe.Domain Authorities (DA) ranging from Very High, Imagine the amount of juice and authority your site will benefitGoogle loves these authority Link building backlinksDo you want to skyrocket your website rankings, increase traffic and boost your page rank?

Quality Dofollow backlinks are the most important part of SEO. 100% Safe High

Quality Backlinks according to latest Google update.#- Can you work on my new website and it Safe?All site accepted excluding Porn, Gambling and adult oriented.#. Do you accept all languages ?All languages are accepted but we do all campaign with English contents,

meanwhile, your keywords still remain intact in your preferred language.#- How long my site will stay GOOGLE new rankings ?Depend on how much your competitors are working on their Seo.#- Do you accept high competition keywords?Yes, But we cannot guarantee a huge boost such as top pages within few weeks.

WHAT WILL YOU GET FOR $5?50 High pr BacklinksWhite hat backlinksManual backlinksLogin Details provide24 Hours Express DeliveryWhat i will need from you?Website URLKeywordsA Short Description

.(tagsToTranslate)usa(t)hight(t)profile(t)backlink(t)based

Buying – UK based php programmer

Hi,
SEMrush

I am looking for a UK based programmer to come in with me on a business idea. There is some money to put into this, but having been over promised and under delivered by a few people in the past on different projects I want someone who is prepared to work with me on this.

I do not want to go in to details at this stage, but I want to create a website that is ultimately a form that cross references with a database to provide a list of products in the financial services industry – there is obviously more to it than that (registrations, API integrations in time, payment processing down the line), but it gives a very broad outline of what is needed.

I have worked in financial services for about 15 years, I run my own business which has been trading since 2013 as a sole trader and then 2016 as a limited company – in essence you can vet my business and credentials on companies house and the FCA register.

I have everything in place to get the venture earning money once this is done, we have insurance we are regulated by the FCA, we have the agreements with the banks etc. But it must be someone in the UK.

Thank you.