phpBB2 install(Doublechecked my steps and still stumped)

Mr.Ampersand() · 09-28-2004, 08:39 AM

Hi,

First of all this is my second forum installation of phpBB2 but a bit older. Now since I had previous experience installing I knew where to look and what to do. I'm running this on Mandrake Linux 10. I've already installed mysql via RPM then set up root password the reccommended way according to my Linux book and set up a user. I could create tables etc. So now that mysql4x is running I had to install php(latestversion). I retrieved the installation from www.php.net for Linux (source only). So I downloaded it and started installing it. During make and make install It halted after libpassword.lo(something like that) and then I did make install. I then installed apache2 with configure --enable-so. that seemed to make direcories in /usr/local/apache2. The php one didnt so anything so I took some shared library files from my working install and transferred them to the computer. I then followed instructions from phpbb homepage. I printed the whole userguide out (25 pages). I think i'm missing out a step but anyway i'm up to the point where I could visit the phpBB2 install page then I put in all the correct information and press install then it complained that it couldnt find the database type when I chose the right one. That made me look up the error on google and then I found an awnser on phpcommunity forum:

http://www.phpbb.com/phpBB/viewtopic...920&highlight=

After trying out what that thread mentioned I got this error:

Code:

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/phpBB2/db/mysql4.php on line 48

And so it seems that its not connecting to mysql...

However this doesnt seem to work since I think my situation is different. Is is possible I could modify the php.ini file to point to mysql or something? I'll look at that in a moment and see what I could do. It took me so long to get this forum working to this point even though I have accomplished this before (on KDE) this time it was shell only with other mistakes I havent made. I wrote the steps I took and the trouble I had plus solutions, I just didnt post them here.

bye,
George

Mr.Ampersand() · 09-28-2004, 09:06 AM

I think I do need to link the php.ini file to mysql client libraries according to the searches I am doing on Google. According to one FAQ it says php must be linked to the mysql libraries manually or something.

bye,
George

GraemeK · 09-28-2004, 10:46 AM

let me know how you get on...

i have phpBB2 installed on RH9 but this was using the installed versions of apache, mysql and php.

I hate to think what problems i'd have found if i installed from scratch like you!

G

Arune · 09-28-2004, 11:22 AM

It is best to install in this order:

Apache
Mysql
PHP

Depending upon the installation, and capabilities....I would install Apache with the following switches:

--enable-so --enable-ssl

Default installation will put Apache in /usr/local/apache2

Mysql:

--prefix=/usr/local/mysql

PHP:

--with-mysql=/usr/local/mysql --with-apxs2=/usr/local/apache2/bin/apxs

That should net you very little problems. You are on your own for securing them however. 8)

UnmodNick · 09-28-2004, 12:57 PM

Are you sure the mySQL service is running???

Depending on your install location you could input this to verify:

# /usr/local/mysql/bin/mysqlshow -p

If you didn't set mySQL to start when the system boots then it probably isn't running.

Mr.Ampersand() · 09-28-2004, 01:04 PM

Hi,

I've already installed apache, mysql and php in that same order. Mysql was installed from the official RPMs from www.mysql.com and php was installed just fine. It seems I've worked most kinks out.

Now what I've done in addition after posting this thread is look at other peoples problems by looking up the error on google and I ended up editing the /etc/php.ini file and unnotted:

Code:

;extension=msql.so

After doing that I didnt see any affect untill I added

Code:

extension=mysql.so

and renoted out extension=msql.so

It seems I am recieving the error I recieved a while ago when configuring the forum the way I have it on this computer i'm posting the thread on. The server when installing doesnt complain about mysql_connect() but gives me this old familiar messaga:

Code:

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /var/www/html/phpBB2/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /var/www/html/phpBB2/db/mysql4.php on line 331
phpBB : Critical Error 

Could not connect to the database

So it seems i'm getting somewhere. I'll research the new error and find the solution unless anyone else here does a quicker reply then I get to search for it.

What also had me going was I have two php.ini files one in /usr/lib/ and one that affects the actual server in /etc. Anyway I have apache2 installed from binary in /usr/local/apache2 already and I think I already mentioned that however I have a http server I think from rpm installation in /etc/httpd. I dont really care to delete them since they dont seem to be conflicting. All of the changes seem to be taking affect from /etc/httpd.

I also learned from another post to make this 3 lines of php code to get the php info from the server. Go here to check out my info if you want. Maybe it'll help me. I think I know what to do from here:

http://207.237.145.49:97/test.php

bye,
George

Mr.Ampersand() · 09-28-2004, 01:22 PM

UnmodNick,

Yes MySQL is running and up now, I have a user kc2keo and the root on there. Its all configured and with a password. I used my Linux book as a guideline along with 2 tutorials, one from yolinux.com and one from some other place along with the mysql docs. I could create a database now which is a plus however thats not the issue. MySQL is up.

bye,
George