Topic: Unable to Log in :: MySQL access denied (Read 23439 times)

JodyLamb · « **on:** August 04, 2009, 11:41:37 pm »

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'mylogin'@'localhost' (using password: NO)

Gallery Link: http://ramblinrhodesmusic.com/specials/

I changed the MySQL password in the config.inc.php. This would not allow my public page to be displayed.
I changed it back and public page is visible, but still getting the error above when selecting Login.

Tried to debug mode in phpMyAdmin on the config file, but was unable to log in after changing the setting to 1. Changed it back to 0.

Contacted my Host and am currently trying to see if the problem lies there, but have no solution yet. Still communicating.

Am I missing another option somewhere? Thanks in advance for you help.

François Keller · « **Reply #1 on:** August 04, 2009, 11:55:22 pm »

hum, your gallery is running cpg1.4.20, upgrade to the latest stable version -cpg1.4.25 for now
it's not a bright idea to put a black police color on a black background for the "powered by Coppermine".
If you want support here, please don't breack the rules

JodyLamb · « **Reply #2 on:** August 05, 2009, 12:00:50 am »

If I could log in as ADMIN, I would gladly fix the Coppermine tag line color oversight.
I will try the upgrade now.

Fabricio Ferrero · « **Reply #3 on:** August 05, 2009, 12:10:03 am »

Quote from: JodyLamb on August 05, 2009, 12:00:50 am

If I could log in as ADMIN, I would gladly fix the Coppermine tag line color oversight.

It's not needed, just edit the style.css file from the theme you're using.

JodyLamb · « **Reply #4 on:** August 05, 2009, 12:22:52 am »

I have corrected my mistake.
Powered by Coppermine is now a white police car in the dark.

JodyLamb · « **Reply #5 on:** August 05, 2009, 01:03:23 am »

Following the instructions: 3.1.3 Upgrading from cpg1.4.0 or better to version cpg1.4.25

I ran the update.php and the following errors occurred:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'rambccom'@'localhost' (using password: NO) in /home/rambccom/public_html/specials/update.php on line 46

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/rambccom/public_html/specials/update.php on line 46

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rambccom/public_html/specials/update.php on line 47

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/rambccom/public_html/specials/update.php on line 50

François Keller · « **Reply #6 on:** August 05, 2009, 07:10:31 am »

seems you have a problem with the database connection datas: check your include/config.inc.php file once more and enable manually the debugg mode http://coppermine-gallery.net/tutorial/debug_mode.php

Joachim Müller · « **Reply #7 on:** August 05, 2009, 08:06:57 am »

Enabling debug_mode will not help in that case if you get the error message you posted about initially, but that appears to have gone away, as you now just have the words "fatal error" on the screen, so the other recommendation Francois posted seems to have applied - you already seem to have edited http://ramblinrhodesmusic.com/specials/include/config.inc.php
Therefore, do as Francois suggested and manually enable debug_mode. After that, post the actual error message you get (the query that fails). Do not post debug_output here though.

JodyLamb · « **Reply #8 on:** August 05, 2009, 02:45:26 pm »

Fatal Error Message run from Debug Mode:

While executing query "delete from `rambccom_copp1`.cpg_sessions where time<1249472603 and remember=0;" on Resource id #5

mySQL error: Table './rambccom_copp1/cpg_sessions' is marked as crashed and should be repaired

Joachim Müller · « **Reply #9 on:** August 05, 2009, 03:52:09 pm »

Then do as the error message suggests and repair the crashed table. Not related to coppermine, but a straightforward database question that has been asked and answered countless times: http://lmgtfy.com/?q=%22mySQL+error%22+%22Table+is+marked+as+crashed+and+should+be+repaired%22 (25k+ results).

JodyLamb · « **Reply #10 on:** August 05, 2009, 06:05:01 pm »

The crashed table repaired, I am now back to the original error:

Coppermine critical error:Unable to connect to database !
MySQL said: Access denied for user 'rambccom'@'localhost' (using password: NO)

