Critical error connecting to IPB 1.3 database Critical error connecting to IPB 1.3 database
 

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

Critical error connecting to IPB 1.3 database

Started by Jaero, November 07, 2004, 08:55:52 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Jaero

QuoteCoppermine critical error:
Unable to connect to Invision Board database !

MySQL said: Access denied for user: 'planetme_ibrd1@localhost' (Using password: YES)

Here's the code from my bridge file:
Quote// database configuration
define('IB_DB_NAME', 'planetme_ibrd1'); // The name of the database used by the board
define('IB_BD_HOST', 'localhost'); // The name of the database server
define('IB_DB_USERNAME', 'planetme_ibrd1'); // The username to use to connect to the database
define('IB_DB_PASSWORD', '********'); // The password to use to connect to the database

// The web path to your Invision Board directory
// In this example http://yoursite_name.com/ivboard/
define('IB_WEB_PATH', '/forums/');
// ------------------------------------------------------------------------- //
// You can keep the default values below if your installation is standard
// ------------------------------------------------------------------------- //
// The prefix for the Invision Board cookies
define('IB_COOKIE_PREFIX', ''); // The prefix used for board cookies

// Prefix and names for the database tables
define('IB_TABLE_PREFIX', 'ibf_'); // The prefix used for the DB tables
define('IB_USER_TABLE', 'members'); // The members table
define('IB_SESSION_TABLE', 'sessions'); // The sessions table
define('IB_GROUP_TABLE', 'groups'); // The groups table

// Group definitions (default values used by the board)
define('IB_VALIDATING_GROUP', 1);
define('IB_GUEST_GROUP', 2);
define('IB_MEMBERS_GROUP', 3);
define('IB_ADMIN_GROUP', 4);
define('IB_BANNED_GROUP', 5);

And from my MySQL database:
QuoteConnection Strings
Perl $dbh = DBI->connect("DBI:mysql:planetme_ibrd1:localhost","planetme_ibrd1","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "planetme_ibrd1", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("planetme_ibrd1"); 

Both the DB_NAME and DB_USERNAME are the same thing. The password I'm sure is what it should be in the bridge file. All the information checks out. A few things to note - in my forum, I have 3 more custom groups, so I'm not sure how that would affect the bridge. My forum is also installed at http://forums.domainname.com and the gallery at http://forums.domainname.com/fanart - I'm not sure if that's acceptable. However, since the forums can be accessed from http://www.domainname.com/forums (and the gallery from ../fanart/), that is why I defined the web path as "define('IB_WEB_PATH', '/forums/');".

I'm just getting the hang of the code, but I don't have any idea why I'm getting this error.
Jaero - jaero@warcry.com
Site Manager - ME Warcry
http://me.warcry.com

Jaero

I also tried adding the CPG user to the forum database, hoping the problem was that the forum database was protecting itself - that didn't seem to work either.
Jaero - jaero@warcry.com
Site Manager - ME Warcry
http://me.warcry.com

Jaero

Err, problem solved. Created new user in database and granted it the permissions. Also fixed the cookie issue with having the forums in a subdomain - made the forum cookie global ('.domainname.com').

Thanks for your help. :P
Jaero - jaero@warcry.com
Site Manager - ME Warcry
http://me.warcry.com