coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: JSi on October 31, 2004, 05:36:50 AM

Title: database configuration Help
Post by: JSi on October 31, 2004, 05:36:50 AM
Need help. Don't know what to put in these two lines for my phpBB Forum.

// 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.
Title: Re: database configuration Help
Post by: CapriSkye 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.
Title: Re: database configuration Help
Post by: JSi 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
Title: Re: database configuration Help
Post by: Joachim Müller 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
Title: Re: database configuration Help
Post by: JSi on October 31, 2004, 08:04:21 PM
Quote from: GauGau 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).

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.
Title: Re: database configuration Help
Post by: Joachim Müller on November 02, 2004, 02:30:44 AM
Quoteselect command denied to user
insufficient permissions for mySQL user - I guess you're self-hosted ;)

Joachim
Title: Re: database configuration Help
Post by: JSi on November 02, 2004, 05:02:23 AM
Quote from: GauGau on November 02, 2004, 02:30:44 AM
Quoteselect command denied to user
insufficient permissions for mySQL user - I guess you're self-hosted ;)


So now what? How do I fix this?
Title: Re: database configuration Help
Post by: Joachim Müller 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