Enable log files

MySQL provides many different log files to capture various information that you can use for performance tuning or during problem determination.

To enable the log files, do the following:
Create the /etc/my.cnf options file with the following definitions that enable the log files automatically:

[mysqld]
log-bin
log
log-error
log-slow-queries

By default, the logs are placed in the data directory /pathname/mysql/data. The log names default to the name of the host system followed by a log identifier such as -bin.

How and where to set administrator's e-mail in Apache

If your system was not configured with administrator e-mail then on 500 Internal Server Error you will see the following message:

Internal Server Error
 
The server encountered an internal error or misconfiguration and was unable to complete your request.
 
Please contact the server administrator, [no address given] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
 
More information about this error may be available in the server error log.

To set admin's e-mail open:

How to install memcached on Ubuntu for use with Drupal

This guide is based on various community forum posts. Special thanks to Jonathan Wagener for the Ubuntu specific instructions

Monit configuration to monitor Memcached instances

Monit is a free open source utility for managing and monitoring, processes, files, directories and filesystems on a UNIX system. It is pretty easy to configure and even easier to use. It comes with a simple web server to monitor statuses of the alerts you set (with basic HTTP authentication). On Monit W’k’ you can find configuration examples for different services. Just in case you need a configuration example for Memcached instances, here is what you need.

How to properly install drush on Ubuntu 10.04

Despite it is clearly noted on http://drupal.org/node/1248790 the recommended way is to download Drush from the project page and to install it manually by reading the instructions of the README.txt file, many people start executing the aptitude command given on the same page:

$ sudo apt-get install drush

and the subsequent commands like

$ drush --version
$ drush dl drush

give you no joy since the official Ubuntu repositories contain very much outdated version of drush, which can not neither update itself nor display its version.

Monit mysql monitoring problem with mysqld.pid missing

Monit is a nice tool, it lets you monitor daemons like apache and mysql, and not only sends you alerts when these services fail but also it automagically restarts those services. But I have always faced problem with having monit properly detect whether mysql is running or not. The default monit config file /etc/monit/monitrc has this entry for mysql:

check process mysql with pidfile /var/run/mysqld/mysqld.pid
group database
start program = "/etc/init.d/mysql start"
stop program = "/etc/init.d/mysql stop"
if failed host 127.0.0.1 port 3306 then restart

Install Munin On Ubuntu 10.04

Munin is a networked resource monitoring tool that can help analyze resource trends and “what just happened to kill our performance?” problems. It is designed to be very plug and play. A default installation provides a lot of graphs with almost no work.

Install

To start this tutorial you will need a web server, both Lighttpd and Apache will do the job. For this tutorial I will use Lighttpd which is available from the Ubuntu Repositories.

sudo aptitude install lighttpd

You will also need PHP installed on the system.

How to properly install APF (Advanced Policy Firewall) on CentOS or Ubuntu

This guide will show you how to properly install APF firewall, one of the better known Linux firewalls available, on different Linux distros like Redhut/CentOS and Debian/Ubuntu. Configuration part doesn't differ from distro to another distro, so reading the official README file or googling will suffice.

sysv-rc-conf is RedHut/CentOS chkconfig alternative for Debian/Ubuntu

The sysv-rc-conf program gives an easy to use interface for managing "/etc/rc{runlevel}.d/" symlinks. The interface comes in two different flavors, one that simply allows turning services on or off and another that allows for more fine tuned management of the symlinks.

Unlike most programs configuration of the levels, you can edit startup scripts for any runlevel, not just the current.
To install just need to run the command:

sudo apt-get install sysv-rc-conf

Once installed run the command:

sudo sysv-rc-conf

Locking Down Your Linux Server with APF + BFD

If you allow SSH access to your server, there are some simple steps you can take to restrict access and protect yourself from brute force attacks. Two of my favorite scripts to do this are Advanced Policy Firewall coupled with Brute Force Detection, both by R-FX Networks.

Syndicate content