Users not visible in daloRADIUS

[DapraLeonardo]

Description:
I am encountering an issue where users are not visible in daloRADIUS. The users are correctly created in the MySQL database and appear in the radcheck table, but they do not show up on the daloRADIUS web page.

Problem Details:

1. Platform: Ubuntu 24.04.1
2. FreeRADIUS Version: 3.0
3. daloRADIUS Version: 1.3
4. Database: MySQL Ver 8.0.40-0

Steps to Reproduce the Issue:

1. Create a new user in the MySQL database:

   INSERT INTO radcheck (username, attribute, op, value) VALUES ('Testuser', 'Cleartext-Password', ':=', 'mpae2020');

2. Verify that the user is present in the database:

   SELECT * FROM radcheck WHERE username = 'Testuser';

3. Open daloRADIUS and check if the user "Testuser" appears in the user list.

Expected Result:
The user "Testuser" should be visible in the user list on the daloRADIUS web page.

Actual Result:
The user "Testuser" does not appear in the user list on the daloRADIUS web page, even though the user is present in the database.

Logs and Screenshots:

1. FreeRADIUS Logs: No errors found in the FreeRADIUS logs.
2. Web Server Logs: No errors found in the web server logs (e.g., /var/log/httpd/error.log).
3. daloRADIUS Logs: No specific errors found in the daloRADIUS logs.
4. Screenshots:
   • The radcheck table in the MySQL database with the "Testuser".
   • The daloRADIUS web page without the "Testuser".

Possible Causes:

1. Synchronization issues between FreeRADIUS and daloRADIUS.
2. Database configuration problems.
3. Bug in the version of daloRADIUS being used.

Steps Already Taken to Resolve the Issue:

1. Verified the FreeRADIUS configuration.
2. Verified daloRADIUS’s database connection.
3. Updated the daloRADIUS database schema.
4. Checked the web server and FreeRADIUS logs for errors.

Additional Information:
I am available to provide more details and logs if needed. I would appreciate any assistance or guidance on how to resolve this issue.