Topic: phpBB setup problems

[drdyno]

I am installing PHPBB2 on my site and when I click "Install" I receive this message: "The PHP configuration on your server doesn't support the database type that you chose"

I am using a MY SQL database and I don't get it I am following the instructions and still now good. Any ideas?

Apache 2.2.3
PHP 5.1.6
MySQL 5.0.24

[James Blond]

Did you enable php_mysql.dll in php.ini ?

[Steffen]

Maybe you can try the test scriptmysqlinfo.php: www.apachelounge.com/download/mysqlinfo.zip . This script should tell you if your php/mysql setup is ok. It gives hints when there is something wrong.

Steffen

[drdyno]

ok, I have done those 2 things.. not sure what it is that I am looking for in the mysqlinfo but you can take a look at it
http://www.act3d.com/mysqlinfo.php

Dyno

[drdyno]

well i got past that error now it tells me it cannot connect to the database.

the last time I installed phpbb it went nice and smooth.. now i get crap.
thank for your help in advance.

Jeff

[James Blond]

it cannot connect to the database
Did you created the databese before running the setup for phpBB?

[Steffen]

I looked at your mysqlinfo.php output:

Mysql version: 5.0.24-community-nt

and

At the phpinfo:

Client API version 4.1.12

So that is a version mismatch !!

You must have somewhere an old libmySQl.dll or leftover from a previous install.

Try to find libmySQl.dll in your system (c:/windows; c:/windows/system32; c:/php etc.) and be sure that there is a version equal to the one in yor mysql/bin folder.

Steffen

[drdyno]

ok fixed the version error just had to replace the libmysql.dll in the system32 folder.

still getting the error that it cannot connect to the database though, I guess i'll keep plugging along at it and figure it out.

Thanks,
Jeff

[ali_fareed]

you should probably remove the script or restrict access to it because it's giving a lot of information about your server like internal paths , your internal ip address, environment variable paths even sql options this can help an attacker a lot

[Ninko]

Hi there,
I'm having a mysql problem. I tryed the 2 test scripts that Steffen was talking about, and basically it said php_mysql.dll wasn't loaded, but php_mysqli.dll was loaded. Yet both are in the same folder (extensions) and both are enabled:

extension=php_mysql.dll
extension=php_mysqli.dll

Anyone any ideas?

Thanks

[skindu26]

FOR THOSE WHO TRIED INSTALLING APACHE,PHP AND MYSQL BEFORE AND FAILED TO CONNECT

1) Search My Computer for php.ini..If found delete all the instances.
2) Search My Computer for libmysql.dll..If found delete all the instances.
3) Delete Previous Installations directories of Apache, PHP and MySQL. Go to Step 5
4) If you have installed PHPDEV and want to try this Standalone installations Go To
Start->
Run->
type regedit->
Go To the Following Key: HKLM/CurrentControlSet/Services/dev4_* or dev5_*----* represents the version number of phpdev
Delete the Key.
Delete phpdev installation Directory and Startmenu Directory.
Do the Steps 1,2 and 3 above.
5) Restart the Computer.


FOR FRESH INSTALLATION AND THOSE WHO HAVE ADOPTED THE STEPS ABOVE.
1) Install Apache - www.apache.org - VERSION 2.2.4--(recomend version 2+)

2) Choose Custom installation and install it into directory C:\Apache

3) Install Mysql - www.mysql.com - VERSION 5.0.41 -(recomend version 5+)

4) Choose Custom installation and install it into directory C:\MySQL

5) Download PHP5(Not Windows Installer but only Zip binaries-VERSION 5.2.2)

6) Unzip into C:/php - www.php.net - (recomend version 5+)

7) Configure Apache>Edit http.config from Directory C:\Apache\Conf\ and do the following:

For Apache version 2.2.4 Add To the http.config file

1) Find 'DirectoryIndex index.html' in dir_module and change it to:
<IfModule dir_module>
DirectoryIndex index.html index.php
</IfModule>

2) Insert the following lines inside <IfModule mime_module> below AddType application/x-gzip .gz .tgz
# Load php module
LoadModule php5_module c:/php/php5apache2_2.dll (!!!!Front Slashes please)
AddType application/x-httpd-php .php




