http://www.wormsign.net/ 2012-02-22T11:42:45-08:00 http://www.wormsign.net/ http://www.wormsign.net/lib/tpl/default/images/favicon.ico text/html 2012-02-18T00:06:00-08:00 admin http://www.wormsign.net/doku.php?id=logging-index&rev=1329552360&do=diff Logging btmp and wtmp btmp is a record of failed login attempts. wtmp is a record of successful user logins and logouts. If you have SSH open to the public and aren't running something reactive, such as fail2ban, chances are your /var/log/btmp file will grow to outrageous sizes over time. You can clear these two files as follows: text/html 2012-02-17T23:56:06-08:00 admin http://www.wormsign.net/doku.php?id=start&rev=1329551766&do=diff Worm Sign “We Fremen have a saying. God created Perl to train the faithful. One must not go against the word of God.” ---------- Apache Drupal Logging Mail Monitoring MySQL Package Management Shell Users Varnish Zend CE ---------- Disclaimer: Unless otherwise noted, the scattered pearls of knowledge contained within this wiki are specific to RedHat-based distributions. If you're using Debian or Ubuntu, we'll pray for your eternal soul. text/html 2011-10-10T13:09:26-08:00 admin http://www.wormsign.net/doku.php?id=zend-index&rev=1318277366&do=diff Zend CE Do you use PHP 5.2 or 5.3? It doesn't matter what Linux distribution you use, or even if you're running PHP on Windows. Your PHP stack is complete crap. Use Zend CE. Tests and real world use of Zend CE with Drupal has shown 50-85% reduction in time spent serving PHP. Zend CE contains an obscenely optimized PHP stack, and comes with damned near every PHP module you could possibly want. Zend keeps their packages up to date, and installation (on Linux) is as simple as running a simp… text/html 2011-09-11T13:31:49-08:00 admin http://www.wormsign.net/doku.php?id=mysql-index&rev=1315773109&do=diff MySQL Import Slow Query Log to MySQL I find developers are lazy bastards who won't lift a damned finger unless you send them data on their borked ass queries in an easy-to-digest format. As a sysadmin, I can only respect that. The epic nature of being able to execute SQL against slow query logs cannot possibly be overstated. Now, you can of course have MySQL log slow queries to a table by default. But there are a number of reasons you might not want to do that, or might be prevented from … text/html 2011-09-11T13:29:36-08:00 admin http://www.wormsign.net/doku.php?id=mysql-script-slow_query_import&rev=1315772976&do=diff #!/usr/bin/perl ############################################################################### # Copyright (c) 2011, Workhabit, Inc. # All rights reserved. # # Redistribution and use in source and binary forms, with or without # modification, are permitted provided that the following conditions are met: # # * Redistributions of source code must retain the above copyright notice, # this list of conditions and the following disclaimer. # # * Redistributions in binary form must reproduce the… text/html 2011-08-29T11:49:37-08:00 admin http://www.wormsign.net/doku.php?id=apache-index&rev=1314643777&do=diff Apache Removing Module Bloat Apache, by default, comes with a great many modules enabled, the vast majority of which won't be used. It's thus a good idea to disable anything not being used - the savings in memory aren't exactly huge, but squeezing another simultaneous client or two adds up when you're dealing with a large cluster. The following are my default module configurations for Apache on RHEL5 and RHEL6. Note that you may actually need certain modules I've disabled; or perhaps could… text/html 2011-08-29T11:20:15-08:00 admin http://www.wormsign.net/doku.php?id=package-index&rev=1314642015&do=diff Package Management Determine Installed Package Origin The following will tell you what repository an installed package originally came from. Replace PACKAGENAME with the name of the package in question. rpm -qa --qf '%{NAME} %{VENDOR}\n' | grep PACKAGENAME text/html 2011-07-28T13:25:09-08:00 admin http://www.wormsign.net/doku.php?id=varnish-index&rev=1311884709&do=diff Varnish Broken Apache Allow/Deny The inclusion of Varnish will break Deny From All/Allow From 127.0.0.1 for Apache (eg, locking down server-status). Best solution is to keep the Apache backend unavailable to the general public, and deny server-status through Varnish's configuration. text/html 2011-06-08T14:14:43-08:00 admin http://www.wormsign.net/doku.php?id=drupal-script-bm_clean&rev=1307567683&do=diff #!/usr/bin/perl ############################################################################### # Copyright (c) 2011, Workhabit, Inc. # All rights reserved. # # Redistribution and use in source and binary forms, with or without # modification, are permitted provided that the following conditions are met: # # * Redistributions of source code must retain the above copyright notice, # this list of conditions and the following disclaimer. # # * Redistributions in binary form must reproduce th… text/html 2011-06-08T14:06:13-08:00 admin http://www.wormsign.net/doku.php?id=drupal-index&rev=1307567173&do=diff Drupal Backup and Migrate Cleanup Developers seem to love the Backup and Migrate module. Sir, I do not - mostly because I keep running into problems where it isn't cleaning up after itself (clustered systems, anyone?), causing zealous developers to fill up disk.