While working on upgrade (AG 5.3 => 5.81) I found that no existing users can login, including admin. No errors displayed, no entry in error_log.
I can however submit a new user and login that way. Was able to make that new user admin, so have permissions and access to Admin area.
But I have no idea what it is about the user tables or Appgini code that is preventing existing users from logging in.
Any suggestions of how I can fix this problem? mysql 5.7 php 7
thanks, Bob
all users unable to login
Re: all users unable to login
Hi Bob,
just a guess (I started at 5.75): Maybe the structure of the table membership_users has changed since then? Use a tool like phpmyadmin or adminer to check if all users have the "approved" flag and none of the users has the "ban" flag. ... Especially the admin user
Olaf
just a guess (I started at 5.75): Maybe the structure of the table membership_users has changed since then? Use a tool like phpmyadmin or adminer to check if all users have the "approved" flag and none of the users has the "ban" flag. ... Especially the admin user
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: all users unable to login
Hi Bob,
if I got it right, login works for new users but not for existing users. So the integrity of membership table should not be the problem.
As far as I remember there was a change in 5.73 related to a more secure password encryption.
You could try to reset a password for one of the non-working users using the "Password Reset Page" (in login-page: forgot password option).
Then, with a new password, check again.
If this user can login with a new password, you will have to reset all users' passwords - which on the one hand side is annoying, on the other hand side more secure than before (and only required once).
Hope this helps,
Jan
if I got it right, login works for new users but not for existing users. So the integrity of membership table should not be the problem.
As far as I remember there was a change in 5.73 related to a more secure password encryption.
You could try to reset a password for one of the non-working users using the "Password Reset Page" (in login-page: forgot password option).
Then, with a new password, check again.
If this user can login with a new password, you will have to reset all users' passwords - which on the one hand side is annoying, on the other hand side more secure than before (and only required once).
Hope this helps,
Jan
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: all users unable to login
Jan, that was the problem, thanks for the explanation. I have about 40 users but it won't take too long to reset for them.