error when clicking users tab error when clicking users tab
 

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]

Main Menu

error when clicking users tab

Started by satellite, March 14, 2011, 10:43:40 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

satellite

Coppermine install: www.forum.bombastic417.com/coppermine
Bridging app install: ../
Coppermine version: cpg1.5.12
Bridging app version: SMF 2.0 RC5
Test user account: test/test

BridgeManager settings:
Bridge app URL:  www.forum.bombastic417.com/coppermine
Relative path to your bridge app's config file: ../
Cookie name or prefix: cpg15x
Use bridge app custom groups?:  not sure what this is?

When i log into my forum i can go to www.forum.bombastic417.com/coppermine and it takes me in as admin.
When i click the user tab i get this message.

While executing query 'SELECT id_member AS user_id, real_name AS user_name, email_address AS user_email, date_registered AS user_regdate, last_login AS user_lastvisit, is_activated AS user_active, COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota FROM `db_smf`.smf_members AS u INNER JOIN `db_cpg`.cpg15x_usergroups AS g ON u.id_post_group+100 = g.group_id LEFT JOIN `db_cpg`.cpg15x_pictures AS p ON p.owner_id = u.id_member GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;' in bridge/udb_base.inc.php on line 230

mySQL error: Access denied for user: 'dbo_smf' to database 'db_cpg'

Thanks for the support ...ps. i posted this in the bugs section and then found this section i donnt know if someone can delette the other one.
Thanks Sat

satellite

Use bridge app custom groups?:  is set to 1

Αndré

#2
The error message should be quite self-explanatory:
QuotemySQL error: Access denied for user: 'dbo_smf@%' to database 'db_cpg'

Either you grant that MySQL user the needed privilege to access both databases, or you use the same database for SMF and Coppermine.

satellite

Hi Andre

I had a idea thats what it was but had no idea how i can actually fix it....never dont the mysql thing before.
I started with two databases and then after bridge and this error i tried to set the coppermine to that database by changing it in the config.inc.php.
But that just gave me white screens on my coppermine site and error mesages.

Any help you can give would be great .
Thanks Sat

satellite

#4
Andre

I dont know if this will help but dbo_smf@% is my SMF
and db_cpg is my coppermine.

mySQL error: Access denied for user: 'dbo_smf@%' to database 'db_cpg'

Αndré

Quote from: satellite on March 15, 2011, 05:39:43 PM
I started with two databases and then after bridge and this error i tried to set the coppermine to that database by changing it in the config.inc.php.
But that just gave me white screens on my coppermine site and error mesages.
Of course you have to import the Coppermine tables into that database.

satellite

OK so if i change the config.inc.php to direct it to my smf database i must also add the coppermine database into the smf database.
If i am right i remember reading coppermine came with a database you can manualy install would that be what you mean?

Αndré

If you have no data in your gallery you can simply delete the config.inc.php file and re-install Coppermine to your SMF database. Otherwise you have to use a tool like MySQLDumper to export your existing Coppermine database and import the tables to your SMF database. Make sure not to overwrite your existing SMF tables (there's somewhere an option where you can select if you want to drop all tables when importing a dump).

satellite

OK i uploaded one pic with the batch to test i can delete it and then also the confg.inc.php and then run the install.php again.
Would it be best to remove the bridge as well ?

satellite

YOU ARE THE MAN !!!!!!!!!!  ;D

OK i did as i said up above and it worked great just as you said it would.

Andre could you just edit the posts if you would and replace the numbers in my db........ for dots if you dont mine.
I donno if it makes it easy to hack the db but i just sooner be safe.
And thanks again for a great job.
Cheers happy Sat

Αndré

Quote from: satellite on March 15, 2011, 09:02:58 PM
Andre could you just edit the posts if you would and replace the numbers in my db........ for dots if you dont mine.
Done as requested.


Quote from: Joachim Müller on September 28, 2008, 12:46:26 PM
you can tag your answer as "solved" by clicking on the little image in your initial posting on your thread.