Database Upgrade Not Accepting Password 1.5.3-to-1.5.4

I uploaded the changed files since 1.53. When I click on the upgrade database button it tells me my password is incorrect.

I have the correct prefix (_zen), database name and user name.

I am entering my shop admin password and username not my database details in the upgrade database details.

PHP Version: 5.3.3 (Zend: 2.3.0)

My store admin password is correct as I renamed /zc_install/ to /1zc_install/ and I can login all good.

What I tried with no luck:
1/ Create a new user and try those login details.
2/ Re-uploaded /zc_install/
3/ tried /zc_install/includes/functions/general.php at http://www.zen-cart.com/showthread.php?213868-Known-Bugs-%28and-fixes%29-with-v1-5-3&p=1253144#post1253144
4/ Tried going back to the old code for /includes/classes/class.zcPassword.php http://www.zen-cart.com/showthread.php?213868-Known-Bugs-%28and-fixes%29-with-v1-5-3&p=1266905#post1266905

Kind regards
Tim

nuganics:

4/ Tried going back to the old code for /includes/classes/class.zcPassword.php http://www.zen-cart.com/showthread.php?213868-Known-Bugs-%28and-fixes%29-with-v1-5-3&p=1266905#post1266905
The fix in that post is what's in v1.5.4, and has worked on every combination of upgrade I was able to test.
If you have a unique case that's failing to allow the password to work, I'd appreciate knowing further details and a chance to get a copy of your files+database for testing, if you're willing.

More tests:
1/ Install a clean version of 1.5.4 works fine on PHP 5.3.3 (this is the highest PHP version number on CentOS 6.6).
2/ Installed a clean version of 1.5.3 with hotfixes from http://sourceforge.net/projects/zencart/files/CURRENT%20-%20Zen%20Cart%201.5.x%20Series/ . I completed the install so ready to use (zc_install removed, admin folder renamed, permissions correct and password updated on first login). I then only uploaded the /zc_install/ folder from 1.5.4 and tried a database upgrade but I still get "Admin Password required to proceed with upgrade".
3/ I deleted all the files except for the 2 configure.php files and kept the 1.5.3 database. I uploaded all the clean 1.5.4 files and run zc_install and get the same issue when I try to update the 1.5.3 database.

My guess it is a issue with new \zc_install\includes\functions\general.php and PHP Version: 5.3.3 as the 3rd test above should work as all 1.5.4 files. I don't know PHP to figure out the issue but maybe the below is a place to start (didn't fix the issue for me)?
Was
require('../includes/classes/class.zcPassword.php');

Now
require (realpath(dirname(FILE)) . '/../../../includes/classes/class.zcPassword.php');

I am not sure what else I can try?

Kind regards
Tim

I'm in the same boat. 1.5.3 was working fine up until it stopped accepting orders. 1.5.4 would not complete the database update. No amount of password resetting via Cpanel would make a difference. Finally converted PHP from 5.2 to 5.3 and that did the trick.

No idea how long 5.3 will remain viable, but hopefully long enough that it won't be an issue in the near future. Not knowing what all those terms mean and why they won't play nice together is a real hassle when it ends up taking the store out of action.

PHP 5.3 had its EOL (end of life) in June or July of last year.> 14 Aug 2014 The PHP development team announces the immediate availability of PHP 5.3.29. This release marks the end of life of the PHP 5.3 series. Future releases of this series are not planned. All PHP 5.3 users are encouraged to upgrade to the current stable version of PHP 5.5 or previous stable version of PHP 5.4, which are supported till at least 2016 and 2015 respectively.

        PHP 5.3.29 contains about 25 potentially security related fixes 	     backported from PHP 5.4 and 5.5.

I was using PHP 5.3.3 but have installed PHP 5.4.16 and have that running but get the same result on a fresh install of Zen cart 1.5.3 try to upgrade database to 1.5.4.

I deleted the mysql user and created again and updated the config files with the new details but get the same issue.

I reset the password via Mysql query and logged in (renamed zc_install) and put in a new password. Tried zc_install with new store admin login but get the same result.

Under /logs/ it creates 2 files but checks are OK and just has the below:
Jan 25 2015 16:17 -- database_upgrade
FATAL: Admin Password required to proceed with upgrade

Running out of ideas. Would be great if anyone has some suggestions.

Okay, I'm beginning to think what I'm seeing in your post is not a typo or misprint. Are you actually using files from 1.5.3, adding zc_install from 1.5.4, and then trying to update the existing 1.5.3 database to 1.5.4?
And, if not.... Are you using the admin password from the old database when upgrading?
Neither of your three steps above is a recommended way to upgrade ZC. Have you looked at http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading

