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: Can't Login to my website using Coppermine  (Read 6690 times)

0 Members and 1 Guest are viewing this topic.

ringsidephotos

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Can't Login to my website using Coppermine
« on: January 31, 2019, 04:32:34 pm »

I can't login to my website, which is using Coppermine. I haven't been on my site in a long time and I can't remember my login or password (please don't ask how that's possible... two surgerys last year, stress, memory loss). My site is ringsidephotos.com and I have a customized Coppermine installed. My webhosting (Lunarpages) says they don't store this data (login/password). Also, when I click on the lost password, it shows "Selected user does not exist!" I don't know how that's possible. What can I do to get into my website as the administrator?
Logged

FansCityEu

  • Coppermine newbie
  • Country: 00
  • Offline Offline
  • Posts: 17
  • FC
Re: Can't Login to my website using Coppermine
« Reply #1 on: January 31, 2019, 06:40:13 pm »

This happened to a few clients of mine when they upgraded to 1.6.x a few months back, when we made PHP 7.2 mandatory.

Steps:

1. Login to cPanel
2. Go to "Databases" > PhpMyAdmin
3.  Select your database
4. Go to cpg_users or (yourprefix_users), click on that table
5. You will see your user, click on "copy, change user_name to anything (admin2, for example), in user_password place a new password using MD5 Function (see: https://prnt.sc/mev75x) and click on "continue"
6. Login to your CPG gallery with that new user and change your old user's password through there.

You can also try just to change your user's user_password with MD5 function but sometimes does not work.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Can't Login to my website using Coppermine
« Reply #2 on: January 31, 2019, 10:01:48 pm »

FansCityEu

While your intentions are good, in truth the method you outline can cause more problems. A lot has changed in the database with the move to 1.6.x making it more important than ever to run update.php . There is quite a lot included in that script which is why it is mandatory to run it.

Please also be aware that version 1.6.x salts the passwords in a much more secure manner than either plain text or md5.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

ringsidephotos

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Can't Login to my website using Coppermine
« Reply #3 on: February 02, 2019, 04:27:21 pm »

Phil,
If the solution mentioned can cause more problems, what do you suggest I do?
Logged

ringsidephotos

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Can't Login to my website using Coppermine
« Reply #4 on: February 02, 2019, 04:28:56 pm »

Also, I know I have a much older version. How can I find out what version I have? Perhaps it's easier to retrieve my login and password with an older version?
Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 2026
Re: Can't Login to my website using Coppermine
« Reply #5 on: February 02, 2019, 05:42:32 pm »

The CPG version you are running is 1.5.46. The 6-step method to reset your password pointed out by FansCityEu should work for you without causing issue.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Can't Login to my website using Coppermine
« Reply #6 on: February 02, 2019, 06:43:41 pm »

Ok, just to clarify my comment above to FansCityEu, I was purely mentioning this for those that have upgraded where it is really important to run update.php. This site is still, Thanks Ron for checking, on CPG 1.5.x so this is purely password recovery. I will move this to the 1.5.x forums.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Can't Login to my website using Coppermine
« Reply #7 on: March 14, 2019, 09:52:56 pm »

For your information (as I've added the password salting to cpg1.6.x): it's fine to set the password string to a md5 hashed password even in cpg1.6.x, but you need to clear the user_password_salt field in addition, otherwise it won't work. Coppermine will salt it on next successful login of that user, as it's done for every non-salted password (they don't get salted all at once on upgrade, as that's just possible if we know the actual password).
« Last Edit: March 15, 2019, 08:58:44 pm by Αndré »
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.