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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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