HOWTO: Set up an Invision Board Forum [Fedora]

I thought I'd post a tutorial on this because it's so simple to do :)

This can be adapted to most distros, but is designed for Fedora. In RedHat you can use apt-get instead of yum, same goes for Debian although I can't guarantee everything else will be the same!

1. Log into your Linode as the root user; if you aren't root, type su -

2. Type: yum install httpd mysql-server mysql php php-mysql

This will install the necessary packages to get Invision board (and of course most other websites) working

3. Type: service httpd start

This will start the Apache 2 http server. At this point you should be able to visit your Linode in a web browser and be presented with the Fedora test page. If not, check that you haven't enabled any form of firewall and access to port 80 is available. At this point, you can place your website in /var/www/html/ if you want to.

4. Type: service mysqld start

This will start the MySQL server. Check that it's running along with apache by typing ps uax to show a list of processes - don't worry if you see more than one 'instance' of mysql or apache!

5. Type mysql to access the MySQL monitor. You need to create a database and username/password for Invisionboard to use. We will call the database and username both db1.

6. In the MySQL monitor, type create database db1;

7. Then type use db1; to switch to the database and confirm it exists

8. Create a new username/password with the following commands:

*GRANT ALL PRIVILEGES ON *.* TO [email protected]* and then

IDENTIFIED BY 'password' WITH GRANT OPTION;

9. Your MySQL editing should now be done! Type quit to leave the MySQL interface.

10. To create a new folder in your web directory, switch to it using cd /var/www/html and type mkdir forums where forums is the name of the folder.

11. Download Invisionboard from www.invisionboard.com in tar.gz forum. Upload this somewhere and use wget to download it to your Linode.

12. Type tar zxvf 1p3Final[1].tar.gz to extract the forum files

