Need help setting up a phpbb forum on my local machine

[NathanBWF]

Originally posted by: kamper

Originally posted by: http://www.php.net/manual/en/ref.mysql.php
This MySQL extension doesn't support full functionality of MySQL versions greater than 4.1.0. For that, use MySQLi.

When setting up phpbb, are you selecting mysql or mysqli from the drop down list?

From which drop down list? I don't believe there is any option for mysqli anywhere.

Oh, and I don't have that much php knowledge to do what you were talking about in your previous post... 🙁

 

[kamper]

There should have been a list of databases to choose from on the installation page. You'd have chosen mysql (as opposed to oracle or postgres or something). If you don't see mysqli in that list you'll probably have to go with an older version of mysql. Wouldn't surprise me as they don't seem to support pgsql 8 yet and it's been out for a long time too.

 

[kamper]

Read: http://www.phpbb.com/phpBB/viewtopic.php?t=346071&highlight=mysqli
as well as the announcement linked from the second post in that thread.

Edit: you might want to also do a search for "mysqli" and other relevant things on those forums. There appears to have already been a decent amount of chatter about similar issues.

 

[NathanBWF]

Originally posted by: kamper
Read: http://www.phpbb.com/phpBB/viewtopic.php?t=346071&highlight=mysqli
as well as the announcement linked from the second post in that thread.

Edit: you might want to also do a search for "mysqli" and other relevant things on those forums. There appears to have already been a decent amount of chatter about similar issues.

I actually unistalled MySQL 5, and re-installed version 4 so that shouldn't be an issue as far as that announcement goes. Also, for that guys thread, it appeared he was getting the same error as me but it was because he didn't create the database first, which I know I've done because the "USE DATABASE phpBB2" command completes successfully through the command line utility. I'm going to try running the install process from a remote machine and see if I get the same errors...

 

[kamper]

Which version of 4? The change in question happened between 4.0.x and 4.1.x.

Also, have you done the GRANTs to give the proper user access from the proper locations (ie 'localhost' or 127.0.0.1 or your actual ip)?

 

[NathanBWF]

Originally posted by: kamper
Which version of 4? The change in question happened between 4.0.x and 4.1.x.

Also, have you done the GRANTs to give the proper user access from the proper locations (ie 'localhost' or 127.0.0.1 or your actual ip)?

I went back to 4.1.

I used the MySQL QUI to assign permissions to the appropriate user...but I don't remember anywhere configuring the locations. I'll have to check that on Monday when I get back to work...

 

[kamper]

For a test, use the commandline client to connect over the network using the same user as phpbb. That's assuming you've always connected as root for administration.

 

[NathanBWF]

Originally posted by: kamper
For a test, use the commandline client to connect over the network using the same user as phpbb. That's assuming you've always connected as root for administration.

I rarely use root, I created a 2nd "super user" account for lack of better terms which is the same account I'm specifying during the install. I'll try to cmd line client over the network tomorrow and see what I get.

 

[imported_LoKe]

Skip the annoying crap and install Apache2Triad. It comes with PHP(PHPMyAdmin), MySQL, etc.

 

[NathanBWF]

Originally posted by: LoKe
Skip the annoying crap and install Apache2Triad. It comes with PHP(PHPMyAdmin), MySQL, etc.

That's not going to help me get phpBB installed. 🙂

Besides, apache, php, and mysql are all working anyway.