Problem /etc/cron.hourly/modsecparse.pl
Cuando el sistema muestre este error :
DBD::mysql::st execute failed: Incorrect key file for table './modsec/modsec.MYI'; try to repair it at /etc/cron.hourly/modsecparse.pl line 157, [$al_fh] line 18.
DBD::mysql::st execute failed: Incorrect key file for table './modsec/modsec.MYI'; try to repair it at /etc/cron.hourly/modsecparse.pl line 157, [$al_fh] line 37.
DBD::mysql::st execute failed: Incorrect key file for table './modsec/modsec.MYI'; try to repair it at /etc/cron.hourly/modsecparse.pl line 157, [$al_fh] line 56.
DBD::mysql::st execute failed: Incorrect key file for table './modsec/modsec.MYI'; try to repair it at /etc/cron.hourly/modsecparse.pl line 157, [$al_fh] line 75.
DBD::mysql::st execute failed: Incorrect key file for table './modsec/modsec.MYI'; try to repair it at /etc/cron.hourly/modsecparse.pl line 157, [$al_fh] line 37.
DBD::mysql::st execute failed: Incorrect key file for table './modsec/modsec.MYI'; try to repair it at /etc/cron.hourly/modsecparse.pl line 157, [$al_fh] line 56.
DBD::mysql::st execute failed: Incorrect key file for table './modsec/modsec.MYI'; try to repair it at /etc/cron.hourly/modsecparse.pl line 157, [$al_fh] line 75.
Seguir los siguientes pasos para solucionarlo :
nano /etc/cron.hourly/modsecparse.pl
rm -f /etc/cron.hourly/modsecparse.pl
cd /var/lib/mysql/
myisamchk -r modsec/*.MYI
mysqladmin drop modsec
mysqladmin create modsec
rm -f /etc/cron.hourly/modsecparse.pl
cd /var/lib/mysql/
myisamchk -r modsec/*.MYI
mysqladmin drop modsec
mysqladmin create modsec