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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Moving CiviCRM from one directory/database to another
Pages: [1]

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

pedalinfaith

  • Guest
Moving CiviCRM from one directory/database to another
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Moving CiviCRM from one directory/database to another
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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

pedalinfaith

  • Guest
Re: Moving CiviCRM from one directory/database to another
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Moving CiviCRM from one directory/database to another
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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

pedalinfaith

  • Guest
Re: Moving CiviCRM from one directory/database to another
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

  • Guest
Re: Moving CiviCRM from one directory/database to another
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

  • Guest
Re: Moving CiviCRM from one directory/database to another
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

  • Guest
Re: Moving CiviCRM from one directory/database to another
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Moving CiviCRM from one directory/database to another
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
Found this reply helpful? Support CiviCRM

pedalinfaith

  • Guest
Re: Moving CiviCRM from one directory/database to another
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Moving CiviCRM from one directory/database to another
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
Found this reply helpful? Support CiviCRM
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Moving CiviCRM from one directory/database to another

This forum was archived on 2017-11-26.