Unable to login-reset password

[preacherrichd]

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]

It's possible to set a new password via CLI: https://docs.espocrm.com/administrat...-user-password

[preacherrichd]

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]

[yuri]

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

Yes. Softaculous seems provides access to CLI.

bin/command set-password your-espo-user

If no file permission to execute, then an alternative:

php command.php set-password your-espo-user

[preacherrichd]

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.

[yuri]

Inactive user means that someone inactivated this user. You can update the user record manually in the DB. Set is_active to true.

[preacherrichd]

What table do I find the field is_active?

[shalmaxb]

table user, set is_active to 1

[preacherrichd]

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.

[preacherrichd]

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?