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

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 "/usr/local/lib/php/20131226/db.so" 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

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

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.

Hie Lira

I am having this error:Login must use encrypted connection on virtual machine.How can I resolve this error

Thank you in advance

Should be $myDictionary = preg_split('/\n/', $dictionary); at line 38 of mng-rad-attributes-import.php

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.

Hi
I need to know hardware spec for support user 20000 user With Daloradius?
Thank

Hi,

Any plans to add support for freeradius 3.x ?

When Add a Recharge cards functions? ? thank you very much

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?

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

Hei guys,

seems like your hosting contract went out.
www.daloradius.com is not online anymore.

rgds schabi

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.

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?

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.

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

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

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,

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

This line failes dueto a deprecated function call of ereg_replace() according to this site preg_replace() should be used.

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.

Any ideas?

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?

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

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;
                                        }

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.

Hi there,

is it better do get daloRadius from this repository, or download the 2012 version from the website?

rgd schabi

Why 128 characters for currency? Besides 'decimal' taking less storage space in what appears to be a decimal only situation, wouldn't this create sanitation issues?
planCost | varchar(128) | YES | | NULL

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

Hello,

Is daloradius compatible with freeradius3?

rgds Schabi

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 ?

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

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

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"```

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 .

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 ?.

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.

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

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

The daloradius.com website is suspended

Adding daloRADIUS screenshots here.

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

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

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:

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?

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.

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

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

When trying to connect as user to change password using PHP7.0

Main install works just trying to login as user to edit password and so forth.

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";
}
}

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