Forums / Upgrading to 1.5.x / Can't upgrade db: Admin Password Required- but won't accept my password

Can't upgrade db: Admin Password Required- but won't accept my password

Views: 14,585

Results 1 to 20 of 88
6 Jul 2014, 3:49 PM
#1
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Can't upgrade db: Admin Password Required- but won't accept my password

I'm upgrading from 1.5.2 to 1.5.3. When I go to upgrade the db, I'm getting 'Admin Password required to proceed with upgrade'. To reset the admin password, to be sure I was using the right one, but get the same error.

Jim
Wheaton Website Services

6 Jul 2014, 3:56 PM
#2
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

I reset the admin password via phpMyAdmin and then was able to proceed with the db upgrade. Not sure what the original issue was.

Jim
Wheaton Website Services

19 Jul 2014, 3:14 PM
#3
ellivir avatar

ellivir

Zen Follower

Join Date:
Sep 2005
Posts:
444
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

The same problem when upgrading from 1.5.1 to 1.5.3.
It keeps asking the admin password even if I surely give it correctly. Refuses to patch the db because of that.
The site also has an annoying red warning about the db needing patching…

I may be blond but at least I found Zen.

19 Jul 2014, 3:37 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Can't upgrade db: Admin Password Required- but won't accept my password

We've identified a bug with that password validation specific to v1.5.3. We're working on a fix.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

19 Jul 2014, 4:18 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Can't upgrade db: Admin Password Required- but won't accept my password

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

20 Jul 2014, 8:09 AM
#6
ellivir avatar

ellivir

Zen Follower

Join Date:
Sep 2005
Posts:
444
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

Thanks DrByte,
now it accepts the password but the next page is BLANK and the logs has this Fatal Error:

PHP Fatal error: require_once(): Failed opening required '/home/myserverspace123/public_html/shop/../includes/classes/vendors/password_compat-master/lib/password.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/myserverspace123/public_html/shop/includes/classes/class.zcPassword.php on line 52

I may be blond but at least I found Zen.

20 Jul 2014, 1:19 PM
#7
darkangel avatar

darkangel

Totally Zenned

Join Date:
Oct 2007
Location:
Emporia, Kansas
Posts:
1,729
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

I am running the update from 1.5.1 to 1.5.3 in a test store prior to doing his live one.

got this message, applied the "password fix", yes I started out with the download from the Sourceforge page. I can now use the password to access admi but...now I get a whie page with this error:

PHP Fatal error: Class 'zcPassword' not found in /home/server/public_html/teststore/includes/functions/password_funcs.php on line 15

that code from 11-17:

// //
// This function validates a plain text password with an encrpyted password
function zen_validate_password($plain, $encrypted, $userRef = NULL)
{
$zcPassword = zcPassword::getInstance(PHP_VERSION); <----this is the line
return $zcPassword->validatePassword($plain, $encrypted);
}

what do I do now, it was working last night.

20 Jul 2014, 1:38 PM
#8
laurelsstitchery avatar

laurelsstitchery

Zen Follower

Join Date:
Jun 2010
Posts:
145
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

ellivir:

Thanks DrByte,
now it accepts the password but the next page is BLANK and the logs has this Fatal Error:

PHP Fatal error: require_once(): Failed opening required '/home/myserverspace123/public_html/shop/../includes/classes/vendors/password_compat-master/lib/password.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/myserverspace123/public_html/shop/includes/classes/class.zcPassword.php on line 52

I have the same exact error. :)

20 Jul 2014, 5:44 PM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Can't upgrade db: Admin Password Required- but won't accept my password

DarkAngel:

I am running the update from 1.5.1 to 1.5.3 in a test store prior to doing his live one.

got this message, applied the "password fix", yes I started out with the download from the Sourceforge page. I can now use the password to access admi but...now I get a whie page with this error:

PHP Fatal error: Class 'zcPassword' not found in /home/server/public_html/teststore/includes/functions/password_funcs.php on line 15

that code from 11-17:

// //
// This function validates a plain text password with an encrpyted password
function zen_validate_password($plain, $encrypted, $userRef = NULL)
{
$zcPassword = zcPassword::getInstance(PHP_VERSION); <----this is the line
return $zcPassword->validatePassword($plain, $encrypted);
}

what do I do now, it was working last night.

