DB problem using JoomlaPack Kickstart to move files to remote MAMP server

[honeyl]

Hi,

I'm using JoomlaPack's Kickstart to move a production server to a local MAMP 1.7.2 test server on my MacBook Pro. After placing my JPA backup file and the kickstart.php file in the fresh htdoc directory of MAMP, the transfer process goes fine. It changes the Joomla config file to the local server paths, and I'm able to open Joomla Admin no problem.

I then changed all CiviCRM config files to replace paths of the production server with those of the local server. I did this by searching for the base path of the production server in all files of the htdoc directory, so I know I got them all.

However, when I try to open up CiviCRM, it gives me the following error, with the directory on the first line that of the production server:

Code: [Select]

Error: Could not create directory: /home/username.
If you have moved your database from a development install to a production install and the directory paths are different, please set the column config_backend in the civicrm_domain table to NULL. You will need to reinitialize your settings in the production install.
However, I checked the civicrm_domain table, and the config_back column was already set to NULL.  I scoured the forums, and tried one suggestion about deleting the Config.IDS.ini that contains cached paths, but it didn't work.

I'm writing installation instructions as I go through this, and I feel like I'm almost there, but I can't quite solve this problem with the database.  Seems lots of people are encountering this problem, on both Joomla and Drupal. Any help would be appreciated.

[Donald Lobo]

i assume /home/username is a directory on your local install but not on the production server

if so, there is at least one place in the production install that has the value. i'd do the following:

1. delete all files from media/civicrm

2. double check and ensure that config_backend from civicrm_domain is null

3. double check and ensure that there is no /home/username in administrator/components/com_civicrm/civicrm.settings.php AND components/com_civicrm/civicrm.settings.php

lobo

[honeyl]

i assume /home/username is a directory on your local install but not on the production server

No, just the opposite. It's on the production server, but not on the local.

3. double check and ensure that there is no /home/username in administrator/components/com_civicrm/civicrm.settings.php AND components/com_civicrm/civicrm.settings.php

I went into both and made the changes, and then just to make sure, did a search of file contents in htdoc for "/home/username," and found nothing. I've also checked the database three times, and it's set on Null. I'll try the media files delete you suggested. If you think of anything else, please let me know.

[honeyl]

1. delete all files from media/civicrm

This had no effect as well.

[Donald Lobo]

ok if

/home/username is on the production server, then you should see it in the various settings files, right? (specifically in the CIVICRM_TEMPLATE_COMPILEDIR define)

most likely the web server does not have either read or write access to /home/username/..../media.

the error is reported by: CRM/Utils/File.php, line 115. You might want to add some debug statements there and figure out what is happening. Please do report back with your findings

lobo

[honeyl]

ok if

/home/username is on the production server, then you should see it in the various settings files, right? (specifically in the CIVICRM_TEMPLATE_COMPILEDIR define)

Lobo, I just want to make sure we're on the same page here. The /home/username/ part of the path was (and still is) on the production server, which is where I made the JoomlaPack backup. I then moved the backup file to the test server, which is where I'm having the problems. I changed the /home/username/ to the MAMP path (/Applications/MAMP/htdocs/) in both configuration files. I then searched the contents of all files in the htdocs directory for any remaining instances of /home/username, and there are none. I saw them originally, but they've been changed, yet the error message persists.

[honeyl]

ok if

the error is reported by: CRM/Utils/File.php, line 115. You might want to add some debug statements there and figure out what is happening. Please do report back with your findings

Found the code on line 115, but I'm not a programmer and don't know how to add debug statements. If you send me a quick slice o' code, I'll put it in there and let you know what comes back. Thanks.

[Donald Lobo]

If you can give us ssh access to the server we can take a look at it and figure out what happening. (i still think there is /home/username in one of the config files/db)

ping us on irc once u have a valid ssh account for us along with the permissions

thanx

lobo

[honeyl]

Lobo,

Our host won't even give *me* SSH access, so what I'll do instead is send you a personal message with a link to a zipped folder containing the two CiviCRM settings files as well as a screen shot of the database column in question. Besides, the problem is on my localhost MAMP, not on the production server.

Thanks for taking the time to help me with this.

[honeyl]

OK, I opened up the config_backend column of the civicrm_domain table and found two variables where the URL needed updating:

userFrameworkResourceURL and imageUploadURL

and three where the full path to the media folder needed changing:

