Results 1 to 5 of 5

Thread: not possible to login as admin after changing the admin as inactive

  1. #1
    gbaumeister is offline Junior Member
    Join Date
    Oct 2006
    Posts
    3

    Default not possible to login as admin after changing the admin as inactive

    Hallo, my problem is: today I changed the user "admin" from Status "activ" to "inactiv". Now the problem is, that it is not possible for me to log in as "admin" - the error-massage: "wrong password or username". What can I do to re-activate the user "admin" or is it possible to change the admin password?

  2. #2
    Scott_Savage is offline Sugar Community Member
    Join Date
    Aug 2006
    Location
    Sydney, Australia
    Posts
    193

    Default Re: not possible to login as admin after changing the admin as inactive

    You will have to use a program such as phpMyAdmin to access your database directly and change the values in the users table. Namely sugar_login and is_admin are set to 1 for the relevent user.

    Good luck!
    Web Server: IIS 6, Win2k3
    PHP: 5.2.5
    MySQL: 5.0.27-community-nt
    Sugar: 4.5.0j Open Source
    Website: www.scottsavage.net

  3. #3
    george_bbch is offline Sugar Community Member
    Join Date
    Jan 2006
    Location
    Switzerland
    Posts
    349

    Default Re: not possible to login as admin after changing the admin as inactive

    You may also need to change the field "status" back to "Active", and make sure that field "deleted" is 0, just in case...
    If it still not works, it's possible that the "user_hash" field is empty or has been changed, and you need to regenerate an MD5 hash of a password you choose and paste it into this field.

  4. #4
    gbaumeister is offline Junior Member
    Join Date
    Oct 2006
    Posts
    3

    Default Re: not possible to login as admin after changing the admin as inactive

    Quote Originally Posted by Scott_Savage
    You will have to use a program such as phpMyAdmin to access your database directly and change the values in the users table. Namely sugar_login and is_admin are set to 1 for the relevent user.

    Good luck!

    many thanks!!
    greetings from germany - gbaumeister.

  5. #5
    gbaumeister is offline Junior Member
    Join Date
    Oct 2006
    Posts
    3

    Default Re: not possible to login as admin after changing the admin as inactive

    Many thanks, I will try it!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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
  •