Posts

Showing posts from 2012

MySQL Delete dupes

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

phpMyAdmin - The plain HTTP request was sent to HTTPS port

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

Enabling Pure-ftpd TLS

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.

Remove unused kernels in Ubuntu

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/

Enabling the Android "Move To SD Card"

By simply adding the following line to your manifest file, your app will get the ability to get moved/installed on the SD Card! < manifest   xmlns:android ...>   android:installLocation = "auto"   ... </manifest>