Giter VIP home page Giter VIP logo

lirantal / daloradius Goto Github PK

View Code? Open in Web Editor NEW
631.0 58.0 322.0 21.98 MB

daloRADIUS is an advanced RADIUS web management application for managing hotspots and general-purpose ISP deployments. It features user management, graphical reporting, accounting, a billing engine, and integrates with OpenStreetMap for geolocation. The system is based on FreeRADIUS with which it shares access to the backend database.

Home Page: http://www.daloradius.com

License: GNU General Public License v2.0

PHP 81.86% JavaScript 2.43% CSS 0.56% HTML 14.60% Shell 0.50% Dockerfile 0.02% Hack 0.03%
php hotspot-management radius freeradius-webinterface hotspot-manager wifi-manager freeradius

daloradius's Introduction

daloRADIUS is an advanced RADIUS web management application for managing hotspots and general-purpose ISP deployments. It features user management, graphical reporting, accounting, a billing engine, and integrates with OpenStreetMap for geolocation. The system is based on FreeRADIUS with which it shares access to the backend database.

daloRADIUS is written using the PHP programming language and uses a database abstraction layer (DAL) for database access. Although DAL allows the use of different database management systems (DBMSs) (e.g. MariaDB, MySQL, PostgreSQL, SQLite, MsSQL, etc.), daloRADIUS has been mainly tested on the MariaDB DBMS.

Installation

quick installation

To quickly install a basic standalone AAA infrastructure - based on daloRADIUS - on a Debian environment, run the following command in a root terminal:

wget -qO - https://raw.githubusercontent.com/lirantal/daloradius/master/setup/install.sh | bash

installation guide

To install daloRADIUS, you can follow the installation guide available in the project's official wiki:

Alternatively, you can also find the installation guide in the doc/install folder of this repository.

If you encounter any issues during the installation or have any questions, feel free to ask for support in the Issues section.

Documentation

The documentation for daloRADIUS is available in Markdown format and can be found in the doc folder of this repository.

Contributors

Special thanks to these wonderful people for their contributions to daloRADIUS...

... and many more who have contributed to the project over time. Thank you for your valuable contributions!

Would you like to contribute too? Learn how to get started: How to Contribute.

Features

Management

User Management

  • List Users: View a list of all registered users in the system.
  • Create New User: Easily create new user accounts with required attributes.

  • Quick Add New User: Streamlined process for quick user account creation, ideal for POS or HotSpot shops.
  • Edit User: Modify user account details and attributes as needed.
  • Search User: Easily find users using various search criteria.
  • Delete User: Remove user accounts from the system.

HotSpot Management

  • List HotSpots: View a list of all configured hotspots.
  • Create New HotSpot: Effortlessly create new hotspots and configure their settings.
  • Edit HotSpot: Modify hotspot details and settings as required.
  • Delete HotSpot: Remove hotspots from the system.

NAS Management

  • List NAS: View a list of all Network Access Servers (NAS) registered in the system.
  • Create New NAS: Add new NAS devices to manage network access.
  • Edit NAS: Modify NAS details and settings.
  • Delete NAS: Remove NAS devices from the system.

Groups Management

  • List, Create New, Edit and Delete User-Groups Mapping: Manage user-group mapping in the radius database.
  • List, Create New, Edit and Delete Group-Reply and Group-Check Settings: Configure group-wide attributes in the radius database.

Accounting

Users Accounting By

  • Username: View accounting information for specific users by their username.
  • IP Address: Monitor accounting details based on the user's IP address.
  • NAS IP Address: Track accounting data based on the NAS IP address.
  • Date (From/To): Get accounting records within a specified date range.
  • Display of All Accounting Records: Access a comprehensive view of all accounting records in the radius database.
  • Display of Active Accounting Records: Monitor active accounting sessions using Max-All-Session attribute or Expiration attribute.
  • Custom Accounting Query: Perform custom accounting queries to extract specific data.

HotSpots Accounting

  • Comparison of Accounting for different HotSpots: Compare accounting data for different hotspots, providing information on hotspot's unique users, total hits, average time, and total time.

GIS - Geographical Information System

daloRADIUS comes with integrated support for GIS provided by Leaflet and CARTO basemap, enabling the visual location of deployed HotSpots across a map. It allows you to see their status and monitor them visually.

  • View Map: Monitor deployed HotSpots using the GIS map.
  • Edit Map: Add or delete HotSpots directly on the map, without navigating to the HotSpots Management page.

Reporting

