CiviCRM Community Forums (archive)

Hi All,

IM trying to install CiviCRM on my dev site and I was following the directions on CiviCRM website on how to install. Because Pantheon uses a newer version of MySQL, they say I should add the following code to MySQL:

-- Assuming a database called "civicrm" and a user called "civicrm_user"
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, TRIGGER, CREATE ROUTINE, ALTER ROUTINE ON civicrm.* TO 'civicrm_user'@'localhost' IDENTIFIED BY 'realpasswordhere';

Now I am a newbie, so I connected to MySQL and ran the code changing local host to the host pantheon gave me and put in the password pantheon assigned me. But it doesnt work. I also changed civicrm.* to pantheon.* because I know pantheon doesnt allow you to have more than one database. I also tried changing user name from civicrm_user to pantheon to try that. I keep getting this error though:

Error Code 1044: Access denied for user 'pantheon'@'%' to database 'pantheon'

Any help for a newbie?? 

Thanks

Pantheon is different than most hosts.  As @ j0sh1314 pointed out, because of the integrated dev -> test -> live workflow, you cannot simply create additional databases or grant additional users access to the databases.   Each environment uses a different MySQL user to connect to a different database.  That everything you need to connect to MySQL, Git, and/or SFTP is available in under the Connection Information button in the Pantheon Dashboard.  Clicking on that button while in the dev environment will show the dev connection info, test will shows test, etc. 

To get CiviCRM to run on Pantheon, you must add the civicrm_ tables to the same database as the Drupal tables.  This may annoy many sysadmin types, but it's the trade off for having a low cost, web controlled staging workflow. 

Unfortunately, understanding how Pantheon's databases are configured isn't enough to get CiviCRM running.  If you look at the Drupal setting.php file, you'll notice that the same file is used in all the environments using variables instead of hard coded connection information...

http://helpdesk.getpantheon.com/customer/portal/articles/708588-working-with-settings-php

You have to do the same thing for the civicrm.settings.php file.

https://drupal.org/project/civicrm_starterkit includes patches to that the civicrm.settings.php includes the necessary Pantheon specific configuration information when CiviCRM is installed https://dashboard.getpantheon.com/products/civicrm_starterkit/spinup.  We're also patching the way sessions are managed during the install and taking advantage the fact that user the web server is running as can write to /sites/default/ during the initial configuration.  After the install, the files in /sites/default/ are read only.  The web server can only write to /sites/default/files.

The Pantheon specific patches are clearly labeled in the .make http://drupalcode.org/project/civicrm_starterkit.git/blob/refs/heads/7.x-4.x:/drupal-org.make#l25

Unfortunately, while it is possible to switch between install profiles/distributions using a module like https://drupal.org/project/profile_switcher or manually adjusting variables and database settings, that won't change where your Pantheon site is looking for upstream updates so you won't be able to take advantage of one click installs of CiviCRM updates

http://helpdesk.getpantheon.com/customer/portal/articles/1150064-running-a-custom-distribution-on-pantheon

The CiviCRM Start Kit includes several Drupal modules that make is easier to run CiviCRM on Pantheon including https://drupal.org/project/civicrm_cron and https://drupal.org/project/civicrm_clear_all_caches.

So while you can do it on your own, it's a heck of a lot easier if you switch from an the standard D7 upstream drop to the CiviCRM Start Kit. 

I'd be glad to barter my time helping you make that switch with your time improving the CiviCRM Starter Kit documentation.

Thanks Chris and Keynen!

Kreynen, so you think it would be easier to migrate my site to the CiviCRM starter kit than to patch it? If so (or either way), Id love your help and would be willing to help with the documentation for this with the knowledge that I am quite a novice at all this, but I will do my best.

Let me know if that works!

Thanks
Josh

Unfortunately changing the upstream source of a Pantheon site is actually much more complicated than I thought.  I thought this would be as easy as...

git remote set-url origin http://github.com/kreynen/civicrm-starterkit-drops-7
But you can't change that in the git repo for the dev environment... only on your local clone.  I asked Pantheon about changing that...

http://help.getpantheon.com/pantheon/topics/is_it_possible_to_change_the_upstream_distribution_an_existing_install_is_using

Their response is that while you could add profiles/civicrm_starterkit to the profiles on your site and merge it into the updates coming from the D7 Standard upstream, you wouldn't be able to apply CiviCRM updates this way.  So the process involves starting a new site on Pantheon and would look something like...

• Start a new CiviCRM Starter Kit site on Pantheon
• Download the code, files, and database Backups from the existing site
• Using Git or SFTP, upload your modules, themes, and libraries to sites/all/modules
• Upload the database and files to the new site using the Workflow import option. When you replace the initial install database, Drupal will forget about modules in /profiles/civicrm_starterkit including CiviCRM.  Only modules from an active profile even show up in the admin/modules/list to be enabled.  The standard Drupal profile doesn't include any modules in the profile (the are in the core /modules).  The Standard profile simply enables more modules by default than the Minimal profile.
• At this point your site should look the way it did on the original Pantheon instance
• Add https://drupal.org/project/profile_switcher to your sites/all/modules and enable.  This module is included in the CiviCRM Starter Kit, but (again) until you enable that profile, the module won't show up in admin > modules > list
• Switch the profile to civicrm_starterkit using Admin > Configuration > Development > Profile Switcher
• Once the CiviCRM Starter Kit profile is enabled, the list of modules will include the modules in the profiles/civicrm_starterkit/moderate.  Enable and configure CiviCRM the same way you normally on any other install

Because the install is using the version of CiviCRM from the Starter Kit, it CiviCRM will be aware that it is being installed on Pantheon and adjust the settings to your civicrm.settings.php file appropriately. 

If you want to remove modules from your sites/all/modules directory that may be overriding the same module that's now being maintained as part of the distribution, you can use https://drupal.org/project/profile_status_check to find those modules.  When you remove them from your sites/all/modules, Drupal will use the version in profiles/civicrm_starterkit/modules.   

JF, that error is telling you that the database CiviCRM is configured to use does not have a 'civicrm_domain' table.

This might indicate that the CiviCRM schema is not loaded, OR that the wrong database has been addressed in CIVICRM_DSN in your civicrm.settings.php?