I have problem with "Database configuration". Drupal don't install on my host.

Comments

VM’s picture

Drupal 7.x requires MySQL 5

Drupal 7.x is only for testing and not for production at this time.

Konstantin_by’s picture

I want to test that product but it don't start installation. I use mysql 5.0.45 apache php5.2.6

VM’s picture

you will need to provide more information. Drupal 7.x is updated almost daily, as such ensure you are using the latest 7.x code.

Filippo73’s picture

I have the same problem. When I try installing I have the following answer

Your web server does not appear to support any common database types. Check with your hosting provider to see if they offer any databases that Drupal supports.

I think the problem is in settings.php
This is what I did

<?php
// $Id: default.settings.php,v 1.15 2008/10/06 10:54:15 dries Exp $
...
 $databases['default']['default'] = array(
   'driver' => 'mysql',
   'database' => 'nomedatabase',
   'username' => 'nomeutente',
   'password' => 'password',
   'host' => 'localhost',
 );
...
$databases = array();
$db_prefix = '';
...
$update_free_access = FALSE;
...
ini_set('arg_separator.output',     '&amp;');
ini_set('magic_quotes_runtime',     0);
ini_set('magic_quotes_sybase',      0);
ini_set('session.cache_expire',     200000);
ini_set('session.cache_limiter',    'none');
ini_set('session.cookie_lifetime',  2000000);
ini_set('session.gc_maxlifetime',   200000);
ini_set('session.save_handler',     'user');
ini_set('session.use_only_cookies', 1);
ini_set('session.use_trans_sid',    0);
ini_set('url_rewriter.tags',        '');
...

I downloaded the last release of D7 on friday 7th

p.s.: php and mysql works perfectly. I have an installation of D6 running on the same server with php 5.2.6

VM’s picture

Are you using MySQL 5?

Filippo73’s picture

Yes: 5.0.45
Any idea?
Thank you

VM’s picture

No idea, but it's safe to say that at any time the 7.x-dev can be broken.

I'd keep downloading the lastest nightly build and if the problem continues file an issue using the issue queue for the 7.x version.

Filippo73’s picture

I tried the last release (downloaded 5 minutes ago). Now the problem is

"In your ./sites/default/settings.php file you have configured Drupal to use a mysql server, however your PHP installation currently does not support this database type."

I changed a bit the settings.php.
Now it is just like this

<?php
...
$databases['default']['default'] = array(
   'driver' => 'mysql',
   'database' => 'drupal7',
   'username' => 'drupalusr',
   'password' => 'drpVE08',
   'host' => 'localhost',
 );
$db_prefix = '';
...
$update_free_access = FALSE;
...
ini_set('arg_separator.output',     '&amp;');
ini_set('magic_quotes_runtime',     0);
ini_set('magic_quotes_sybase',      0);
ini_set('session.cache_expire',     200000);
ini_set('session.cache_limiter',    'none');
ini_set('session.cookie_lifetime',  2000000);
ini_set('session.gc_maxlifetime',   200000);
ini_set('session.save_handler',     'user');
ini_set('session.use_only_cookies', 1);
ini_set('session.use_trans_sid',    0);
ini_set('url_rewriter.tags',        '');
...

If you have no idea, can you please give the correct url where to post the issue?
Thank you

Konstantin_by’s picture

I solved that problem for drupal 6.6. I added manually to settings.php " $db_url = 'mysql://username:password@localhost/databasename';" but in d7dev there are no any $db_ur

lungtung’s picture

same here,
i want to install d7 for testing on local

Apache/2.0.63 (Win32)
PHP/5.2.9-1
mysql 5.1.32

all config is correct, but the setup process is not run (at the database config page)

paloczp’s picture

Enable php_pdo.dll and php_pdo_mysql.dll in your php.ini, restart the webserver and try again the install:

; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.
.
.
.
extension=php_pdo.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
.
.

Paul

clscoza’s picture

Spot on Paul!

amariotti’s picture

I looked on my available PHP Extensions that I can install with my webhost and found the following:

Structures_DataGrid
_DataSource_PDO (0.
1.0 beta)

Then I get the following error, due to the fact that the extension is a "beta."

Failed to download pear/Structures_DataGrid within preferred state "stable", latest release is version 0.9.0, stability "beta", use "channel://pear.php.net/Structures_DataGrid-0.9.0" to install
pear/Structures_DataGrid_DataSource_PDO requires package "pear/Structures_DataGrid" (version >= 0.8.4)
No valid packages found
install failed
/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/courier-imap/sbin:/usr/lib/courier-imap/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin

I'm hoping that this error is coming up (even to this date) because this is a small bug that was missed in the dev release last night. Otherwise there will be lots of frustrated new users. :) I'm sure it will be fixed—just a little frustrated because I decided to try to install it for the first time today. Oh well! Maybe tomorrow!

airliner’s picture

