CiviCRM Community Forums (archive)

Hi

this document
http://wiki.civicrm.org/confluence/display/CRMDOC40/Views3+Integration

describes how to integrate civicrm with drupal views assuming

CiviCRM and Drupal are on separate databases located on the same physical host

We host the separate databases on different hosts.
Is it at al possible to integrate views3 and civicrm like that ?

curious,
*-pike

We host the separate databases on different hosts.
Is it at al possible to integrate views3 and civicrm like that ?

This may be possible, but by using a slightly different method, of defining the CiviCRM DB connect string. I'm not sure where that method is documented however...

This may be possible, but by using a slightly different method, of defining the CiviCRM DB connect string. I'm not sure where that method is documented however...

If I see the sql that views3 creates, it might work, if only Drupal would switch DB connection just before executing it. Ofcourse, this is just a generic 'get me some contacts with some details' query. Views would never be able to do table joins across different hosts. So even if it is possible, a bit of clicking in the views interface would generate errors...

Nevertheless, and for the record too: it is possible, and how  ?

*-pike

Hi

I still think telling the robots at your host to put your databases on the same server would be worth asking.

This is what the hosting provider says.

It's not possible, the host is set randomly by the robots. It's not possible to choose.
I remain at your disposal for any further information.

  I wasn't joking about the robots, you see. I suspect the entity that wrote that mail
is a robot itself. You can't phone these beings either. It's a 100% virtual helpdesk. I wonder where
all the money goes. Grease and diodes, perhaps.

haha,
*-pike

I am using two different databases for drupal and civicrm, both have their own credentials. Since i cannot grant privileges to the users, I need to make a separate connection to use the civicrm db.

I don't know how to configure this, i always get an error message.

Now i added this to my settings.php but still drupal will connect to the wrong database with the wrong credentials.


$databases['civicrm']['default']['prefix'] = array (
      'database' => 'civicrm',
      'username' => 'civicrm',
      'password' => 'password',
      'host' => 'localhost',
      'port' => '3306',
      'driver' => 'mysql',
      'prefix' => '',
);
$databases['civicrm']['default']['prefix']= array(
  'database'                   => '`civicrm`',
  'civicrm_acl'                              => '`civicrm`.',
  'civicrm_acl_cache'                        => '`civicrm`.',
  'civicrm_acl_contact_cache'                => '`civicrm`.',
  'civicrm_acl_entity_role'                  => '`civicrm`.',
....
);

The error message I get is:
Base table or view not found: xxxx Table 'drupaldb.civicrm_event' doesn't exist.

This doesn't help either.

I get different messages now:

Notice: Undefined offset: 0 in Database::parseConnectionInfo() (line 1507 of /home/httpd/vhosts/krempel.ch/httpdocs/cms/includes/database/database.inc).

SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'drupal_c'@'localhost' for table 'civicrm_event'

So he tries to connect with the drupal credentials again...

Maybe the error is that two database connections follow each other?


$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'drupal_7',
      'username' => 'drupal_c',
      'password' => 'password',
      'host' => 'localhost',
      'port' => '3306',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);
$databases['civicrm']['default']['prefix'] = array (
      'database' => 'civicrm',
      'username' => 'civicrm',
      'password' => 'password',
      'host' => 'localhost',
      'port' => '3306',
      'driver' => 'mysql',
      'prefix' => '',
);