Author Topic: Moving CiviCRM from one directory/database to another (Read 3787 times)

pedalinfaith · August 08, 2007, 03:50:18 pm

Hi,

I prototyped a Joomla website, which included CiviCRM. I'm trying to move that website to its production location, but when I'm in the Joomla Administrator and select "Components" --> "CiviCRM" --> [anything], I get the following error:

Error Details:

[db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::handle prefix="" info=" [nativecode=Access denied for user 'bfjung_joom2'@'localhost' (using password: YES)]"]

I've changed the database and username in the civicrm.setting.php file. I suspect my problem is that my new database user password is different. It appears that CiviCRM stores this password encrypted in that same file. But I don't know how to change this string to represent the new db user password.

Where/how do I inform the CiviCRM configuration of its new database password?

Kind regards,
Alyson

Donald Lobo · August 08, 2007, 04:24:41 pm

In Joomla there are two files where CiviCRM stores the password

1. administrator/components/com_civicrm/civicrm.settings.php
2. components/com_civicrm/civicrm.settings.php

Please edit and change both the files. In each file there are two places where the password is stored:

define( 'CIVICRM_UF_DSN' , 'mysql://DBUSER:PASSWORD@HOSTNAME/DATABASE?new_link=true' );
define( 'CIVICRM_DSN' , 'mysql://DBUSER:PASSWORD@HOSTNAME/DATABASE?new_link=true' );

Please fix the user/password/hostname/database on both those lines and you should be all set

lobo

pedalinfaith · August 08, 2007, 06:26:54 pm

Ah! Yes, I missed the other settings file. Thanks!

OK, I'm getting closer. Now when I attempt, in the Joomla Administrator, to go to Components --> CiviCRM --> [anything], it mostly loads the page but for a series of errors that look like

Warning: mkdir() [function.mkdir]: Permission denied in /home/bfjung/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/File.php on line 114

Warning: mkdir() [function.mkdir]: No such file or directory in /home/bfjung/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/File.php on line 114

I'm assuming that either it can't find the mkdir function or that the directory in which I'm trying to make a new directory doesn't have its permissions set correctly. If I knew what directory that is, I could change it. But I'm stabbing in the dark.

Thanks for any help,
Alyson

Donald Lobo · August 08, 2007, 07:18:12 pm

Goto:

CiviCRM >> Administer CiviCRM >> Global Settings >> Directories

and adjust the directory paths on that screen to match your new machine information

lobo

pedalinfaith · August 08, 2007, 07:25:48 pm

Worked like a charm! Thanks so much for your help. I'm looking forward to getting to know the bells and whistles.

pedalinfaith · August 08, 2007, 07:31:05 pm

OK, something looks a little fishy. I haven't come across any broken functionality yet, but when I go to "Find Contacts" and search on a name, I notice that when the page is loading, the status bar in the browser says, "Transferring data from bfjung.org" (which would be correct, and at the end it says "Read pedalinfaith.com" (which is incorrect since that's the old prototyping site).

I can't imagine that it actually is getting anything from pedalinfaith.com since it doesn't have permissions. However, one never knows and soon I'm going to take down the prototype site.

Any ideas where leftover references to the old location might still be?

Thanks,
Alyson

pedalinfaith · August 08, 2007, 07:42:37 pm

Got it! I had to also change the "Resource URLs" in the Administrator screen.

Thanks again for your help,
Alyson

pedalinfaith · August 08, 2007, 07:48:17 pm

Hrmmmm, something else now. At the "Administer CiviCRM" --> "Global Settings" --> "CiviCRM Resource URL", there is a little "?" (help icon). But when I hover over it, the pop-up says something like

Error loading
http://bfjung.org/administrator/components/com_civicrm/civicrm//extern/ajax.php?q=civicrm/help&id=re...
(500 Internal Server Error)

Ideas?

Regards,
Alyson

Kurund Jalmi · August 09, 2007, 04:19:39 am

Alyson:

Can you see image icons in Adminster CiviCRM, if not then you have entered incorrect resource url. Do check you resource url.

kurund

pedalinfaith · August 09, 2007, 08:09:45 am

Hi, Kurund.

Yes, I can the image icons. The problem seems to be limited to the "?" (help) pop-up messages.

Regards,
Alyson

Kurund Jalmi · August 09, 2007, 11:48:32 pm

Alyson:

Try clearing your browser cache. Also may be using FireBug (firefox plugin), give us exact error that it generates.

thanx

kurund

CiviCRM Community Forums (archive)

News:

Author Topic: Moving CiviCRM from one directory/database to another (Read 3787 times)

pedalinfaith

Moving CiviCRM from one directory/database to another

Donald Lobo

Re: Moving CiviCRM from one directory/database to another

pedalinfaith

Re: Moving CiviCRM from one directory/database to another

Donald Lobo

Re: Moving CiviCRM from one directory/database to another

pedalinfaith

Re: Moving CiviCRM from one directory/database to another

pedalinfaith

Re: Moving CiviCRM from one directory/database to another

pedalinfaith

Re: Moving CiviCRM from one directory/database to another

pedalinfaith

Re: Moving CiviCRM from one directory/database to another

Kurund Jalmi

Re: Moving CiviCRM from one directory/database to another

pedalinfaith

Re: Moving CiviCRM from one directory/database to another

Kurund Jalmi

Re: Moving CiviCRM from one directory/database to another