phpBB and MySQL

[Ramon F. Herrera]

Yes, I realize that I am pressing my luck. I have been unable to get any assistance in the phpBB forum and since you guys have been so nice to this poor noob, plus you happen to be running exactly that forum platform here, maybe you can provide the guidance I need.

I have spent hours Googling, etc. and nothing.

This is my latest obstacle to overcome:

http://vps62316.inmotionhosting.com/php ... hp/install (Click on "Install")

I followed the PHP code behind the "Retest requirements" button. What exactly is being tested?

Is there any file that I need to edit in order to inform phpBB about the existence of MySQL?

I installed the MySQL package but it is sitting dormant. Do I have to create a database?

What about MySQLi? Is it required? Where do I get it?

TIA,

-Ramon
JFK Numbers

[TrevorH]

Rather than exposing the installation dialog for phpBB to anyone who cares to run it, how about you lock it down and then post screenshots of the error(s) you get.

Did you install mariadb-server? Did you start it? Did you run mysql_secure_installation afterwards and set root password and secure the set up?

[Ramon F. Herrera]

Rather than exposing the installation dialog for phpBB to anyone who cares to run it, how about you lock it down and then post screenshots of the error(s) you get.

I was doing exactly that, Trevor. See here:

mysqld is up and running.jpg (117.32 KiB) Viewed 1499 times

Plus this:

Supported Databases.jpg (50.84 KiB) Viewed 1499 times

Did you install mariadb-server? Did you start it? Did you run mysql_secure_installation afterwards and set root password and secure the set up?

I have not install mariadb-server, I did install mysql-community-server.

I have not done the secure_installation. Will do it next.

Thanks!

-Ramon
JFK Numbers

[TrevorH]

Run yum list \*php\*mysql\* and check that you have a package installed for your version of php that provides mysql support.

[Ramon F. Herrera]

Run yum list \*php\*mysql\* and check that you have a package installed for your version of php that provides mysql support.

If I am not mistaken, I need a version of PHP which comes with the file mysqli.so

That is not as easy as it should be. Will keep on looking.

Thanks!

-Ramon
JFK Numbers

MySQLi Required.jpg (156.42 KiB) Viewed 1474 times

[Ramon F. Herrera]

Eureka! I found the solution!

If you want to implement the phpBB application in a CentOS 7 box, these are the steps, starting with a recently re-OSed VPS:

Code: Select all

# yum install centos-release-scl
# yum install rh-php73-php-mysqlnd.x86_64   // MySQLi
# yum install rh-php73-php                  // PHP with htppd
# yum install php73-xml                     // DOM

The fascinating part that some will notice is that there is no database whatsoever installed.

The web based phpBB installation procedure only checks the status of your PHP.

As usual, many thanks to Trevor (and remirepo) ...

-Ramon
JFK Numbers

[Ramon F. Herrera]

Step 1.jpg (118.26 KiB) Viewed 1442 times

Step 2.jpg (57.52 KiB) Viewed 1442 times

-Ramon
JFK Numbers

[remirepo]

# yum install rh-php73-php-mysqlnd.x86_64 // MySQLi
# yum install rh-php73-php // PHP with htppd
# yum install php73-xml // DOM

Again, php73-xml is NOT the proper package

Good practice, when you need a "foo" extension, yum install <package namespace>-<foo>

So in your case

Code: Select all

yum install rh-php73-php-mysqli rh-php73-php-dom ...

Package name is not interesting, package layout have changed, and may change again

[TrevorH]

You want rh-php73-php-xml.x86_64 not php73-xml.

[Ramon F. Herrera]

You want rh-php73-php-xml.x86_64 not php73-xml.

I will Re-OS the VPS and try that approach. I have done it only like 40 times. : -)

Once I have the phpBB forum up&running in my cheap VPS ($5/month), I will repeat the procedures in my real VPS ($50/month).

-Ramon
JFK Numbers