Comments (3)
Yeah, I can see your point. I managed to fix that.
from daloradius.
@trpl7,
The second query you wrote considers all records distinctly in the radcheck
table.
However, the first query only considers Auth-Type
and Password-like
attributes.
Which RADIUS attributes are you using for your MAC authentication users?
from daloradius.
I think this problem is coming from the check against the radacct table. A new user will not have entries in the table until they authenticate and generate accounting data which is throwing off the total user count. Modifying total_users.php to the query below is returning the correct count.
$sql = sprintf("SELECT COUNT(DISTINCT ui.username) FROM %s AS rc, %s AS ui
WHERE ui.username=rc.username
AND (rc.attribute='Auth-Type' OR rc.attribute LIKE '%%-Password')",
$configValues['CONFIG_DB_TBL_RADCHECK'],
$configValues['CONFIG_DB_TBL_DALOUSERINFO']);
from daloradius.
Related Issues (20)
- Import users - CSV-formatted data - Polish characters HOT 2
- How can i change administator password or create new admin user? HOT 1
- Attribute non-existent or inconsistency in your vendor/attribute dictionary
- conf files in Freeradius are not writable via web interface DaloRadius
- Wrong include in graph "New users" file cause warning and fatal error.
- Operators passwords are not encryped and saved in plain text. WHY? HOT 1
- Cannot add/edit groups. HOT 1
- Search Users HOT 1
- Security Vulnerability HOT 1
- default web username and password HOT 3
- daloradius is completely broken on Postgres. HOT 1
- Daloradius v2.1b - Access-Reject in Expiration module - Date format issue. HOT 1
- Happy Birthday to Filippo 🎂 HOT 3
- Empty environment MYSQL_ROOT_PASSWORD
- missing table radhuntgroup HOT 2
- Connecting ldap to daloRadius
- Expiration Date Format HOT 6
- Default Username and Password doesn't match HOT 4
- Install script does not check for write access to /proc HOT 1
- How to uninstall packages added by the script HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from daloradius.