Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By zhaphod on
Hi All
I am trying to setup Drupal for the first time and I am getting some data base configuration problem. I followed the procedure given below:
0. Using Windows machine
1. Installed Apache 2.2.4 to default location
2. Changed doc_root to d:\ApacheDocRoot
3. Manual install of php
3.1 Downloaded the zip package from php.net
3.2 unzipped it in c:\php
3.3 copied php.ini-recommended as php.ini in c:\php
3.4 added c:\php to the environment variable PATH
3.5 set doc_root in php.ini to d:\ApacheDocRoot
3.6 enabled extension=php_mysql.dll
3.7 set session.save_handler = user
3.8 Added following lines to Apache httpd.conf file
PHPIniDir "C:/PHP/"
LoadModule php5_module "C:/PHP/php5apache2_2.dll"
AddType application/x-httpd-php .php
4. Installed MySQL 5.0.37
4.1 mysqladmin -u zhaphod -p create zhaphoddb
4.2 mysql -u zhaphod -p
4.3 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON zhaphoddb.* TO 'zhaphod'@'localhost' IDENTIFIED BY 'password'; {got Query OK, 0 rows affected}
4.4 FLUSH PRIVILEGES;
5. Run install script
5.1 pointed my browser to http://localhost/install.php
And I get the following error:
"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 appreciate any help towards solving this problem.
Have a nice day.
Srini
Comments
some thoughts
synopsis: windows, apache 2.2.4, mysql 5.0.37, php5.?
assuming apache and mysql are running (i forget sometimes, too). the error indicates php is installed (check for index.php in directoryindex in apache's httpd.conf)
what does phpinfo() say? if you scroll down the page, does is indicate mysql as loaded? also, consider using mysqli, if you can. don't forget to restart apache if you make php changes.
if mysql is not indicated as loaded in phpinfo(),
- put ";c:\php;c:\php\ext" into your global system PATH statement (don't forget to restart windows)
- try phpinfo() again.
hope it helps
tm, Thanks for the help.
tm,
Thanks for the help. phpinfo() told me that mysql was not getting loaded. Then I added c:\php\ext to the PATH variable and it solved the problem. I only had c:\php in the PATH.
regards
Srini
PS: Couldnt believe I missed out the php version. It is 5.2.5
system: Zenwalk Linux
system: Zenwalk Linux 2.6.23.12 (Slackware-based), apache 2.2.6, mysql 5.0.51, php 5.2.5
Apache and mysql are started.
I'm getting the same message as the OP with a Zenwalk 5.0 install. Where would phpinfo() indicate mysql being loaded? I'm think I might have seen 'mod_mysql' under 'loaded modules' in the apache2handler table when I first loaded it, but after editing my PATH variable and restarting, I'm definitely not seeing it now - a few entries under 'Configure Command' in the first table are the only mention of mysql I see.
What file do I need to make visible in my PATH? I found a config.php file in /etc/phpldapadmin and a php.ini file in /etc/apache. I've added both folders to the /etc/profile default path line with no change to the Drupal rejection at localhost...
I usually have no trouble
I usually have no trouble installing Drupal on Slackware (my preferred distro). If Zenwalk is identical to Slackware under the hood, you should be OK.
You shouldn't need to add anything to the PATH variable.
phpldapadmin's config file is irrelevant, that's a separate application.
mod_mysql is also irrelevant, that's an Apache authentication module.
If you scroll down the page output by phpinfo(), you should definitely see a section for mysql and/or mysqli.
If it's not there, I'd say you have missed installing a package or something.
Either that or your PHP package doesn't support MySQL.
Or something funny is going on with MySQL. Are you sure its running?
not sure
is there not an "include_path" to be uncommented in php.ini for *nix to get to the extensions? and then, i am wondering if 'mod_mysqli' should be enabled, too (seems to be the preferred for mysql 5.x for drupal). don't forget to restart apache if changes are made.
phpinfo(): mysql/mysqli should be in alpha order after the http headers section, by module. the php core section should indicate where your php.ini settings are coming from.
why mysqli?
There is a line in php.ini 'include_path = ".:/php/includes"' that I just now uncommented. Restarting apache and mysql doesn't change the 'no database support' Drupal message at localhost. Should an apache restart incorporate php.ini changes or do I need to reboot?
I'm not sure I understand the significance of these 'mod_*' labels. Should I see them somewhere other than the apache2handler in phpinfo() (which currently has neither)? How do I enable 'mod_mysqli'?
modules
what does phpinfo() say now regarding the mysql/mysqli being loaded? on the include path; be sure that it has the directory that your mod files are in, that is what it is looking for and pointing to.
the "mod_*" are php extensions... assuming that the extension has be compiled with your php package, you should be able to enable it by uncommenting it in php.ini and restarting apache. rebooting the host should not be necessary.
no mysql extension
The series of smaller tables goes from 'mhash' to 'openssl' with nary a "my*" between them still. So should there be a php extension for mysql? I ran find on the filesystem and there is no mod_mysql or mod_mysqli...
BTW when (re)starting apache it tells me "Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName" I assume this is just a loopback mode and shouldn't affect configuration yet?
modules in nix
maybe the php help will help, because i am getting a little lost.
don't think the loopback should hurt; maybe you can use 'localhost' instead? it usually resolves to the loopback via the hosts file.
another option: if you would rather not deal with the system stuff and focus on drupal, something like xampp might be useful.
Found it!
The line in my php.ini file that I uncommented read:
extension=msql.so
instead of
extension=mysql.so
After an apache restart, the proper Drupal configuration page showed up!
I'll check with the Zenwalk people and see if this is something to fix in the PHP package.
Thanks for your patience. :-)
very good
there is a 'msql' package; very easy to get confused, especially when frustrated and tired.
glad you got it working.