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) »
  • Drupal database does not exist? Error in 2.2.5. What the heck?
Pages: [1]

Author Topic: Drupal database does not exist? Error in 2.2.5. What the heck?  (Read 1454 times)

oban

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 2
Drupal database does not exist? Error in 2.2.5. What the heck?
June 17, 2009, 01:40:59 pm
Ok.

I've been at this issue for 2 days now. I simply cannot install 2.2.5 on XAMPP stack or Acquia stack. I have come up the same error again and again: the Drupal database does not exist. I enclosed a screenshot so you can see it too.

Trust me. The database seen in that capture, drupal_6 does exist.

What the heck is going on?



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: Drupal database does not exist? Error in 2.2.5. What the heck?
June 17, 2009, 01:49:16 pm

your best bet would be to add debug code at: install/index.php, line 153

You can also call the function mysql_error in your message to get more details

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

oban

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 2
Re: Drupal database does not exist? Error in 2.2.5. What the heck?
June 17, 2009, 03:01:46 pm
Quote from: Donald Lobo on June 17, 2009, 01:49:16 pm

your best bet would be to add debug code at: install/index.php, line 153

You can also call the function mysql_error in your message to get more details

lobo


I'm not sure how to debug. I could use some pointers. I did the most basic thing I could.

I did a var_dump on mysql_error and $req object.

var_dump(mysql_error()) returned bool(false).

var_dump($req->hasErrors()); returned int(0).

var_dump($req) returned


Code: [Select]


object(InstallRequirements)#1 (3)
{
    ["errors"]=>; NULL ["warnings"]=>; NULL ["tests"]=>; array(2)
    {
        ["PHP Configuration"]=>; array(3)
        {
            ["PHP5 installed"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(22) "OK (PHP version 5.2.9)"
            }
            ["MySQL support"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            ["Memory allocated (PHP config option 'memory_limit')"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(9) "OK (256M)"
            }
            
        }
        ["File permissions"]=>; array(10)
        {
            ["Does the webserver know where files are stored?"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(71) "OK (C:/Users/Picardo/Sites/drupal-6/sites/all/modules/civicrm/install/)"
            }
            ["CRM folder exists"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            ["packages folder exists"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            ["templates folder exists"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            ["js folder exists"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            ["api folder exists"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            ["i folder exists"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            ["sql folder exists"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            ["Is the sites/default/files folder writeable?"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            ["Is the sites/default folder writeable?"]=>; array(2)
            {
                [0]=>; string(4) "good" [1]=>; string(2) "OK"
            }
            
        }
        
    }
    
}


« Last Edit: June 17, 2009, 03:10:26 pm by picardo »

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: Drupal database does not exist? Error in 2.2.5. What the heck?
June 17, 2009, 08:16:25 pm

in 2.2 it is line 552

add:

var_dump( mysql_error( ) );
echo "<p>";
var_dump( mysql_errno( ) );
echo "<p>";
var_dump($conn );
exit( );

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

oban

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 2
Re: Drupal database does not exist? Error in 2.2.5. What the heck?
June 17, 2009, 08:42:07 pm
Quote from: Donald Lobo on June 17, 2009, 08:16:25 pm

in 2.2 it is line 552

add:

var_dump( mysql_error( ) );
echo "<p>";
var_dump( mysql_errno( ) );
echo "<p>";
var_dump($conn );
exit( );

lobo



Here is the response:


string(60) "Access denied for user ''@'localhost' to database 'drupal_6'"

int(1044)

resource(10) of type (mysql link)


Edit: I think I fixed it by changing the username on the Druppal database to 'root' from drupal. I wonder if filling in these fields automatically is very useful, because they seem to be very authoritative, and I didn't realize they weren't correct until I saw that error message. Maybe the next version could have a tooltip, or a few sentences to explain what the username is and where to find it.
« Last Edit: June 17, 2009, 08:47:37 pm by picardo »

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Drupal database does not exist? Error in 2.2.5. What the heck?

This forum was archived on 2017-11-26.