LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
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 07-07-2003, 03:10 PM   #1
nautilus_1987
Member
 
Registered: Aug 2002
Distribution: Slackware 8.1
Posts: 750

Rep: Reputation: 30
phpBB


Hello!
I am trying to install phpBB now and I really need some help.
I have downloaded phpBB 2.05 copied it to my server. And started the install (install.php). BTW I have compiled Apache with PHP 4.3.0 + MySQL 4.x. So I think that's enough for phpBB to run. Now I am complicated with such fields:
===========
Database Server Hostname / DSN:
Your Database Name:
Database Username:
Database Password:
Prefix for tables in database:
=================
What should I type here?
 
Old 07-07-2003, 03:16 PM   #2
Proud
Senior Member
 
Registered: Dec 2002
Location: England
Distribution: Used to use Mandrake/Mandriva
Posts: 2,794

Rep: Reputation: 116Reputation: 116
The details for your MySQL database doodle?
 
Old 07-07-2003, 03:19 PM   #3
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
Use these values - you need to create a database and asign permissions first (see below):
Database Server Hostname / DSN: localhost
Your Database Name: phpbb
Database Username: phpbb
Database Password: (see below - YOURPASSWORD)
Prefix for tables in database: (leave as is)

Create the db:
mysqladmin create phpbb

Add the privilages:
mysql

Then at the prompt:
grant all on phpbb.* to phpbb@localhost identified by 'YOURPASSWORD';
 
Old 07-07-2003, 03:25 PM   #4
nautilus_1987
Member
 
Registered: Aug 2002
Distribution: Slackware 8.1
Posts: 750

Original Poster
Rep: Reputation: 30
interesting ......... when I type 'mysqladmin create phpbb' it gives following errors:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

???
 
Old 07-07-2003, 03:27 PM   #5
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
You probably don't have mysql running - start it then try again.
 
Old 07-07-2003, 03:31 PM   #6
nautilus_1987
Member
 
Registered: Aug 2002
Distribution: Slackware 8.1
Posts: 750

Original Poster
Rep: Reputation: 30
1. I am not familiar with 'how to run mysql'
2. I have tried alot of commands starting with 'mysql' prefix and all they drop similar error. Can't open socket
 
Old 07-07-2003, 03:37 PM   #7
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
Try this:

/etc/init.d/mysqld restart

to restart mysql.
 
Old 07-07-2003, 03:38 PM   #8
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
http://www.mysql.com/documentation/m...utomatic_start
 
Old 07-07-2003, 04:56 PM   #9
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 235Reputation: 235Reputation: 235
On Slackware do this first:

Code:
mysql_install_db
chown -R mysql.mysql /var/lib/mysql
safe_mysqld &
This will get your mysql server running.

Then to create another database instead of using the default one created by the mysql_install_db command, do what david_ross mentioned with the:

Code:
mysqladmin create phpbb
I would just opt to just use the database mysql though if you want to.

And then you can connect as root to mysql like this and then do these commands to grant a user that you will use for the phpbb board like this, if your going to use the default mysql DB that is installed already:

Code:
bash# mysql
mysql> use mysql
mysql> grant all on mysql.* to username@localhost identified by 'YOURPASSWORD' with grant option;
If you want your mysql to start automatically at boot time, do this:

Code:
cp /usr/share/mysql/mysql.server /etc/rc.d/
cd /etc/rc.d
mv mysql.server rc.mysql
Then you can edit your particular runlevel you boot to to start mysql with something like this in the file, for example runlevel 3 would be rc.M:
Code:
if [ -x /etc/rc.d/rc.mysql ] then
  . /etc/rc.d/rc.mysql start
fi
You can add the same thing on your reboot and shutdown scripts but instead stop mysql with the stop command in place of start to properly shut it down.

Hope this helps out..
 
Old 07-08-2003, 02:27 AM   #10
nautilus_1987
Member
 
Registered: Aug 2002
Distribution: Slackware 8.1
Posts: 750

Original Poster
Rep: Reputation: 30
thanks trickykid, but
[root@ ~]# mysqladmin create phpbb
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
=========
Maybe I have to login as simple user?
 
Old 07-08-2003, 02:36 AM   #11
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
Hey Nautilus, how's it goin?

Try logging is as the root user into mysql:
#mysql -u root -p

It should then prompt you for your root password (for mysql, not your root password for your system, these are seperate entities), so enter it. IF you get to a:
mysql>
Prompt, then you are good to go, but if you don't, or you haven't setup a root password in mysql, then that's what you should do.

You might wanna have a read over the mysql docs at www.mysql.com It really helped me get a slight hold on how mysql works, and how to use it. I still get caught up sometimes, but usually referring back to the docs works out the kinks.

Good Luck!

Cool
 
Old 07-08-2003, 08:32 AM   #12
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 235Reputation: 235Reputation: 235
Quote:
Originally posted by nautilus_1987
thanks trickykid, but
[root@ ~]# mysqladmin create phpbb
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
=========
Maybe I have to login as simple user?
And if that doesn't work for some unknown reason for the instructions MasterC gave, login as root then simply type:
Code:
# mysql
And that should allow you access. Then see if you can't setup a user with permissions in the above steps, etc.
 
Old 07-08-2003, 10:04 AM   #13
nautilus_1987
Member
 
Registered: Aug 2002
Distribution: Slackware 8.1
Posts: 750

Original Poster
Rep: Reputation: 30
Quote:
Hey Nautilus, how's it goin?
everything is ok Chad (except mysql )
===============
some strange stuff is happenning ........ People what version of mysql you are using? Mine is 3.2.25

Last edited by nautilus_1987; 07-08-2003 at 10:16 AM.
 
Old 07-08-2003, 10:07 AM   #14
nautilus_1987
Member
 
Registered: Aug 2002
Distribution: Slackware 8.1
Posts: 750

Original Poster
Rep: Reputation: 30
I remember when I was installing Apache + PHP + Mysql, everything was running smoothly ....... really. I have created a database, set pass .... interesting. Maybe I should upgrade mysql ?
 
Old 07-08-2003, 11:00 AM   #15
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
I'm using one from the 4.x tree, I believe it's 4.0.13, yes, just checked.

Working smoothly, and appears to be the suggested version in everything I've used lately. Might be worth a shot, follow the install docs perfectly and you shouldn't have a hitch at all.

Good Luck

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
phpBB and MySQL The_Messiah Linux - Software 5 04-18-2005 01:34 PM
PhpBB m3trj Linux - Software 1 03-08-2005 02:55 PM
phpBB help?? halo14 Linux - General 2 01-26-2005 05:04 PM
Help configuring phpbb kola Linux - Networking 5 01-08-2005 11:46 PM
phpbb... xconspirisist LQ Suggestions & Feedback 12 11-24-2003 01:22 PM


All times are GMT -5. The time now is 10:50 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