Rpow doesn't play nice with logging

[eileenmcnaughton]

I'm hitting an issue with rpow locally when I try to turn logging on or off.

The issue is the CRM_Logging_Schema class makes liberal use of $this-db defined as

    if (defined('CIVICRM_LOGGING_DSN')) {
      $dsn = DB::parseDSN(CIVICRM_LOGGING_DSN);
      $this->useDBPrefix = (CIVICRM_LOGGING_DSN != CIVICRM_DSN);
    }
    else {
      $dsn = DB::parseDSN(CIVICRM_DSN);
      $this->useDBPrefix = FALSE;
    }
    $this->db = $dsn['database'];

With RPOW enabled $this->db winds up as '' and the queries wind up as
'CREATE TABLE .civicrm_x'
I'm wondering what the best approach is here @totten

[eileenmcnaughton]

For now we are using the same DB - & just adding the DSN in buildkit.

[eileenmcnaughton]

Note this means

1. CIVICRM_LOGGING_DSN must be defined to use logging with rpow
2. read only connections are not used to access the log tables.

The latter will likely become important at some point but at this stage we are not actively concerned about this