Config php

1) Copy the 'php5ts.dll' from "C:\php\" to the bin dir in the Apache main dir
(C:\Apache\bin)

2) Copy the 'php.ini-dist' from "C:\php\" to "C:\Windows" and rename it as 'php.ini' (Don't Move)

3) Open C:\Windows\php.ini

Set extension_dir:
extension_dir = "C:/php/ext/" (!!!!Front Slashes please)
Find and remove the ';'
;extension=php_mysql.dll

4) Copy the 'libmysql.dll' file from "C:\php\" to C:\Windows



*** NO NEED FOR ANY OTHER SETTINGS AND NO NEED FOR ANY PHP.INI IN PHP INSTALLATION PATH..
*** NO NEED FOR ANY CHANGES IN THE PHP DIRECTORY APART FROM THE ONE'S EXPLAINED ABOVE ..
*** DON'T TEST UNTIL THE COMPLETION OF ALL THE CHANGES ABOVE

RESTART THE COMPUTER SEE IT WORKS.....BEST OF LUCK....

FOR TESTING PURPOSE NOW...
1) Ensure Apache Server is running...
2) Open a Notepad and Type:
<?
phpinfo();
?>
3) Save it as info.php at "C:\Apache\htdocs\"
4) Open your browser and type http://localhost/info.php
5) PHP information pages will be displayed in the browser and you have successfully integrated everything.
6) If the page displays blank, then flush the browser cache
7) Open C:\Windows\php.ini for editing
Find the setting short_open_tag and Change its value to On if Off.
9) If it still displays blank page
10) Open a Notepad and Type:
<?php
phpinfo();
?>
11) Save it as info1.php at "C:\Apache\htdocs\"
12) Open your browser and type http://localhost/info1.php
13) PHP information pages will be displayed in the browser and you have successfully integrated everything.


AND LAST BUT NOT THE LEAST..I WISH TO INFORM YOU ALL THAT I AM A NEWBIE THAT TRIED THE INTEGRATION OF APACHE,PHP AND MYSQL FOR DEVELOPING A FORUM...THESE PIECES OF INFORMATION IS COLLECTED FROM VARIOUS SUPPORT WEBSITES AFTER STRUGGLING FOR MORE THAN 16 HOURS OF CONTINOUS SITTING IN FRONT OF MY PC TO FIND A WAY OUT FOR CONFIGURING INSTEAD OF USING EITHER APPSERVER OR PHPDEV.. I TRIED ATLEAST 25 TIMES INSTALLING AND UNINSTALLING ALL THESE APPLICATIONS.. WHEN I GOOGLED "THE PHP CONFIGURATION DOES NOT SUPPORT THE DATABASE YOU CHOSE" AFTER INSTALLATIONS, I FOUND 100's of SUPPORT FORUMS HAVE BEEN ADDRESSED FOR A SOLUTION TO THIS..
SO I THOUGHT IT FIT TO SHARE MY SUCCESSFUL CONFIGURATION WITH WHICH I WAS ABLE TO INSTALL PHPBB 2.0.22 DATABASE IN THE ABOVE APACHE, MYSQL AND PHP SERVERS.

[Bruce]

for MySQl copy you php.ini_recommended to your windows dir save as php.ini

in you php.ini put
extension_dir = "C:/PHP/ext/"
extension=php_mysql.dll
in httpd.conf put
LoadModule php5_module "C:/php/php5apache2_2.dll"

AddHandler application/x-httpd-php .php
PHPIniDir "C:/Windows/"
DirectoryIndex index.php index.htm index.html

set windows environment variables to PHPRC C:\windws\
copy libmySQL.dll from MYSQL server bin to Apache bin

to install phpbb
create database name
make user name and pass then in you mysql admin setup user connection
in tools manage connection us your IP for the host
set globel permission for your username to the database that you created
if MYSQL admin dos not have globel permission then set permission to mysql database and information\_schema for the user name pass to your MYSQL server
in you phpbb config file enter database name username pass and in host put your IP
save as conf.php

for fast and simple MYSQL editing try out heidisql
http://www.heidisql.com/screenshots.php
downloads
http://www.heidisql.com/download.php

this all work for my phpbb install
Bruce