Issues enabling rpow

[VangelisP]

Hi all!

We've tried to install the rpow ext in one of our environments.

The current setup:

• We got a master db and a replica db.
• The replica db does have less tables (eg the caches tables) than the master db (we tried to minimize the replica size to be more efficient)
• We got advanced logging enabled on a separate db (CIVICRM_LOGGING_DSN)
• We did not enable or install Redis

What we did: We installed the rpow extension via the UI and then we configured it, as described on https://docs.civicrm.org/rpow/en/latest/install/#general in the civicrm.settings.php, as such:

if (!defined('CIVICRM_DSN')) {
  if (CIVICRM_UF === 'UnitTests' && isset($GLOBALS['_CV']['TEST_DB_DSN'])) {
    define('CIVICRM_DSN', $GLOBALS['_CV']['TEST_DB_DSN']);
  } else {
    //define('CIVICRM_DSN', 'mysql://localcivicrm:xxx79xVA3@localhost/iucncrm?new_link=true%%dbSSL%%');
    //require_once '/var/www/testcrm.iucn.org/html/vendor/civicrm/rpow/autoload.php';
    require_once '/var/www/testcrm.iucn.org/html/web/sites/testcrm.iucn.org/files/civicrm/ext/rpow/autoload.php';
    rpow_init([
      'masters' => ['mysql://xxxxx:yyyyy@localhost/myproddb?new_link=true%%CMSdbSSL%%'],
      'slaves' => ['mysql://rpow_user:yyyyyy@myreplica:3306/replicadb?new_link=true%%CMSdbSSL%%'],
      'cookieSigningKey' => 'asdf12344321fdsa',
    ]);    
  }
}

PS. We've used the cookieSigningKey value as seen in the code, just in case it helped.

While CiviCRM does boot up once, whenever we try to access a contact or navigate the first time it works fine (loads ok) but upon a refresh, we get a WSOD with a message on the watchdog: Error: Class "CRM_Utils_Signer" not found in _rpow_signer().

I am trying to figure out why we get this error and why it does load one time properly but not the second time, it's like it cannot bootload civicrm at that point.

Some of the excluded tables are: civicrm_managed, civicrm_extension, civicrm_cache, civicrm_job, civicrm_job_log, civicrm_menu, civicrm_setting

Could it be possible that this is due to some missing replica tables? I can't figure out why though.

@eileenmcnaughton perhaps you got any ideas?

Many many thanks all!

[totten]

I haven't looked in any depth, but an observation: the error is class-loading related. The original dev/testing (and the main live user) have used Civi-D7, and class-loading is fairly different on D8+. So it probably needs some tweak related to classloading or boot-positioning.

[eileenmcnaughton]

Speaking to @totten he thinks the difference between your usage & ours is likely drupal version (we are Drupal 7) and there might be a bootstrap difference - Luciano says you are probably D10. (He didn't actually suggest what the fix might be....)

I note that rpow-init is called from civicrm_settings.php & assumes that Civi knows how to load CRM classes in core at that point - which it DOES in D7 - and that is the first call to load a Core CRM class ...

Regarding Redis - I don't think it IS optional with rpow because it handles the PrevNext cache (search results)

[VangelisP]

Hi all, thanks for looking at it. I do indeed use it on a Drupal 9 website and yes, you are right, my conclusion is, as well, that the issue is how it bootstraps. Though my problem is that I don't know how to properly bootstrap it.

As it stands right now, I was able to get things going (I think that it works based on mysql monitoring only) by checking if the class exists before initializing:

#19

This is my ugly version with debug disabled and just some logging. If that appears correct, I can refine my branch and make a proper PR.

By the way, the debug=1 variable kills it for some reason, perhaps too much data to display on screen? I don't know.