DarkAngel, the "password fix" is only for the installer. It has nothing to do with the Admin side, so if you're seeing errors trying to log into the Admin, then that makes me wonder if you've removed files from the server.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

20 Jul 2014, 5:48 PM
#10
laurelsstitchery avatar

laurelsstitchery

Zen Follower

Join Date:
Jun 2010
Posts:
145
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

I know I haven't removed any files from catalog or admin side, but I'm still getting a white screen instead of the database being upgraded.

edited to add: The white screen in during the database upgrade. I get to the screen where you enter your login information at the bottom. I put in my username and password and hit the button to continue and it goes to a white screen.

20 Jul 2014, 5:50 PM
#11
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Can't upgrade db: Admin Password Required- but won't accept my password

laurelsstitchery, my last post was directed at DarkAngel, not you. I'm pretty sure your situations are different.

ellivir:

Thanks DrByte,
now it accepts the password but the next page is BLANK and the logs has this Fatal Error:

PHP Fatal error: require_once(): Failed opening required '/home/myserverspace123/public_html/shop/../includes/classes/vendors/password_compat-master/lib/password.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/myserverspace123/public_html/shop/includes/classes/class.zcPassword.php on line 52

laurelsstitchery:

I have the same exact error. :)
ellivir and laurelsstitchery,
Just double-checking ... what PHP version are you using?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

20 Jul 2014, 5:54 PM
#12
laurelsstitchery avatar

laurelsstitchery

Zen Follower

Join Date:
Jun 2010
Posts:
145
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

I'm on 5.4.30 :)

20 Jul 2014, 6:12 PM
#13
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Can't upgrade db: Admin Password Required- but won't accept my password

laurelsstitchery:

I'm on 5.4.30 :)
Puzzling.
Ajeh and I have tested on 5.3.10 and 5.4.30 and 5.5.7 and had no problems with it. Hmmmm...

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

20 Jul 2014, 6:14 PM
#14
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Can't upgrade db: Admin Password Required- but won't accept my password

Granted, I think our configure.php files are all built with v1.5.3, not copied from older versions.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

20 Jul 2014, 6:17 PM
#15
laurelsstitchery avatar

laurelsstitchery

Zen Follower

Join Date:
Jun 2010
Posts:
145
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

If I went ahead and ran the SQL files via the patch installer in admin, would it work?

20 Jul 2014, 6:17 PM
#16
laurelsstitchery avatar

laurelsstitchery

Zen Follower

Join Date:
Jun 2010
Posts:
145
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

I guess if the whole thing imploded, it's not a huge deal because this is just a test site on my new host's server.

20 Jul 2014, 6:38 PM
#17
darkangel avatar

darkangel

Totally Zenned

Join Date:
Oct 2007
Location:
Emporia, Kansas
Posts:
1,729
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

no i did not remove any either but...it seems that although super orders is great in 1.5.1 and lower, it does not place nice with 1.5.3

It has a file that when it is on the server the admin will let you log in but then gives you a totally white page

so I removed the file and was able to get back the admin section.

I also noticed that it worked to edit the files in 1.5.1 but this version has different coding so it choked up.

Hope the mod creators for ty tracker, superorders and edit orders get their packages updated with 1.5.3 code

20 Jul 2014, 6:49 PM
#18
laurelsstitchery avatar

laurelsstitchery

Zen Follower

Join Date:
Jun 2010
Posts:
145
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

Well, doing the patches via the SQL installer in admin didn't work either. Back to the drawing board.

20 Jul 2014, 7:07 PM
#19
laurelsstitchery avatar

laurelsstitchery

Zen Follower

Join Date:
Jun 2010
Posts:
145
Plugin Contributions:
0

Re: Can't upgrade db: Admin Password Required- but won't accept my password

This is off-topic for this thread I guess, but tell me if this will work:

  1. Downgrade to PHP 5.2 on new host
  2. Install ZC 1.5.1 on new host
  3. Backup database (1.5.1) on old host
  4. Import old database to new host
  5. Upgrade ZC to 1.5.3
  6. Upgrade PHP back to 5.4.30

I can't figure out another way to do it and have everything work.

20 Jul 2014, 7:31 PM
#20
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Can't upgrade db: Admin Password Required- but won't accept my password

Your upgrade issue is not an issue with PHP 5.4

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.