nuganics:

I was using PHP 5.3.3 but have installed PHP 5.4.16 and have that running but get the same result on a fresh install of Zen cart 1.5.3 try to upgrade database to 1.5.4.

I deleted the mysql user and created again and updated the config files with the new details but get the same issue.

I reset the password via Mysql query and logged in (renamed zc_install) and put in a new password. Tried zc_install with new store admin login but get the same result.

Under /logs/ it creates 2 files but checks are OK and just has the below:
Jan 25 2015 16:17 -- database_upgrade
FATAL: Admin Password required to proceed with upgrade

Running out of ideas. Would be great if anyone has some suggestions.

In post 2 of this thread: http://www.zen-cart.com/showthread.php?215814-Upgrade-v1-53-to-v1-54-Database-Upgrade-Not-Accepting-Password&p=1269283#post1269283 Dr. Byte has offered to review the situation, if information would be shared. Might I suggest that instead of theorizing something that is completely unfamiliar, that the information requested to help figure out the cause be shared with those that have the knowledge of the system to help?

Also, do any of the issues identified in this next thread apply to your situation?
http://www.zen-cart.com/showthread.php?215694-Known-Bugs-%28and-fixes%29-with-v1-5-4

Can you post the php.ini from that server? Either paste the text, or attach the file as an attachment.

Please find the attached php.ini for PHP 5.4.16 running on this server. I copied out of Virtualmin PHP manual configure so I know it is the php.ini running and zc_install mentions PHP 5.4.16 (below)

Attachment: Attachment #14906

Other server settings:
Webserver = Apache/2.2.15
GD Version = GD bundled (2.1.0 compatible)
PHP include_path = .:/opt/rh/php54/root/usr/share/pear:/opt/rh/php54/root/usr/share/php

Thank you for having a look

Hi dbltoe,
Thank you for the reply. I installed a fresh version of Zen Cart 1.5.3 and works fine. I then moved all the 1.5.3 files into a sub-folder and uploaded all of 1.5.4 and put the configuration files into place and ran zc_install. When upgrading the database inside zc_install I am using the store admin login and password not the database username and password. zc_install or log files give no warnings of issues connecting to the database so I think the configuration files are ok but I gave it a go update the configuration files with the database login and password and still the same result. To test I am entering the right store admin login and password by renaming zc_install so I can login to the store and I can so login and pass are correct.

I think it is a issue with my PHP/Curl setup or I have corrupt files. Going to run another fresh install today of 1.5.3.

Cheers
Tim

Hi dbltoe,
I read the known bugs in 1.5.4 but don't think they apply http://www.zen-cart.com/showthread.php?215694-Known-Bugs-%28and-fixes%29-with-v1-5-4 . The only one xcache I am unsure about but I can't find it in php.ini or phpinfo so assume it isn't running. The closest I have is it is running Cloudflare but I have put it in development mode so Cloudflare is bypassed. PHP 5.3 is a dog as you mentioned. I am on CentOS 6.6 (PHP 5.3)and a bit crazy to try upgrade to CentOS 7 as it isn't perfect and I know know unix that well. I did https://www.virtualmin.com/documentation/web/multiplephp and it seems to be working great. I am keen to dump CentOS 6.6 and move to Ubuntu 14.04 CLI as the upgrade to newer Ubuntu LTS in a few years looks easier.

Kind regards
Tim

nuganics:

Please find the attached php.ini for PHP 5.4.16 running on this server. I copied out of Virtualmin PHP manual configure so I know it is the php.ini running and zc_install mentions PHP 5.4.16 (below)

Attachment: php.zip

Other server settings:
Webserver = Apache/2.2.15
GD Version = GD bundled (2.1.0 compatible)
PHP include_path = .:/opt/rh/php54/root/usr/share/pear:/opt/rh/php54/root/usr/share/php

Thank you for having a look
I see no related issues with that.

Another debugging idea:

