Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

7
  • A bit better, but still not working... I get a new error message: Drupal\Core\Database\DatabaseExceptionWrapper type: Exception in xxxViewNamexxx[xxxBlockNamexxx]: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'xMyCiviCRMUserx'@'localhost' for table 'civicrm_contact': SELECT [...] message Drupal\views\Plugin\views\query\Sql->execute() function (/var/www/devweb/web/core/modules/views/src/Plugin/views/query/Sql.php file in line 1548.). (in the section [...] is a simple query, but it's too long for pasting here. xMyCiviCRMUserx has access to the db.
    – Pál Rudan
    Commented Feb 10, 2021 at 12:17
  • This looks like Drupal DB user, set in settings.php trying to query CiviCRM database but not having permissions to SELECT on it. Commented Feb 10, 2021 at 22:03
  • The Drupal DB user is the same as the CiviCRM user. Checked by me and by the DB manager too, and the DB User has ALL PRIVILEGES on both DB's.
    – Pál Rudan
    Commented Feb 11, 2021 at 13:39
  • Could happen, that this github.com/eileenmcnaughton/civicrm_entity/issues/259 issue has some relation with my problem?
    – Pál Rudan
    Commented Feb 12, 2021 at 8:43
  • It seems so, that CiviCRM Entity (at least up to CiviCRM Entity 8.x-3.0-beta2 version) not handles, if Drupal and CiviCRM are in separate databases.
    – Pál Rudan
    Commented Feb 19, 2021 at 8:48