Basic Reporting

  • Online Users: View online users currently connected to the system from all NAS devices at a current point in time.
  • Last Connection Attempts: View last connection attempts and their status - whether they were rejected or successful.
  • Search Users: Search for Users - similar to the functionality in User Management page.
  • Top Users: View a report of the Top Users based on their Bandwidth consumption or Time usage.

Logs Reporting

  • daloRADIUS Log: Keep track of all actions performed within the daloRADIUS interface, such as page visits, form actions (e.g., deleting users, creating new hotspots), and queries submission for user accounting.
  • RADIUS Server Log: Monitor the FreeRADIUS server logfile.
  • System Log: Monitor the system log, which can include syslog or messages, depending on the configuration.
  • Boot Log: Monitor the boot/kernel log (dmesg).

Status Reporting

  • Server Status: Provides detailed information on the server where daloRADIUS is deployed, including CPU utilization, uptime, memory, disk information, and more.
  • RADIUS Status: Provides information on whether the FreeRADIUS server is running, along with the database server (e.g., MySQL, PostgreSQL, or others).

Billing

  • POS (Point of Sales)
  • Plans
  • Rates
  • PayPal Transactions
  • Billing History
  • Invoices
  • Payments

Graphs

Users Graphs

Provides visual graphs and statistical listing per user connection's attributes, including:

  • Logins/Hits
  • Download
  • Upload

Server-Wide Graphs

Provides visual graphs and statistical listing for the entire server, showing all-time information on:

  • Logins/Hits
  • Traffic Comparison

Configuration

Global Configuration

  • Database Settings: Configure database connection information (storage: MySQL, PostgreSQL, and others), credentials (username and password), radius database table names (radcheck, radacct, etc.), and database password encryption type (none, md5, sha1).
  • Language Settings: daloRADIUS is multi-lingual and currently supports English and Russian language packs.
  • Logging Settings and Debugging: Enable logging of different actions, queries, and page visits. Also supports debugging of SQL queries executed.
  • Interface Settings: Support for displaying password text in either clear-text or as asterisks to hide it. Table listing spanning across multiple pages is configurable on the number of rows per page and addition of number links for quick-access to different pages.

Maintenance

  • Test User Connectivity: Provides the ability to check if a user's credentials (username and password) are valid by executing a radius query to a radius server (configurable for radius port, shared secret, etc.).
  • Disconnect User: Supply a username and send a PoD (Packet of Disconnect) or CoA (Change of Authority) packet to the NAS to disconnect the user.

Operators

daloRADIUS supports Operators for complete management of the entire platform. Different Operators can be added with their contact information and ACLs settings to grant or revoke them permissions to access different pages.

  • List Operators
  • Create New Operator
  • Edit Operator
  • Delete Operator

Credits

daloRADIUS makes use of several third-party packages and I would like to thank these great tools and their authors for releasing such a good software to the community.

Support

Helpful resources to find help and support with daloRADIUS:

Copyright

daloradius's People

Contributors

adityaasoleh avatar alexlorvi avatar ashadebi avatar biwhite avatar bmwfrs avatar bruvv avatar dcec avatar dennisdegreef avatar dormancygrace avatar fercho1999leon avatar filippolauria avatar frauhottelmann avatar h44z avatar huseyinyildirim avatar inthesun29 avatar jomaxro avatar kudarisenmon avatar lirantal avatar miguelvis avatar moffitj avatar momothefox avatar omelendres avatar robertkwok2 avatar rongzedong avatar screwloose83 avatar takahe avatar thefra985 avatar wellesximenes avatar wookielinux avatar zanix avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

daloradius's Issues

There is any plan optimize daloradius to suitable for PHP7?

Hi this is a excellent tool for radius management.

But in PHP7 it have many error because of some function has been removed.

There is any plan optimize daloradius to suitable for PHP7?

If yes,please let me know.
If no,can I fixes it by myself?

Freeradius 3.x PHP7 and Postgres: DB connection failure

On dologin.php:

 Warning: include_once(DB.php): failed to open stream: No such file or directory in /var/www/localhost/htdocs/daloradius/library/opendb.php on line 84

Warning: include_once(): Failed opening 'DB.php' for inclusion (include_path='.:/usr/share/php7:/usr/share/php') in /var/www/localhost/htdocs/daloradius/library/opendb.php on line 84

Fatal error: Uncaught Error: Class 'DB' not found in /var/www/localhost/htdocs/daloradius/library/opendb.php:86 Stack trace: #0 /var/www/localhost/htdocs/daloradius/dologin.php(49): include() #1 {main} thrown in /var/www/localhost/htdocs/daloradius/library/opendb.php on line 86

