beberapa hari ini radius server terserang “demam panas” sehingga terpaksa rawat inap.  Alhamdulillah akhirnya bisa kembali pulih. Permasalahan ternyata ada crash pada tabel databasenya. log menunjukkan crash pada file radpostauth. Berikut penangan yang dilakukan:

root@masin:/home/syarif# tail -F /var/log/freeradius/radius.log
Wed Mar 14 11:13:25 2018 : Info: rlm_sql (sql): Connected new DB handle, #31
Wed Mar 14 11:13:25 2018 : Info: Loaded virtual server
Wed Mar 14 11:13:25 2018 : Info: Loaded virtual server inner-tunnel
Wed Mar 14 11:13:25 2018 : Info: Ready to process requests.
Wed Mar 14 11:18:44 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radpostauth’ is marked as crashed and last (automatiair failed
Wed Mar 14 11:18:44 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radpostauth’ is marked as crashed and last (automatiair failed
Wed Mar 14 11:19:11 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radpostauth’ is marked as crashed and last (automatiair failed
Wed Mar 14 11:19:11 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radpostauth’ is marked as crashed and last (automatiair failed
Wed Mar 14 11:20:42 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radpostauth’ is marked as crashed and last (automatiair failed
Wed Mar 14 11:20:42 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radpostauth’ is marked as crashed and last (automatiair failed
^C
root@masin:/home/syarif# tail -F /var/log/freeradius/radius.log
Wed Mar 14 11:13:25 2018 : Info: rlm_sql (sql): Connected new DB handle, #31
Wed Mar 14 11:13:25 2018 : Info: Loaded virtual server
Wed Mar 14 11:13:25 2018 : Info: Loaded virtual server inner-tunnel
Wed Mar 14 11:13:25 2018 : Info: Ready to process requests.
Wed Mar 14 11:18:44 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radp
Wed Mar 14 11:18:44 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radp
Wed Mar 14 11:19:11 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radp
Wed Mar 14 11:19:11 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radp
Wed Mar 14 11:20:42 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radp
Wed Mar 14 11:20:42 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radp
Wed Mar 14 11:23:28 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radp
Wed Mar 14 11:23:28 2018 : Error: rlm_sql (sql) in sql_postauth: Database query error – Table ‘./radius/radp
cd ^C
root@masin:/home/syarif# cd /var/lib/mysql/radius/
root@masin:/var/lib/mysql/radius# myisamchk -r radpostauth
– recovering (with sort) MyISAM-table ‘radpostauth’
Data records: 1447360
myisamchk: error: Can’t create new tempfile: ‘radpostauth.TMD’
MyISAM-table ‘radpostauth’ is not fixed because of errors
Try fixing it by using the –safe-recover (-o), the –force (-f) option or by not using the –quick (-q) flag
root@masin:/var/lib/mysql/radius# myisamchk -r -v -f radpostauth
– recovering (with sort) MyISAM-table ‘radpostauth’
Data records: 1447360
– Fixing index 1
– Searching for keys, allocating buffer for 116417 keys
Wrong bytesec: 0- 0- 0 at 77230248; Skipped
Wrong bytesec: 0- 0- 0 at 77230268; Skipped
Wrong bytesec: 0- 0- 0 at 77230288; Skipped
– Last merge and dumping keys
root@masin:/var/lib/mysql/radius# service mysql start
start: Job is already running: mysql
root@masin:/var/lib/mysql/radius# service mysql restart
mysql stop/waiting
mysql start/running, process 1690