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 61 to 80 of 88
3 Aug 2014, 3:02 PM
#61
nwce avatar

nwce

Zen Follower

Join Date:
Oct 2009
Posts:
444
Plugin Contributions:
0

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

One other question Dr. Byte, when updating my database, I am upgrading from zen v.1.5.0 to v.1.5.3 can I check multiple boxes when doing the update....i.e. check the boxes for v.1.5.0 to v.1.5.1 and also v.1.5.1.to v.1.5.2 and v.1.5.2 to v.1.5.3 and then run press the Update Database button or do I have to run it three separate times (choosing the next update each time) to get it updated to the latest version.

When I ran the test in my post #60 I only selected to update database v.1.5.0 to v.1.5.1

Thanks,
Jeff

3 Aug 2014, 10:42 PM
#62
goofygrrl2 avatar

goofygrrl2

New Zenner

Join Date:
Jun 2007
Location:
Texas
Posts:
41
Plugin Contributions:
0

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

Hello, I have been using Zen Cart since 2005 and I am in awe of it. Thank you everyone who made it for us to build a DYI website. I have been struggling upgrading from 1.5.0 to 1.5.3. I had all the problems mentioned in this "thread" and more mentioned on others. I would like to post something for everyone to think about.

This happen to be what I overlooked that caused these problems for me: I forgot to delete the "removed" files from each version of 1.5.0 to 1.5.3 (by following the list in the changed_files_*.html docs in the /docs folder). So, read them all; more than once will help a lot.

Once I followed all the instructions it turned out I had deleted the WRONG password_funcs.php file. I did not realize a new on was located in the Includes/Functions Folder. I thought it was the one to delete. Wrong of course. I uploaded that one back in place and deleted the one in Admin/Includes/Functions. Everything works now. Doing my Snoopy Happy Dance now! :lol: So just a little thought if this will help anyone else.
BTW- what was actually occurring here was... No Passwords were accepted, No Password resets would work. I was allowed to login once before I had to use phpmyadmin to set to default.

Kind Regards,
Gail
www.goodiesbygail.com

5 Aug 2014, 1:09 AM
#63
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

NWCE:

One other question Dr. Byte, when updating my database, I am upgrading from zen v.1.5.0 to v.1.5.3 can I check multiple boxes when doing the update....i.e. check the boxes for v.1.5.0 to v.1.5.1 and also v.1.5.1.to v.1.5.2 and v.1.5.2 to v.1.5.3 and then run press the Update Database button or do I have to run it three separate times (choosing the next update each time) to get it updated to the latest version.

When I ran the test in my post #60 I only selected to update database v.1.5.0 to v.1.5.1

Thanks,
Jeff

