Monthly Archives: November 2015

InnoDB Corruption and Recovery

Databases get corrupted for many reasons. In my case, our  hard drive went down during writes to the database from a power failure. InnoDB corruption can cause all of the databases running on that server to become inaccessible. My server is … Continue reading

Posted in Linux, MySQL | Tagged , | Leave a comment

Set Password Policy in Mysql 5.6

——————————————————————————————- 1) INSTALL PLUGIN loads the plugin, and also registers it in the mysql. plugins table to cause the plugin to be loaded for each subsequent normal server startup. ——————————————————————————————- mysql> INSTALL PLUGIN validate_password SONAME ‘validate_password.so’; ——————————————————————————————- 2) Edit my.cnf … Continue reading

Posted in Linux, MySQL | Tagged , | Leave a comment

Postfix Hardening

Make sure the Postfix is running with non-root account: root@Philip:~#ps aux | grep postfix | grep -v ‘^root’ Change permissions and ownership on the destinations below: root@Philip:~#chmod 755 /etc/postfix root@Philip:~#chmod 644 /etc/postfix/*.cf root@Philip:~#chmod 755 /etc/postfix/postfix-script* root@Philip:~#chmod 755 /var/spool/postfix root@Philip:~#chown root:root … Continue reading

Posted in Linux, Mail server, Postfix | Tagged , | Leave a comment