Never had daloradius working, so I don't know what to compare this output to.

DB Error: extension not found

Install from master(02.09.2018)
Fedora 28 aarch64
PHP 7.2.9 (cli) (built: Aug 14 2018 14:26:29) ( NTS )
MariaDB 10.2

daloradius/dologin.php:

Database connection error  
Error Message: DB Error: extension not found

/var/log/php-fpm/www-error.log:

PHP Warning:  A non-numeric value encountered in /var/www/html/daloradius/lang/en.php on line 1408
PHP Warning:  A non-numeric value encountered in /var/www/html/daloradius/lang/en.php on line 1409
PHP Warning:  A non-numeric value encountered in /var/www/html/daloradius/lang/en.php on line 1410
PHP Warning:  count(): Parameter must be an array or an object that implements Countable in /usr/share/pear/DB.php on line 775

Docker support for daloRADIUS

Opening this ticket and leaving open to grab the community attention.

Initial support for Docker daloRADIUS image: #12
You're welcome to comment, propose changes, or fork the PR and update it.

latest version last connection attempts not showing up?

Using FR 3.1.2 and the latest commit of daloRADIUS last connection attempts never updates.

Debugging SQL Queries:
SELECT radpostauth.username, radpostauth.pass, radpostauth.reply, radpostauth.authdate FROM radpostauth WHERE (radpostauth.username LIKE '%%') AND (authdate >='2017-01-01' AND authdate <='2017-02-28') ORDER BY radpostauth.id desc LIMIT 0, 25

is there something I need to change from the previous config? It's been working well for going on a year with every update until this last one. Thank you

ACL page does not save

When using the acl page for an operator. Certain options when set to disable make the acl page hang and not process the request. What is the fix for this?

Simultaneous-Use login

Hi
please elaborate on how to setup Simultaneous-Use login so that users are limited to the number of loggins. I am using a pfsense captive portal which is not among the listed vendors. Which vendor exactly has the feature?

Issues with PHP 7.0

Issues with PHP 7.0

View logs
2018/03/31 17:57:05 [error] 19899#19899: *1928 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Call to undefined function eregi_replace() in /usr/share/nginx/html/daloradius/library/exten-radius_log.php:62
Stack trace:
#0 /usr/share/nginx/html/daloradius/rep-logs-radius.php(61): include()
#1 {main}
thrown in /usr/share/nginx/html/daloradius/library/exten-radius_log.php on line 62" while reading upstream

Server Status
2018/03/31 17:58:33 [error] 19899#19899: *1940 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Call to undefined function split() in /usr/share/nginx/html/daloradius/library/exten-server_info.php:33
Stack trace:
#0 /usr/share/nginx/html/daloradius/library/exten-server_info.php(258): uptime()
#1 /usr/share/nginx/html/daloradius/rep-stat-server.php(56): include('/usr/share/ngin...')
#2 {main}
thrown in /usr/share/nginx/html/daloradius/library/exten-server_info.php on line 33" while reading upstream

Access-Period not working after migration to ubuntu 16.04

OS: ubuntu 16.04
PHP 7
mysql Ver 14.14 Distrib 5.7.21
FreeRADIUS Version 2.2.8,

I have running daloradius vm on my private lan which I have a plan of migrating to Ubuntu 16.04 in a VPS. I have successfully install and configure daloradius on my new OS. I have backed up the radius database on the old system and restore it to Ubuntu 16.04. Right now i am doing some system testing, Everything works well except on access-period that supposed to deny access to the user who has access period laps. Below is the free radius logfile.

Error: rlm_sql (sql): database query error, SELECT IF(COUNT(radacctid>=1),(UNIX_TIMESTAMP() - IFNULL(UNIX_TIMESTAMP(AcctStartTime),0)),0) FROM radacct WHERE UserName = '6BuA4z' AND AcctSessionTime >= 1 ORDER BY AcctStartTime LIMIT 1: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'radius.radacct.acctstarttime'; this is incompatible with sql_mode=only_full_group_by

Hope you could help me
thanks,

Modify here you can disconnect the user mikrotik ros

Daloradius + mikrotik ros can not disconnect online users! I modified the source code as follows:
rep-online.php
In line 241 add: Framed-IP-Address = $ ip