13. Then, move the forum files to the folder you created using: mv 1p3Final/upload/ forums/*

14. Load up the forum installation page in your browser, eg. www.yourdomain.com/forums/sminstall.php (sminstall.php is the file you must load to install the forums)

15. Enter all the details as prompted

In this case the location of the SQL server is localhost (as prompted) and the username/database name are db1, and the password is password. You do not need to enter any forum tables.

16. Click Continue a few times, and you're done!

17. To get both httpd and mysqld to start when you reboot your Linode, type: chkconfig httpd on and chkconfig mysqld on (thanks caker!)

Please note that this is a very basic guide - barely anything at all is customised or hardened, so you may want to Google for how to secure Apache and MySQL. For example:

The MySQL server will be listening to requests from all IPs. If you will only be accessing SQL databases from the local machine, it is best to change this (for example, Invision boards only access the database from the local machine) in the interest of security. Type nano -w /etc/my.cnf to bring up the small configuration of the MySQL server. Under [mysqld], place the line skip-networking and then exit nano using Ctrl-X saving the changes. Typing service mysqld restart will restart MySQL and stop it from listening to requests from other IP addresses.

However, it does the job and I hope it helps those who want a quick and easy setup template which is easily customised.

Quik

14 Replies

Thanks but what is mysql moniter?

@LokiVidalez:

Thanks but what is mysql moniter?

MySQL monitor is the program which allows you to edit your databases through the SSH prompt I believe. Just access it by typing MySQL in SSH.

refering to this as the mysql command-line client might make it a bit clearer

@mikegrb:

refering to this as the mysql command-line client might make it a bit clearer

Indeed :)

well what i alwayz do is after i get teh root password set i install phpmyadmin and i bypass the mysql commandline =P

An error has occurred during installation

The PHP configuration on your server doesn't support the database type that you chose

phpBB error can anyone help please

@You_Wish:

An error has occurred during installation

The PHP configuration on your server doesn't support the database type that you chose

phpBB error can anyone help please

What distro are you using? What packages have you installed on it (eg. apache2, php, mysql, etc)? What version of phpBB are you trying to install? Where does it give you that error?

Catch my drift? :)

distro rh8

phpBB-2.0.6.tar.gz

httpd is already the newest version.

mysql is already the newest version.

php is already the newest version.

The following NEW packages will be installed:

mysql-server php-mysql

0 packages upgraded, 2 newly installed, 0 removed and 0 not upgraded.

Need to get 0B/1505kB of archives.

After unpacking 3777kB of additional disk space will be used.

Executing RPM (-Uvh)…

warning: /var/cache/apt/archives/mysql-server3.23.56-1.80i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e

Preparing… ########################################### [100%]

1:mysql-server ########################################### [ 50%]

2:php-mysql ########################################### [100%]

[[email protected] root]# service httpd start

Starting httpd:

[[email protected] root]# service mysqld start

Starting MySQL: [ OK ]

the error comes up when completing data in browser then clicking install from the browser

Thank you for choosing phpBB 2. In order to complete this install please fill out the details requested below. Please note that the database you install into should already exist. If you are installing to a database that uses ODBC, e.g. MS Access you should first create a DSN for it before proceeding.

@You_Wish:

distro rh8

phpBB-2.0.6.tar.gz

httpd is already the newest version.

mysql is already the newest version.

php is already the newest version.

The following NEW packages will be installed:

mysql-server php-mysql

0 packages upgraded, 2 newly installed, 0 removed and 0 not upgraded.

Need to get 0B/1505kB of archives.

After unpacking 3777kB of additional disk space will be used.

Executing RPM (-Uvh)…

warning: /var/cache/apt/archives/mysql-server3.23.56-1.80i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e

Preparing… ########################################### [100%]

1:mysql-server ########################################### [ 50%]

2:php-mysql ########################################### [100%]

[[email protected] root]# service httpd start

Starting httpd:

[[email protected] root]# service mysqld start

Starting MySQL: [ OK ]

the error comes up when completing data in browser then clicking install from the browser

Thank you for choosing phpBB 2. In order to complete this install please fill out the details requested below. Please note that the database you install into should already exist. If you are installing to a database that uses ODBC, e.g. MS Access you should first create a DSN for it before proceeding.

Silly question - did you create a MySQL database before trying to install the forums?

@Quik:

@You_Wish:

distro rh8

phpBB-2.0.6.tar.gz

httpd is already the newest version.

mysql is already the newest version.

php is already the newest version.

The following NEW packages will be installed:

mysql-server php-mysql

0 packages upgraded, 2 newly installed, 0 removed and 0 not upgraded.

Need to get 0B/1505kB of archives.

After unpacking 3777kB of additional disk space will be used.

Executing RPM (-Uvh)…

warning: /var/cache/apt/archives/mysql-server3.23.56-1.80i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e

Preparing… ########################################### [100%]

1:mysql-server ########################################### [ 50%]

2:php-mysql ########################################### [100%]

[[email protected] root]# service httpd start

Starting httpd:

[[email protected] root]# service mysqld start

Starting MySQL: [ OK ]

the error comes up when completing data in browser then clicking install from the browser

Thank you for choosing phpBB 2. In order to complete this install please fill out the details requested below. Please note that the database you install into should already exist. If you are installing to a database that uses ODBC, e.g. MS Access you should first create a DSN for it before proceeding.

Silly question - did you create a MySQL database before trying to install the forums?

yes i named it phpBB and it can be viewed using webmin so i can see that it is there

this is new error i am getting

this line fix above line error: Options Indexes FollowSymLinks ExecCGI Multiviews

Anybody know what cause this? thanks

phpBB : Critical Error

Could not connect to the database

great post, for us newbie here, we want to see MORE!MORE!!MORE!!! :P


@Quik:

8. Create a new username/password with the following commands:

*GRANT ALL PRIVILEGES ON *.* TO [email protected]* and then

IDENTIFIED BY 'password' WITH GRANT OPTION;

I know this is old, but that first command here is wrong.

it should be:

GRANT ALL PRIVILEGES ON db1.* TO [email protected]

You want to give all access to the user on all the tables of db1. Not everyother db as well.

Bill Clinton

@Bill Clinton:

@Quik:

8. Create a new username/password with the following commands:

*GRANT ALL PRIVILEGES ON *.* TO [email protected]* and then

IDENTIFIED BY 'password' WITH GRANT OPTION;

I know this is old, but that first command here is wrong.

it should be:

GRANT ALL PRIVILEGES ON db1.* TO [email protected]

You want to give all access to the user on all the tables of db1. Not everyother db as well.

Bill Clinton

:wink:

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct