All Linux HowTo's

Install Memcached for Magento (or any PHP site) on CentOS/Redhat

This article explains how to install and configure memcached for Magento (or any PHP site) on a Redhat or CentOS server. Install memcached: yum install memcached php-pecl-memcache -y Now edit your “/etc/sysconfig/memcached” file to look something like this: PORT=”11211″ USER=”memcached” MAXCONN=”1024″ CACHESIZE=”256″ ## Accept connections from another server (192.168.1.2)? #OPTIONS=”-l

Read more
All Linux HowTo's

Enabling Triggers within RDS (Amazon)

By default, Amazon’s AWS RDS databases don’t permit Triggers. This article explains how to change that. Source: “http://techtavern.wordpress.com/2013/06/17/mysql-triggers-and-amazon-rds/”. Open the RDS web console. Open the “Parameter Groups” tab. Create a new Parameter Group. On the dialog, select the MySQL family compatible to your MySQL database version, give it a name

Read more
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