Comments (3)
Greetings!
I downloaded the last version (1.0.0)
today i got same error on General Reports
tab for Last-Connection-Attempts :
Database error
Error Message: DB Error: syntax error
Debug info: SELECT radpostauth. FROM radpostauth WHERE (radpostauth. LIKE '%') AND ( >='2019-04-01' AND <='2019-04-30') [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM radpostauth WHERE (radpostauth. LIKE '%') AND ( >='2019-04-01' AND <='20' at line 2]
from daloradius.
Hi @alimp5
I guess I have discovered a potential bug in rep-lastconnect.php
after checking your issue:
if (isset($configValues['FREERADIUS_VERSION']) && ($configValues['FREERADIUS_VERSION'] == '2')) {
$tableSetting['postauth']['user'] = 'username';
$tableSetting['postauth']['date'] = 'authdate';
} elseif (isset($configValues['FREERADIUS_VERSION']) && ($configValues['FREERADIUS_VERSION'] == '1')) {
$tableSetting['postauth']['user'] = 'user';
$tableSetting['postauth']['date'] = 'date';
}
I wonder you are running daloRADIUS under FreeRadius 3 and you have set $configValues['FREERADIUS_VERSION']
to the value '3'
.
If that is the case, both $tableSetting['postauth']['user']
and $tableSetting['postauth']['date']
will be undefined, so the SQL queries would be bad formed:
$sql = "SELECT ".
$configValues['CONFIG_DB_TBL_RADPOSTAUTH'].".".$tableSetting['postauth']['user']."
FROM ".$configValues['CONFIG_DB_TBL_RADPOSTAUTH'].
" WHERE (".$configValues['CONFIG_DB_TBL_RADPOSTAUTH'].".".$tableSetting['postauth']['user']." LIKE '".
$dbSocket->escapeSimple($usernameLastConnect)."%') $radiusReplySQL ".
" AND (".$tableSetting['postauth']['date']." >='$startdate' AND ".$tableSetting['postauth']['date']." <='$enddate') ";
I have prepared and merged to master branch the PR #99 that possibly fix your issue.
Please, check and confirm if that's the case, in order to close the issue.
from daloradius.
No reply has arrived and I understand that PR #99 fix this issue. So, closed.
from daloradius.
Related Issues (20)
- UI issues: daloRADIUS - RADIUS Management version 2.0 beta / 9 Feb 2023 HOT 3
- Problema con mariadb, no inicia (ubuntu 16.04) HOT 3
- Accounting information not being updated HOT 2
- attribute value not change HOT 2
- New Install - Authentication Issues HOT 2
- 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
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.