HOWTO: Set up an Invision Board Forum [Fedora]
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 db1@localhost* 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
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.
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
@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.
@mikegrb:
refering to this as the mysql command-line client might make it a bit clearer
Indeed
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?
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%]
[root@Slick root]# service httpd start
Starting httpd:
[root@Slick 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%]
[root@Slick root]# service httpd start
Starting httpd:
[root@Slick 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%]
[root@Slick root]# service httpd start
Starting httpd:
[root@Slick 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 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
@Quik:
8. Create a new username/password with the following commands:
*GRANT ALL PRIVILEGES ON *.* TO db1@localhost* 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 db1@localhost
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 db1@localhost* 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 db1@localhostYou want to give all access to the user on all the tables of db1. Not everyother db as well.
Bill Clinton