1. Fresh install v1.5.4
2. Import v1.5.3 data into the v1.5.4 database
3. Look at the "admin" table in the database, and record the password hash for the admin user you're trying to login as.
4. Run zc_install to attempt a database upgrade. Supply the admin username and the corresponding password (just to be clear, that's not the hash above)
5. Does it come back saying password invalid?
   If so, carry on:
6. Go back to the database, and in the "admin" table, grab the new password hash for that same user.
7. Post the 2 hashes here. They're not vulnerable. Please don't alter any characters, because the patterns are important for understanding what's happening.

DrByte:

Another debugging idea:

1. Fresh install v1.5.4
2. Import v1.5.3 data into the v1.5.4 database
3. Look at the "admin" table in the database, and record the password hash for the admin user you're trying to login as.
4. Run zc_install to attempt a database upgrade. Supply the admin username and the corresponding password (just to be clear, that's not the hash above)
5. Does it come back saying password invalid?
   If so, carry on:
6. Go back to the database, and in the "admin" table, grab the new password hash for that same user.
7. Post the 2 hashes here. They're not vulnerable. Please don't alter any characters, because the patterns are important for understanding what's happening.

I did the above on PHP 5.4.16 and upgraded fine this time. Must have been PHP 5.3.3. I even tried a 1.5.3 fresh install then uploaded the zc_install from 1.5.4 and it uploaded fine. I will go back to PHP 5.3.3 and do the test again if you want as in test environment? I donated as normal and what to thank DrByte, dbltoe and mc12345678 it is much appreciated. I am never going to be stuck using outdated software again and will be writing a idiots guide to running a Cheap VPS+Virtualmin with Ubuntu 14.04+Cloudflare so others can do the same on a budget also.

admin_pass $2y$10$flUzbm4J8QfRbzn/QuAroOORbT3Wvz16d/fAXP4q8hrrU3tkUm9RK
prev_pass1 $2y$10$osOMY8OwfdKxDTt5s4eA6OCY/NW2e5o2wO.teFCa.yM3zdhBYQQTG

admin_pass $2y$10$flUzbm4J8QfRbzn/QuAroOORbT3Wvz16d/fAXP4q8hrrU3tkUm9RK
prev_pass1 $2y$10$osOMY8OwfdKxDTt5s4eA6OCY/NW2e5o2wO.teFCa.yM3zdhBYQQTG

nuganics:

I did the above on PHP 5.4.16 and upgraded fine this time. Must have been PHP 5.3.3.
Thanks for confirming that using a supported PHP version resulted in success.
(I confess I'm a little surprised that you had password problems on 5.3.3 but password "rules" changed at 5.3.7 so perhaps that was a contributing factor.)
Glad it's working for you now!

I am having the exact same problem, also on an older version of PHP. I don't even know if I have access to update the php version without making a support ticket with the provider.

Just wanted to post here because this is clearly an issue, DB upgrade does not work on this older but still commonly found version of php.

EDIT:: Posted a little prematurely, but, I found a setting in cpanel to set PHP version and I am now running on 5.4 as confirmed by the Prerequesites page of zc_install. Even on this newer PHP version, I get the error "Admin Password required to proceed with upgrade " and it is physically impossible to update the database.

Any ideas would be greatly appreciated. Thanks.

rnoack:

I am having the exact same problem, also on an older version of PHP. I don't even know if I have access to update the php version without making a support ticket with the provider.

Just wanted to post here because this is clearly an issue, DB upgrade does not work on this older but still commonly found version of php.

EDIT:: Posted a little prematurely, but, I found a setting in cpanel to set PHP version and I am now running on 5.4 as confirmed by the Prerequesites page of zc_install. Even on this newer PHP version, I get the error "Admin Password required to proceed with upgrade " and it is physically impossible to update the database.

Any ideas would be greatly appreciated. Thanks.

Make sure you are using your store login and pass. To test just rename zc_install folder to test-zc_install and you should be able to login (I copy the login and pass from a text file to make sure it is entered correctly). If all good rename test-zc_install to zc_install and paste your login and pass from the text file.

Yes the password works on the admin screen but does not work on the upgrade screen. It is 100% the exact same password, I have it saved inside last pass and I copied and pasted it into the admin screen, then without editing the clipboard pasted it into the upgrade page. Then, I tried manually typing it in just to be sure and I get the same error.

rnoack:

Yes the password works on the admin screen but does not work on the upgrade screen. It is 100% the exact same password, I have it saved inside last pass and I copied and pasted it into the admin screen, then without editing the clipboard pasted it into the upgrade page. Then, I tried manually typing it in just to be sure and I get the same error.

Hate to ask, but 100% sure that the zc_install files are from zc 1.5.4 and not from 1.5.3? There was a similar issue with 1.5.3 that was to be fixed in 1.5.4, but if those files are inadvertently still of the older set, then likely to continue to have issues see:http://www.zen-cart.com/showthread.php?213868

The other thought is that the zc_install directory should be uploaded again for the second instance of running the zc_install process. If I remember correctly in previous comparisons, two files get modified/removed as part of the zc_install process...