I use IIS 7.5 (Win7 Pro x64) with MySQL5.1 and PHP 5.3.

When I try to install, I got this error: SQLSTATE[HY000] [2002] with a timeout message.

The PHP.ini don't look like the "old one" from PHP5.1?!

The IIS should be configured right, because it is possible what kind of installation I want etc (language and so on).
username, password and the name of the database are correct.
Where is my misstake?

Willabee’s picture

  • Use the WPI (Web Platform Installer) for PHP and MySQL (I installed the WordPress application, which installs all the required elements).
  • Create a website pointing to your downloaded and renamed Drupal 7 latest installation folder..
  • In IIS7.5, change the identity of the Application Pool used by the web site to 'Network.Service' and give this user access to '/drupal/sites/default/default.settings.php.
  • Create your database and drupaluser with full permissions.
  • In php.ini, enable extension=php_pdo.dll and extension=php_pdo_mysql.dll
  • Nag the Drupal team to get jQuery 1.4 and jQuery UI 1.8 into the core (I am already testing with these libraries).

Install, Enjoy and feedback your bugs.

salang’s picture

This is a newbie experience. I use xampp-win32-1.7.1-installer and drupal-7.x-dev. It was just a few simple steps and I have successfully installed it in my folder c:\xampp\htdocs\drupal-7.x-dev. Hope my experience may help those still struggling with the installation.

1. Create your database and your username with your password.
Grant full permissions to your username.

2. Go to c:\xampp\htdocs\drupal-7.x-dev\sites\default, make a copy of default.settings.php
and rename it as settings.php.

3. Open settings.php, go to line 154 and modify $databases = array as follows:

$databases = array (
'default' =>
array (
'default' =>
array (
'driver' => 'mysql',
'database' => 'yourdataasename',
'username' => 'yourusername',
'password' => 'yourpassword',
'host' => 'localhost',
'port' => '3306',
),
),
);

4. Run your browser (I use Mozilla Firefox) and enter
localhost\drupal-7.x-dev\install.php. Now you can start to enjoy.

Kgaut’s picture

When installing on my ovh Hosting, i've this message:

SQLSTATE[70100]: <>: 1317 Query execution was interrupted

PHP 5.3
MySQL 5.0.51

I've tried with a1 a2 and Nightly Build, always the same problem!

Do someone face this issue?

Cheers.

Oeil-de-nuit’s picture

Precisely the same thing happens for me dude.

I'm recently booked a hosting service from OVH.com, successfully installed Drupal-6.15, and thought I could give a try to the upcoming 7 version (alpha 1 & 2).

But right after I fill in the database details the install script run for a short while and suddenly outputs :

SQLSTATE[70100]: <>: 1317 Query execution was interrupted

I'm new to Drupal and have very little time to inquire into this, so I can't really provide meaningful details on what's happening. I'm not running it with PHP 5.3 though but rather 5.2.12 : Here's a phpinfo() link : http://thirdeye.copernicus.fr/_phpinfo_.php

The MySQL version is 5.0.90 according to phpmyadmin, whereas the PHP client module is version 5.0.32.

All I can tell after several attempts is that the install script do not halt on a specific table-creation query since at times I get a dozen of these created, and other times only two -_- weird.

Have a nice day ;-)
( Gonna give it another try... )

edit: It really fails randomly on OVH : / Got 6 tables created this time :]

edit: Gave it another try this morning (still on OVH) on a different database server, same problem. For those who have a OVH hosting : I tried using servers : mysql5-5.pro and mysql5-7.bdb.

SebCorbin’s picture

Same thing here, on mysql5-10.start (OVH hosting)

SebCorbin’s picture

Error is coming from the line 1976 of includes/database.inc.
Query was "SELECT 1 FROM information_schema.tables WHERE (table_schema = :db_condition_placeholder_4) AND (table_name = :db_condition_placeholder_5)"

Seems that we do not have access to the information_schema database. Should Drupal take consideration of this behavior and provide a workaround ?
A strange thing is that the error is not about an access denied but "Query execution was interrupted".

Kgaut’s picture

Did someone faced that problem on another hosting provider?

Is the problem reported to ovh yet?

EDIT: I just created a bug repport, feel free to bring your experiences on it.

Kgaut’s picture

problem solved in the fourth alpha of drupal 7! great!

Anonymous’s picture

During database setup I get the following error:

The installation has encountered an error.
Please continue to the error page
An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: http://localhost/d7/drupal-7.0-alpha6/install.php?profile=standard&local... StatusText: OK ResponseText: Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\d7\drupal-7.0-alpha6\includes\database\database.inc on line 960

I am trying a local install on Windows 7. MySQL Version 5.1.36 PHP 5.2.6 Apache 2.2.11

Any help?

TIA,
Dorai

VM’s picture

max execution time is set in php.ini.

selvarajk’s picture

test file