Problem integrating CPG with phpBB

[panem]

I recently installed Coppermine, which worked fine as a stand-alone-application.
Now I tried to integrate it into my existing installation of phpBB, but after I applied all the changes mentioned in the documentation (http://coppermine.sourceforge.net/manual.php#integrating)
I received the following error message while trying to access coppermine:

Fatal error :

There was an error while processing a database query.

Since that is not very helpful, I turned on debug mode. Now when I try to access coppermine I get the following:

Fatal error :

There was an error while processing a database query.

While executing query "SELECT user_id, username as user_name, user_level FROM `phpBB`.phpbb_users WHERE user_id='3' AND user_password='*************'" on 0

mySQL error: select command denied to user: 'zoom-heli@localhost' for table 'phpbb_users'

(I replaced the "password" with asterisks)

Can anyone help me resolve this issue or point me in the right direction?

Thanks,
Matt

[Joachim Müller]

what version of cpg are you using?

GauGau

[panem]

Version 1.2.1

[Joachim Müller]

please paste the content of bridge/phpbb.inc.php, line 24-28 (replace the password with ***) into your posting; my guess is you haven't modified the bridge file correctly.

GauGau

[panem]

// ------------------------------------------------------------------------- //
// 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
define('PHPBB_DB_USERNAME', 'zoom-heli'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', '******'); // The password to use to connect to the database

[Joachim Müller]

are you sure your database name is phpbb? Is coppermine installed on the phpbb database as well?

GauGau

[panem]

Yes, both coppermine and phpbb share the same database. Would it be better if I used seperate databases?

[Joachim Müller]

no, you MUST use the same db. What about my first question: is the db actually called "phpbb"?

GauGau

[panem]

Sorry I took so long to respond, I had an urgent family emergency to deal with. :-\\
Anyway, back on-topic...

The database is indeed called "phpbb".

Matt