Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Mar 2005
    Location
    Helsinki
    Posts
    570
    Plugin Contributions
    0

    Default lost clients admin password - restarted through mysql - cant access any admin profile

    So I forget my clients master password which I only use.. admin was named masteradmin (I looked from sql). I cannot send passwords through email it is disabled. I ran the script

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

    which lets me in but I cannot see the menu so I think admin roles mod(or something similar) messes things up. I need this urgently so please please help. Im totally lost with this one.

  2. #2
    Join Date
    Mar 2005
    Location
    Helsinki
    Posts
    570
    Plugin Contributions
    0

    Default Re: lost clients admin password - restarted through mysql - cant access anything role

    Im basically fired if I don't find out a way to fix this.. I tried this

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

    which lets me in as masteradmin with pw admin BUT still no menu and
    "Sorry, your security clearance does not allow you to access this resource."

  3. #3
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: lost clients admin password - restarted through mysql - cant access anything role

    If you're using the admin profiles mod, you'll have to set up the security in the admin profiles tables manually.
    .

    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.

  4. #4
    Join Date
    Mar 2005
    Location
    Helsinki
    Posts
    570
    Plugin Contributions
    0

    Default Re: lost clients admin password - restarted through mysql - cant access any admin pro

    Im not really that handy with the mysql and wouldnt really want to make this issue even huger but do I need to reset the table? I don't have admin profiles table? theres admin_allowed_pages table though? How can I reset it? thanks Byte!

  5. #5
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: lost clients admin password - restarted through mysql - cant access any admin pro

    You may have to study the admin profiles contribution documentation for more information.

    I have to run off to a meeting, so can't help at this moment.
    .

    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.

  6. #6
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: lost clients admin password - restarted through mysql - cant access any admin pro

    Before trying to reset it (which you could do by re-running the installation SQL bundled with the Admin Profiles release package) which would be a complete reset, that would wipe out all settings for other users too, try this ...

    Go into your admin table (e.g. via phpMyAdmin) and edit your admin_id to be "1".
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  7. #7
    Join Date
    Mar 2005
    Location
    Helsinki
    Posts
    570
    Plugin Contributions
    0

    Default Re: lost clients admin password - restarted through mysql - cant access any admin pro

    Thanks Kuroi. Glad that you found the thread. I was looking for your help already in the profiles thread :) So actually how I set admin id in to 1?

  8. #8
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: lost clients admin password - restarted through mysql - cant access any admin pro

    I was nudged here. You can update it by editing the table contents in phpMyAdmin or similar. But maybe easier would be to just run the following SQL
    update admin set admin_id=1 where admin_name="masteradmin";
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  9. #9
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: lost clients admin password - restarted through mysql - cant access any admin pro

    Unfortunately I need to go out too. But Let me know how that goes. I'll check-in when I return.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  10. #10
    Join Date
    Mar 2005
    Location
    Helsinki
    Posts
    570
    Plugin Contributions
    0

    Default Re: lost clients admin password - restarted through mysql - cant access any admin pro

    Thanks guys I figured it out and you cannot imagine how relieved I am! cheers!

    for the others who're not so fluent with sql

    https://www.zen-cart.com/tutorials/index.php?article=95

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. admin login page is missing. cant access admin area
    By ztotheetothen in forum Customization from the Admin
    Replies: 11
    Last Post: 26 Feb 2011, 05:44 PM
  2. Urgent Please Lost admin access after DB PassWord update
    By motobuddy in forum General Questions
    Replies: 4
    Last Post: 3 Jun 2010, 05:51 AM
  3. Password recovery crashed with admin profile addon
    By alimtlai in forum Customization from the Admin
    Replies: 1
    Last Post: 27 Sep 2009, 03:00 PM
  4. cant access admin through ipaddress/~login/admin
    By dellvostro in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 12 Nov 2008, 08:23 AM
  5. lost password to admin
    By Pilli in forum General Questions
    Replies: 1
    Last Post: 29 Nov 2007, 08:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR