Technology Insights

Configure Logrotate To Rotate And Flush MySQL Logs Without A Password

If you have the resources (CPU + RAM) available on your server then its can be a great troubleshooting tool if you enable MySQL logging which includes server messages, SQL query logs, and slow query logs. If you do not have the resources I would suggest only enable minimal logging such as only server messages and the slow query log since enabling all queries to be written to a file can become expensive rather quickly. Below I discuss enabling three different types of MySQL logging, adding a MySQL configuration file to logrotate, and configuring root to run mysqladmin commands without having to type the password out each time.

Technology Insights

Backing up Subversion Repositories using hot-backup.py

Since I have started managing the Backtrack Projects new subversion server I have started to learn some interesting lessons in backup which I didn’t do before. As with most things, once I learn my lesson, I like to make a quick post on the solution so others can learn from my errors. So I was backing up the Berkly database it self for my svn projects but it turns out subversion actually includes a python script for hot back ups.

Technology Errors

MM-Forms WordPress Plugin Not Working Over HTTPS After FORCE_SSL_ADMIN Set

I have had FORCE_SSL_ADMIN set for quite awhile now in my wp-config.php file which forces all traffic to /wp-admin/ to be HTTPS. When I initially configured this setting it broke numerous WordPress plugins which I fixed however I missed MM-Forms being broken. The issue was the exact same as previous plugins that had the issue so it wasn’t to hard to fix but I wanted to share in case anyone else is having trouble getting the MM-Forms plugin working over SSL. Below I will explain what lines need to be changed to get MM-Forms working over HTTPS including syntax, line numbers, and old code.