LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 02-13-2003, 12:39 AM   #1
wldkos
Member
 
Registered: Jan 2003
Distribution: Mandrake 9.2 =<3 and Red Hat 8.0 (server)
Posts: 242

Rep: Reputation: 30
apache, mysql php Rh8.0


I need desperate help installing apache then php with mysql support for a forum I am hosting from my linux box. I have read all of the readme's, docs.... and i can't figure out the mysql and php part. For Apache, I am confused towards the directory setup and how to start it without using the terminal ( i have no prob using the terminal though). Consider me a newbie with windows server setup, this is a new world to me. I am doing this on RH 8.0.

Please make this easy [sorry, i know it's hard]. Thanks is advance.
 
Old 02-13-2003, 12:57 AM   #2
vbp6us
Member
 
Registered: Sep 2002
Location: Redding, CA
Distribution: SuSE
Posts: 253

Rep: Reputation: 30
Redhat 8.0. Ok that shouldnt be too hard.

Have you installed Apache from your RedHat cd? The wizard when installing? If not, go install it. There should be some kind of "add/remove" button on your "start" menu...assuming your using kde.

To make life even EASIER, get Webmin . This is a grapical configurer. It is really helpful. Go get the RPM from the site and install that. After you install that install Apache if you havent dont that yet. Before you go on...make sure your ISP is not blocking port 80!!! I had trouble w/ this at first. If they dont block port 80 than your fine..although there is a way around but we aren't there yet.

PHP, and Mysql can be installed from the same place you install Apache.

Quote:
forum I am hosting from my linux box
Remember...you also need an FTP server because when you install your forum, it will require you to upload stuff to your server using ASCII and Binary. This can only be done through FTP. FTP is the hard part.

Last edited by vbp6us; 02-13-2003 at 01:05 AM.
 
Old 02-13-2003, 12:58 AM   #3
dsgdevil
Member
 
Registered: Jan 2003
Distribution: RedHat Linux 9
Posts: 126

Rep: Reputation: 15
Re: apache, mysql php Rh8.0

Quote:
Originally posted by wldkos
I am doing this on RH 8.0.
did u install mysql when ur installing redhat?if so,u can run the command '# mysql_install_db' and then '# service mysqld start'

Last edited by dsgdevil; 02-13-2003 at 01:00 AM.
 
Old 02-14-2003, 12:40 AM   #4
wldkos
Member
 
Registered: Jan 2003
Distribution: Mandrake 9.2 =<3 and Red Hat 8.0 (server)
Posts: 242

Original Poster
Rep: Reputation: 30
As for mysql, I am positive that i installed it when i installed linux. I also have postgresql as well, if that helps. I am also trying to install an ftp server as well. I set one up on my windows machine before but linux is totally confusing me with that. Well do ftp at the end? COOL.

Uhh ill try the
Quote:
'# mysql_install_db'
Soon. I wasn't familiar with the command line comments to get it going. Where is it going to install the mysql? and i might be jumping ahead, but how do i then make all of this work together; apache, mysql and php?

Thanks for the help guys.
 
Old 02-14-2003, 12:54 AM   #5
amish_geek
LQ Newbie
 
Registered: Feb 2003
Location: Duluth MN
Distribution: Debian, FreeBSD, SuSE
Posts: 23

Rep: Reputation: 15
You should just be able to install apache, mysql, and php4 (assuming you are using 4), and they will install to their default locations.

Configuring apache:

The cheating way to configure apache for your folder structure is to leave the configuration alone. Then, add a new user (if your forum site is going to be named "my forum" add the user myforum or something like that) Apache's default user folder is "public_html" so log in as that new user, and create the folder "public_html" what this does is when you go to http://(your Ip address)/~myforum/ apache points it to the /home/myforum/public_html/ dir. You can go through the /etc/apache/httpd.conf file and find the part that talks about userdirs and change it from public_html to whatever you want (I use "www")

Extract your forum into the public_html folder.

In the command line, as root, go to the SQL folder for your forum. (Assuming there is one, if you are using phpBB2, which is really slick, there will be a SQL folder) and type in "mysqladmin create myforum". What this does is creates a database called myforum. You may need to type in "mysqladmin create myforum -p" and then type in the root users password for mysql, but by default, it should be blank (which you may want to think about changing for security purposes).

Once you have created the database, you need to load the db structure. In the SQL folder, type "mysql myform < forum.sql" or whatever the .sql files name is. This tells mysql to put all the tables from the forum.sql file into the myforum database. (You may need to add the -p to the end again if you have a password, AND be sure not to do "mysql myforum > forum.sql" as this will write the contents of the myforum database, which is currently blank, over the .sql file, which will force you to re-upload the sql file)

That should be it, you should be able to read the forums readme and go to the install page, and whatnot to install and configure the forum. Remember you will most likely need to edit the config.php file for the forum to tell it what database to use "myforum" and the username and password. Use webmin from www.webmin.com to create a mysql user for your forum to use, unless you really want it to use the root user, which is a security risk.

Hope this helps!

~Amish
 
Old 02-14-2003, 01:01 AM   #6
wldkos
Member
 
Registered: Jan 2003
Distribution: Mandrake 9.2 =<3 and Red Hat 8.0 (server)
Posts: 242

Original Poster
Rep: Reputation: 30
hey wow, thanks for that detailed explanation, that is exactly what i was looking for. I am going to try this prolly on sat, my next free day and report back here. I think that by what you wrote, I should be good right? I have a choice between 3 boards

Yabb < no php or sql setup just cgi and perl
Invisions boards < php & mysql
PHPbb < php& mysql

I wouldn't mind using any of these, but does anyone have a reccomendation for using which one? Currently my board is on a Yabb forum. But i won't mind a change.

http://wldkos.smutstars.com
 
Old 02-14-2003, 01:06 AM   #7
amish_geek
LQ Newbie
 
Registered: Feb 2003
Location: Duluth MN
Distribution: Debian, FreeBSD, SuSE
Posts: 23

Rep: Reputation: 15
I recommend phpBB2... its clean, its easy to administrate, and there are quite a few themes out there for it, and its relatively easy to theme yourself. Plus, you can integrate it into phpnuke or postnuke. Check out my site www.thegamelan.com which is postnuke with phpBB2 implemented in it.
 
Old 02-14-2003, 01:15 AM   #8
wldkos
Member
 
Registered: Jan 2003
Distribution: Mandrake 9.2 =<3 and Red Hat 8.0 (server)
Posts: 242

Original Poster
Rep: Reputation: 30
It seems nice. Are there good mods for it like the birthday ones and extra smiles and shit? ( i hate the smile's but memebrs love them ) I think i might go with phpbb, but has anyone here used anyof the above that would suggest another?

And what does post nuke and nuke do to the phpbb?
 
Old 02-14-2003, 01:20 AM   #9
amish_geek
LQ Newbie
 
Registered: Feb 2003
Location: Duluth MN
Distribution: Debian, FreeBSD, SuSE
Posts: 23

Rep: Reputation: 15
Postnuke and phpnuke dont really do anything to phpBB... people just ported phpBB2 as a module for postnuke and phpnuke to replace the current forums for them. Basically modding it so that it fits, and leaves the menu systems and other features available.

You can download tons of smilies for phpBB, along with other things... check out www.phpbb.com and look at all the addons. I have downloaded over 1000 avatars for my users to choose from, and allow them to link/upload their own. Its a very scalable forum, and looks clean/professional as a bare install too.

I havent really used any other boards, cuz phpbb was the first I found and have used. And i have a thing with "if it aint broke, dont fix it" so ive just always used it because I can set it up in 5 mins, and it works seamlessly.

~Amish
 
Old 02-14-2003, 01:29 AM   #10
wldkos
Member
 
Registered: Jan 2003
Distribution: Mandrake 9.2 =<3 and Red Hat 8.0 (server)
Posts: 242

Original Poster
Rep: Reputation: 30
5 minutes would be nice for me, although it seems like it is going to take much longer (well the whole process). I currently have a poll on my other forum to see what my members think. I guess that will be the ultimate decision right there.

Thanks again.
 
Old 02-18-2003, 06:31 PM   #11
wldkos
Member
 
Registered: Jan 2003
Distribution: Mandrake 9.2 =<3 and Red Hat 8.0 (server)
Posts: 242

Original Poster
Rep: Reputation: 30
Is there going to be a problem with me running this web server on my machine behind a router? I checked my Ip address on my linux machine and it is the same as this one (windows) which i figured, so do i just have to mess with the port fowarding.
 
Old 03-02-2003, 04:19 AM   #12
wldkos
Member
 
Registered: Jan 2003
Distribution: Mandrake 9.2 =<3 and Red Hat 8.0 (server)
Posts: 242

Original Poster
Rep: Reputation: 30
ok i got php ready to be installed and apache is working. But the only problem is that mysql is being a pain in the ass. I was in the /usr/local/mysql/bin and tried to run: mysqladmin create myforum... with and without a "-p". Maybe I installed wrong, or mySQL sucks. Anyone have a suggestion?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Apache Mysql Php: mysql with php doesn't work breakerfall Linux - Networking 6 12-27-2003 09:59 PM
apache or php doesn't work properly on RH8.0 abd_bela Linux - Networking 6 03-18-2003 06:20 AM
Newbie on Apache and PHP rpm install on RH8 1beagle Linux - General 5 03-11-2003 07:54 PM
RH8 Modifying Default Apache / PHP config p4ck37p1mp Linux - General 4 02-10-2003 11:09 PM
RH8/Apache - PHP installed but not enabled(?) bkeating Linux - Software 3 12-05-2002 01:10 PM


All times are GMT -5. The time now is 06:58 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration