DK's cut&paste

Everyone has their own requirements of what they need enabled or not, this is my setup that I've used over the last couple of years. I have had the option of both PHP 5.4 and 5.5, but my personal preference is to go with the latest 5.5 releases. apt-get install autoconf libxml2-dev libcurl3-dev libmysqlclient-dev libbz2-dev libsnmp9-dev libjpeg-dev libpng-dev libfreetype6-dev libmcrypt-dev libc-client-dev snmp export PHP_VER=5.4.29 export PHP_PREFIX=php5.4 -- for php 5.3 - 5.4 wget "http://nl.php.net/distributions/php-$PHP_VER.tar.gz" -O php-$PHP_VER.tar.gz tar xfz "php-$PHP_VER.tar.gz" cd "php-$PHP_VER" export PHP_VER=5.5.13 export PHP_PREFIX=php5.5 cd /app/sources/ rm php* -fr -- for php 5.5 wget "http://dk1.php.net/get/php-$PHP_VER.tar.bz2/from/www.php.net/mirror" -O php-$PHP_VER.tar.bz2 tar xjf "php-$PHP_VER.tar.bz2" cd "php-$PHP_VER" ### compile touch ac*; ./buildconf --force ./configu

Getting a new server with the latest LTS started out like great news, but soon turned out to be a "couple" of hours wasted on google'n without success. #percona on freenode is sadly still very very idle and of no help, and after reading different sources such as http://www.percona.com/doc/percona-xtradb-cluster/5.5/installation/compiling_xtradb_cluster.html http://www.percona.com/doc/percona-xtradb-cluster/5.6/installation/compiling_xtradb_cluster.html https://mariadb.com/kb/en/building-the-galera-wsrep-package-on-ubuntu-and-debian/ I managed to get it all working and wanted to share the success. Note: There might be more packages that need to be installed that I already had when installing another application, if you get an error along the way, leave a comment and I'll help out and update the blog as we go along. apt-get install bzr openssl cmake libncurses5-dev bison xinetd socat build-essential flex bison automake autoconf bzr libtool libaio-dev zlib1

My favorite way of deleting dupes (taken from the honorable #mysql on freenode) If you have a unique ID and the name may contain duplicates then DELETE t1 FROM table1 AS t1 JOIN table1 AS t2 ON t1.id>t2.id AND t1.name=t2.name; If you have other fields that need to be taken into consideration extend the join as needed. If it fails on a myisam table see http://bugs.mysql.com/bug.php?id=28837

So I tried getting phpMyAdmin to work with https again, turns out there was a solution posted back in 2008 on this blog. His solution didn't quite work out for me, so I thought I'd update it with my working solution. His version states add fastcgi_param HTTPS on which is correct, just at the wrong place. location ~ \.php$ { fastcgi_param HTTPS on; fastcgi_pass 127.0.0.1:xxxx; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME /var/www$fastcgi_script_name; include /usr/local/nginx/conf/fastcgi_params; } What I need to do is the following: location ~ \.php$ { fastcgi_pass 127.0.0.1:xxxx; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME /var/www$fastcgi_script_name; include /usr/local/nginx/conf/fastcgi_params; fastcgi_param HTTPS on; } Why? Simply cause in the conf/fastcgi_params file I had this: fastcgi_param HTTPS $ssl_protocol; Which doesn't seem to be good enough for good ol' phpMyAdmin, so we need to overwrite it after we inclu

Tell pure-ftpd to accept tls connections echo 1 > /etc/pure-ftpd/conf/TLS Setup your certificate mkdir -p /etc/ssl/private openssl req -x509 -nodes -newkey rsa:1024 -keyout \ /etc/ssl/private/pure-ftpd.pem \ -out /etc/ssl/private/pure-ftpd.pem chmod 600 /etc/ssl/private/*.pem Restart pure-ftpd /etc/init.d/pure-ftpd restart Enjoy.

Update @20:th Aug 2015 The old dpkg trick was unstable and wanted to delete tons of unwanted things more than 50% of the time, so I found another useful command which has a higher success rate of doing what we want. aptitude purge ~ilinux-image-\[0-9\]\(\!`uname -r`\) source: http://www.upubuntu.com/2011/11/how-to-remove-unused-old-kernels-on.html Run the following command to see what the command will remove: dpkg -l linux-* | awk '/^ii/{ print $2}' | grep -v -e `uname -r | cut -f1,2 -d"-"` | grep -e [0-9] | xargs sudo apt-get --dry-run remove And finally to actually remove the kernels use: dpkg -l linux-* | awk '/^ii/{ print $2}' | grep -v -e `uname -r | cut -f1,2 -d"-"` | grep -e [0-9] | xargs sudo apt-get -y purge source: http://tuxtweaks.com/2010/10/remove-old-kernels-in-ubuntu-with-one-command/