Difference between revisions of "PhpBB3"

From MineOS Wiki
Jump to navigation Jump to search
Line 6: Line 6:
 
== Secure MySQL ==
 
== Secure MySQL ==
 
Be sure to set the MySQL root password by [[MySQL#Securing_MySQL|securing your MySQL installation]]
 
Be sure to set the MySQL root password by [[MySQL#Securing_MySQL|securing your MySQL installation]]
 +
 +
== GD library pre-requisite ==
 +
PhpBB requires an imaging library, such as [[php-gd]], which is available as an addon.
  
 
== Downloading phpBB3 ==
 
== Downloading phpBB3 ==
Line 19: Line 22:
  
 
== Creating database and user ==
 
== Creating database and user ==
As 'root':
+
As ''mc'':
  
 
  <syntaxhighlight>
 
  <syntaxhighlight>

Revision as of 08:00, 26 September 2011

Getting started

Download phpBB 3.0.9 (bz2) (~1.5MB)

The following instructions will set up a phpBB3 forum at [ip-address]/forum. If you prefer a different path, be sure to adjust the values accordingly.

Secure MySQL

Be sure to set the MySQL root password by securing your MySQL installation

GD library pre-requisite

PhpBB requires an imaging library, such as php-gd, which is available as an addon.

Downloading phpBB3

Download as user mc:

<syntaxhighlight>

  1. cd /var/www/hiawatha/
  2. wget http://www.phpbb.com/files/release/phpBB-3.0.9.tar.bz2
  3. tar -xjf phpBB-3.0.9.tar.bz2
  4. mv phpBB3 forum

</syntaxhighlight>

Creating database and user

As mc:

<syntaxhighlight>

cd /usr/games/minecraft/addons root:addons/ $ ./mysql_create_user.py Type in the EXISTING root password for MySQL: mysqlrootpass Database name to create in MySQL: phpforum Username for MySQL backend: phpbbuser Set the password for phpbbuser: phpbbpass /usr/bin/mysql -uroot -pmysqlrootpass -e "CREATE DATABASE IF NOT EXISTS phpforum;" /usr/bin/mysql -uroot -pmysqlrootpass -e "CREATE USER 'phpbbuser'@'localhost' IDENTIFIED BY 'phpbbpass';" /usr/bin/mysql -uroot -pmysqlrootpass -e "GRANT ALL ON *.* TO 'phpbbuser'@'localhost' IDENTIFIED BY 'phpbbpass';" /usr/bin/mysql -uroot -pmysqlrootpass -e "FLUSH PRIVILEGES;" </syntaxhighlight>

Note: phpforum, phpbbuser, and phpbbpass can and should be changed to values of your choice. These are used for PhpBB's backend into the database and WILL NOT be used beyond the installation. Also, the above SQL queries are echoed to you for your benefit as they are executed for you (no further action needed in this script).

Completing quick install

  • Open your browser to http://[ip-address]/forum/install/index.php, filling in your server's IP address.
Overview page
Install page
Requirements page (top)
Database page
Database confirmation page
Administrator page
Administrator confirmation page
Configuration confirmation page
Advanced settings page
Create database tables page
Final Stage output
Remove install directory
  • As the page states, the board is inaccessible while the /install directory exists. Remove the directory:
    • rm -rf /var/www/hiawatha/forum/install/
  • Congratulations! PhpBB is set up!