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) »
  • install.php cannot access new civicrm DB
Pages: [1]

Author Topic: install.php cannot access new civicrm DB  (Read 1084 times)

m.e.

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.0.9
  • CMS version: Drupal 7.9
install.php cannot access new civicrm DB
April 28, 2010, 09:38:34 am
Trying to install 3.1.4 in a Drupal site. I've created a new DB and am specifying the same user as for my Drupal DB. It has all permissions.

The install.php script gives me the green light on all settings, but when I continue with the installation I get this:

Installing CiviCRM...

I am now running through the installation steps (this should take a few minutes)

If you receive a fatal error, refresh this page to continue the installation

Building database schema and setup files...
Cannot open mysql://db_username:password@localhost/db_name?new_link=true: DB Error: connect failed

Any ideas? I'm on a cPanel with Bluehost, if that matters.

I tried not creating the CiviCRM DB and letting the script do it, but it kept telling me the user didn't have CREATE DB permissions. (I gave it all the permissions available to me on cPanel.)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: install.php cannot access new civicrm DB
April 28, 2010, 09:54:30 am
I would ask your host if they can tell you why it's not connecting. If you're certain that the credentials are correct.
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.

m.e.

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.0.9
  • CMS version: Drupal 7.9
Re: install.php cannot access new civicrm DB
April 28, 2010, 10:04:58 am
I had already received the message "Database version and connection settings have been verified and look correct!" - so credentials must be OK.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: install.php cannot access new civicrm DB
April 28, 2010, 11:06:33 am
Then I would ask your host if they can tell you why it's not connecting.
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.

m.e.

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.0.9
  • CMS version: Drupal 7.9
Re: install.php cannot access new civicrm DB
April 29, 2010, 06:45:21 am
I did that, and now I'm in a pickle.

My host claimed they were able to install without a hitch -- but they installed it using a new, dummy Drupal database, not the existing Drupal DB.

I guess I need to remove all the civicrm directories and start over? Or can I just adjust the DB settings somewhere?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: install.php cannot access new civicrm DB
April 29, 2010, 06:51:17 am
One can adjust the DB settings for an existing site, yes. The file to edit is sites/default/civicrm.settings.php

You must adjust several items there, however, including the DB pointers and the directory values. Full instructions are here:

http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location

but the first few steps are not required for you because you're just moving from one install to another on the same server.

But make sure you know what you're doing--what I think you want to do is connect your 'old' Drupal install to the 'new' CiviCRM database that your host made. Then you could remove the 'new' Drupal DB the host made. I think--I can't be sure without seeing everything myself however.
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.

m.e.

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.0.9
  • CMS version: Drupal 7.9
Re: install.php cannot access new civicrm DB
April 29, 2010, 02:13:40 pm
Thanks for the help. It seemed easier to just undo what the server host did and start over. That did work today -- no idea why it couldn't access the DB yesterday.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • install.php cannot access new civicrm DB

This forum was archived on 2017-11-26.