Thanks. That fixed the problem.
> hi:
>
> you have to repare you database, like this
>
> repair table `databasename`.`radacct`;
>
> _____
>
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Radius
> Sent: Sunday, August 08, 2004 9:22 PM
> To: [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]:/radius
> Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
> server for #0
> Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
> server for #1
> Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
> server for #2
> Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
> server for #3
> Sun Aug 8 21:41:07 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
> server for #4
> Sun 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?
