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) »
  • Quick help w settings.php
Pages: [1]

Author Topic: Quick help w settings.php  (Read 1303 times)

kgilnack

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
    • a beautiful mix of Drupal & CiviCRM.. when things are going right
Quick help w settings.php
May 22, 2010, 04:42:22 pm
I am trying to configure my settings.php file to work with Sunlight's Congressional District module per these instructions:
Quote
3)Make sure you have an entry in db_url for civicrm in your settings.php file.  Something like:
    $db_url = array(
      'default' => 'mysqli://user:pass@localhost/drupal',
      'civicrm' => 'mysqli://user:pass@localhost/civicrm',
    );
  Make sure to use the same schema for both database ULRs (mysqli, mysql, pgsql).

Currently our settings.php file reads like this (except the correct user, password, & host are in the db_url):

Code: [Select]
$db_url = 'mysqli://user:pass@localhost/providers_drupal';
$db_prefix = array(
  'civicrm_acl'                              => 'providers_civicrm.',
  'civicrm_acl_cache'                        => 'providers_civicrm.',
  'civicrm_acl_entity_role'                  => 'providers_civicrm.',
  'civicrm_activity'                         => 'providers_civicrm.',
  'civicrm_activity_assignment'              => 'providers_civicrm.',
  'civicrm_activity_target'                  => 'providers_civicrm.',
  'civicrm_address'                          => 'providers_civicrm.',
  'civicrm_cache'                            => 'providers_civicrm.',
  'civicrm_case'                             => 'providers_civicrm.',
  'civicrm_case_activity'                    => 'providers_civicrm.',
  'civicrm_case_contact'                     => 'providers_civicrm.',
  'civicrm_component'                        => 'providers_civicrm.',
  'civicrm_contact'                          => 'providers_civicrm.',
  'civicrm_contribution'                     => 'providers_civicrm.',
  'civicrm_contribution_page'                => 'providers_civicrm.',
  'civicrm_contribution_product'             => 'providers_civicrm.',
  'civicrm_contribution_recur'               => 'providers_civicrm.',
  'civicrm_contribution_type'                => 'providers_civicrm.',
  'civicrm_contribution_widget'              => 'providers_civicrm.',
  'civicrm_country'                          => 'providers_civicrm.',
  'civicrm_county'                           => 'providers_civicrm.',
  'civicrm_currency'                         => 'providers_civicrm.',
  'civicrm_custom_field'                     => 'providers_civicrm.',
  'civicrm_custom_group'                     => 'providers_civicrm.',
  'civicrm_dedupe_rule'                      => 'providers_civicrm.',
  'civicrm_dedupe_rule_group'                => 'providers_civicrm.',
  'civicrm_discount'                         => 'providers_civicrm.',
  'civicrm_domain'                           => 'providers_civicrm.',
  'civicrm_email'                            => 'providers_civicrm.',
  'civicrm_entity_file'                      => 'providers_civicrm.',
  'civicrm_entity_tag'                       => 'providers_civicrm.',
  'civicrm_event'                            => 'providers_civicrm.',
  'civicrm_event_page'                       => 'providers_civicrm.',
  'civicrm_file'                             => 'providers_civicrm.',
  'civicrm_financial_trxn'                   => 'providers_civicrm.',
  'civicrm_grant'                            => 'providers_civicrm.',
  'civicrm_group'                            => 'providers_civicrm.',
  'civicrm_group_contact'                    => 'providers_civicrm.',
  'civicrm_group_contact_cache'              => 'providers_civicrm.',
  'civicrm_group_nesting'                    => 'providers_civicrm.',
  'civicrm_group_organization'               => 'providers_civicrm.',
  'civicrm_im'                               => 'providers_civicrm.',
  'civicrm_line_item'                        => 'providers_civicrm.',
  'civicrm_loc_block'                        => 'providers_civicrm.',
  'civicrm_location_type'                    => 'providers_civicrm.',
  'civicrm_log'                              => 'providers_civicrm.',
  'civicrm_mailing'                          => 'providers_civicrm.',
  'civicrm_mailing_bounce_pattern'           => 'providers_civicrm.',
  'civicrm_mailing_bounce_type'              => 'providers_civicrm.',
  'civicrm_mailing_component'                => 'providers_civicrm.',
  'civicrm_mailing_event_bounce'             => 'providers_civicrm.',
  'civicrm_mailing_event_confirm'            => 'providers_civicrm.',
  'civicrm_mailing_event_delivered'          => 'providers_civicrm.',
  'civicrm_mailing_event_forward'            => 'providers_civicrm.',
  'civicrm_mailing_event_opened'             => 'providers_civicrm.',
  'civicrm_mailing_event_queue'              => 'providers_civicrm.',
  'civicrm_mailing_event_reply'              => 'providers_civicrm.',
  'civicrm_mailing_event_subscribe'          => 'providers_civicrm.',
  'civicrm_mailing_event_trackable_url_open' => 'providers_civicrm.',
  'civicrm_mailing_event_unsubscribe'        => 'providers_civicrm.',
  'civicrm_mailing_group'                    => 'providers_civicrm.',
  'civicrm_mailing_job'                      => 'providers_civicrm.',
  'civicrm_mailing_spool'                    => 'providers_civicrm.',
  'civicrm_mailing_trackable_url'            => 'providers_civicrm.',
  'civicrm_mapping'                          => 'providers_civicrm.',
  'civicrm_mapping_field'                    => 'providers_civicrm.',
  'civicrm_membership'                       => 'providers_civicrm.',
  'civicrm_membership_block'                 => 'providers_civicrm.',
  'civicrm_membership_log'                   => 'providers_civicrm.',
  'civicrm_membership_payment'               => 'providers_civicrm.',
  'civicrm_membership_status'                => 'providers_civicrm.',
  'civicrm_membership_type'                  => 'providers_civicrm.',
  'civicrm_menu'                             => 'providers_civicrm.',
  'civicrm_msg_template'                     => 'providers_civicrm.',
  'civicrm_note'                             => 'providers_civicrm.',
  'civicrm_openid'                           => 'providers_civicrm.',
  'civicrm_openid_associations'              => 'providers_civicrm.',
  'civicrm_openid_nonces'                    => 'providers_civicrm.',
  'civicrm_option_group'                     => 'providers_civicrm.',
  'civicrm_option_value'                     => 'providers_civicrm.',
  'civicrm_participant'                      => 'providers_civicrm.',
  'civicrm_participant_payment'              => 'providers_civicrm.',
  'civicrm_payment_processor'                => 'providers_civicrm.',
  'civicrm_payment_processor_type'           => 'providers_civicrm.',
  'civicrm_phone'                            => 'providers_civicrm.',
  'civicrm_pledge'                           => 'providers_civicrm.',
  'civicrm_pledge_block'                     => 'providers_civicrm.',
  'civicrm_pledge_payment'                   => 'providers_civicrm.',
  'civicrm_preferences'                      => 'providers_civicrm.',
  'civicrm_preferences_date'                 => 'providers_civicrm.',
  'civicrm_premiums'                         => 'providers_civicrm.',
  'civicrm_premiums_product'                 => 'providers_civicrm.',
  'civicrm_price_field'                      => 'providers_civicrm.',
  'civicrm_price_set'                        => 'providers_civicrm.',
  'civicrm_price_set_entity'                 => 'providers_civicrm.',
  'civicrm_product'                          => 'providers_civicrm.',
  'civicrm_project'                          => 'providers_civicrm.',
  'civicrm_relationship'                     => 'providers_civicrm.',
  'civicrm_relationship_type'                => 'providers_civicrm.',
  'civicrm_saved_search'                     => 'providers_civicrm.',
  'civicrm_state_province'                   => 'providers_civicrm.',
  'civicrm_subscription_history'             => 'providers_civicrm.',
  'civicrm_tag'                              => 'providers_civicrm.',
  'civicrm_task'                             => 'providers_civicrm.',
  'civicrm_task_status'                      => 'providers_civicrm.',
  'civicrm_tell_friend'                      => 'providers_civicrm.',
  'civicrm_timezone'                         => 'providers_civicrm.',
  'civicrm_uf_field'                         => 'providers_civicrm.',
  'civicrm_uf_group'                         => 'providers_civicrm.',
  'civicrm_uf_join'                          => 'providers_civicrm.',
  'civicrm_uf_match'                         => 'providers_civicrm.',
  'civicrm_value_event_sign_up_10'           => 'providers_civicrm.',
  'civicrm_value_expo_9'                     => 'providers_civicrm.',
  'civicrm_value_expo_details_11'            => 'providers_civicrm.',
  'civicrm_value_individual_bio_7'           => 'providers_civicrm.',
  'civicrm_value_interests_6'                => 'providers_civicrm.',
  'civicrm_value_organizational_bio_1'       => 'providers_civicrm.',
  'civicrm_value_tr_certificate_12'          => 'providers_civicrm.',
  'civicrm_value_tr_remission_12'            => 'providers_civicrm.',
  'civicrm_value_training_group_w_org_13'    => 'providers_civicrm.',
  'civicrm_worldregion'                      => 'providers_civicrm.',
);
I've tried making a few attempts at this but have not been able to figure out how to make it work.  Any assistance or directions to tutorials would be greatly appreciated.