No, it will do all that are checked, all at once, and only if they're needed.
In a future version we'll probably remove the checkboxes to minimize confusion since they're not really needed anymore (they were put in a long time back because of the way upgrading used to work, but it's much smoother now in how it handles doing required updates).

.
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.

21 Aug 2014, 7:39 PM
#64
darnaez avatar

darnaez

Zen Follower

Join Date:
Jun 2009
Location:
Miami, Fl
Posts:
138
Plugin Contributions:
0

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

I'm upgrading from 1.5.0 to 1.5.3 but I'm stuck in the same password admin problem. Even I replace the zc_install/includes/functions/general.php.
Very frustrating day.

21 Aug 2014, 8:21 PM
#65
darnaez avatar

darnaez

Zen Follower

Join Date:
Jun 2009
Location:
Miami, Fl
Posts:
138
Plugin Contributions:
0

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

Plus... I added the line 53 at include/classes/class.zcPassword.php but the same result.

20 Nov 2014, 1:09 PM
#66
zipp99 avatar

zipp99

New Zenner

Join Date:
Nov 2014
Location:
USA
Posts:
3
Plugin Contributions:
0

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

Original version of 1.3.x that has been upgraded multiple times over the years, and I am at a point of upgrading 1.5.1 to 1.5.3 and when running zc_install I am unable to get past the admin name and password, the password is being rejected.

Earlier in this thread there was a "patch" and further instructions to alter the patched file more, which I did do but to no avail.

I NEED to get the database updated, is there any other way than through the zc_install method to get the database updated?

20 Nov 2014, 4:38 PM
#67
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

zipp99:

Original version of 1.3.x that has been upgraded multiple times over the years, and I am at a point of upgrading 1.5.1 to 1.5.3 and when running zc_install I am unable to get past the admin name and password, the password is being rejected.

Earlier in this thread there was a "patch" and further instructions to alter the patched file more, which I did do but to no avail.

I NEED to get the database updated, is there any other way than through the zc_install method to get the database updated?
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 Nov 2014, 7:11 PM
#68
zipp99 avatar

zipp99

New Zenner

Join Date:
Nov 2014
Location:
USA
Posts:
3
Plugin Contributions:
0

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

PHP Version 5.3.3

22 Nov 2014, 7:22 AM
#69
daffy avatar

daffy

Zen Follower

Join Date:
Jul 2008
Posts:
114
Plugin Contributions:
0

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

Yes, me too. Original 1.3.9 site. Running 1.5.1 and attempting to upgrade to 1.5.3, which I didn't expect to be difficult but upgrading the database is impossible. I did have the correct admin password but messed that up with PHPMyAdmin in all my efforts to try to accomplish something... so I guess I'll have to ask the server manager to reload the site from a couple days ago. I really don't even want to attempt this upgrade again, this has been so frustrating. I don't understand why I'm totally locked out of every aspect of the site, the front end, admin and all. It's a pure disaster. Can't you revise your upgrade procedures so this doesn't happen??

My version of PHP is 5.3.27.

The reason why I thought it was time to upgrade is because my customers are getting persistent PayPal errors, the one that says the addresses don't match.

22 Nov 2014, 11:09 AM
#70
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

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

daffy:

Yes, me too. Original 1.3.9 site. Running 1.5.1 and attempting to upgrade to 1.5.3, which I didn't expect to be difficult but upgrading the database is impossible. I did have the correct admin password but messed that up with PHPMyAdmin in all my efforts to try to accomplish something... so I guess I'll have to ask the server manager to reload the site from a couple days ago. I really don't even want to attempt this upgrade again, this has been so frustrating. I don't understand why I'm totally locked out of every aspect of the site, the front end, admin and all. It's a pure disaster. Can't you revise your upgrade procedures so this doesn't happen??

My version of PHP is 5.3.27.

The reason why I thought it was time to upgrade is because my customers are getting persistent PayPal errors, the one that says the addresses don't match.

In working this again assuming you are going to start over, you could save yourself the business heartache of the upgrade by first making a working backup of your site, and then stepping through the process on that backup.. if not mistaken that is part of the process of the upgrade. At least as identified here: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading.
There is no reason to put the live site in jeopardy of loss or damage.

Also, haven't seen that the store side has necessarily been affected are talking about users are. Unable to login (password authentication) or is it not possible to navigate the store after this attempted upgrade? If it is anything other than a login issue, then something went wrong with the file upgrade/merge process. Have seen sites thaat have upgraded the software but not the database still function, but a banner is displayed indicating that the database needs to be upgraded.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

22 Nov 2014, 7:00 PM
#71
daffy avatar

daffy

Zen Follower

Join Date:
Jul 2008
Posts:
114
Plugin Contributions:
0

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

I had full backups. I restored the site to 1.5.1 and reset my admin password. But this would have happened even if I'd built a test site with a test database, because the problem happened at the very final step of the upgrade, when the live database is upgraded. That's where it stalled.

Yes, the front end and back end were all locked out. No matter where I navigated on the site, I got the screen saying congratulations, now click here to finish...

So then I did a clean install of 1.5.3 instead of over-writing 1.5.1, but that didn't make a difference. Apparently I cannot upgrade to 1.5.3. , all because of this admin password issue. To me, this is a really big problem over a very small thing.

I have an apache/linux server. I downloaded the very latest ZC version from Sourceforge.

I have a whole lot of error logs if that's helpful, but the logs seem to consistently point to the same errors that are already mentioned in this thread. I assume the any bugfixes were included in the October file?

22 Nov 2014, 7:17 PM
#72
daffy avatar

daffy

Zen Follower

Join Date:
Jul 2008
Posts:
114
Plugin Contributions:
0

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

Sometimes it seemed like it did accept the password, but then I got a white screen and nothing happened.

I was experimenting with many different variations in the config files. For one thing, the upgrade menu would not come up unless I included the database prefix in the config files, even though the default is to leave it blank. I didn't get the database upgrade option unless the prefix was in there. Also, at the top of the config files where it requests location of the server, I had to put in the urls rather than localhost. But it would not accept anything but localhost in the actual section for the database. So maybe my particular config files messed up the database upgrade? I entered what made the Upgrade menu happy. I had all green lights when I pushed the button to upgrade the database.

22 Nov 2014, 10:43 PM
#73
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,725
Plugin Contributions:
56

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

For people reading this thread: If you are a developer who has updated someone else's cart on your own machine and uploaded a test database to a different machine, (or you're the storeowner and doing that) be sure different versions of PHP aren't causing you trouble - see my explanation here: http://www.zen-cart.com/showthread.php?214858-Local-upgrade-to-1-5-3-Upload-to-test-site-Can-t-login&p=1260911#post1260911

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

