Zen Cart Logo
Forums / General Questions / New install 155f and new database, admin lockout

New install 155f and new database, admin lockout

Views: 1,578

Results 1 to 16 of 16
20 Jan 2018, 9:22 PM
#1
jhande1 avatar

jhande1

New Zenner

Join Date:
Dec 2017
Location:
New Hampshire, USA
Posts:
15
Plugin Contributions:
0

New install 155f and new database, admin lockout

Instead of updating from 155e to 155f I deleted everything.

Created a new database and fresh install of 155f, all went fine.

The catalog/store front side works fine.

I try logging into the admin side and keep receiving the error message of wrong password.

I tried fixing it according to another post editing the database.

Any ideas?

21 Jan 2018, 3:35 AM
#2
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: New install 155f and new database, admin lockout

There appears to either be some steps performed that are not described or some of what is described as done was not exactly...

First thing stated was that everything was deleted. Therefore that would mean both files and database. Is that correct?

The setup of the new store should have either provided admin credentials or allowed you to choose them.

Whichever the case, those are the credentials to use considering that the entire 1.5.5e install was erased instead of just updating a "few" files...

Admin login after a series of failed attempts is locked for a period of time for that login id.
Use of the database credential reset process: https://www.zen-cart.com/content.php?44
Requires using a lowercase username and first letter uppercase in the password.

21 Jan 2018, 12:03 PM
#3
soxophoneplayer avatar

soxophoneplayer

Totally Zenned

Join Date:
Feb 2008
Posts:
534
Plugin Contributions:
0

Re: New install 155f and new database, admin lockout

I've been caught a few times on the password re-set for admin, ending in endless loop. For me, it turned out to be a Windows auto-fill thing on the temporary password.

I would copy the zc created temporary password according to instruction. Then on login when it asks to create a new password, the spot on the form for the temp password was autofilled, but with dots not actual password for me to see. So while I presumed zc was autofilling thattemp password, in fact windows was autofilling with some other password it had retained from some other program in which I had the same user name.

I beat my head against the wall several times on this ;o)

21 Jan 2018, 5:46 PM
#4
jhande1 avatar

jhande1

New Zenner

Join Date:
Dec 2017
Location:
New Hampshire, USA
Posts:
15
Plugin Contributions:
0

Re: New install 155f and new database, admin lockout

Oop's my old tired brain left out that I'm doing this on localhost running XAMPP, 155e went smooth as silk.

Went into phpMyAdmin and dropped the 155e database.

Deleted the ZenCart 155e folder in XAMPP\htdocs.

Created a new database in phpMyAdmin - Database Name: ZenCart; Collation: utf8_general_ci. Just like I did for 155e.

Unzipped 155f to folder: XAMPP\htdocs\ZenCart. Just like I did with 155e.

Ran ZenCart install and received my temporary password.

Clicked on the go to admin link and "over" typed the temporary password where Windows auto-fill had dots.

"Invalid password"

Repeated above steps three times, same results.

Tried steps in this post to reset password.

DELETE FROM admin WHERE admin_name = 'Admin'; 
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_profile) 
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

Still no luck.

Wondering if I go back to v155e (if it will work) and just update the files would be a work-around?

21 Jan 2018, 8:23 PM
#5
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: New install 155f and new database, admin lockout

So still seems like there is some more "missing".

