How To: Install Zabbix on Ubuntu 12.04 - AWS free tier

Install the Zabbix Server

Edit apt source list to add the PPA:
sudo nano /etc/apt/sources.list

Add the following items at the end of the file:
# Zabbix Application PPA
deb http://ppa.launchpad.net/tbfr/zabbix/ubuntu precise main
deb-src http://ppa.launchpad.net/tbfr/zabbix/ubuntu precise main

Press ctrl+x to quit, enter Y to save and close the file.

Next, we need to add the PPA's key so that apt-get trusts the source:
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys C407E17D5F76A32B

We can now install Zabbix:
sudo apt-get update
sudo apt-get install zabbix-server-mysql zabbix-frontend-php

During the installation, you will be asked to choose a password for the MySQL root account. Note the password so that you won't forget it.

How To: Backup a MySQL Database with mysqldump

Backup

The basic syntax of the command is:

# mysqldump -u username -p database_to_backup > backup_name.sql

Restore

To restore a database dump created with mysqldump, you simply have to redirect the file into MySQL again.

We need to create a blank database to house the imported data.
First, log into MySQL by typing:

# mysql -u username -p

Create a new database which will hold all of the data from the data dump and then exit out of the MySQL prompt:

# CREATE DATABASE database_name;
# exit

Next, we can redirect the dump file into our newly created database by issuing the following command:

# mysql -u username -p database_name < backup_name.sql

Your information should now be restored to the database you've created.

How To: Update Hardware Clock - CentOS 6

Change the date with the "date" command, for example:

# date --set="6 SEP 2013 15:55:00"

To update the hardware clock use the following command:

# hwclock --systohc

To view the date/time in hardware clock use the following command:

# hwclock --show

How To: Disable Iptables Firewall In Ubuntu Server

You can type the following command to see if firewall is active or not:

$ sudo iptables -L -n

You can save existing firewall rules as follows:

$ sudo iptables-save > firewall.rules

Finally, type the following commands to stop firewall:

$ sudo iptables -X
$ sudo iptables -t nat -F
$ sudo iptables -t nat -X
$ sudo iptables -t mangle -F
$ sudo iptables -t mangle -X
$ sudo iptables -P INPUT ACCEPT
$ sudo iptables -P FORWARD ACCEPT
$ sudo iptables -P OUTPUT ACCEPT

To disable ufw, enter:

$ sudo ufw disable

How To: Disable Iptables Firewall In Redhat/CentOS Linux

To disable iptables in Redhat/CentOS we have to use the following commands:

#service iptables stop
#service iptables save
#chkconfig iptables off

If you want to remove iptables completly from your system, use the "rpm" command:
#rpm -e iptables

How To: Set Up Apache Virtual Hosts on Ubuntu 12.04

Virtual Hosts are used to run more than one domain on a single IP address. This is especially useful to people who need to run several sites on one virtual private server.

1. Create a New Directory where we will keep the new website’s information

sudo mkdir -p /var/www/example.com/public_html

How To: Recover a MySQL root password

Stop the MySQL server process
# /etc/init.d/mysql stop 

Start again with no grant tables
# mysqld_safe --skip-grant-tables &

Login to MySQL as root.
# mysql -u root
mysql> use mysql;

Set new password
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;

Exit MySQL and restart MySQL server
mysql> quit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

Other useful commands:

How To: Install EHCP control panel on Ubuntu 12.04-12.10 using the AWS EC2 Free Tier

Get the latest version of EHCP:

root@ubuntu:~$ sudo wget http://www.ehcp.net/ehcp_latest.tgz
root@ubuntu:~$ sudo tar -zxvf ehcp_latest.tgz

Now execute the install.sh script to begin installation:

root@ubuntu:~$ cd ehcp/
root@ubuntu:~/ehcp$ sudo ./install.sh

How To: Install Webmin in Ubuntu 12.04 using the AWS EC2 Free Tier

Install Webmin

To install webmin in Ubuntu 12.04 using the AWS EC2 Free Tier, you need to open the terminal and add the following repository:

 1- Edit /etc/apt/sources.list file

root@ubuntu:~# sudo nano /etc/apt/sources.list

2- Add the following lines

deb http://download.webmin.com/download/repository sarge contrib deb http://webmin.mirror.somersettechsolutions.co.uk/repository sarge contrib

Save and exit the file

How to: Backup MySQL database and send to Amazon S3

Here's how to use Amazon S3 to keep your MySQL backups.

Make a file e.g.: mysqltos3.sh in your server, for example inside your home directory like: /home/mysqltos3.sh and paste the following code:

How to: Full Hard-drive backup using the tar command

It's a good idea to do a full backup of the hard-drive after the initial installation as well as when you finally get your server set up the way you want. Having a snapshot of your system right after the initial installation gives you something to revert back to should you want to reconfigure your server without starting from scratch. Linux has many backup utilities but the old standard is still the favorite of admins because of the flexibility offered by its myriad of options.


tar commands can become quite complex. It's easier to enter the command in a text file and make it a shell script. We also need to create a directory to hold the backup file. We'll use a separate directory so we can exclude that directory from the backup (we don't want tar trying to backup a file it's in the process of creating). Enter the following commands:

cd /home
mkdir backups
cd backups

First 5 Minutes Troubleshooting A Server

The cause of the issues are rarely obvious: here are a few things you should do to get started with:

Get some context

Don’t rush on the servers just yet, you need to figure out how much is already known about the server and the specifics of the issues. You don’t want to waste your time (trouble) shooting in the dark.

A “must have”:

• What exactly are the symptoms of the issue? Unresponsiveness? Errors?
• When did the problem start being noticed?
• Is it reproducible?
• Any pattern (e.g. happens every hour)?
• What were the latest changes on the platform (code, servers, stack)?
• Does it affect a specific user segment (logged in, logged out, geographically located…)?
• Is there any documentation for the architecture (physical and logical)?
• Is there a monitoring platform? Munin, Zabbix, Nagios, New Relic… Anything will do.
• Any (centralized) logs?. Loggly, Airbrake, Graylog…
• The last two ones are the most convenient sources of information, but don’t expect too much: they’re also the ones usually painfully absent. Tough luck, make a note to get this corrected and move on.

How to: Install Softaculous in DirectAdmin

The following guide will show you how to install Softaculous on DirectAdmin.

Requirements

1. A server with Direct Admin.
2. If you have a firewall, then please allow access to all packages from *.softaculous.com

Note : Please allow access to the following domains to your firewall as these are the mirrors used to download the script packages.

api.softaculous.com (IP : 216.18.221.243)
s1.softaculous.com (IP : 108.61.84.171)
s2.softaculous.com (IP : 23.29.77.179)
s3.softaculous.com (IP : 142.4.49.46)
s4.softaculous.com (IP : 188.138.10.177)

How to: Install Softaculous in cPanel

Requirements

• A server with cPanel
• If you have a firewall, then please allow access to download all packages from *.softaculous.com

Note : Please allow access to the following domains to your firewall as these are the mirrors used to download the script packages.

• api.softaculous.com (IP : 216.18.221.243)
• s1.softaculous.com (IP : 108.61.84.171)
• s2.softaculous.com (IP : 23.29.77.179)
• s3.softaculous.com (IP : 142.4.49.46)
• s4.softaculous.com (IP : 188.138.10.177)

How to: WHM Initial Setup

Access WHM

To access the WHM interface:
Type https://IP:2087 in your preferred web browser.
IP is meant to stand for the IP address of your web server.
Use root as the login name in the Username field.
Enter the root password into the Password field.
Click Login.

Initial Setup

When you log into WHM for the first time, you will see an Initial Setup screen. This feature will help you configure your server in 6 steps.

How to: Install cPanel / WHM

Obtain a cPanel / WHM license

If you do not already own a license for cPanel &amp; WHM, you should obtain one for your IP address before attempting installation. To obtain a cPanel &amp; WHM license, visit the cPanel Store.
 Note: The cPanel Store offers 15-day test licenses at no cost.

Connect to your server remotely via SSH

To connect to your server remotely via SSH, open the command line interface (using a terminal application).
Run the command ssh root@$IP (where $IP represents your target server's IP address).
Enter your server's root password.

How to: Speed up RAID1 resync

Just echo large numbers into both min and max resync speed proc entries:

/proc/sys/dev/raid/speed_limit_max
and
/proc/sys/dev/raid/speed_limit_min

E.g. login as root and do:

 echo 200000 > /proc/sys/dev/raid/speed_limit_max
 echo 200000 > /proc/sys/dev/raid/speed_limit_min

And watch the speed fly up till it maxes out your hardware!

The above will set both speeds to 200MiB/s which ought to be more than your device can do...

Email notification when a drive in software RAID fails

Debian - Ubuntu

Edit /etc/mdadm/mdadm.conf and add the following line:

MAILADDR example@example.com

You can also optionally configure the sending email address:

MAILFROM mdadm@example.com

Important is that "AUTOCHECK" in the file /etc/default/mdadm is set to "true":

# grep AUTOCHECK= /etc/default/mdadm
AUTOCHECK=true

How to: Replace a faulty drive in software RAID

Example scenario

The following configuration is assumed:

# cat /proc/mdstat
Personalities : [raid1]
md3 : active raid1 sda4[0] sdb4[1]
      1822442815 blocks super 1.2 [2/2] [UU]

md2 : active raid1 sda3[0] sdb3[1]
      1073740664 blocks super 1.2 [2/2] [UU]

md1 : active raid1 sda2[0] sdb2[1]
      524276 blocks super 1.2 [2/2] [UU]

md0 : active raid1 sda1[0] sdb1[1]
      33553336 blocks super 1.2 [2/2] [UU]

unused devices: none

There are four partitions in total:

• /dev/md0 as swap
• /dev/md1 as /boot
• /dev/md2 as /
• /dev/md3 as /home

/dev/sdb is the defective drive in this case and it is shown by [U_]. If the defective drive is /dev/sda it is show by [_U]. If the RAID array is intact, it shows [UU].

How to: Install Open Panel

Prerequisites

OpenPanel is designed to be installed on a clean server. Having packages installed is not a problem, but having their configuration modified can be a problem. Especially products like cPanel and DirectAdmin tend to modify configuration files to an extent where they’re no longer usable for other software.

OpenPanel supports the following platforms:

• Debian 5 “Lenny”
• Debian 6 “Squeeze”
• Ubuntu 10.04 “Lucid”
• Ubuntu 10.10 “Maverick”

In theory, OpenPanel can be installed on Ubuntu 11.04 “Natty” or Ubuntu 11.10 “Oneiric”. These platforms are not officially supported, though.

How to: change php settings using php.ini and .htaccess

How to change PHP settings using php.ini and .htaccess files.

In this article we will change the following php settings:

• memory_limit – maximum amount of physical memory that can be allocated to PHP script
• max_post_size – maximum size of data that can be transferred via POST method
• register_globals – this variable allows to enable or disable register_globals
• file_uploads – enables or disables file_uploads

First we will create our custom php.ini file.

How to: Change the default SSH port

By default, SSH runs on port 22.  Running SSH on port 22, though, makes it an easy target for those who might try to brute-force their way into your server and do all sorts of evil things with it.

Removing SSH from Port 22 and making it run on a different, unusual and hard-to-guess port, like, say, 61612 for instance, will increase the security of your server by making it appear to a bot or lazy port-scanner that you don’t have SSH running at all.

Of course, this won’t stop those determined to find the port that your SSH is running on, but it will immediately cut out those hackers who aren’t that invested in your machine in particular, but are looking instead for easy “ins”.

How to: Secure your cPanel / WHM server

1) Use secure passwords!

Insecure passwords are the most common security vulnerability for most servers. If an account password is insecure and is compromised, client sites can be defaced, infected, or used to spread viruses. Having secure passwords is paramount to having a secure server.

You can edit /etc/login.defs to configure many password options on your system. It is well documented.
Generally, a password utilizing at least 8 characters including alphanumeric and grammatical symbols is sufficient.

Never use passwords based upon dictionary words or significant dates. If you are uncertain about the security of a password, then you can test it using JTR cracker. If a password can be broken in a few hours, then it is probably too insecure and should not be used. You can also install tools like pam_passwdqc to check the strength of passwords.