24 Nov 2014, 2:02 PM
#74
zipp99 avatar

zipp99

New Zenner

Join Date:
Nov 2014
Location:
USA
Posts:
3
Plugin Contributions:
0

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

php versions are the same on both the development and the live sites, its actually the same hosting env. So I guess its time to just find a different solution. Take care.

24 Nov 2014, 2:21 PM
#75
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

zipp99:

Original version of 1.3.x that has been upgraded multiple times over the years, and I am at a point of upgrading 1.5.1 to 1.5.3 and when running zc_install I am unable to get past the admin name and password, the password is being rejected.

Earlier in this thread there was a "patch" and further instructions to alter the patched file more, which I did do but to no avail.

I NEED to get the database updated, is there any other way than through the zc_install method to get the database updated?

zipp99:

PHP Version 5.3.3
To upgrade the database manually you could apply the 2 .sql files from the zc_install folder, using phpMyAdmin. In the case of going from v1.5.1 to 1.5.2 to 1.5.3 it's only .sql changes that are needed. It's not always safe to do just .sql scripts because sometimes there's a need for some php-scripted updates too, and that's why zc_install is provided, so that those things can be taken care of in a way that protects the data.

PHP 5.3.7 and lower have weak security, so it would be prudent to upgrade your PHP version at some point.

.
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.

29 Nov 2014, 11:03 AM
#76
daffy avatar

daffy

Zen Follower

Join Date:
Jul 2008
Posts:
114
Plugin Contributions:
0

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

I tried installing 1.5.3 again and this time it looks as if the database is upgraded. I did see a message that the database was up to date.

However, now I can't get into the Admin. I get the page that says, "Hello. Thank you for loading Zen Cart®. You are seeing this page for one or more reasons: "

I've done the zc_install setup a number of times so that's not it. I've checked the configs and the .htaccess. Just absolutely do not get the Admin login no matter what I try.

My shop has been nonfunctional all week. If I use 1.5.1, people can't checkout with PayPal even though I turned off ALL the address checking features they're still getting the 10736 error.

So I tried the upgrade again (via FTP) and now customers can't even get to checkout - because I can't get into Admin to turn things on and off.

I asked my server manager about upgrading the PHP version. We'll see if that helps.

I'm feeling rather desperate actually. ZenCart has never been this impossible before.

30 Nov 2014, 1:35 AM
#77
daffy avatar

daffy

Zen Follower

Join Date:
Jul 2008
Posts:
114
Plugin Contributions:
0

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

My server manager upgraded PHP to version 5.4

I still can't login to the admin. I think I've run the database upgrade scripts a zillion times now hoping to finish installation but it always goes to this screen in the Admin:

Attachment 14739

Here's an error that showed up in the LOGS folder one of those times. This was before we upgraded the PHP:

[29-Nov-2014 09:29:00 UTC] PHP Warning:  Invalid argument supplied for foreach() in /home/prillych/public_html/zc_install/includes/classes/installer.php on line 764

I'm totally locked out of the Admin and I've done everything I can think of. Suggestions?

30 Nov 2014, 2:26 AM
#78
daffy avatar

daffy

Zen Follower

Join Date:
Jul 2008
Posts:
114
Plugin Contributions:
0

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

