php and mysql... ready to cry

[Anon]

hello,

I'm running a RH 7.2 box and I did just try to install the phpbb2 forum (latest release). I go on getting this error:

"The php configuration on your server doesn't support the database type that you choose"

I'm running mySQL 3.23.49a and PHP 4.0.6. Could you pls tell me what I'm doing wrong?

I'm already using mySQL for other stuff and its up and running fine... also... I've created the database for the phpBB2 forum but ... as you can see...

I've tryed to uncomment in php.ini the msql.so module.... but then when I type 'php' in the shell I get:

[root@mybox php4]# php
Content-type: text/html

PHP Warning: Unable to load dynamic library '/usr/lib/php4/msql.so' - /usr/lib/php4/msql.so: cannot open shared object file: No such file or directory in Unknown on line 0

I'm not sure if this is the (enabling msql.so) is the right way to get things working... but there is not even a file named msql.so on my box.


Thanks in advance for any help or hint you could give me.

[Anon]

I think you're getting confused between dtabases. MySQL and mSQL are two different databases.

You have MySQL whereas your BB package sounds like it needs mSQL.

When you comment in the mSQL module it can't find it as mSQL is not installed.

You will I think need to load mSQL - never having done this it's over to you I'm afraid.

regards,

Fes.

[Anon]

thanks a lot for your kind help. in fact this was what I discovered 1 minute ago :). the forum wants MYsql... I'm sure about this... do you think that when the system was built, php was installaed without mysql support? Is there a way to see this? Will I have to get php again and reinstall it?

thank you so much,
chris

[Anon]

This is the procedure that i have done in my machine. I hope you have time to reconfigure everything...

1. Install REDHAT 7.2

2. MYSQL-3.23.38

./configure –prefix=/usr/local/mysql
make
make install
cd scripts
./mysql_install_db
cd /usr/local/mysql/bin
./safe_mysqld & then hit enter
./mysqladmin –u root password (any password)
./mysql –u root –p
enter password
type SHOW DATABASES;

3. APACHE 2.0.35

CC=”gcc” \
./configure –prefix=/usr/local/apache \
--enable-rewrite=shared \
--enable-speling=shared \
--enable-module=so \
--enable-module=cgi

make
make install
cd /usr/local/apache/htdocs
vi phpinfo.php

<?
phpinfo ();
?>

then save…

http://localhost/phpinfo.php

configure httpd.conf and add a line like this to where you would normally add the AddType line.

<Files *.php>
SetOuputFilter PHP
SetInputFilter PHP
</Files>

<FilesMatch "\php?|phtml)$">
SetOuputFilter PHP
SetInputFilter PHP
</FilesMatch>

<FilesMatch ".php(.+)?$">
SetOuputFilter php
SetInputFilter php
</FilesMatch>

AddType application/x-tar.gz
AddType application/x-httpd-php .php


Add this to the DirectoryIndex

index.html index.php

3. PHP 4.2.1

./configure \
--with-apxs2=/usr/local/apache/bin/apxs \
--with-mysql=/usr/local/mysql \
--enable-track-vars \
--enable-versioning \
--with-xml
--with-dom \
--with-zlib-dir=/usr/include

make
make install

cp php.ini-dist /usr/local/php.ini