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) »
  • Multisite Install Problem - error after navigation link import
Pages: [1]

Author Topic: Multisite Install Problem - error after navigation link import  (Read 1591 times)

jclemo

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.0.95
  • PHP version: 5.3.10
Multisite Install Problem - error after navigation link import
July 25, 2012, 02:23:31 am
Ok so I'm doing a multisite installation using Drupal 7.14 and Civi 4.1.5
By multisite I mean
Drupal - three sites share the same code base but different databases. As per instructions on drupal site I have set up the first site to be redundant (core) and then the two active sites (site1) and (site2). These all have parked domains directing to them letting Drupal sort out which site to load. Drupal functions fine for all three sites.

Civi- same database and code serving all three sites with the intention of having groups 'core', 'site1' and 'site2' where 'core' is a parent of both 'site1' and 'site2'

Following the Civi multisite install instructions I installed civi for the core site- This functions fine
I then enabled multisite and added the two additional domains into `civicrm_domain`- Again this functions fine on the core site
I then edit the civicrm_navigation.mysql file for the first of the two domains and import it using phpMyAdmin

This seems to have imported ok but when I check the core site which shouldn't have been effected by this Drupal is fine but civi will not load and I get

Fatal error: Maximum execution time of 30 seconds exceeded in /home/mysite/public_html/sites/includes/errors.inc on line 74
Uncaught exception thrown in session handler.
With a load of error code underneath it the two bits that make any sense to me are
PDOException: SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet'
and open_basedir restriction in effect. File(/) is not within the allowed path(s):


This is my second install attempt which allowed my to isolate the problem to after  the navigation import
Any thoughts gratefully received. My skills are at the lower end of the spectrum so if you don't mind please make your posts understandable to a noob

many thanks   

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Multisite Install Problem - error after navigation link import
July 25, 2012, 01:54:42 pm
I think either php (probably) or mysql has been configured with to small a value on

max_allowed_packet

& you need to increase that setting
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

jclemo

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.0.95
  • PHP version: 5.3.10
Re: Multisite Install Problem - error after navigation link import
July 25, 2012, 03:06:06 pm
Thanks - just checking but this would be in the php.ini file?
I don't think I have access to it on the host so will have to contact them?

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Multisite Install Problem - error after navigation link import
July 25, 2012, 03:24:48 pm
looks like mysql
https://www.google.co.nz/search?q=max_allowed_packet&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Multisite Install Problem - error after navigation link import
July 26, 2012, 03:12:15 am
Quote from: jclemo on July 25, 2012, 03:06:06 pm
Thanks - just checking but this would be in the php.ini file?
I don't think I have access to it on the host so will have to contact them?

This is in my MySQL config file. Ask your host about that, yes.
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.

jclemo

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.0.95
  • PHP version: 5.3.10
Re: Multisite Install Problem - error after navigation link import
August 01, 2012, 01:50:01 am
Thanks Hershel and Eileen for your help
Just an update for anyone coming across this post with a similar problem

The MySQL setting was certainly part of the issue. This is changed in the my.cnf file which can be stored in a number of locations

http://www.tutorialsolve.com/2009/08/01/what-is-mysql-configuration-file/

On my host I can't access it but if you access to phpmyadmin you can see the current setting under the variables tab. Mine was set to 1M and I go the host to increase it to 16M.

This got rid of the long error code that was obviously being spat out by MySQL but unfortunately left me with a fatal error message with no real information (again when just trying to access civicrm dashboard the rest of drupal ran fine).

So I returned to googling the 'open_basedir restriction in effect' part of the original error code. This is a php setting that limits the files php can access for security  - apparently it seems to be an issue generally when using subdomains and parked domains as if I understood it "All symbolic links are resolved, so it's not possible to avoid this restriction with a symlink"

http://www.php.net/manual/en/ini.core.php#ini.open-basedir
http://stackoverflow.com/questions/223800/how-can-i-relax-phps-open-basedir-restriction

The host basically disabled the setting for me - this strangely produced initially an error in drupal core and only for the base site
Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(/) is not within the allowed path(s):

 At this point I decided to sleep on the problem which now appears to have resolved itself. Civi is now functioning on the core site I'll continue to config the other multisites and post back any issues but finders crossed
« Last Edit: August 01, 2012, 01:54:38 am by jclemo »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Multisite Install Problem - error after navigation link import

This forum was archived on 2017-11-26.