<a class='toolTip' href='config-maint-disconnect-user.php?username=$username&nasaddr=$nasip&customattributes=Acct-Session-Id=$acctsessionid,Framed-IP-Address=$ip'>".
Test command:echo User-Name=777,Framed-IP-Address="192.168.1.20" | radclient -x -F 192.168.2.39:3799 disconnect testing123
Test video:http://pan.baidu.com/s/1c2tcHTQ
blog :http://blog.csdn.net/chinasanduo/article/details/62231831#t15
QQ:1064331064
Sorry for my bad english

Reading log files return blank page

Daloradius log and Freeradius log all don't show anything. Entirely blank screen. Permission and location everything looks fine, and the log files aren't empty too.

A screenshot:
screenshot from 2016-12-22 17-48-02

Database error

Install from https://github.com/lirantal/daloradius/archive/master.tar.gz (29.06.2018)
PHP Version 7.0.30
daloRADIUS -> Reports Page -> Last Connection Attempts:

Database error
Error Message: DB Error: syntax error
Debug info: SELECT radpostauth. FROM radpostauth WHERE (radpostauth. LIKE '%%') AND ( >='2018-06-01' AND <='2018-07-01') [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 ( >='2018-06-01' AND <='2' at line 2]

Fatal error: Call to undefined method DB_Error::numRows() in /usr/local/lib/php/DB.php on line 985

Remove User:

> Database error
> Error Message: DB Error: syntax error
> Debug info: DELETE FROM radpostauth WHERE ='user' [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 '='user'' at line 1]

Login Daloradius with cyrilic password:

Database error
Error Message: DB Error: unknown error
Debug info: SELECT id, username FROM operators WHERE username = 'administrator' AND password = 'кфвшгы' [nativecode=1267 ** Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '=']

Fatal error: Call to undefined method DB_Error::numRows() in /usr/local/lib/php/DB.php on line 985

5/5000 Recharge card function

Want to join the bulk generation recharge card function, when the user after the board, if the recharge page enter the recharge card number and password automatically to the user network time

daloradius with Nginx

I run my entire VPS using Nginx. Introducing Apache wouldn't be a flexible addition, at least if it'll be used to run only one and single service.

On that note, is there a way I can have Daloradius work with Nginx? I'll be honest, I've not spotted even a single documentation online using Nginx. Everyone is using Apache,

Except this: https://gist.github.com/atmosx/e1949150e74baae0b813 which doesn't help, and only give 502 Gateway error.

  • I want the Radius to run on radius.example.com

Below is my current server block in Nginx:

server {
    listen 80;

    root /var/www/html/radius;
    index index.php index.html index.htm;

    server_name radius.khophi.co;

    location ~ .*\.php$ {
        # What should I put in here
        # or what shouldn't I?
    }
}

Will appreciate help. Thanks

Uncaught ReferenceError: __displayTooltip is not defined

There is an old issue about a JavaScript function not defined on Tooltips, as a ticket in the old SourceForge repository:

#62 __displayTooltip is not defined in User List

Uncaught ReferenceError: __displayTooltip is not defined mng-list-all.php:229
onclick mng-list-all.php:229
etc.

Liran Tal - 2014-07-19
Known issue.
You are welcome to find the fix for it and I'll distribute it in daloRADIUS and to everyone else.

This issue occurs in lots of Daloradius PHP files (in every tooltip, actually!).

Reading the documentation about this plugin in Tooltip For Forms, and looking at the demo source code in Form field tooltip, I have arrived to the conclusion that the following code included in every tooltip is useless and causing a JS error totally avoidable, by deleting it:

onClick='javascript:__displayTooltip();'

I will send a PR (and merge) to solve this very old issue in a short time.

GIS with Google Maps

There is an old issue with GIS hotspot geolocating with Google Maps: it does not work anymore.

See SourceForge thread for more information on the subject:

GIS with google maps

We have two problems here:

  1. daloRADIUS is using a very old version of the Google Maps API, not compatible with the new one. That implies refactoring the code.
  2. To get an API-KEY from Google in order to use the Google Maps services, you have to give them a credit card number. I will not do that. Now is a paid service, although there are certain number of free API calls. See Google Maps Pricing.

Maybe there are free alternatives to Google Maps.

Help is needed here from the daloRADIUS community.

Problem when downloading invoices

Hi,

I've recently installed DaloRadius on my Pi, and I've set up my users, my groups, my plans, etc... And it works well (Thank you @lirantal for what you have done). But when I try to download or to preview invoices, I get a 500 HTTP error and my browser tells me "This page doesn't work"...

--- EDIT ---

Here are the logs of /var/log/nginx/error.log :
2019/01/05 22:19:06 [error] 924#924: *886 FastCGI sent in stderr: "PHP message: PHP Notice: Undefined index: billinvoicesedit in /usr/share/nginx/html/daloradius/bill-invoice-edit.php on line 265" while reading upstream, client: 192.168.42.35, server: _, request: "GET /bill-invoice-edit.php?invoice_id=6 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "192.168.42.38", referrer: "http://192.168.42.38/bill-invoice-list.php?user_id=5" 2019/01/05 22:19:06 [error] 924#924: *886 FastCGI sent in stderr: "PHP message: PHP Notice: Undefined index: user_idTooltip in /usr/share/nginx/html/daloradius/bill-invoice-edit.php on line 354" while reading upstream, client: 192.168.42.35, server: _, request: "GET /bill-invoice-edit.php?invoice_id=6 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "192.168.42.38", referrer: "http://192.168.42.38/bill-invoice-list.php?user_id=5"

Does someone know how to fix it?
Thank you in advance,

Victor

Delete User

Hello,

When I try to delete a user from daloradius i have this error:

Database error Error Message: DB Error: syntax error Debug info: DELETE FROM radpostauth WHERE ='XXXXX' [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 '='XXXXX'' at line 1]

OS: Debian 9.1 64bit
PHP: 7

Radius service info check

library/exten-radius_server_info.php with 1 works for me
function check_service($sname) {
if ($sname != '') {
system("pgrep ".escapeshellarg($sname)." >/dev/null 2>&1", $ret_service);
if ($ret_service == 1) {
return "Enabled";
} else {
return "Disabled";
}
} else {
return "no service name";
}
}

Database error

Database error
Error Message: DB Error: unknown error
Debug info: SET GLOBAL sql_mode = ''; [nativecode=1227 ** Access denied; you need (at least one of) the SUPER privilege(s) for this operation]

I get this with all versions from here and from SF if I use a mysqluser that has no global SUPER privileges.
I wonder why SUPER is needed?

daloradius/contrib/configs/ not working for freeradius 3.

I'm reporting this issue as I like daloradius.

daloradius/contrib/configs/freeradius-2.1.8 files does not work for freeradius 3.

one noticeable difference is the counter.conf is now sqlcounter.conf and of different location...
also the content of sqlcounter.conf has a lot of changes.

I tried to apply some settings from counter.conf to sqlcounter.conf but still daloradius does not work.

List all user empty

Hi, i've installed daloradius for the first time, because dialup_admin it's almost dead,
I'm working in a ISP, and refreshing historic servers, like the radius server, quite old,
freeradius 2.x, dialup_admin, etc...
Now the new server I've build up is a Centos7, with freeradius3, php7.1, percona 5.7 as
mysql flavour. In the end, I managed to run daloradius in this configuration but the problem
started with the list users made by this select:

SELECT 
 distinct(radcheck.username),
 radcheck.value, 
 radcheck.id,radusergroup.groupname as groupname, 
 attribute, 
 userinfo.firstname, 
 userinfo.lastname , 
 IFNULL(disabled.username,0) as disabled 
FROM 
 radcheck 
 LEFT JOIN radusergroup ON radcheck.username=radusergroup.username 
 LEFT JOIN userinfo ON radcheck.username=userinfo.username 
 LEFT JOIN radusergroup disabled ON disabled.username=userinfo.username  
AND 
 disabled.groupname = 'daloRADIUS-Disabled-Users' 
WHERE 
 (radcheck.username=userinfo.username) 
AND 
 Attribute IN ('Cleartext-Password', 'Auth-Type','User-Password', 'Crypt-Password', 'MD5-Password', 'SMD5-Password', 'SHA-Password', 'SSHA-Password', 'NT-Password', 'LM-Password', 'SHA1-Password', 'CHAP-Password', 'NS-MTA-MD5-Password') 
GROUP BY 
 radcheck.Username 
ORDER BY 
 id asc LIMIT 0, 25;

it's empty....
tried to modify to let it report something but SQL isn't my best point.
Can You help me ?

PHP Fatal error: Call to undefined function session_start() in checklogin.php line 27

Running Apache 2.4 with PHP version 5.6.24 on FreeBSD 10.2
PHP is working when tested with <?php phpinfo(); ?>

index.php loads as a blank page and apache error log shows:

[Sat Aug 06 20:56:52.608468 2016] [:error] [pid 87226] [client 1.2.3.4:14883] PHP Fatal error: Call to undefined function session_start() in /usr/local/www/daloradius-0.9-9/library/checklogin.php on line 27

login.php loads but trying to login with the default username and password also gives a blank page with apache logging:
[Sat Aug 06 21:06:17.046399 2016] [:error] [pid 87225] [client 1.2.3.4:15859] PHP Fatal error: Call to undefined function session_id() in /usr/local/www/daloradius-0.9-9/dologin.php on line 36, referer: http://my.host.name/radius/login.php

PHP warnings in apache error log:

PHP Warning:  PHP Startup: gd: Unable to initialize module\nModule compiled with build ID=API20131226,NTS,debug\nPHP    compiled with build ID=API20131226,NTS\nThese options need to match\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/20131226/db.so' - Cannot open &quot;/usr/local/lib/php/20131226/db.so&quot; in Unknown on line 0
PHP Warning:  PHP Startup: session: Unable to initialize module\nModule compiled with build ID=API20131226,NTS,debug\nPHP    compiled with build ID=API20131226,NTS\nThese options need to match\n in Unknown on line 0
PHP Warning:  PHP Startup: xml: Unable to initialize module\nModule compiled with build ID=API20131226,NTS,debug\nPHP    compiled with build ID=API20131226,NTS\nThese options need to match\n in Unknown on line 0
PHP Warning:  PHP Startup: gd: Unable to initialize module\nModule compiled with build ID=API20131226,NTS,debug\nPHP    compiled with build ID=API20131226,NTS\nThese options need to match\n in Unknown on line 0
PHP Warning:  PHP Startup: zlib: Unable to initialize module\nModule compiled with build ID=API20131226,NTS,debug\nPHP    compiled with build ID=API20131226,NTS\nThese options need to match\n in Unknown on line 0
PHP Warning:  Module 'mysql' already loaded in Unknown on line 0
 % ls /usr/local/lib/php/20131226
total 968
drwxr-xr-x  2 root  wheel   512B Aug  6 21:25 ./
drwxr-xr-x  5 root  wheel   512B Aug  6 20:47 ../
-r--r--r--  1 root  wheel   510K Aug  6 21:25 gd.so
-r--r--r--  1 root  wheel    48K Jul 28 09:08 mysql.so
-r--r--r--  1 root  wheel   134K Jul 28 07:47 mysqli.so
-r--r--r--  1 root  wheel   112K Aug  6 21:25 session.so
-r--r--r--  1 root  wheel    64K Aug  6 21:25 xml.so
-r--r--r--  1 root  wheel    47K Aug  6 21:25 zlib.so

#70 Issue with CSV export of 'Last Connection Attempts'

Reference open issue on SF: https://sourceforge.net/p/daloradius/bugs/70/

A fault was reported on a job with an install of daloradius where the CSV export of the report 'Last Connection Attempts'. The fault was identified with the error report as follows:

Database error
Error Message: DB Error: no such field
Debug info: SELECT user, pass, reply, date FROM radpostauth WHERE (username LIKE '%') AND (authdate >='2016-09-01' AND authdate <='2016-09-30') ORDER BY User ASC [nativecode=1054 ** Unknown column 'user' in 'field list']

Upon investigation into the code for daloradius, it was discovered there was a bug in the SQL query used to generate the requested report. The query as discovered was as follows:

$sql = "SELECT user, pass, reply, date FROM ".$configValues['CONFIG_DB_TBL_RADPOSTAUTH']." $reportQuery ORDER BY User ASC";

This SQL query requests information on 4 fields in the database. These fields exist, but in the database names used by default by freeradius they are named slightly differently. For reference, in the database they are named respectively "username, pass, reply, authdate".
This appears to be a bug. To the best of my knowledge in daloradius the database mapping used is identical to the defaults set by freeradius. In this instance it is not so I suspect it's a bug.
To resolve this issue on the instance I was working on, the following changes were made to the SQL query.

$sql = "SELECT username, pass, reply, authdate FROM ".$configValues['CONFIG_DB_TBL_RADPOSTAUTH']." $reportQuery ORDER BY username ASC";

This was tested and shown to work in our environment.

debian-8, php5 daloradius Database connection error Error Message: DB Error: not found

Hello everybody.
I can not make it work daloRadius. When a connection to the database get : "Database connection error
Error Message: DB Error: not found "
`root@debian-8:~# pear list

Installed packages, channel pear.php.net:

Package Version State
Archive_Tar 1.4.2 stable
Auth_SASL 1.0.6 stable
Console_Getopt 1.4.1 stable
DB 1.9.2 stable
MDB2 2.5.0b5 beta
MDB2_Driver_mysql 1.5.0b4 beta
Mail 1.3.0 stable
Mail_Mime 1.8.9 stable
PEAR 1.10.1 stable
Structures_Graph 1.1.1 stable
XML_Util 1.3.0 stable
root@debian-8:~#`

Help me please. I am ready to provide any necessary information .

daloRADIUS PHP-7 Support

How to get daloRADIUS to work in PHP-7?

Dependencies

  • This assumes an Ubuntu 16.04 OS installled
  • This assumes PHP 7 installed
  • This assumes MySQL >= 5.7.5 installed
  • This assumes you have already installed all the LAMP related packages and have a working LAMP environment.
    Next, is to make sure you have the required extra packages for daloRADIUS, run:
sudo apt-get install php-common php-gd php-curl php-mail php-mail-mime php-pear php-db

and then

pear install DB

daloRADIUS internal change

Changing file library/daloradius.conf.php

It's required to update daloRADIUS's database connection code so that it identifies the MySQL server using the new and improved mysqli driver:

  1. Open for editing the file library/daloradius.conf.php and locate the configuration variable CONFIG_DB_ENGINE and change it to the value of mysqli (it is now probably set to mysql, notice the extra i). It should end up looking as follows: $configValues['CONFIG_DB_ENGINE'] = 'mysqli';

Changing file library/opendb.php

  1. Open for editing the file library/opendb.php
  2. At the very end of the file just add this new line of code: $dbSocket->query("SET GLOBAL sql_mode = '';"); which makes the MySQL version work with less strict SQL syntax

Uncaught Error: Call to undefined function set_magic_quotes_runtime()

An extract from my nginx error logs.
It happens when I try to open this url:
https://radius.example.co/rep-batch-details.php?batch_name=5_5Cedis_Bundle

Any idea why? Am I doing something wrong?

2016/12/19 11:54:24 [error] 4845#4845: *13255 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to undefined function set_magic_quotes_runtime() in /var/www/html/daloradius/notifications/dompdf-0.5.1/lib/class.pdf.php:4672
Stack trace:
#0 /var/www/html/daloradius/notifications/dompdf-0.5.1/include/cpdf_adapter.cls.php(578): Cpdf->addJpegFromFile('/var/www/html/d...', 492, 710.64, 57.6, 51.36)
#1 /var/www/html/daloradius/notifications/dompdf-0.5.1/include/image_renderer.cls.php(66): CPDF_Adapter->image('/var/www/html/d...', 'jpg', 492, 30, 57.6, 51.36)
#2 /var/www/html/daloradius/notifications/dompdf-0.5.1/include/renderer.cls.php(180): Image_Renderer->render(Object(Image_Frame_Decorator))
#3 /var/www/html/daloradius/notifications/dompdf-0.5.1/include/renderer.cls.php(110): Renderer->_render_frame('image', Object(Image_Frame_Decorator))
#4 /var/www/html/daloradius/notifications/dompdf-0.5.1/include/renderer.cls.php(132): Renderer->render(Object(Image_Frame_Decorator))
#5 /var/www/html/daloradius/notifications/dompdf-0.5.1/include/renderer.cls.php(13" while reading response header from upstream, client: 45.210.141.212, server: radius.khophi.co, request: "GET /include/common/notificationsBatchDetails.php?batch_name=5_5Cedis_Bundle&destination=download HTTP/2.0", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock:", host: "radius.khophi.co", referrer: "https://radius.example.co/rep-batch-details.php?batch_name=5_5Cedis_Bundle"```

Dockerfile doesn't build

Trying to build the docker image exactly how described will error halfway through with the following error.

Step 12/19 : RUN chown -R mysql:mysql /var/lib/mysql /var/run/mysqld; /usr/bin/mysqld_safe &  sleep 10s &&  /usr/bin/mysql --host localhost --port 3306 -u root --password="" -e "CREATE DATABASE radius" &&  /usr/bin/mysql -u root --password="" radius < /var/www/html/contrib/db/fr2-mysql-daloradius-and-freeradius.sql
 ---> Running in f52b61612a4e
chown: cannot access '/var/run/mysqld': No such file or directory
2018-06-20T01:49:38.045880Z mysqld_safe Logging to syslog.
2018-06-20T01:49:38.053506Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2018-06-20T01:49:38.059839Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
The command '/bin/sh -c chown -R mysql:mysql /var/lib/mysql /var/run/mysqld; /usr/bin/mysqld_safe &  sleep 10s &&  /usr/bin/mysql --host localhost --port 3306 -u root --password="" -e "CREATE DATABASE radius" &&  /usr/bin/mysql -u root --password="" radius < /var/www/html/contrib/db/fr2-mysql-daloradius-and-freeradius.sql' returned a non-zero code: 1

ifconfig output can't be parsed in newer versions

Ubuntu 18.04.1 LTS
net-tools version: 1.60+git20161116.90da8a0-1ubuntu1

Same for Debian Stretch:
version: 1.60+git20161116.90da8a0-1

Old ifconfig output looks like:

eth0      Link encap:Ethernet  HWaddr 00:00:00:00:00:00  
          inet addr:10.0.0.1  Bcast:10.255.255.255  Mask:255.0.0.0
          inet6 addr: fe80::0d0:00ff:aa00:a000/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:9001  Metric:1
          RX packets:6392137 errors:0 dropped:0 overruns:0 frame:0
          TX packets:4742850 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:2526325872 (2.5 GB)  TX bytes:4421795076 (4.4 GB)

New ifconfig output looks like:

eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.0.0.1  netmask 255.0.0.0  broadcast 10.255.255.255
        inet6 fe80::0d0:00ff:aa00:a000  prefixlen 64  scopeid 0x20<link>
        ether 00:00:00:00:00:00  txqueuelen 1000  (Ethernet)
        RX packets 858712  bytes 149708112 (149.7 MB)
        RX errors 0  dropped 330  overruns 0  frame 0
        TX packets 106095  bytes 13823656 (13.8 MB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

And if it matters, ifconfig is slowly being deprecated in favour of ip, which looks like this:

$ /sbin/ip address show dev eth0
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000
    link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff
    inet 10.0.0.1/8 brd 110.255.255.255 scope global eth0
       valid_lft forever preferred_lft forever
    inet6 fe80::0d0:00ff:aa00:a000/64 scope link 
       valid_lft forever preferred_lft forever

Bug in mng-del.php

Line 157
which is
list($userSessions,$acctStartTime) = preg_split('\|\|', $value);
should be
list($userSessions,$acctStartTime) = preg_split('/\\|\\|/', $value);

Last connection attempts no show

Last connection attempts no show, with all in sudden, it just keep stop at last 2 days record, not updating, but i can see there are some records in the database, kindda weird

DD-wrt chilispot

why i cannot see the splash (signup-free) on clients ? Any Glue ?

i am using the last 0.9.9 daloradius with freeradius on Ubuntu .

DD-wrt is v2.4 sp2

Users Listing is empty on Ubuntu 14.04

Hi!
I've installed daloradius on Ubuntu 14.04, and cannot get the users listing to work. It seems like the SQL is working alright, as one can change pages (27 total, see image below). Also, editing a single user works.

capture

Any ideas?

Problem with daloradius profile

Hi there
I install daloradius in centoe7 machine but I get some problem with it
When I created user without profile I get access accept but when I created profile with access-peroid check or max all session and add user to this profile I get access reject .

I use maradb and php7 and httpd httpd-devel
I test it with mikrotik and the internal freeradius with raddtest any help
Thx

Problem with Users Accounting

Good afternoon, I have a problem, I have clients with PPPoE sessions and I create the users in FreeRadius with DaloRadius, what happens is that before going to version 3 of FreeRadius a history of the client's login was saved as well as the total consumption of it, but now no longer, have any solution for that ?.

Billing improvements are welcome?

Hi!

I was thinking about doing some improvements to billing options, but I would like to know if there is a real interest in that - ie:

  • Invoicing preview (in addition to downloading and sending by email as pdf).
  • Amount and prices format including number of decimals, decimal separator, thousands separator, currency symbol.
  • Company name, address, legal identification, etc.
  • Name of tax (VAT, etc.).

Are you using Daloradius billing options? Any additional ideas? Or it would be better if I make an effort in another area of Daloradius?

Thanks.

sha1

sha1 option it's not working for passwords.
mng-edit.php

switch($configValues['CONFIG_DB_PASSWORD_ENCRYPTION']) {
                                                case "cleartext":
                                                        if ( ($value != $passwordOrig) )
                                                                $value = "$value";
                                                        break;
                                                case "crypt":
                                                        if ( ($value != $passwordOrig) )
                                                                $value = "ENCRYPT($value, 'SALT_DALORADIUS')";
                                                        break;
                                                case "md5":
                                                        if ( ($value != $passwordOrig) )
                                                                $value = "MD5($value)";
                                                        break;
                                        }

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.