Dialup admin questions
Does it make it sense to use dialup admin for administration if the freeRADIUS server uses the active directory for authentification? Because I have the following errors in the interface: Warning: asort() expects parameter 1 to be array, null given in /usr/share/freeradius-dialupadmin/htdocs/accounting.php3 on line 47 Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-11 00:00:00' AND acctstoptime <= '2008-10-11 23:59:59' ; Database query failed: Table 'radius.radacct' doesn't exist DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-03 00:00:00' AND acctstoptime <= '2008-10-03 23:59:59' ; Database query failed: Table 'radius.radacct' doesn't exist How should I fix them? Thanks. F. Niedernolte
Does it make it sense to use dialup admin for administration if the freeRADIUS server uses the active directory for authentification?
Not a lot. You won't be able to do any user administration (add users, change passwords,...)
Because I have the following errors in the interface:
Warning: asort() expects parameter 1 to be array, null given in /usr/share/freeradius-dialupadmin/htdocs/accounting.php3 on line 47
Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95
Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95
DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-11 00:00:00' AND acctstoptime <= '2008-10-11 23:59:59' ; Database query failed: Table 'radius.radacct' doesn't exist DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-03 00:00:00' AND acctstoptime <= '2008-10-03 23:59:59' ; Database query failed: Table 'radius.radacct' doesn't exist
How should I fix them?
It's looking for the accounting database. Check your sql.conf settings. Ivan Kalik Kalik Informatika ISP
OK. 1. Can I see the statistics or aren't they passed, too? I mean can I use it for information or is it completely useless in my environment? 2. Is there an alternative with which I can edit the configuration files etc. via webinterface? 3. How can I fix this warning message: Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 Thanks F. Niedernolte -----Ursprüngliche Nachricht----- Von: freeradius-users-bounces+frederik.niedernolte=bertelsmann.de@lists.freeradius.org [mailto:freeradius-users-bounces+frederik.niedernolte=bertelsmann.de@lists.freeradius.org] Im Auftrag von tnt@kalik.net Gesendet: Freitag, 10. Oktober 2008 13:01 An: FreeRadius users mailing list Betreff: Re: Dialup admin questions
Does it make it sense to use dialup admin for administration if the freeRADIUS server uses the active directory for authentification?
Not a lot. You won't be able to do any user administration (add users, change passwords,...)
Because I have the following errors in the interface:
Warning: asort() expects parameter 1 to be array, null given in /usr/share/freeradius-dialupadmin/htdocs/accounting.php3 on line 47
Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95
Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95
DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-11 00:00:00' AND acctstoptime <= '2008-10-11 23:59:59' ; Database query failed: Table 'radius.radacct' doesn't exist DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-03 00:00:00' AND acctstoptime <= '2008-10-03 23:59:59' ; Database query failed: Table 'radius.radacct' doesn't exist
How should I fix them?
It's looking for the accounting database. Check your sql.conf settings. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
1. Can I see the statistics or aren't they passed, too?
They will come up once you connect to the accounting.
2. Is there an alternative with which I can edit the configuration files etc via webinterface?
You can use things like OpenOffice if it is installed and you connect via KVM or VNC. Normally you connect with ssh (putty) and use joe or such text editors. Chap from daloRadius used to post here some time ago. You can try that and see.
3. How can I fix this warning message: Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95
That's something to do with php. That extension is .php3 so it probably wasn't updated for quite some time. Ivan Kalik Kalik Informatika ISP
To fix your warning about mktime(), edit the file function.php3, go to line 95 and the function should look like this. function date2time($date) { list($day,$time)=explode(' ',$date); $day = explode('-',$day); $time = explode(':',$time); #$timest = mktime($time[0],$time[1],$time[2],$day[1],$day[2],$day[0]); $timest = mktime(0,0,0,$day[1],$day[2],$day[0]); return $timest; } I had the same problem and that was the fix for me. Good luck.. tnt@kalik.net wrote:
1. Can I see the statistics or aren't they passed, too?
They will come up once you connect to the accounting.
2. Is there an alternative with which I can edit the configuration files etc via webinterface?
You can use things like OpenOffice if it is installed and you connect via KVM or VNC. Normally you connect with ssh (putty) and use joe or such text editors. Chap from daloRadius used to post here some time ago. You can try that and see.
3. How can I fix this warning message: Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95
That's something to do with php. That extension is .php3 so it probably wasn't updated for quite some time.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Frederik.Niedernolte＠Bertelsmann.de -
Madwifi Wireless -
tnt＠kalik.net