CiviCRM Community Forums (archive)

Hi All!
I am struggeling to make this happen:
1 Drupal 5.7 installation with separate database, let´s call it www.abc.xxx
1 Drupal 5.7 installation with separate database, let´s call it www.xyz.xxx
1 civicrm 2.05 installation with seperate database, supposed to keep contacts for www.abc.xxx and www.xyz.xxx

I made sure, that the civicrm.settings.php in the indiviuals sites/defaults/ sections of the two installations are identical, and only deferr when it comes to the

define( 'CIVICRM_UF_DSN'.... statement, which obviously has to point to the databases of www.abc.xxx and www.xyz.xxx


So it works fine, with one Drupal installation, let´s say with www.abc.com. I can set all the settings in the Global settings section the way I want. I can also find existing contacts and copy them from the drupal database into the civicrm-Database. I can set the suffix of the database, which is ABC.
Then I go to the second installation. It opens, but shows an error at the browser buttom line. I can go to the global settings section, and then I start to struggle. Obviously I want all users pictures in one directory, not individual on each related installation. Secondly I am struggeling how to set the suffix, which for the second installation is XYZ. When I do so, still no contact can be found within the second installations database.

The error message while loading each page on www.xyz.xxx on the bottom line of the browser disappears, when I set the CIVICRM Ressource URL to the www.xyz.xxx/sites/all/modules/civicrm/

My problem is: since the value of this ressources URL is stored in the civicrm-database in table userFrameworkResourceURL, so how can this database serve two installations? Or am I walking into the wron direction?
I was searching in the installations manual, but I am sorry to say, this was not really helpfull. There is a line mentioned supposed to be fnd in the Drupal setting.php, saying
$db_url[CRM:'civicrm'] = 'mysql://.............user:pswd@domain/databasename';
This cannot be found in any of my two Drupal settings.php. Does it mean, that this line with the related information for user, pswd, domain and databasename needs to be added to the settings.php?

Any help would be highly appreciated, because I am really stuck.

 
That are really bad news, because this was the main reason why I went away from the Drupal profiles section to CIVICRM, since I thought it would be very nice to have the members of the two sites in one db, while the two insome way different, in some way very similar contents are located in two other installations.

Any idea, when this id going to be fixed, if at all?

At this stage we are not sure if we will reintroduce this feature and enable multiple sites to share the same civicrm db

if this is essential to you, you might want to consider sponsoring this feature for the 2.2 release

lobo

I know we moved the settings file into the database... that was a good thing.

Any way we can allow "special cases" like multi-site drupal installs to override the database values with a settings file? That way experts can basically take responsibility for constructing their settings file correctly and the vast majority of users can bask in the warm glow of usability provided by settings in the database.

Or is the actual construction of the system now such that you cannot have two instances of drupal point at the same civicrm db? P.S. the original way we did this assumed that the two instances of drupal would share the same users table, which allows CiviCRM to get what it expects... a single user table.

This will need to be a sponsored or community contributed project. If i had to guess, restructuring the code to handle this will be between 100-200 hours of work. This will be part of core and hence supported / upgraded / QA'ed for follow on releases, which the above hours include. Consulting rates and contract on the wiki at:  http://wiki.civicrm.org/confluence/display/CRM/Consulting+Services+Agreement

The multi-org features coming in for PIRG are quite undefined. We expect most of them to be taken care of via "custom PIRG specific" acl hooks, so except for the mailing aspects, i do not expect a lot of multi-org features to appear in 2.2

lobo

Would it be possible to get some of PIRG-specific hooks to be more generalised in 2.2? This is definitely something that would be of value to many voluntary sector orgs in UK where in many larger cities there is a ChangeUp Consortium or similar made up of many Local Infrastructure Organisations. There would be benefits all round if consortia could pull out management reports from across their whole area while LIOs all worked with the same system and could share experiences as well as some data. Most of the LIO client organisations are local to them but some stretch across their boundaries, like a city wide cycling network or faith group.

an hook implementaion by definition is custom based on the few we've done so far (HRD, Greens and USPIRG) each org has a few specific needs and ways of structuring things and so hooks seem significantly better. They are much more scalable also (compared to the current model)

Once we are done with PIRG implementation, we'll see if we can generalize stuff. The code will be public and under AGPL etc

lobo

2.2 will support relative URL's which will allow multiple Drupal sites to access the same CiviCRM db (assuming shared user table for the drupal db). The code for this is already in trunk

i'm not sure what we will do for paypal standard / google checkout in this case, since they need absolute urls. We'll figure it out before the release

lobo