All Linux HowTo's

Fix Munin Graphs – When they wont update

This article explains how to fix Munin graphs that wont update or have stopped updating. The official FAQ (http://munin-monitoring.org/wiki/faq#Q.Thegraphsarenotupdatinganymore) doesn’t really say much about it. So do this: More info: This is an interesting article related to the issue. “http://grokbase.com/t/sf/munin-users/1166b12gsk/increase-in-period-for-munin-cron-or-munin-update-results-no-graphs”. First, disable munin cron task: mv /etc/cron.d/munin ~/munin.cron Wait until

Read more
All Linux HowTo's

Get MySQL Database Sizes

Log into MySQL and issue the following command as it is: SELECT table_schema AS “Database name”, SUM(data_length + index_length) / 1024 / 1024 AS “Size (MB)” FROM information_schema.TABLES GROUP BY table_schema; And you’ll get something like the following: +——————–+————–+ | Database name | Size (MB) | +——————–+————–+ | my_db1 |

Read more
All Linux HowTo's Security HowTo's

Encrypt Large Files With OpenSSL Using Public/Private Keys

This article explains how to encrypt large files with OpenSSL and Public/Private keys. Create your key-pair: openssl req -x509 -nodes -newkey rsa:2048 -keyout private.pem -out public_nopass.pem Encrypt your larger file: openssl smime -encrypt -aes256 -in bigfile.tar -binary -outform DEM -out bigfile.tar.ssl public.pem Decrypt your file: openssl smime -decrypt -in bigfile.tar.ssl

Read more
All Linux HowTo's

Install Munin Server on Redhat/CentOS

This article explains how to install Munin Server on CentOS and Redhat. This article doesn’t deal with the client (node) side of things. The Munin Node is documented here. Install the Munin Server packages: rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm yum groupinstall “Web Server” yum install -y munin php You can change the

Read more
All Linux HowTo's

Minimal Nginx and PHP-FPM on CentOS

This article explains how to install a minimal Nginx server with php-fpm on a CentOS server. Install the packages: yum install nginx php-fpm php And here is the sample virtual-host config “/etc/nginx/conf.d/agix.com.au.conf”: server { listen 80; server_name agix.com.au *.agix.com.au; access_log /var/log/nginx/agix.com.au.access.log; error_log /var/log/nginx/agix.com.au.error.log; root /var/www/agix.com.au; index index.php; location / {

Read more