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
Online Users
Hi, 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. Thanks. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Online Users Question
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? Thanks, Shawky - 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
Online Users
Hi, When viewing the online users and I wish to drop or clear the connection, nothing actually happens. 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 Kind Regards, Shawky Skaf [Description: Description: cid:710305523@08062009-0910] iVox Communications www.ivox.com.auhttp://www.ivox.com.au/ P: +61 2 8252 0205 F: +61 2 8252 0202 The contents of this document may be privileged and confidential, any unauthorised use of the contents is expressly prohibited. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. iVox Communications is not liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt. inline: image001.gif- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FR 2.1.8 + dialup admin: Online users
Dear all, I am having troubles with user_finger.php3 because Online users do not show up. Problem is that there are no entries in radacct with 'AcctStopTime'. Entries show up in my radacct table when the user session ends and a AcctStopTime gets logged. But then the user is not online anymore ;-) Any ideas? Cheers, Alexander - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Graphing - Online users
Dear All , I have a question , is there any way to make a graph ( Like mrtg or cacti ) to graph no of online users ?? Regards - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Online users
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
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: mysql isn't match with online users status
Zahra Bahar wrote: we have freeradius for accounting of dialup and vpn users. sometimes users have been stoped but they are online in mysql table . what's wrong? is there any log of commmands exchange between freeardius and mysql? What's wrong is that the NAS isn't telling FreeRADIUS that the users have logged off. There's very little you can do except fix the NAS. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql isn't match with online users status
I considerd row fields in radacct table. all the fields even duration time is correct but stop field is zero for some users that we know they are disconnected so they cann't to be conected until passing random time that thay go to be stoped but the stop-time field is the same as start-time. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql isn't match with online users status
Zahra Bahar wrote: I considerd row fields in radacct table. all the fields even duration time is correct but stop field is zero for some users that we know they are disconnected so they cann't to be conected until passing random time that thay go to be stoped but the stop-time field is the same as start-time. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html As Alan said, it's a problem with your NAS. It's failing to send an Accounting-Request with an Acct-Status-Type attribute of 'Stop'. Unless your NAS tells FreeRADIUS to close the session, the session will stay open in the database. FreeRADIUS does not keep track of accounting session state internally. Arran -- Arran Cudbard-Bell ([EMAIL PROTECTED]) Authentication, Authorisation and Accounting Officer Infrastructure Services (IT Services) E1-1-08, Engineering 1, University Of Sussex, Brighton EXT: +44 1273 873900 | INT: 3900 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql isn't match with online users status
but another fields are true. could radius have true session-duration but didn't receive stop time? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql isn't match with online users status
Zahra Bahar wrote: but another fields are true. could radius have true session-duration but didn't receive stop time? The server has session duration until the NAS stops sending packets. The session MAY continue for a short time after the last packet. In short, we've been doing this for 10 years. If the server isn't getting a stop packet, then it's the fault of the NAS. Don't try to fix the server. You can't. The server isn't broken. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql isn't match with online users status
@Zahra Check the connection between NAS and your radius server. Problem can be caused if your connection is unstable and sometimes radius server didn't receive stop packages. So, just like Alan said.. RS server works fine and you don't need to fix it :) On Tue, May 20, 2008 at 1:09 PM, Alan DeKok [EMAIL PROTECTED] wrote: Zahra Bahar wrote: but another fields are true. could radius have true session-duration but didn't receive stop time? The server has session duration until the NAS stops sending packets. The session MAY continue for a short time after the last packet. In short, we've been doing this for 10 years. If the server isn't getting a stop packet, then it's the fault of the NAS. Don't try to fix the server. You can't. The server isn't broken. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
mysql isn't match with online users status
we have freeradius for accounting of dialup and vpn users. sometimes users have been stoped but they are online in mysql table . what's wrong? is there any log of commmands exchange between freeardius and mysql? - 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
online users
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
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
radwho not disply online users
dear all I have installed freeradius with mssql but after few error i have run this command on my shell # echo/var/log/radius/radutmp after runing this command now i run this command [EMAIL PROTECTED] ~]# radwho Login Name What TTY When From Location [EMAIL PROTECTED] ~]# no data display since one week what is the problem in radwho is there any option to recover this command $ cat ~/satish/url.txt System administrator ( Data Center ) please visit this site http://linux.tulipit.com - Heres a new way to find what you're looking for - Yahoo! Answers - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: radwho not disply online users
radwho displays online users. If nobody is online now ... Ivan Kalik Kalik Informatika ISP Dana 6/3/2007, satish patel [EMAIL PROTECTED] piše: dear all I have installed freeradius with mssql but after few error i have run this command on my shell # echo/var/log/radius/radutmp after runing this command now i run this command [EMAIL PROTECTED] ~]# radwho Login Name What TTY When From Location [EMAIL PROTECTED] ~]# no data display since one week what is the problem in radwho is there any option to recover this command $ cat ~/satish/url.txt System administrator ( Data Center ) please visit this site http://linux.tulipit.com - Heres a new way to find what you're looking for - Yahoo! Answers - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: radwho not disply online users
Dear 100 user login on my cisco router VPDN tunnel i can see those user into in cisco router but not display on radwho output [EMAIL PROTECTED] wrote: radwho displays online users. If nobody is online now ... Ivan Kalik Kalik Informatika ISP Dana 6/3/2007, satish patel pi¹e: dear all I have installed freeradius with mssql but after few error i have run this command on my shell # echo/var/log/radius/radutmp after runing this command now i run this command [EMAIL PROTECTED] ~]# radwho Login Name What TTY When From Location [EMAIL PROTECTED] ~]# no data display since one week what is the problem in radwho is there any option to recover this command $ cat ~/satish/url.txt System administrator ( Data Center ) please visit this site http://linux.tulipit.com - Heres a new way to find what you're looking for - Yahoo! Answers - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html $ cat ~/satish/url.txt System administrator ( Data Center ) please visit this site http://linux.tulipit.com - Heres a new way to find what you're looking for - Yahoo! Answers - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
online users checking
Dear all I have freeradius with mssql setup but dialup_admin not support MSSQL so how do i check online users on radius server is it any solution regarding this isse please inform me Satish patel - Heres a new way to find what you're looking for - Yahoo! Answers - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup_admin online users problems
Hi, i use freeradius-1.0.1 with mysql on Fermi Linux LTS Release 3.0.1 and dialup_admin1.62 I have a problem in showing the online user in dialup_admin. when a user over ppp connect on NAS, it doesn't appear in user online because nothing is writing into the radacct table and i don't know why. it 's different when an administrator connect into the NAS iver telnet or ssh, this session is writing into the radacct table. can anyone help me. -- mailto : [EMAIL PROTECTED] G.I.C.M. Infrastructure réseau 32 Rue Mirabeau, 29480 Le Relecq-Kerhuon Tél : +33 298003671 Fax : +33 298284005 -- Ce message et toutes les pieces jointes (ci-apres le message) sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message etant susceptible d'alteration, l'emetteur decline toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. --- This message and any attachments (the message) are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. As e-mails are susceptible to alteration, the issuer shall not be liable for the message if altered, changed or falsified. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Error in Dialup Admin's online users page
Hi, there's a mistake in user_admin.php3 of dialup_admin. Right now, it's displaying the Download value twice on the Online Users page. Once as human-readable value under Upload and once as raw bytes under Download. I found the glitch on line 196. if ($lastlog_input) $lastlog_input = bytes2str($lastlog_input); else $lastlog_input = 'not available'; if ($lastlog_output) $lastlog_input = bytes2str($lastlog_output); else $lastlog_output = 'not available'; Of course it's got to be $lastlog_output. cheers, tobias - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: dialup admin - online users not displaying
hi: you have to repare you database, like this repair table `databasename`.`radacct`; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of RadiusSent: Sunday, August 08, 2004 9:22 PMTo: [EMAIL PROTECTED]Subject: dialup admin - online users not displaying Hi all, We are using FreeRadius 0.9.3 with the dialup admin gui interface on a Red Hat 9 server. Tonight, the dialup admin stopped displaying the "online users"and we have not been able to figure out what the problem is. We had not changed anything on the server. Radius is still authenticating users but for some reason the "online users" button in dialup admin shows 0 users connected. The radius.log has the following error entries: Sun Aug 8 21:13:22 2004 : Error: rlm_sql: Couldn't insert SQL accounting STOP record - Incorrect key file for table: 'radacct'. Try to repair it [Note - here we stopped and started mysql and then rebooted the server] Sun Aug 8 21:41:07 2004 : Info: rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radiusSun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4Sun Aug 8 21:41:08 2004 : Info: Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on 1814/udp.Sun Aug 8 21:41:08 2004 : Info: Ready to process requests.Sun Aug 8 21:44:38 2004 : Error: rlm_sql (sql): Couldn't update SQL accounting for START packet - Can't open file: 'radacct.MYI'. (errno: 145) What is the 'radacct.MYI' file? Does anyone know what causes the problem or what we need to do to correct the problem? Thanks in advance- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup admin - online users not displaying
Hi all, We are using FreeRadius 0.9.3 with the dialup admin gui interface on a Red Hat 9 server. Tonight, the dialup admin stopped displaying the "online users"and we have not been able to figure out what the problem is. We had not changed anything on the server. Radius is still authenticating users but for some reason the "online users" button in dialup admin shows 0 users connected. The radius.log has the following error entries: Sun Aug 8 21:13:22 2004 : Error: rlm_sql: Couldn't insert SQL accounting STOP record - Incorrect key file for table: 'radacct'. Try to repair it [Note - here we stopped and started mysql and then rebooted the server] Sun Aug 8 21:41:07 2004 : Info: rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radiusSun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4Sun Aug 8 21:41:08 2004 : Info: Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on 1814/udp.Sun Aug 8 21:41:08 2004 : Info: Ready to process requests.Sun Aug 8 21:44:38 2004 : Error: rlm_sql (sql): Couldn't update SQL accounting for START packet - Can't open file: 'radacct.MYI'. (errno: 145) What is the 'radacct.MYI' file? Does anyone know what causes the problem or what we need to do to correct the problem? Thanks in advance - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