maciej.zgadzaj

  • Guest
Re: Quick help w settings.php
May 22, 2010, 05:22:46 pm
Ok, let me give you slightly longer answer than 140 chars. :)

Generally, $db_prefix is used only if you have your tables in not default schema.

Example for postgres - by default, all Drupal tables are created in "public" schema. But you can create any other schema if you want to (for example "drupal"), and put them there. Then you would need to configure $db_prefix:

Code: [Select]
$db_prefix = array(
    (...)
    'node' => 'drupal.',
    (...)
);
The same applies to civicrm tables. I suspect, in your example previously you had all your civicrm tables in "providers_civicrm" schema. But if you moving them to a separate database, you probably want to create them in default schema, hence no need to use $db_prefix.

Hope this helps.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Quick help w settings.php
May 23, 2010, 03:17:39 am
I think all you need to do is replace:

Code: [Select]
$db_url = 'mysqli://user:pass@localhost/providers_drupal';
with

Code: [Select]
$db_url = array(
      'default' => 'mysqli://user:pass@localhost/providers_drupal',
      'civicrm' => 'mysqli://user:pass@localhost/providers_civicrm',
    );
and that's it--leave the rest as it is. What happens when you try that?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

kgilnack

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
    • a beautiful mix of Drupal & CiviCRM.. when things are going right
Re: Quick help w settings.php
May 23, 2010, 05:51:56 pm
Don't I feel silly - went back to the settings.php.new, which I I saved after it wouldn't work and found I was missing a single apostrophe in " 'civicrm => '...". I knew this problem shouldn't be complex and am sorry about my lack of attention to detail.  Thanks for the help.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Quick help w settings.php

This forum was archived on 2017-11-26.