LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 05-30-2003, 12:08 AM   #1
psycho2000
LQ Newbie
 
Registered: May 2003
Posts: 15

Rep: Reputation: 0
Question Bulletin Board software install problems.


Greets all

First off - let me warn you - I am a newbie to Linux (or returning newbie). I have used Linux many years ago but was unfortunately dragged to the dark side (m$).......

I have currently setup a clarkconnect box (RedHat 7.2) as a dedicated gateway/webserver/mailserver box (avail from http://www.clarkconnect.org). I have been able to configure it to do all the basic functions (webmail, snort etc) but I want to run a forum board on the server. I have tried both phpBB2 and UltimateBB) but I have not been able to get either of them to work.

This is what I have installed:
CC 1.2 (based on RedHat 7.2)
Apache 1.37
Perl
mySQL and php-mysql.

The errors I received was as follows:
UltimateBB
- everytime I attempted to access the control.pl object on the control panel I received a "Internal Error" message. I have checked the permissions and they were set as required (755).

I tried everything but couldn't get the bl@sted thing to work so I tried phpBB2.

phpBB2
I installed the package, mysql and php-mysql as required but everytime I attempted to start mysql to create the database I received a "unable to connect to socket /var....." error.

Could someone please point me in the right connection before I rip out what is remaining of my hair. Should I go with UltimateBB (cgi based) or phpBB2 (PHP based)? If so, could someone recommend a simple step-by-step guide for getting it working. I really want to get it working and also understand how it is working.

THanks in advance

P2000

Last edited by psycho2000; 05-30-2003 at 01:03 AM.
 
Old 05-30-2003, 12:50 AM   #2
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
With this especially a more useful thread title would have recieved a much wider response You might consider asking a mod to change it for you.

But, for now..

How did you install mysql? Did you use an RPM or did you use the binary tarball provided by mysql? If you used the RPM, might I suggest using the tarball. Once you get that going (just follow the directions, use the defaults, they work just fine) it's as easy as following directions from the mysql website to setup a database for your PHPBB (by the way, I'm suggesting the phpBB2 board since that's what I use ) board. From there, follow the instructions to setup the board from the board's info. It's not bad, one thing to advise you on: setup a password for your users who have access to the database. You'll need that for security later on. Also, setup a root password for mysql since root has all power/control there just as anywhere in linux.

HTH

Cool
 
Old 05-30-2003, 12:59 AM   #3
psycho2000
LQ Newbie
 
Registered: May 2003
Posts: 15

Original Poster
Rep: Reputation: 0
Wink

@MasterC

Thanks for the response - the original question did go on for a bit
 
Old 05-30-2003, 01:02 AM   #4
psycho2000
LQ Newbie
 
Registered: May 2003
Posts: 15

Original Poster
Rep: Reputation: 0
Question

@MasterC

Thanks for the response - the original question did go on for a bit


I did install the rpm version of mysql (using the apt-get option). Should I uninstall the rpm version before installing the tar version? If so do I use the rpm -U <application name> command?

Thanks for the quick response.

P2000
 
Old 05-30-2003, 01:14 AM   #5
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
The syntax to remove an rpm is:
rpm -e application
So:
rpm -e mysql
Should do it. And yeah, I think you should remove it before using the mysql.com tarball (or even rpm if they have em, however I always prefer a tarball over an RPM, but you lose the easy ability to uninstall it, so try the official RPM's first from www.mysql.com )

Cool
 
Old 05-30-2003, 02:35 AM   #6
psycho2000
LQ Newbie
 
Registered: May 2003
Posts: 15

Original Poster
Rep: Reputation: 0
@MasterC

Is that the mysql-server application? Do I also have to reinstall the php-mysql rpm application (since I had to remove it when uninstalling mysql)?

Cheers

P2000
 
Old 05-30-2003, 06:26 AM   #7
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
I don't know what that app is, if it's php compiled with mysql then yes, you should.

Cool
 
Old 05-30-2003, 08:17 AM   #8
psycho2000
LQ Newbie
 
Registered: May 2003
Posts: 15

Original Poster
Rep: Reputation: 0
@MasterC

All working - thanks you very much....

Your da man!!!!

P2000

PS - How do i go about changing the colour scheme of phpBB2?

P2000
 
Old 05-31-2003, 06:01 AM   #9
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
It's in the style, you can see the various styles at:
http://www.phpbb.com/styles/styles_demo/
OR
if you are into it, you can create your own. It's on the admin section. Glad I could help If you want, you can check out my phpBB2 board:
www.masterc.no-ip.org/forums

I have a few of the mods on there (like quick reply) and a few of the styles available so you can get a feel for how things work.

Cool
 
Old 06-01-2003, 12:33 AM   #10
psycho2000
LQ Newbie
 
Registered: May 2003
Posts: 15

Original Poster
Rep: Reputation: 0
@ MasterC

Not sure if you can help but I when to go to continue my work on my board and got this error...

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/phpBB2/db/mysql4.php on line 48

Now I have completely uninstalled and reinstalled the MySQL server/client/libraries, deleted and reinstalled phpBB and dropped the old table. I then started the install again and entered in the same information but everytime I go to enter the information I get the following error..

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

I am really ready to throw the whole lot away......

Any help would be great

P2000
 
Old 06-01-2003, 12:46 AM   #11
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
hmm...

Do you have mysql running? To check:
ps aux
Look for anything referring to mysql. You can grep too:
ps aux | grep mysql

FYI: I don't like using RPM's for anything big. They work fine for small things like IM apps, and basic "workstation" tools. But for server applications such as Apache, MySQL, or PHP I prefer grabbing a tarball and working with it. That way you know what you have, AND more importantly, you know what you don't have.

The documentation on all 3 of these things are excellent as it is, so the need for RPM's to install it is minimized. The main drawback is that you are expected to have a little linux knowledge.

Check your mysql setup to see that you are supplying the correct information to PHPBB2 for access to the database. Things like username/pass are important, and definitely SHOULD NOT be using root's info there.

Cool
 
Old 06-01-2003, 01:07 AM   #12
psycho2000
LQ Newbie
 
Registered: May 2003
Posts: 15

Original Poster
Rep: Reputation: 0
OK

Have done that - found the following:
root 6223 0.0 0.6 1700 604 pts/2 S 15:35 0:00 grep mysql

no other process are running (have uninstalled the lot again....).

Is there anything I should do before reinstalling (should I try another version or such?)

Cheers

P2000
 
Old 06-01-2003, 01:13 AM   #13
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
That is just showing you your grep, that means you don't have mysql running. Start it up first To start it up, I use:
/etc/rc.d/mysql.server start
However, more than likely you won't. There should be some other way for you, something like:
/etc/init.d/mysql start
OR
/usr/local/mysql/support-files/mysql.server start
Assuming that mysql is installed to that location.

Either way, you've got to get it started for it to work

Which versions of all these are you running? PHP, Apache, mysql, phpbb

Cool
 
Old 06-01-2003, 01:20 AM   #14
psycho2000
LQ Newbie
 
Registered: May 2003
Posts: 15

Original Poster
Rep: Reputation: 0
OK here goes

Apache : 1.3.27-2
PHP:4.1.2-7.3.6
MySQL :4.0.13-0 (server, client and dynamic libs)
phpBB2: 2.0.4

Am about to reinstall mysql AGAIN and try again. Is there anything I should do beforehand (ie restart box etc)?

Sorry to sound like a complete newbie - just annoyed that I got the bl@sted thing working yesterday just to have it fall over today but as a tech I should be used to it.....

Cheers

P2000
 
Old 06-01-2003, 01:35 AM   #15
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
How did you install mysql? Are you grabbing the binary tarball? If not, do. Follow those instructions, works great.

Those versions are the same as mine, so everything should be working out together. Before you do re-install, start your mysql server and see if that fixes it. What are you using as your mysql administration tool? phpmyadmin? I've been able to do it all via the command line, just reading through the docs at www.mysql.com and working around my system, so if you need help I'll be glad to give it, but it will be via the command line since I don't use phpMyAdmin.

Cool
 
  


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




All times are GMT -5. The time now is 12:53 PM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration