Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Mon Nov 24, 2003 2:06 pm 
Offline
Senior Member

Joined: Wed Sep 17, 2003 7:39 pm
Posts: 124
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 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 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/sm_install.php (sm_install.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


Top
   
 Post subject:
PostPosted: Mon Nov 24, 2003 9:28 pm 
Offline
Senior Newbie

Joined: Fri Nov 21, 2003 7:34 pm
Posts: 13
Thanks but what is mysql moniter?


Top
   
 Post subject:
PostPosted: Tue Nov 25, 2003 1:16 pm 
Offline
Senior Member

Joined: Wed Sep 17, 2003 7:39 pm
Posts: 124
LokiVidalez wrote:
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.


Top
   
 Post subject:
PostPosted: Wed Nov 26, 2003 4:59 am 
Offline
Linode Staff
User avatar

Joined: Fri Oct 17, 2003 12:38 am
Posts: 287
Location: Dr Wierd's Lab, South Jersey Shore
refering to this as the mysql command-line client might make it a bit clearer


Top
   
 Post subject:
PostPosted: Wed Nov 26, 2003 10:30 am 
Offline
Senior Member

Joined: Wed Sep 17, 2003 7:39 pm
Posts: 124
mikegrb wrote:
refering to this as the mysql command-line client might make it a bit clearer


Indeed :)


Top
   
 Post subject:
PostPosted: Wed Nov 26, 2003 11:22 am 
Offline
Senior Newbie

Joined: Fri Nov 21, 2003 7:34 pm
Posts: 13
well what i alwayz do is after i get teh root password set i install phpmyadmin and i bypass the mysql commandline =P


Top
   
PostPosted: Wed Nov 26, 2003 4:43 pm 
Offline
Senior Member

Joined: Sun Nov 02, 2003 2:05 pm
Posts: 58
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


Top
   
PostPosted: Wed Nov 26, 2003 5:30 pm 
Offline
Senior Member

Joined: Wed Sep 17, 2003 7:39 pm
Posts: 124
You_Wish wrote:
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? :)


Top
   
 Post subject:
PostPosted: Wed Nov 26, 2003 6:19 pm 
Offline
Senior Member

Joined: Sun Nov 02, 2003 2:05 pm
Posts: 58
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-server_3.23.56-1.80_i386.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.


Top
   
 Post subject:
PostPosted: Wed Nov 26, 2003 8:11 pm 
Offline
Senior Member

Joined: Wed Sep 17, 2003 7:39 pm
Posts: 124
You_Wish wrote:
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-server_3.23.56-1.80_i386.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?


Top
   
 Post subject:
PostPosted: Wed Nov 26, 2003 9:22 pm 
Offline
Senior Member

Joined: Sun Nov 02, 2003 2:05 pm
Posts: 58
Quik wrote:
You_Wish wrote:
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-server_3.23.56-1.80_i386.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


Top
   
 Post subject:
PostPosted: Thu Nov 27, 2003 11:21 pm 
Offline
Senior Member

Joined: Sun Nov 02, 2003 2:05 pm
Posts: 58
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


Top
   
 Post subject:
PostPosted: Tue Jan 13, 2004 11:59 am 
Offline
Junior Member

Joined: Sun Dec 21, 2003 11:01 am
Posts: 30
great post, for us newbie here, we want to see MORE!MORE!!MORE!!! :P
________
Colorado Marijuana Dispensaries


Last edited by neorder on Sun Feb 13, 2011 4:56 am, edited 1 time in total.

Top
   
PostPosted: Tue Mar 16, 2004 6:28 am 
Offline
Senior Member
User avatar

Joined: Sun Nov 23, 2003 1:40 pm
Posts: 79
Website: http://www.whitehouse.gov/history/presidents/bc42.html
Quik wrote:
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:

Code:
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


Top
   
PostPosted: Tue Mar 16, 2004 10:37 am 
Offline
Senior Member

Joined: Wed Sep 17, 2003 7:39 pm
Posts: 124
Bill Clinton wrote:
Quik wrote:
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:

Code:
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


:wink:


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group