So, a new install of ZC 1.5.5f now renames or removes the zc_install directory? (can't login to admin until zc_install has been renamed or removed and that action is not described above.)

The "auto-paste" of your browser, did you verify that the username was entered correctly in addition to replacing the auto-populated password with what was provided during the install?

After using the script, what specifically was entered to attempt to login to the admin? It should have been Admin and admin (note the capitalization.)

21 Jan 2018, 9:10 PM
#6
jhande1 avatar

jhande1

New Zenner

Join Date:
Dec 2017
Location:
New Hampshire, USA
Posts:
15
Plugin Contributions:
0

Re: New install 155f and new database, admin lockout

mc12345678:

So still seems like there is some more "missing".

So, a new install of ZC 1.5.5f now renames or removes the zc_install directory? (can't login to admin until zc_install has been renamed or removed and that action is not described above.)
Sorry... Yes ZC 1.5.5f totally replaced the ZC 1.5.5e directory as I deleted it prior. Yes zc_install was removed.

The "auto-paste" of your browser, did you verify that the username was entered correctly in addition to replacing the auto-populated password with what was provided during the install?
Yes I entered the self generated password, over riding the browsers auto-fill.

After using the script, what specifically was entered to attempt to login to the admin? It should have been Admin and admin (note the capitalization.)
Oops... Did not realize Admin & admin was to be used. "hangs head in shame"
I ran the script again and I was able to get into the stores admin. THANK YOU!!!!

I changed the password as directed by the prompt.

Is there any way to change the username from "Admin" to something else?

Thank you again so much everyone for your help!

21 Jan 2018, 11:10 PM
#7
soxophoneplayer avatar

soxophoneplayer

Totally Zenned

Join Date:
Feb 2008
Posts:
534
Plugin Contributions:
0

Re: New install 155f and new database, admin lockout

[QUOTE=j...
Ran ZenCart install and received my temporary password.

Clicked on the go to admin link and "over" typed the temporary password where Windows auto-fill had dots.

"Invalid password"...[/QUOTE]

Don't know if this makes a difference for you - but when install gives me the temp password I don't write it down, I copy/paste it to a blank note-file (I use desk top sticky in windows but have also copied onto a blank notepad file.). Then when I re-enter it over the removed dots, I paste it in rather than type it in.

Going from 1.5.5d to e that made the difference for me. Going from e to f I just automatically did that. I didn't/don't know why this made a diff!

21 Jan 2018, 11:48 PM
#8
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: New install 155f and new database, admin lockout

jhande1:

Is there any way to change the username from "Admin" to something else?

Thank you again so much everyone for your help!

There actually is a way to create whole new profiles in that area. That is the suggested practice. To create a new profile (if needed) or reset the password to one of the existing profiles, logout, attempt to login with the new profile/password. If successful then delete the Admin account so that no one else can "use it" to gain access.

22 Jan 2018, 12:08 AM
#9
jhande1 avatar

jhande1

New Zenner

Join Date:
Dec 2017
Location:
New Hampshire, USA
Posts:
15
Plugin Contributions:
0

Re: New install 155f and new database, admin lockout

mc12345678:

There actually is a way to create whole new profiles in that area. That is the suggested practice. To create a new profile (if needed) or reset the password to one of the existing profiles, logout, attempt to login with the new profile/password. If successful then delete the Admin account so that no one else can "use it" to gain access.

Thank you so much.

I'll work on it. Spotted it once in the admin section.

22 Jan 2018, 12:10 AM
#10
jhande1 avatar

jhande1

New Zenner

Join Date:
Dec 2017
Location:
New Hampshire, USA
Posts:
15
Plugin Contributions:
0

Re: New install 155f and new database, admin lockout

soxophoneplayer:

Don't know if this makes a difference for you - but when install gives me the temp password I don't write it down, I copy/paste it to a blank note-file (I use desk top sticky in windows but have also copied onto a blank notepad file.). Then when I re-enter it over the removed dots, I paste it in rather than type it in.

Going from 1.5.5d to e that made the difference for me. Going from e to f I just automatically did that. I didn't/don't know why this made a diff!

I also tried that way too = copy & paste and also write it down and type it in... no go either way.

Strange... just can't believe I'm the only one that had this problem. Special me LOL.

22 Jan 2018, 12:36 AM
#11
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: New install 155f and new database, admin lockout

I've repaired this by simply installing a new Zen Cart on the same server - separate folder/directory. Follow through the installation process with a new admin name and password. Then when you know that one is working... just drop the admin login records in the failed database and copy the data directly from the new 'working' site. This will keep the rest of your database intact. Regardless of the outcome I always back everything up BEFORE I start and test the backups.

If you need help I've done this many times in nearly every Zen version since 1.37... and 3 weeks ago it happened while adding a vanilla testing site. Easy breezy.

If anything goes wrong after that I'll start looking into the SQL or the server to see where the bottleneck is. Usually it's user error copying passwords with 'extra space' or typing the important bits incorrectly.

You can try it yourself or contact me directly if you're still stuck.

22 Jan 2018, 12:50 AM
#12
jhande1 avatar

jhande1

New Zenner

Join Date:
Dec 2017
Location:
New Hampshire, USA
Posts:
15
Plugin Contributions:
0

Re: New install 155f and new database, admin lockout

Thanks

I'll make a note of the process.

Hopefully I wouldn't need it though...

22 Jan 2018, 5:36 AM
#13
swguy avatar

swguy

Administrator

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

Re: New install 155f and new database, admin lockout

soxophoneplayer:

I've been caught a few times on the password re-set for admin, ending in endless loop. For me, it turned out to be a Windows auto-fill thing on the temporary password.

I have experienced this kind of thing a few times too. Clear cache and remove the password from your password manager (whether it's your browser or some external password manager). This will allow you to start fresh with a new working password.

25 Jan 2018, 12:55 AM
#14
jhande1 avatar

jhande1

New Zenner

Join Date:
Dec 2017
Location:
New Hampshire, USA
Posts:
15
Plugin Contributions:
0

Re: New install 155f and new database, admin lockout

DANG...

Now my store front loads a white page.

Going to investigate, maybe issues with XAMPP...

25 Jan 2018, 10:58 AM
#15
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: New install 155f and new database, admin lockout

jhande1:

DANG...

Now my store front loads a white page.

Going to investigate, maybe issues with XAMPP...

Hopefully haven't gone on too much of a wild goose chase. When presented with a white screen or partial display, follow this FAQ: http://www.zen-cart.com/content.php?124-blank-page

25 Jan 2018, 4:57 PM
#16
jhande1 avatar

jhande1

New Zenner

Join Date:
Dec 2017
Location:
New Hampshire, USA
Posts:
15
Plugin Contributions:
0

Re: New install 155f and new database, admin lockout

mc12345678:

Hopefully haven't gone on too much of a wild goose chase. When presented with a white screen or partial display, follow this FAQ: http://www.zen-cart.com/content.php?124-blank-page

Thanks
Working on localhost and only made changes in admin; ie: deleted products & manufacturers then noticed store front loaded white page.

Have since started with all new fresh install. So far so good!
Deleting or making one change at a time and double checking store front.

Keeping fingers crossed.