Unable to login-reset password

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • preacherrichd
    Junior Member
    • Sep 2025
    • 15

    #1

    Unable to login-reset password

    Fro some reason I cannot log into admin rather I use my admin username or basic username. I have tried the forgot password and I get error saying Username/Email address not found. I cannot find in the database a table with users listed.
  • yuri
    EspoCRM product developer
    • Mar 2014
    • 9440

    #2
    It's possible to set a new password via CLI: https://docs.espocrm.com/administrat...-user-password
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • preacherrichd
      Junior Member
      • Sep 2025
      • 15

      #3
      My installation of EspoCRM was via Softaculous and is on a remote linux server. I have no idea where or how I would run bin/command. I am sure it is something my hosting company will do for me if I know where to tell them to go to this. Where do I go to run this command?

      Would I just go into the server console, go to the directory where my EspoCRM is installed, /leads and then enter this command:bin/command set-password [username]
      Last edited by preacherrichd; 09-19-2025, 04:28 PM.

      Comment

      • yuri
        EspoCRM product developer
        • Mar 2014
        • 9440

        #4
        > Would I just go into the server console, go to the directory where my EspoCRM is installed

        Yes. Softaculous seems provides access to CLI.

        Code:
        bin/command set-password your-espo-user
        If no file permission to execute, then an alternative:

        Code:
        php command.php set-password your-espo-user
        If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment

        • preacherrichd
          Junior Member
          • Sep 2025
          • 15

          #5
          Ok I went into php command.php set-password and entered my username. It then gave me the prompt 'Enter a new password'. I entered the new password and it shows it on the console. I hit entered and it brought me back to the espocrm directory so I assumed it took the new password. But when I log in with the username and new password I still get wrong username/password.

          I went into my database under auth_log_record and it says INACTIVE_USER.
          I try to login with other usernames and the database says Denial Reason 1-CREDENTIALS, when I try to change their password via CLI it comes as user not found. Do not know what to do next. I do not see any table that lists all users.

          Is there a way through CLI I can create a new user and a new admin? I tried php command.php create-admin-user and I get command 'CreadeAdminUser' does not exist.

          No idea why I am not able to log in with any usernames. This worked a week ago.
          Last edited by preacherrichd; 09-19-2025, 06:03 PM.

          Comment

          • yuri
            EspoCRM product developer
            • Mar 2014
            • 9440

            #6
            Inactive user means that someone inactivated this user. You can update the user record manually in the DB. Set is_active to true.
            If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

            Comment

            • preacherrichd
              Junior Member
              • Sep 2025
              • 15

              #7
              What table do I find the field is_active?

              Comment

              • shalmaxb
                Senior Member
                • Mar 2015
                • 1755

                #8
                table user, set is_active to 1

                Comment

                • preacherrichd
                  Junior Member
                  • Sep 2025
                  • 15

                  #9
                  Not making any sense. I go into username and both of the admin are shown as active, set as 1. I did not have to change it.
                  But when I I try to log in with the new passwords (that I set with CLI) it says wrong username/password.
                  When I go into the auth_log_record for both admins it shows 'is denied' as 0 and under 'denialreason 'it says INACTIVE_USER.

                  Is there a setting somewhere else that denies access after so many attempted log ins. Something blocks an IP Address or something.
                  When I go to forget password and enter the username and email address I get a 403 code error.

                  Also what table has user email addresses?

                  NOTE: I installed espocrm in another folder. I copied the password key of the admin for the new install and pasted the password key to the admin of the original install. I tried to log into the original espocrm with the password from the new install and still cannot login.
                  Last edited by preacherrichd; 09-19-2025, 08:13 PM.

                  Comment

                  • preacherrichd
                    Junior Member
                    • Sep 2025
                    • 15

                    #10
                    Latest Status
                    I went into the databse and imported an admin user from the new install to the current espoCRM. Still get the Wrong/Username Password. something is preventing the ability to login.

                    So, it cannot be a username and password issue.

                    BTW the version I am using is 6.1.8. My PHP version is 8.3.25, a recent upgrade. could this be causing the problem.

                    The new version of EspoCRM I have is 9.1.8 is there a way to import all my data from the older version into the new version to bypass the login issue?

                    Comment

                    • yuri
                      EspoCRM product developer
                      • Mar 2014
                      • 9440

                      #11
                      EspoCRM 6.1 did not support PHP 8.3. PHP 8.3 did not exist at that time. It's almost certainly the problem.
                      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                      Comment

                      • preacherrichd
                        Junior Member
                        • Sep 2025
                        • 15

                        #12
                        I changed back to php 7.4.33 and still cannot log in. So it cannot be a pho issue

                        Comment


                        • yuri
                          yuri commented
                          Editing a comment
                          I'd check if PHP 7.4 is applied for the webserver first. It's usual for us to hear claims that PHP version is changed, but actually the previous version is still applied.
                      • yuri
                        EspoCRM product developer
                        • Mar 2014
                        • 9440

                        #13
                        I remember the same issue on the forum, The isActive field always returned false. It was PHP incompatibility problem.
                        If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                        Comment


                        • preacherrichd
                          preacherrichd commented
                          Editing a comment
                          I ran php --version, It comes back 7.4.33

                        • preacherrichd
                          preacherrichd commented
                          Editing a comment
                          There must have been some kind of delay, regarding the php change because I can now log in. using php 7.4.33.
                      • yuri
                        EspoCRM product developer
                        • Mar 2014
                        • 9440

                        #14
                        Am using docker and compose. Did an update to v7.5.6, usual docker steps- set the image version, pull, up. Get the login screen, but cannot log with any user. Turned on DEBUG in the logger. [2023-10-22 14:31:00] INFO: AUTH: Trying to login as user 'billr' which is not active. [] [] It thinks all users are inactive. Turned on


                        There is a problem with my espocrm installation I have been running for many years without problems: recently I cannot login to my website. I enter the correct credentials, then I get a 401 unauthorized (F12 developer options). The errormessage on the webpage is: Invalid username/password. There is NO errormessage about this
                        If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                        Comment

                        • preacherrichd
                          Junior Member
                          • Sep 2025
                          • 15

                          #15
                          So I am able to login.
                          But if I edit a user profile, a lead, etc it will not save the edits.

                          Comment

                          Working...