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.

[dazller4554328]

Cause of the Issue
When users are added directly to the radcheck table (or other FreeRADIUS tables), daloRADIUS doesn't update its own internal records or interface. This is not necessarily a bug but rather a limitation of daloRADIUS's design—it primarily operates as a front-end tool and expects operations to go through its interface.

Solution

1. Ensure All Required Tables Are Updated
   When adding users directly to the database, make sure to populate all related tables that daloRADIUS relies on, such as:

radcheck: Contains the authentication credentials.
radusergroup: Maps the user to a specific group.
userinfo: Stores user details for daloRADIUS.
2. Example SQL Inserts
For a user named testuser:

Add the user to the radcheck table:

INSERT INTO radcheck (username, attribute, op, value)
VALUES ('testuser', 'Cleartext-Password', ':=', 'password123');
Add the user to the radusergroup table:

INSERT INTO radusergroup (username, groupname, priority)
VALUES ('testuser', 'default', 1);
Add the user to the userinfo table (used by daloRADIUS for its interface):

INSERT INTO userinfo (username, firstname, lastname, email, department, company)
VALUES ('testuser', 'Test', 'User', '[email protected]', 'IT', 'CompanyName');
3. Sync Database Schema in daloRADIUS
After adding the users manually, force daloRADIUS to recognize the new entries:

Log in to the daloRADIUS web interface.
Navigate to Administrator -> Database Maintenance.
Click Check Schema Integrity or similar options (depending on your version) to ensure the database structure matches daloRADIUS expectations.

basically, you can get the user to show if you add this. INSERT INTO userinfo (username) VALUES ('testuser');