Author Archives: Etapien

Top 6 RaspberryPI operating systems

The Raspberry Pi is a credit-card sized computer that plugs into your TV and a keyboard. It can be used for many of the things that your desktop PC does, like spreadsheets, word-processing and games. It also plays high-definition video. I personally use it as a backup server (pulls data from several locations using rsnapshot and backs […]

Linux based web tools that sysadmins can use

Web tools are those that work on your browser and don’t need to be downloaded on to the system. They are usually easy-to-use and fast to work with. In addition, they also save a lot of your computer’s resources, which makes them even more useful. So, here are some tools that suit the profile and […]

Top 8 MySQL GUI Tools

MySQL is perhaps one of the most popular databases for development . The fact that it offers tremendous scalability and flexibility in web applications means maximum open source applications use MySQL database today. Here is a list of the top 8 GUI tools you can use with MySQL: 1.MyDB Studio MyDB Studio is a complete collection […]

How to backup MySQL to FTP

Here is a simple script to backup MySQL databases via FTP: Re-reqs – in this case I used ncftp as the client: apt-get install ncftp Create and open a new Backup Script: vim /path/to/backupscript.sh Insert the following code: #!/bin/bash #Variables FILENAME=/backup/$(date +%d%m%Y).sql FTPHOSTNAME=”host” FTPUSERNAME=”ftpuser” FTPPASSWORD=”ftppassword” MESSAGE=”Database Backup Successful” #SQL VARIABLES SQLUSERNAME=”sqluser” SQLPASSWORD=”sqlpassword” DATABASE=”sqldatabase” #SQL BACK […]

How to upgrade Debian 6 squeezy to Debian 7 wheezy

Make sure to backup all your data before doing this, always backup backup backup! Update your sources.list: vim /etc/apt/sources.list Add the following sources: deb http://mirrors.kernel.org/debian/ wheezy main deb-src http://mirrors.kernel.org/debian/ wheezy main deb http://security.debian.org/ wheezy/updates main deb-src http://security.debian.org/ wheezy/updates main # wheezy-updates, previously known as ‘volatile’ deb http://mirrors.kernel.org/debian/ wheezy-updates main deb-src http://mirrors.kernel.org/debian/ wheezy-updates main Update the […]

How to password protect a directory with .htaccess

To protect a directory on the web follow these simple steps: 1. Open a .htaccess file within the directory you wish to protect vim .htaccess 2. Insert the followoing code: AuthUserFile /route/to/directory/.htpasswd AuthGroupFile /dev/null AuthName “Custom text to show in pop-up” AuthType Basic <Limit GET> require valid-user </Limit> 3. Now we need to create the […]

How To Optimize Linux For SSDs

Get the most out of your SSD in Linux – here’s what you need to know. Linux is pretty great out-of-the-box, there are still some items that require a little bit of manual optimization to get them going as smoothly as possible. Controlling power consumption is the most common one, but optimizing your system for SSDs is […]

How to Create Custom Post Types in WordPress

Over the past years, WordPress has evolved into a robust content management system. By default WordPress comes with post and pages as the main content types. However you can create as many custom content types as you like, and these custom content types are referred to as Custom Post Types. In this article, this guide will show […]

How to Add Social Buttons in WordPress RSS Feed

While most modern feed readers include social sharing capabilities, in this article, we will show you how to add social buttons in WordPress RSS feed. First thing you need to do is download the social buttons you would want to display in your feeds. There are several social media icon sets available for free. Choose […]

NGINX – Allow access only to certain IPs

Nginx has a nice module that not many people know about, it basically enables us to allow or deny access to directories served by the webserver. The module is named ngx_http_access_module to allow or deny access to IP address. The syntax looks like this: location / { deny 192.168.1.1; allow 192.168.1.0/24; allow 10.1.1.0/16; allow 2001:0db8::/32; deny all; } The […]