Problem login with dynamic permission phprunner 11.2 built 44228

It appears you are trying to set up dynamic permissions and user authentication in PHPRunner, but you're encountering issues when logging in. Here are some steps to troubleshoot and resolve the problem:

1. Check Password Hashing:

   • Ensure that the password stored in the database is indeed hashed correctly with bcrypt. The format you provided ($2y$12$...) looks correct, but make sure that the password hashing function in your login script corresponds with how you are storing passwords. The password should be hashed when a user registers, and during login, you should verify it against the hash using the same bcrypt function.
   
   
   
   

2. Database Configuration:

   • Confirm that you have enabled database authentication correctly in PHPRunner. Make sure the table names and field names in your configuration match exactly how they are defined in your database.
   
   
   
   

3. User Group Setup:

   • It appears that your skf_uggroups table is empty. This table is typically used to define user groups and their permissions. You may want to add a group (e.g., Admin or User) to this table and then assign your user to this group in the skf_ugmembers table. If there are no groups defined, the login might fail due to lack of permissions.
   
   
   
   

4. User Rights:

   • Ensure that the skf_ugrights table is correctly populated with the required rights for the user groups. If the groups are empty or missing required permissions, users may not be able to log in successfully.
   
   
   
   

5. Debugging the Login:

   • Check the login process for any error messages. PHPRunner might provide logs or debugging information that could give you more insights into why the login is failing.
   • If you can, try to add some debugging statements in your login code to see what values are being processed (e.g., username and password).
   
   
   
   

6. Field Lengths:

   • Verify that the ml_Bruger and ml_Passw fields are appropriately sized to hold the username and password. The varchar(20) for ml_Bruger seems fine, but ensure that it can accommodate the length of usernames you're using.
   
   
   
   

7. Case Sensitivity:

   • Remember that username and password checks are case-sensitive. Make sure the username you are entering matches exactly what is stored in the database.
   
   
   
   

8. Testing with Plain Passwords:

   • As a temporary troubleshooting step, consider testing with plain text passwords (not hashed) to determine if the issue is with the hashing or the login process in general. If it works with plain text, then the issue is likely with how you are hashing or verifying the password.
   
   
   
   

9. PHPRunner Documentation:

   • Review the PHPRunner documentation regarding user authentication and dynamic permissions to ensure that all necessary configurations have been made correctly.
   
   
   
   

By following these steps, you should be able to identify and resolve the issues with your login implementation in PHPRunner. If the problem persists, consider reaching out to the PHPRunner support community or forums for more specific assistance tailored to your setup.

It ill be more helpful if you post in English.

If you have created the password before changing to using bcrypt, you may have to create a new password, use the 'forgotten password'

And now in Danish: hvis din bruger er oprettet for du skiftede til dynamisk og bcrypt så er du nødt til at ændre password før du kan logge ind brug funktionen med glemt password så får du en email med link til ændring af password

Sorry, here in english:
Hi

I am using phprunner 11.2 built 44228:

I have used hardcoded password in my project so far.

Now I want to use dynamic permission so that the members in my project can edit their own data.

I have changed the hardcode for database access, user and password are in the member database password is tested with clear text
and bcrypt(12) starting with '$2y$'. in 2 new fields in the member database (user and password)

When I log in I get the error: logind fails?

Can we see a screenshot with the error message?

Also, do you het exactly the same error using plain text and hashed passwords?