Advanced search  

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]

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Unable to Log in :: MySQL access denied
« 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.
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: Unable to Log in :: MySQL access denied
« 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
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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.
Logged

Fabricio Ferrero

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 1996
  • From San Juan, Argentina, to the World!
    • http://fabricioferrero.com/
Re: Unable to Log in :: MySQL access denied
« Reply #3 on: August 05, 2009, 12:10:03 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.
Logged
Read Docs and Search the Forum before posting. - Soporte en español
--*--
Fabricio Ferrero's Website

Catching up! :)

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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.
Logged

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: Unable to Log in :: MySQL access denied
« 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
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to Log in :: MySQL access denied
« 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.
Logged

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to Log in :: MySQL access denied
« 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).
Logged

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to Log in :: MySQL access denied
« 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).
Logged

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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.
Logged

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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.
Logged

Nibbler

  • Guest
Re: Unable to Log in :: MySQL access denied
« 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.
Logged

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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.
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: Unable to Log in :: MySQL access denied
« 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.... :-\
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to Log in :: MySQL access denied
« Reply #18 on: August 06, 2009, 10:40:25 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.

Logged

JodyLamb

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Unable to Log in :: MySQL access denied
« 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 20 queries.