ExternalAuth Table is Empty for SimpleSAMLphp_auth module

I’m using the simplesamlphp_auth module to integrate a SAML based IDP from my company. When a user logs in, their identifier (in this case their email) is checked against the authmap table.

This occurs in the function ExternalAuth.php::load() of the externalauth module (a required module for simplesamlphp_auth). However, this table authmap is empty and so never loads a user. How is this table populated?

As a work around, I had to patch this file with an additional lookup since the lookup by email in the authmap table fails.

    $  users = \Drupal::entityTypeManager()->getStorage('user')       ->loadByProperties(['mail' => $  authname]);     if (!empty($  users)) {         $  user = reset($  users);         if (!empty($  user)) {             return $  user;         }     } 

Our setup is concerned with linking existing Drupal users with their accounts in the remote IDP, since we have a relatively small and static pool of users in Drupal. The remote IDP authentication serves thousands of people across different parts of the company.

How to count the number of empty rows since the last entry in a column?

I’m trying to get Google Sheets to tell me how many rows it has been since the last “1” was present in column A (see example table below). How do I get Google Sheets to output column B?

An alternative way of looking at this is to count the number of zeros/blanks in between the 1’s in column A (then +1 to account for the row with the second 1) and print that number in Column B. How can I do this?

Data    # rows since last "1" 1 1       1 0 1       2 0 0 0 0 1       5 1       1 

catalog_category_product_index table empty (Magento 2.2.5)

Our indexer re-fills the table catalog_category_product_index_store1, but the table catalog_category_product_index remains empty.

I have found this issue https://github.com/Smile-SA/elasticsuite/issues/991 , but even after an upgrade of the smile/elasticsuite module to 2.5.13, the table remains empty.

In some of our development environments, the table is filled. But when I truncate it and reindex, it stays empty.

This is how I reindex:

bin/magento indexer:reindex catalog_product_category 

Any ideas?