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) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • CiviCRM configuration settings
Pages: [1]

Author Topic: CiviCRM configuration settings  (Read 1248 times)

xcf33

  • I post frequently
  • ***
  • Posts: 181
  • Karma: 7
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.19/6.20
  • MySQL version: 5.x
  • PHP version: 5.2.6
CiviCRM configuration settings
July 12, 2010, 03:06:49 pm
Hi, just scouted the DB and could not find where CiviCRM stores its configuration settings.

I'm referring to those in the configuration checklist, etc.

I need a way to get/set these values from outside of the system.

Any help is appreciated!


Chang
« Last Edit: July 22, 2010, 06:20:33 am by xcf33 »

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: CiviCRM configuration settings
July 13, 2010, 12:48:15 am
Hey,

They are stored in civicrm_domain (in config_backend column), civicrm_preferences and civicrm_preferences_date database tables.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

xcf33

  • I post frequently
  • ***
  • Posts: 181
  • Karma: 7
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.19/6.20
  • MySQL version: 5.x
  • PHP version: 5.2.6
Re: CiviCRM configuration settings (Solved)
July 13, 2010, 06:17:20 am
Thanks lol I see,

I overlooked it because I was expecting many rows of configuration settings rather than one serialized record. :)

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: CiviCRM configuration settings (Solved)
July 13, 2010, 11:15:03 am
You're welcome. :-)
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

xcf33

  • I post frequently
  • ***
  • Posts: 181
  • Karma: 7
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.19/6.20
  • MySQL version: 5.x
  • PHP version: 5.2.6
Re: CiviCRM configuration settings
July 22, 2010, 06:25:34 am
Sorry I think I closed this thread a little bit pre-maturely.

What I'm trying to do is use another way to update the configuration settings.

It seems that civicrm_domain (config_backend) is nothing but a computed field that you can set it to null and the system will regenerate the values.

I'm trying to set the Default FROM Email address as well as adding more FROM Email addresses but cannot find it.

I'm guessing this has something to do with the CRM_Core_Config ?

In addition, I was able to find the SMTP settings in civicrm_preferences but I do not understand where to find "qfKey" as well as it looks like the SMTP password has been encrypted.



Maybe I'm tapping into something too deep?


Any help is appreciated!


Chang
« Last Edit: July 22, 2010, 06:34:40 am by xcf33 »

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: CiviCRM configuration settings
July 22, 2010, 06:38:27 am
Hey,

So you're looking for civicrm_mail_settings table?

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

xcf33

  • I post frequently
  • ***
  • Posts: 181
  • Karma: 7
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.19/6.20
  • MySQL version: 5.x
  • PHP version: 5.2.6
Re: CiviCRM configuration settings
July 22, 2010, 06:43:41 am
Hey Michal,


The civicrm_mail_settings only contains the email handler (for the feedback loop) configurations. :(

Chang

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: CiviCRM configuration settings
July 23, 2010, 07:06:17 am
The code that stores SMTP settings is here: CRM/Admin/Form/Setting/Smtp.php (postProcess method) - you can find hints there on how to handle preferences settings.

From email addresses are stored in civicrm_option_value:
select * from civicrm_option_value where option_group_id = (select id from civicrm_option_group where name like 'from_email_address');

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • CiviCRM configuration settings

This forum was archived on 2017-11-26.