forum.coppermine-gallery.net

Support => Older/other versions => cpg1.3.x Support => Topic started by: mattpage on February 27, 2006, 04:49:03 pm

Title: My SQL help
Post by: mattpage on February 27, 2006, 04:49:03 pm

I had copermine installed, and everything was great.
But I tried to install some other software, and reset the mySQL password, and now coppermine doesnt work.

I went into the cong.inc.php and changed the settings (including the password) but its still not working.
I think maybe the db name is wrong, or something else? I am not sure exacly what.

Is there a way i can revert back to my old config, and just change the password field rather than everything?

Title: Re: My SQL help
Post by: Nibbler on February 27, 2006, 05:00:24 pm

You can't revert unless you made a backup copy yourself. You'll just have to enter the correct information or create a new db user for Coppermine to use.

Title: Re: My SQL help
Post by: mattpage on February 27, 2006, 05:09:16 pm

In the config.inc.php file what should the TABLE PREFIX be set to?
I have no idea what that means.

I have double checked the password, name and localhost bits. I cant see where I am going wrong.

When I try and go to coppermine I get this error:

Notice: Undefined index: dbname in /var/www/html/coppermine/include/functions.inc.php on line 65
Coppermine critical error:
Unable to connect to database !

MySQL said: No Database Selected


I've got lost of stuff there which I really don't want to loose, so I hope I can get it sorted.

Title: Re: My SQL help
Post by: Tranz on February 27, 2006, 05:13:27 pm

You need to peek into the database and look for the coppermine tables. They likely start with cpg. You need to enter something like cpg13_ for prefix, depending on what you see in the database.

Title: Re: My SQL help
Post by: mattpage on February 27, 2006, 05:20:13 pm

when I go into the admin tools for mysql it says I don't have a database  ???  :'(

Title: Re: My SQL help
Post by: mattpage on February 27, 2006, 05:23:45 pm

Delving a little deeper, when I go to the process list it has one entry

 Kill       96080       bikeshed       localhost       None       Query       0       ---       SHOW PROCESSLIST 



Does that mean its been deleted?
I'm confused.

Title: Re: My SQL help
Post by: Nibbler on February 27, 2006, 05:49:27 pm

Ignore that. The error message tells me you probably edited the wrong bits in the file. Post what you have here, use ***** to hide the user/pass. TABLE_PREFIX must match what you chose during installation but that is not the problem.

Title: Re: My SQL help
Post by: mattpage on February 27, 2006, 06:50:25 pm

<?php
// Coppermine configuration file

// MySQL configuration
$CONFIG['localhost'] =                         'localhost';        // Your databaseserver
$CONFIG['*****'] =                         'root';        // Your mysql username
$CONFIG['******'] =                         '';                // Your mysql password
$CONFIG['bikeshed_biz_-_bsdb'] =                         'coppermine';        // Your mysql database name


// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg132_';
?>

Is that what you wanted me to post?

Title: Re: My SQL help
Post by: Nibbler on February 27, 2006, 07:37:19 pm

Yup, should look like this.

Code: [Select]

<?php
// Coppermine configuration file

// MySQL configuration
$CONFIG['dbserver'] =                         'localhost';        // Your databaseserver
$CONFIG['dbuser'] =                         '******';        // Your mysql username
$CONFIG['dbpass'] =                         '******';                // Your mysql password
$CONFIG['dbname'] =                         'bikeshed_biz_-_bsdb';        // Your mysql database name


// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg132_';
?>


Title: Re: My SQL help
Post by: mattpage on February 27, 2006, 10:12:44 pm

ahhhh! I see ;D

Thank you!
I am still having problems mind. Access denied this time.
So I am guessing its a username or password issue.