osCmax v2.5 User Manual
Page 1 of 3 123 LastLast
Results 1 to 10 of 26

Resetting admin password after upgrade

This is a discussion on Resetting admin password after upgrade within the osCmax v1.7 Discussion forums, part of the osCmax v1.7 Forums category; I have successfully upgraded osC2.2 to MS2-MAX 1.5. I used mysqldiff to upgrade the database. It was not without errors, ...

      
  1. #1
    Active Member chrismole's Avatar
    Join Date
    Dec 2003
    Location
    Chicago
    Posts
    102
    Rep Power
    9


    Default Resetting admin password after upgrade

    I have successfully upgraded osC2.2 to MS2-MAX 1.5. I used mysqldiff to upgrade the database. It was not without errors, but they were minor. I highly recommend mysqldiff for an upgrade. It's available with a web interface - http://www.mysqldiff.org/.

    Anyway, after updating the database, I copied the catalog and admin directories from another site I admin that's using MS2-MAX 1.5. The front-end seems to work ok. However, I am trying to log in to the admin site using the admin account from the other site, and it does not work. Also, the "forgot password" email is not working either. So, I am unable to login to the admin site.

    Is there a way to manually reset the admin account?

    thanks,
    Chrismole

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default

    Use the default admin login, not the credentials from your other site. Unless you copied the credentials into the new database, they will not be in there...
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Active Member chrismole's Avatar
    Join Date
    Dec 2003
    Location
    Chicago
    Posts
    102
    Rep Power
    9


    Default

    I tried that and it does not work.

    What I did was, I copied the ocC2.2 db and ran the diff on it and an MM1.5 db. I used the resulting sql to upgrade the osC2.2 db to a MM1.5 db. So there was never username/password values in the new db. Is it possible that the values are empty? How can this be fixed?

    Thanks,
    Chrismole

  4. #4
    Member
    Join Date
    Jan 2004
    Location
    edmonton, Alberta, Canada
    Posts
    62
    Rep Power
    0


    Default

    i HIGHLY doubt the fields were empty. But you may have to add them yourself if you know the means of accessing your database.

  5. #5
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default

    Yes, the values are empty.

    All the mysqldiff does is change the data structure, you still have to add the actual data to the new tables.

    Export all the data from the configuration and admin tables of the max db, and import them into the upgraded database.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  6. #6
    Active Member chrismole's Avatar
    Join Date
    Dec 2003
    Location
    Chicago
    Posts
    102
    Rep Power
    9


    Default

    masaek,

    Export all the data from the configuration and admin tables of the max db, and import them into the upgraded database.
    I am not sure I follow you. My current db is the upgraded db. I took an osC2.2 db and upgraded it to a max db. In so doing, I created data fields that did not exist in the osC2.2 db (it did not have a web login interface, I had been using authentication). So now I've got an updated db with no data in the admin username and password fields. Can I simply write an INSERT statement to plug a username and password into the max db?

  7. #7
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22


    Default

    Using MySQLDiff - only upgrades the database FORMAT and tables - Where MS2-MAX has both NEW tables and in the NEW tables is NEW data ALSO! When you update your OLD table - it does NOT bring in this NEW data. You have to input that separatly. (Same with any new/added configuration values)
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!

  8. #8
    Active Member chrismole's Avatar
    Join Date
    Dec 2003
    Location
    Chicago
    Posts
    102
    Rep Power
    9


    Default

    I understand that there is no data in some of the newly created/formatted tables. Are you suggesting that I append all the data from the original max db into my newly converted max db? If so, do you have any direction on how to do this? Rather, can I just import the admin account info? Or is there a lot of other stuff that will be broke because there is no data?

    Thanks,
    Chrismole

  9. #9
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default

    chrismole, it is not that complicated.

    You updated the structure to add the new tables. Now, in order for the 'Max' features to work, you have to add the 'admin' and 'configuration' table DATA. These tables need to be populated with the Max configuration values, so, from the MAX db, export the DATA only from those tables to an sql file.

    Then in your new upgraded DB, run the batch file. It will populate those tables with your default data so that you can login and start customizing. MAX cannot run without this data.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  10. #10
    Member
    Join Date
    Jan 2004
    Location
    edmonton, Alberta, Canada
    Posts
    62
    Rep Power
    0


    Default

    Try importing the admin data from your old DB into the newly upgraded DB. or try setting it up back to the default manually here are the values under the admin table. admin_id = 1 admin_groups_id =1 admin_firstname = Default admin_lastname = Admin admin_email_address = admin@localhost.com admin_password = 05cdeb1aeaffec1c7ae3f12c570a658c:81 admin_created =2003-07-17 11:35:03 admin_modified = 2003-08-02 19:43:11 admin_logdate = 2004-02-26 21:22:36 admin_lognum = 95

Page 1 of 3 123 LastLast

Similar Threads

  1. Resetting Customer Password
    By goaskmom in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 03-07-2005, 08:14 AM
  2. Admin password
    By vinces in forum osCmax v1.7 Discussion
    Replies: 3
    Last Post: 11-21-2004, 12:04 PM
  3. Admin password out of sync with site password
    By bjrafferty in forum osCmax v1.7 Discussion
    Replies: 3
    Last Post: 07-19-2004, 08:34 AM
  4. No password in Admin
    By goldie in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 08-26-2003, 01:33 PM
  5. Admin password?
    By pilot1 in forum osCommerce 2.2 Installation Help
    Replies: 2
    Last Post: 05-06-2003, 01:23 AM

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
  •