I debugged and checked the config.inc.php file. I am upgraded to the latest version.
I have another CPG running on the same server and it is fine, so it is not the host.

Joachim Müller · « **Reply #11 on:** August 06, 2009, 07:42:41 am »

The error message

Quote

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'rambccom'@'localhost' (using password: NO)

indicates that the mysql access data specified in http://ramblinrhodesmusic.com/specials/include/config.inc.php are wrong. Download that file to yopur client using FTP, use a plain text editor and verify the data, then re-upload the file (overwriting the file on the server).

JodyLamb · « **Reply #12 on:** August 06, 2009, 03:31:33 pm »

dbserver = localhost ........I am assuming this is correct as I cannot find documentation to change it
dbuser= this info is correct and is the same as the dbname
dbpass = As far as I know this is correct. If I change it, I am unable to view the folder that contains the public Coppermine file.

The problem is after I view the PUBLIC coppermine file, I am unable to venture further into the data....Cannot log in, cannot view albums or any other aspects.

JodyLamb · « **Reply #13 on:** August 06, 2009, 03:34:29 pm »

The Host put a test php script to connect to the same database using the same user ad password, which worked perfectly ( http://ramblinrhodesmusic.com/specials/testmysql.php) . So it seems to be some configuration in the coppermine that is creating the conflict.

Nibbler · « **Reply #14 on:** August 06, 2009, 03:50:26 pm »

I think this is the result of a hack. Check your Coppermine directory for an .htaccess file and get your host to check what /home/rambccom/public_html/liblib.php is doing.

JodyLamb · « **Reply #15 on:** August 06, 2009, 05:06:01 pm »

Thank you Nibbler. Where were you the last two days when I needed you? Went through a lot of hoops for naught.
I deleted the .htaccess and the liblib.php. and now I'm back in business.
Many, many thanks.

François Keller · « **Reply #16 on:** August 06, 2009, 06:19:53 pm »

Quote

and now I'm back in business.
Many, many thanks.

fine, but your gallery is allways outdated and you can be re-hacked... so upgrade for your security.

Quote

Went through a lot of hoops for naught.

hum it's your opinion. as a lot of users are pretty sure that theire config.inc.php file is fine and at the end find an error, it's normal that we ask you to check and re-check his content.... $:-\$

JodyLamb · « **Reply #17 on:** August 06, 2009, 10:29:41 pm »

I updated to the latest release of Coppermine following instructions per: instructions: 3.1.3 Upgrading from cpg1.4.0 or better to version cpg1.4.25

I uploaded all of the new files and directories making sure not to overwrite the include/config.inc.php file, my anycontent.php file or the albums directory. I uploaded my versions of include/config.inc.php file, my anycontent.php file and my albums directory.

Then I ran the update.php. Now I have a new error.

Could not create a mySQL connection, please check the SQL values in include/config.inc.php
MySQL error was : Access denied for user 'rambccom_copp1'@'localhost' (using password: YES)

I checked the config.inc.php file and it has not changed. There is no hack file present that I know of.
The test works: http://ramblinrhodesmusic.com/specials/testmysql.php

How do I find out what the correct MySQL password is suppose to be?

Joachim Müller · « **Reply #18 on:** August 06, 2009, 10:40:25 pm »

Quote from: JodyLamb on August 06, 2009, 10:29:41 pm

How do I find out what the correct MySQL password is suppose to be?

Ask your webhost. We can't tell you.

Don't assume that you're clean - do as suggested in the Yikes thread; just upgrading is not enough after having been hacked.

JodyLamb · « **Reply #19 on:** August 06, 2009, 10:51:36 pm »

I checked with my host and I am using the correct password. So my config.inc.php is correct as is the other information in that file.
Any idea how I can get rid of this error?

Could not create a mySQL connection, please check the SQL values in include/config.inc.php
MySQL error was : Access denied for user 'rambccom_copp1'@'localhost' (using password: YES)

I am in another window reading through your Yikes thread presently.

News:

Author Topic: Unable to Log in :: MySQL access denied (Read 23439 times)

Nibbler