MYSQL Problems

[Prohibited]

Hi,

I am trying to install a PHPBB 2 forum, but grrr! I keep getting this error:

An error has occurred during installation
The PHP configuration on your server doesn't support the database type that you chose

I have installed MYSQL from my Fedora disc, and PHP is installed. Anyone that can help?

PS. I tried checking diffrent servers types - Still failed

[sarumont]

Read the error message a little more closely...PHP doesn't support the db you have installed. You have to configure PHP to have mysql support.

Use

./configure --with-mysql

when you run autoconf.

[Prohibited]

First off, thanks for the reply.

Ok, I have downloaded the .tar.gz file from php.net.. Ran this:

./configure --with-mysql
make
make install

Now, it appears my other version that originally came with Fedora Core 3 is still on... How do I make apache read the new version of PHP?

[luma]

before doing all this compiling and installing php........

when you run the install script for phpbb (from a web browser)
it asks you for type of database (MAKRE SURE!!! this is mysql4 (or 3 if you are using 3)
then enter the proper credentials.

do you get the same error?

you have to select the proper database type in the drop down menu of the install script.

now if that don't work then lets look at php.

its important to remove the redhat version of php to do this we need to find the rpm
rpm -qa | grep php

this should locate it, then you can remove it.

Luc

[luma]

if you want to do mysql, apahce and php from the ground up (remove all traces of these 3 items from your installtion first)

here is a VERY good link..
http://hulan.cz/blog/?itemid=576


Luc

[scm]

You need to update the version of libphpX.so in your modules directory (or wherever your config points LoadModule).

[Prohibited]

Thanks for the reply.

How do I update it?

[Prohibited]

Ok, I have looked for the phplib5.so (it's the latest version of PHP if 5 is?) :P Anyway, I cannot find it. I tried to see if it installed the module itself -- it didn't. Where can I find this thing? I need to get PHP installed.

[scm]

Ok, I have looked for the phplib5.so (it's the latest version of PHP if 5 is?) :P Anyway, I cannot find it. I tried to see if it installed the module itself -- it didn't. Where can I find this thing? I need to get PHP installed.

It's in the libs directory of the tree you untarred PHP into. (Sorry, I didn't
install it from an RPM.)

You could try (as root):

find  /  -name libphp5.so  -print  2>/dev/null

to locate it on your system.

[Prohibited]

I went ahead and re-installed linux. (Had to install windows... )

Ok, everything is compiled, but I receive this error..

"
An error occurred trying to update the database
You have an error in your SQL syntax near ''' at line 2"

And

"An error occurred trying to update the database
Table 'forum3_auth_access' already exists"

I don't get it.. Here's my information I put while installing the phpbb forum:

Database: localhost
Your Database name: forum
Database user: root
Database pass:
prefix tables: forum_

So what exactly is the problem? (Best if someone could explain for a dummy and how to get it working. )