uploadDir, imageUploadDir, and customFileUploadDir

Changed all of these, and when I go back to CiviCRM, the warning message goes away. In its place is a blank white screen with nada in view source.

Since I earlier deleted all files in the media/civicrm directory, should I try reinstalling from scratch? Or is there something else I should try first?

[Donald Lobo]

sorry, cant really help a lot here without access to the server etc

when you figure it out, please let us know what happened and why.

you should be able to see the errors in your apache log for the white screen issue

lobo

[honeyl]

sorry, cant really help a lot here without access to the server etc

I certainly understand and I'm working on setting up a SSH tunnel for you now. I'll let you know in a message when it's ready.

In the meantime, look what I found as a consistent error in the PHP logs. It's beginning to look more like a permissions problem now.

Code: [Select]

[13-Jul-2009 09:13:41] PHP Warning:  Invalid argument supplied for foreach() in /Applications/MAMP/bin/phpMyAdmin/tbl_replace.php on line 142
[13-Jul-2009 09:14:57] PHP Notice:  unserialize() [<a href='function.unserialize'>function.unserialize</a>]: Error at offset 108 of 3364 bytes in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php on line 155
[13-Jul-2009 09:14:57] PHP Notice:  Undefined index:  dateformatQfDatetime in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php on line 163
[13-Jul-2009 09:14:57] PHP Notice:  Undefined index:  dateformatQfDatetime in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php on line 163
[13-Jul-2009 09:14:57] PHP Notice:  Undefined index:  dateformatQfDatetime in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php on line 163
[13-Jul-2009 09:14:57] PHP Notice:  Undefined index:  dateformatQfDatetime in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php on line 165
[13-Jul-2009 09:14:57] PHP Notice:  Undefined index:  dateformatQfDatetime in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php on line 165
[13-Jul-2009 09:14:57] PHP Notice:  Undefined index:  lcMonetary in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php on line 168
[13-Jul-2009 09:14:57] PHP Notice:  Undefined index:  lcMonetary in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php on line 168
[13-Jul-2009 09:14:57] PHP Notice:  Undefined index:  lcMessages in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php on line 237
[13-Jul-2009 09:14:57] PHP Fatal error:  Uncaught exception 'Exception' with message 'Please make sure the IDS/tmp folder is writable' in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/packages/IDS/Monitor.php:187
Stack trace:
#0 /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/IDS.php(131): IDS_Monitor->__construct(Array, Object(IDS_Init))
#1 /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(74): CRM_Core_IDS->check(Array)
#2 /Applications/MAMP/htdocs/administrator/components/com_civicrm/admin.civicrm.php(45): CRM_Core_Invoke::invoke(Array)
#3 /Applications/MAMP/htdocs/administrator/components/com_civicrm/admin.civicrm.php(22): civicrm_invoke()
#4 /Applications/MAMP/htdocs/libraries/joomla/application/component/helper.php(162): require_once('/Applications/M...')
#5 /Applications/MAMP/htdocs/administrator/includes/application.php(136): JComponentHelper->renderComponent()
#6 /Applications/MAMP/htdocs/administrator/index.php(67): JAdministrator->dispatch('c in /Applications/MAMP/htdocs/administrator/components/com_civicrm/civicrm/packages/IDS/Monitor.php on line 187


[honeyl]

Further information:

I completely trashed the MAMP installation, reinstalled, then moved my Joomla files into htdocs via a zipped export and FTP download.

Unpacked files, changed settings in both Joomla config and CiviCRM config files, imported database into MySQL.

Get the same white screen and same PHP error log as above. I've ruled out in any problems with JoomlaPack and kickstart.

I still suspect a permissions problem, but don't know how to go about fixing it.

[honeyl]

My last post this thread:

Bottom line? Do NOT use MAMP to set up a Joomla/CiviCRM combo. The Joomla part works fine, but CiviCRM does not work with MAMP for some reason.

I tried an absolute clean install of Joomla 1.5.11 yesterday -- no legacy code at all from production server -- and that worked fine. Then tried to clean install 2.2.7 inside that using both directory and URL installation. Neither one work. At all.

If you've used MAMP successfully with CiviCRM, I'd like to hear about it, cause I don't think it's possible.

[petednz]

Yes have MAMP working on my mac happily with Drupal and CiviCRM - so noting that you are using Joomla I am just trying to confirm that CiviCRM and MAMP is a goer (but don't presume I know why!)