CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Drupal dual-database setup, am I doing it wrong?
Pages: [1]

Author Topic: Drupal dual-database setup, am I doing it wrong?  (Read 699 times)

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Drupal dual-database setup, am I doing it wrong?
January 06, 2012, 11:24:27 am
$db_url['default'] = 'mysqli://drupal_user:pass@localhost/drupal_db';
$db_url['civicrm'] = 'mysqli://civi_user:pass?@localhost/civi_db';

With this setup (and Views + Civi integration) Drupal is still trying to access CiviCRM database with the drupal user. Is Drupal not paying attention that I want it to use a different user to access CiviCRM db?   Or is there some cache file or configuration I am missing?


Try CiviTeacher: the online video tutorial CiviCRM learning library.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Drupal dual-database setup, am I doing it wrong?
January 06, 2012, 12:46:36 pm

the way views is set up (at least for the default case) is to ensure that the drupal db user has permission on the civicrm db

there is another way of doing this also, but i'm not familiar with it (linked from the wiki page)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Drupal dual-database setup, am I doing it wrong?
January 06, 2012, 12:49:39 pm
aha, that is the key.  I will grant civicrm db permissions to the drupal user.  that solves my problem.  thanks
Try CiviTeacher: the online video tutorial CiviCRM learning library.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Drupal dual-database setup, am I doing it wrong?

This forum was archived on 2017-11-26.