Re: Online Users
Shawky Skaff wrote: On the online users gui page of dialup admin, there are serveral columns, one of the columns states “name”, which is after the caller ID column. I would like to know where this comes from, I have set the name on the user info page, but it doesn’t seem like that works. List of online users contains the list of users who are online. Setting something on the user info page doesn't work. Because user information is not online users. The NAS needs to send accounting packets. Once that happens, the online users should be updated. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Online Users Question
On 21 Jun 2012, at 08:26, Shawky Skaff wrote: Hi, On dialup admin online users page, I can see the online users, however if I delete this user and remove of my nas, the user still exists, so can off like a ghost online user. Where does this info come from, the radius itself or the NAS? Also any ideas of maybe something I’ve missed? Probably from radutmp or the radacct table in your MySQL db. It's populated from accounting information received from the NAS. There are no cascade rules setup for MySQL to delete accounting data when a user is removed from the radcheck or radreply tables… -Arran Arran Cudbard-Bell a.cudba...@freeradius.org Betelwiki, Betelwiki, Betelwiki http://wiki.freeradius.org/ !- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Online Users
Am 18.05.2012 01:13, schrieb Shawky Skaff: When viewing the online users and I wish to drop or clear the connection, nothing actually happens. Did you mean clean stale sessions or actually logged in users? Is there anything that I need to do to get this working? Maybe linking this to my NAS somehow, as if I clear the connection from my NAS, it seems to do the job You have to configure the CoA virtual server or just send Packet of Disconnects, see here: http://wiki.freeradius.org/Disconnect-Messages . Maybe you have to adjust your web frontend to support this. Regards, Tobias Hachmer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Online users
Are you getting accounting packets from NAS? Ivan Kalik Kalik Informatika ISP Dana 2/6/2008, Eduardo Cavalcanti [EMAIL PROTECTED] piše: I want to list the online users, but I don't want to use a database such as mysql. Is there any alternative for me?? Is there any command to list the online users?? I tried radwho but it doesn't list any user... Any help? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: online users
Mordor Networks wrote: hi Graham yes sir i know but my question is how to do that im all new to all this.. thank you Connect to your mysql database and type show tables;, then you'll see a list of tables in your database. It's probably the radacct table you need to query for session information. If you don't know how to write SQL queries, have a look at http://www.mysql.org/doc/ Thor. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: online users
Thor Spruyt wrote:
Mordor Networks wrote:
hi Graham
yes sir i know but my question is how to do that im all new to all
this.. thank you
Connect to your mysql database and type show tables;, then you'll see a
list of tables in your database.
It's probably the radacct table you need to query for session information.
If you don't know how to write SQL queries, have a look at
http://www.mysql.org/doc/
Thor.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thanks for your info , i fixed the issue with this :
$request = SELECT COUNT(*) FROM radacct WHERE AcctStopTime=0;
$res = mysql_query($request);
while( $row = mysql_fetch_array($res) )
{ $login_users = $row[0]; }
print $row[0];
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: online users
SELECT COUNT(*) FROM radacct WHERE AcctStopTime=0
That will give you the number of currently logged in users (according to
the database).
Ivan Kalik
Kalik Informatika ISP
Dana 13/4/2007, Mordor Networks [EMAIL PROTECTED] piše:
i want to know how many user logged in mysql database/radius but it only
show the number of user in my databse for example is says 61 logged out
and 0 login
so here is the problem
//login users from//
$login_users = ; what i have to write here ? which table i have to query?
how i can fix that ?
if i change the number from 0 to 1 it show me one user online so their
must be a way to fix it?
heres the code :
?php
include (include/Artichow/class/jpgraph.php);
include (include/Artichow/class/jpgraph_pie.php);
include (include/Artichow/class/jpgraph_pie3d.php);
include_once (class/Oreon.class.php);
include_once (phpradmin.conf.php);
$oreon_db = new OreonDatabase($conf_pra[host], $conf_pra[user],
$conf_pra[password], $conf_pra[db]);
$table = userinfo;
//este si es valido
$total_users_in_db = $oreon_db -getTotalRowsInTable($table);
//$total_users_in_db = 500;
//login users from DB (SELECT COUNT(*) FROM radacct??;)
$login_users = ;
//logoff users total_users_in_db - login_users
$logoff_users = ($total_users_in_db - $login_users);
//percent
$percent_login = ($login_users * 100 / $total_users_in_db);
$percent_logoff = ( 100 - $percent_login );
$data = array($percent_login,$percent_logoff);
//$data = array(12,88);
$graph = new PieGraph(350,170,auto);
$graph-SetShadow();
//$graph-title-Set( $lang['pra_total_users_in_db']: $total_users_in_db);
$graph-title-Set(Total users in Data Base: $total_users_in_db);
$graph-title-SetFont(FF_FONT1,FS_BOLD);
$p1 = new PiePlot3D($data);
$p1-ExplodeSlice( 1);
$p1-SetLabelType( PIE_VALUE_ABS);
$p1-SetSize(0.40);
$p1-SetCenter(0.33);
$p1-SetSliceColors(array('green','blue'));
$p1-setLegends(array(
LogIN Users: $login_users,
LogOUT Users: $logoff_users,
));
$graph-Add($p1);
$graph-Stroke();
?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: online users
Be careful with\ just SQL Count (*)
Some times NASes terminate local session without radius session termination
(ex: nas was powered off) in this case you may have some users who
technically logged in but that is not true! To avoid that you can select all
users in the interwal between Current time and CurentTime-X (where X is your
Idle logout time)
This one still not 100% accurate but it will trim off all old garbage.
-Original Message-
From:
[EMAIL PROTECTED]
.org
[mailto:[EMAIL PROTECTED]
eeradius.org] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, April 13, 2007 2:28 PM
To: FreeRadius users mailing list
Subject: Re: online users
SELECT COUNT(*) FROM radacct WHERE AcctStopTime=0
That will give you the number of currently logged in users (according to
the database).
Ivan Kalik
Kalik Informatika ISP
Dana 13/4/2007, Mordor Networks [EMAIL PROTECTED] piše:
i want to know how many user logged in mysql database/radius but it only
show the number of user in my databse for example is says 61 logged out
and 0 login
so here is the problem
//login users from//
$login_users = ; what i have to write here ? which table i have to query?
how i can fix that ?
if i change the number from 0 to 1 it show me one user online so their
must be a way to fix it?
heres the code :
?php
include (include/Artichow/class/jpgraph.php);
include (include/Artichow/class/jpgraph_pie.php);
include (include/Artichow/class/jpgraph_pie3d.php);
include_once (class/Oreon.class.php);
include_once (phpradmin.conf.php);
$oreon_db = new OreonDatabase($conf_pra[host], $conf_pra[user],
$conf_pra[password], $conf_pra[db]);
$table = userinfo;
//este si es valido
$total_users_in_db = $oreon_db -getTotalRowsInTable($table);
//$total_users_in_db = 500;
//login users from DB (SELECT COUNT(*) FROM radacct??;)
$login_users = ;
//logoff users total_users_in_db - login_users
$logoff_users = ($total_users_in_db - $login_users);
//percent
$percent_login = ($login_users * 100 / $total_users_in_db);
$percent_logoff = ( 100 - $percent_login );
$data = array($percent_login,$percent_logoff);
//$data = array(12,88);
$graph = new PieGraph(350,170,auto);
$graph-SetShadow();
//$graph-title-Set( $lang['pra_total_users_in_db']:
$total_users_in_db);
$graph-title-Set(Total users in Data Base: $total_users_in_db);
$graph-title-SetFont(FF_FONT1,FS_BOLD);
$p1 = new PiePlot3D($data);
$p1-ExplodeSlice( 1);
$p1-SetLabelType( PIE_VALUE_ABS);
$p1-SetSize(0.40);
$p1-SetCenter(0.33);
$p1-SetSliceColors(array('green','blue'));
$p1-setLegends(array(
LogIN Users: $login_users,
LogOUT Users: $logoff_users,
));
$graph-Add($p1);
$graph-Stroke();
?
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: online users
hi ivan thank you for your reply it tried this : $requet = SELECT COUNT(*) FROM radcheck WHERE AcctStopTime=0; $login_users = $requet and $login_users = SELECT COUNT(*) FROM radcheck WHERE AcctStopTime=0; still 0 , what im doing wrong? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: online users
You need to be querying to radacct table - that is where you would find information on sessions. radcheck is generally only the static data regarding the users on your system. regards Graham Beneke Mordor Networks wrote: hi ivan thank you for your reply it tried this : $requet = SELECT COUNT(*) FROM radcheck WHERE AcctStopTime=0; $login_users = $requet and $login_users = SELECT COUNT(*) FROM radcheck WHERE AcctStopTime=0; still 0 , what im doing wrong? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: online users
hi Graham yes sir i know but my question is how to do that im all new to all this.. thank you - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
