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?
Thanks in advance
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
