Login issue after upgrading to 6.1.0

[anuar]

I two different instance with EspoCRM, both where upgraded to 6.1.0. But I'm having login issue on one of them. I get to enter username and password, but after that it does nothing. Also no error in logs.

[emillod]

Did you checked php logs? Anything in console?

[vvlada]

Same here...

[Maximus]

Hi,
You can try to reset the password with this way https://docs.espocrm.com/administrat...st-cant-log-in.

[vvlada]

No, didn't help. Console error:

Error 401: Unauthorized. espo.min.js:674:41
setupAjax espo.min.js:674
jQuery 5
dispatch
handle
trigger
x
b

[vvlada]

Also I have following error in espo logs:

[2021-01-28 12:46:03] ERROR: CronManager: Failed job running, job [6012b0a2a914c1f1e]. Error Details: Job CheckEmailAccounts 5877717e31e9e39e6: [0] cannot login, user or password wrong at /var/www/html/application/Espo/Modules/Crm/Jobs/CheckEmailAccounts.php:74 [] []

[Maximus]

What type of Authentication you have been using before the upgrade (Espo, LDAP). Open the config.php file in the /data directory. Find the 'authenticationMethod' parameter and set to 'Espo' like:

'authenticationMethod' => 'Espo',

After, refresh a login page and try to login again.
Please note if you reseted the password via CLI then you need to log in with the new password you applied.

[vvlada]

Even before i click on Login, in web browser console I have errors:

GET https://xxx.xxx.xxx/api/v1/App/user[HTTP/1.1 401 Unauthorized 111ms]

POST https://xxx.xxx.xxx/api/v1/App/action/destroyAuthToken

[vvlada]

Yes, authenticationMethod is Espo, and yes, I used new password.

[Maximus]

Could you open your Espocrm DB -> table 'user' -> check whether your user (e.g. admin):
1. Exists in the table
2. Has 'delated' = 0

[vvlada]

Yes, users are not deleted, exists in table and have deleted = 0

[vvlada]

Here are Firefox console errors, even before login, so there is something with API and .js...

[yuri]

If it's a production I'd recommend to restore a backup (hope you made). Then try to upgrade a test instance to figure out what went wrong.

[vvlada]

Restore done. Everything works.

[yuri]

Try setting the log level to INFO. And then check what is in log after trying to log in.

[vvlada]

I will wait for other to get into trouble and you to solve it in some of the next releases...

[yuri]

What PHP version do you have?

[vvlada]

PHP 7.4.10, CentOS

[yuri]

Maybe some files were cached. Not sure what it could be. I tested on PHP 7.4 a lot, never had this issue.

[Christian]

I have the same problem.
The log file are empty (warning).
After reset folder permissions and delete cache (data\cache\) became the following messages from the page (firefox web developer):

XHRGET https://xxxxxx/api/v1/App/user
[HTTP/1.1 401 Unauthorized 440ms]

XHRPOST https://xxxxxx/api/v1/App/action/destroyAuthToken
[HTTP/1.1 401 Unauthorized 440ms]

Error 401: Unauthorized.

PHP version 7.1.14
Apache
Windows 2012 r2
MariaDB

[yuri]

Are you sure you have PHP 7.1? This version is not supported by EspoCRM more than a year.

[Christian]

sorry, i meant PHP 7.4.14