Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: database configuration Help  (Read 3788 times)

0 Members and 1 Guest are viewing this topic.

JSi

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
database configuration Help
« on: October 31, 2004, 05:36:50 am »

Need help. Don't know what to put in these two lines for my phpBB Forum.

Code: [Select]
// database configuration
define('PHPBB_DB_NAME', 'phpBB'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server

How do I get the database Name used by the board? How do I know what it is?
How do I get the name of the database Server?

My forum address is www.infectinc.com/forum/
Is "forum" the name of the database used by the board?
Will "infectinc" be the localhost?

 ???

Can I get an example of what is used in another forum? That might help.
Logged

CapriSkye

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Posts: 126
    • 森林之原
Re: database configuration Help
« Reply #1 on: October 31, 2004, 07:03:38 am »

did you install the board yourself? you should've created a database for phpbb when you installed the forum, and it would be the name you made up. do you have access to mysql database? using phpmyadmin maybe?
and the host is where mysql resides on, usually just localhost.
Logged

JSi

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
Re: database configuration Help
« Reply #2 on: October 31, 2004, 01:25:43 pm »

OK. I got it but I get this  ???

Fatal error :
There was an error while processing a database query
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: database configuration Help
« Reply #3 on: October 31, 2004, 02:08:08 pm »

temporarily disable integration (edit include/init.inc.php, re-add double slashes you removed before), log in to coppermine using your standalone admin account you created during install, go to coppermine config, enable debug mode (very bottom of screen), log out, (edit include/init.inc.php, remove double slashes you added before), go to coppermine once again in your browser and post the exact error message (the query that actually failed).

Joachim
Logged

JSi

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
Re: database configuration Help
« Reply #4 on: October 31, 2004, 08:04:21 pm »

temporarily disable integration (edit include/init.inc.php, re-add double slashes you removed before), log in to coppermine using your standalone admin account you created during install, go to coppermine config, enable debug mode (very bottom of screen), log out, (edit include/init.inc.php, remove double slashes you added before), go to coppermine once again in your browser and post the exact error message (the query that actually failed).

Ok, this is what I get:

There was an error while processing a database query.
While executing query "SELECT (ug.group_id + 5) as group_id FROM `infect_phpb1`.phpbb_user_group as ug LEFT JOIN `infect_phpb1`.phpbb_groups as g ON ug.group_id = g.group_id WHERE user_id = 2 AND user_pending = 0 AND group_single_user = 0" on 0
mySQL error: select command denied to user: 'infect_copp1@localhost' for table 'phpbb_user_group'


I use phpMyAdmin. Just in case you need to know that.
Thanx for your help. I hope I can get this fixed soon.
« Last Edit: October 31, 2004, 08:14:55 pm by JSi »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: database configuration Help
« Reply #5 on: November 02, 2004, 02:30:44 am »

Quote
select command denied to user
insufficient permissions for mySQL user - I guess you're self-hosted ;)

Joachim
Logged

JSi

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
Re: database configuration Help
« Reply #6 on: November 02, 2004, 05:02:23 am »

Quote
select command denied to user
insufficient permissions for mySQL user - I guess you're self-hosted ;)


So now what? How do I fix this?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: database configuration Help
« Reply #7 on: November 02, 2004, 08:52:34 am »

go to your mySQL console and set the permissions accordingly - not coppermine related. Check the mySQL manual for details.

Joachim
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 16 queries.