Using vi Editor

Vi is the one of the mostly used editor in Linux via terminal. In most cases where Linux is used as a server operating system, admins use the terminal, where GUI uses more system resources - network bandwidth. Since Vi is used from the terminal, the lack of GUI force the user to learn function keys of the editor. Vi is a powerful and functional application if it is used with the ideas that is built on.

Linux Recursive Search inside files

You can make a search inside files within a a directory using the command "find", to do that:

cd /to_folder

find . -iname '*conf' | xargs grep 'string' -sl

Setting time with NTP in LINUX

NTP (Network Time Protocol) could be used to set time synced with ntp clocks, to do this use the shell command below:

Setting time with NTP:

Directadmin: MySQL root password recovery

DirectAdmin MySQL root password is set within the installation process and written down to setup.txt. If you didn't change this password you can find the default one in the setup.txt, use the command below to see the contents of this file:
less /usr/local/directadmin/scripts/setup.txt

DirectAdmin: How to automatically block IPs

You can block the IPs in DirectAdmin automatically, after a certain number of failed login attempts.

If you have CSF + LFD installed, create a script /usr/local/directadmin/scripts/custom/block_ip.sh:
#!/bin/sh
/etc/csf/csf.pl -td $ip 86400
exit 0

mdadm: common commands

Common mdadm commands I found really great (under Debian).

Generate mdadm.conf

cp /etc/mdadm/mdadm.conf /etc/mdadm/mdadm.conf.save
/usr/share/mdadm/mkconf --generate > /etc/mdadm/mdadm.conf

How To: Back up all MySQL and PostgreSQL databases

Back up all MySQL and PostgreSQL databases with a single line command
The following simply takes the output of mysqlshow, parses it, then passes it to mysqldump.
Files are created in the current directory

for db in ´mysqlshow | cut -d ' ' -f 2 | grep -v '+'´; do mysqldump $db > $db.dmp ; done

Directadmin: Basic System Security

Note that it's ultimately the responsibility of the server admin to ensure his system is secure.  These are some basic security tips that can be done to help protect your system.  This is not an end-all guide for server security, admins must be diligent, but rather some suggestions for a start to securing your server.

Shell script to warn at 90% disk space

df displays the amount of disk space available on the file system containing each file name argument. If no file name is given, the space available on all currently mounted file systems is shown. Read man page of df if you are new to df command.

Steps

=> Find disk space using df

=> Filter out filesystem and find out the percentage of space using grep

=> Write a shell script

Shell Script to notify Admin if System Load is over 10

Shell Script to notify Admin if System Load is over 10

How to Clean Cache in Linux

Open a command shell and type 

echo 1 > /proc/sys/vm/drop_caches 

followed by "Enter" to free the pagecache.

How to block an IP in Linux

I often find that my server is being attacked by other computers. Brute force SSH attacks, viruses scanning for the ability to spread, things like that. I’ll go into the SSH brute force defenses in a later post, but for now I’ll cover how to easily block an IP address.

First, I’ll assume you are already using iptables on Debian.

10 Linux nslookup examples for DNS Lookup

nslookup is a network administration tool for querying the Domain Name System (DNS) to obtain domain name or IP address mapping or any other specific DNS record. It is also used to troubleshoot DNS related problems.

nslookup can operate on both “Interactive mode” and “Non-Interactive mode”. Interactive mode allows the user to query the DNS-Server about various host, and domains. Non-Interactive mode allows the user to query the information for a host or domain. In this article, all the commands explained are “Non-Interactive mode”.

Common server ports

Port Numbers Used by Some Common Protocols 

Port  Name  Comment

1 tcpmux TCP port service multiplexer
5 rje Remote Job Entry
7 echo Echo service
9 discard Null service for connection testing
11 systat System Status service for listing connected ports

Iptables Basic Guide

Where are the main iptables files stored?

/etc/init.d/iptables is the INIT script which is used to start, stop the service and/or to save the rulesets.

/etc/sysconfig/iptables this is the file that holds the saved rulesets.

/sbin/iptables and this is the iptables binary.

Before you actually start configuring the rules, let's take a look at the current configuration:

# iptables -L