The site is working OK on the frontend, but I can't get into the admin at all. Is there any way to kill that screen?? I REALLY think the install procedure is not working right.

One thing it's doing is changing the permissions on the includes/configure.php to 444 every chance it gets, and THEN it gripes at me that it can't write to the configure.php file even though I'm constantly checking on it to make sure it's writable.

Although the configure.php files say they don't want the prefix in there, the site won't run at all unless the database prefix is in there. --- But I think that might be messing up the installation procedure, it's having a hard time writing to some of the tables. I was trying to do it manually with PHPMyAdmin, and I ended up inserting the prefix into the SQL statements, otherwise it couldn't work on the tables.

I've been using ZenCart for almost 10 years, on several sites, and I do everything myself. So it's not like I'm a newbie. I've always been able to fix things on ZenCart, but this is a real mess.

30 Nov 2014, 1:52 PM
#79
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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

Most likely the change of the configure.php permissions is being done by the server ...

As to the Install screen, ensure that you have a good configure.php file in the directory:
/admin/configure.php

I suspect that it is either missing or the paths/database are incorrect ...

Could you post the files, from the server, for:
/includes/configure.php
/your_secret_admin_dir/includes/configure.php

without showing your_secret_admin_dir or any passwords ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

1 Dec 2014, 6:15 AM
#80
daffy avatar

daffy

Zen Follower

Join Date:
Jul 2008
Posts:
114
Plugin Contributions:
0

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

THIS is the configure.php file from the secret-admin/includes/ folder:

<?php
/**
 * SAMPLE (but NOT FUNCTIONAL) file
 *
 * @package Configuration Settings
 * @package Admin
 * @copyright Copyright 2003-2014 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version GIT: $Id: Author: DrByte  May 24 2014 Modified in v1.5.3 $
 * @private
 */
/**
 * WE RECOMMEND THAT YOU USE SSL PROTECTION FOR YOUR ENTIRE ADMIN:
 * To do that, make sure you use a "https:" URL for BOTH the HTTP_SERVER and HTTPS_SERVER entries:
 */
  define('HTTP_SERVER', 'http://www.prillycharmin.com');
  define('HTTPS_SERVER', 'http://www.prillycharmin.com');
  define('HTTP_CATALOG_SERVER', 'http://www.prillycharmin.com');
  define('HTTPS_CATALOG_SERVER', 'http://www.prillycharmin.com');

  // secure webserver for admin?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_ADMIN', 'false');

  // secure webserver for storefront?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_CATALOG', 'false');


  define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_CATALOG', '/');
  define('DIR_WS_HTTPS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTPS_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_HTTPS_CATALOG', '/');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
  define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
  define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
  define('DIR_WS_INCLUDES', 'includes/');
  define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
  define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
  define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
  define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
  define('DIR_WS_CATALOG_LANGUAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * DIR_FS_* = Filesystem directories (local/physical)
  define('DIR_FS_ADMIN', preg_replace('#/includes/$#', '/', realpath(dirname(__FILE__) . '/../') . '/'));

  define('DIR_FS_CATALOG', '/');

  //the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
  define('DIR_FS_LOGS', DIR_FS_CATALOG . '/home/prillych/public_html/logs');

  define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
  define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
  define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
  define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
  define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
  define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', 'zen_');
  define('DB_CHARSET', 'utf8');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'xxxxxx');
  define('DB_SERVER_PASSWORD', 'xxxxxx');
  define('DB_DATABASE', 'xxxxxx');

  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash
  define('SQL_CACHE_METHOD', 'none');
  define('DIR_FS_SQL_CACHE', '/home/prillych/public_html/cache');


//Explanations of the webserver and path parameters:
// HTTP_SERVER is your Main webserver: eg-http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg-https://www.yourdomain.com
// HTTP_CATALOG_SERVER is your Main webserver: eg-http://www.yourdomain.com
// HTTPS_CATALOG_SERVER is your Secure webserver: eg-https://www.yourdomain.com
/*
 * URLs for your site will be built via:
 *     HTTP_SERVER plus DIR_WS_ADMIN or
 *     HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or
 *     HTTP_SERVER plus DIR_WS_CATALOG or
 *     HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
 * ...depending on your system configuration settings
 */